The Installation - BFI School

The Installation - BFI School

SQL for Data Analysis The Installation

SQL for Data Analysis

0% Completed

Introduction to SQL

Introduction to SQL

Video - 7:57 mins

Video - 4:42 mins

The Installation

Video - 7:12 mins

Video - 7:41 mins

Create Database

Video - 5:14 mins

First SELECT Query

Video - 7:34 mins

Video - 15:29 mins

SQL Command and Types

Video - 10:48 mins

SQL Basics

Accompanying File - DOWNLOAD !

Introduction to TABLES

Video - 10:07 mins

Creating TABLES

Video - 10:09 mins

Inserting ROWS of Data

Video - 11:13 mins

Retreiving Data from Table

Video - 6:07 mins

DELETE, TRUNCATE, & DROP Keywords

Video - 16:43 mins

BULK INSERT Dataset

Video - 12:32 mins

GROUP BY and ORDER BY Clauses

Video - 17:03 mins

Video - 10:58 mins

UPDATE Statement

Video - 17:03 mins

Constraints

Accompanying File - DOWNLOAD !

Why CONSTRAINTS ?

Video - 5:44 mins

Types of Constant (Introduction)

Video - 19:16 mins

NOT NULL Primary Key Defaut Constraints

Video - 10:57 mins

How to ALTER Table with Constraints

Video - 23:40 mins

FOREIGN KEY Constraints

Video - 26:47 mins

CHECK Constraints

Video - 21:06 mins

UNIQUES Constraints

Video - 26:47 mins

JOINS

Accompanying File - DOWNLOAD !

Introduction to JOINS

Video - 17:10 mins

Movie Database (For JOIN Practice)

Video - 5:08 mins

First Challenge Using JOINS

Video - 20:04 mins

Second Challege Using JOINS

Video - 17:32 mins

RIGHT and FULL OUTER JOIN Uses

Video - 12:00 mins

SELF JOIN Use Case

Video - 13:53 mins

SQL Functions

Introduction to Functions

SQL Server Operations

How to use NUL, ISNULL, and COALESCE to Handle NULL VALUE

Video - 20:47 mins

Using UNION, UNIONALL, INTERCEPT, EXCEPT

Video - 19:11 mins

Finding Duplicate on Dataset

Video - 17:59 mins

How to Use SELECT INTO to Clean Dataset with Duplicates

Video - 14:01 mins

How to Change Data Types

Video - 23:30 mins

More Data Cleaning and Analysis

Video - 20:36 mins

How to Use Wildcards in SQL Server

Video - 18:40 mins

CASE Statement in SQL Server

Video - 30:31 mins

Handling NULL Value

Video - 20:43 mins

Subqueries

Accompanying File - DOWNLOAD !

Introduction to SQL Subqueries

Video - 10:02 mins

Subqueries Exercise (Actual)

Video - 25:10 mins

Subquery Exercise

Video - 15:24 mins

Correlated Subquery

Video - 25:41 mins

Subquery in Having Clause

Video - 23:49 mins

CommonTable Expressions (CTEs) - Execise I

Video - 23:21 mins

CommonTable Expressions (CTEs) - Execise II

Video - 31:30 mins

CommonTable Expressions (CTEs) - Execise III

Video - 17:15 mins

Views

Demonstration of VIEWS

Video - 7:00 mins

Introduction to VIEW in SQL Server

Video - 6:30 mins

How to ALTER and DROP a VIEW

Video - 11:46 mins

How to SECURE a VIEW

Video - 11:39 mins

Restricting Operations in VIEW

Video - 15:26 mins

Stored Procedures

Introduction to STORED PROCEDURES

Video - 10:08 mins

Creating First STORED PROCEDURES

Video - 18:30 mins

Introducing Parameters in STORED PROCEDURES

Video - 24:43 mins

If… Else… Statement

Video - 10:33 mins

Introducing OUTPUT Parameters in STORED PROCEDURES

Video - 24:46 mins

Windows Functions

Introduction to SQL Server Window Functions

Video - 10:02 mins

Aggregate Window Functions

Video - 23:24 mins

Ranking Window Functions

Video - 16:56 mins

Value Window Functions

Video - 13:18 mins

Window Functions Exercise I

Video - 13:18 mins

Window Functions Exercise II

Video - 23:50 mins

Window Functions Exercise III

Video - 20:22 mins

CAPSTONE PROJECT

SQL Capstone Project

Announcements Reviews Live Classes Gradebook Certificate Course Info