SQL Server - BFI School

SQL for Financial Analysis SQL Server

SQL for Financial Analysis

0% Completed

Introduction to SQL

Video - 00:15:29 mins

SQL Command and Types

Video - 00:10:48 mins

SQL Basics

Accompanying File - DOWNLOAD !

Reading

Introduction to TABLES

Video - 00:10:07 mins

Creating TABLES

Video - 00:10:09 mins

Inserting ROWS of Data

Video - 00:11:13 mins

Retreiving Data from Table

Video - 00:6:07 mins

DELETE, TRUNCATE, & DROP Keywords

Video - 00:16:43 mins

BULK INSERT Dataset

Video - 00:12:32 mins

GROUP BY and ORDER BY Clauses

Video - 00:17:03 mins

WHERE Clause

Video - 00:10:58 mins

UPDATE Statement

Video - 00:17:03 mins

Constraints

Accompanying File - DOWNLOAD !

Reading

Why CONSTRAINTS ?

Video - 00:5:44 mins

Types of Constant (Introduction)

Video - 00:19:16 mins

NOT NULL Primary Key Defaut Constraints

Video - 00:10:57 mins

How to ALTER Table with Constraints

Video - 00:23:40 mins

FOREIGN KEY Constraints

Video - 00:26:47 mins

CHECK Constraints

Video - 00:21:06 mins

UNIQUES Constraints

Video - 00:26:47 mins

JOINS

Accompanying File - DOWNLOAD !

Reading

Introduction to JOINS

Video - 00:17:10 mins

Movie Database (For JOIN Practice)

Video - 00:5:08 mins

First Challenge Using JOINS

Video - 00:20:04 mins

Second Challege Using JOINS

Video - 00:17:32 mins

RIGHT and FULL OUTER JOIN Uses

Video - 00:12:00 mins

SELF JOIN Use Case

Video - 00:13:53 mins

SQL Functions

Introduction to Functions

Reading

SQL Server Operations

Reading

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

Video - 00:20:47 mins

Using UNION, UNIONALL, INTERCEPT, EXCEPT

Video - 00:19:11 mins

Finding Duplicate on Dataset

Video - 00:17:59 mins

How to Use SELECT INTO to Clean Dataset with Duplicates

Video - 00:14:01 mins

How to Change Data Types

Video - 00:23:30 mins

More Data Cleaning and Analysis

Video - 00:20:36 mins

How to Use Wildcards in SQL Server

Video - 00:18:40 mins

CASE Statement in SQL Server

Video - 00:30:31 mins

Handling NULL Value

Video - 00:20:43 mins

Subqueries

Accompanying File - DOWNLOAD !

Reading

Introduction to SQL Subqueries

Video - 00:10:02 mins

Subqueries Exercise (Actual)

Video - 00:25:10 mins

Subquery Exercise

Video - 00:15:24 mins

Correlated Subquery

Video - 00:25:41 mins

Subquery in Having Clause

Video - 00:23:49 mins

CommonTable Expressions (CTEs) - Execise I

Video - 00:23:21 mins

CommonTable Expressions (CTEs) - Execise II

Video - 00:31:30 mins

CommonTable Expressions (CTEs) - Execise III

Video - 00:17:15 mins

Views

Demonstration of VIEWS

Video - 00:7:00 mins

Introduction to VIEW in SQL Server

Video - 00:6:30 mins

How to ALTER and DROP a VIEW

Video - 00:11:46 mins

How to SECURE a VIEW

Video - 00:11:39 mins

Restricting Operations in VIEW

Video - 00:15:26 mins

Stored Procedures

Introduction to STORED PROCEDURES

Video - 00:10:08 mins

Creating First STORED PROCEDURES

Video - 00:18:30 mins

Introducing Parameters in STORED PROCEDURES

Video - 00:24:43 mins

If… Else… Statement

Video - 00:10:33 mins

Introducing OUTPUT Parameters in STORED PROCEDURES

Video - 00:24:46 mins

Windows Functions

Introduction to SQL Server Window Functions

Video - 00:10:02 mins

Aggregate Window Functions

Video - 00:23:24 mins

Ranking Window Functions

Video - 00:16:56 mins

Value Window Functions

Video - 00:13:18 mins

Window Functions Exercise I

Video - 00:13:18 mins

Window Functions Exercise II

Video - 00:23:50 mins

Window Functions Exercise III

Video - 00:20:22 mins

CAPSTONE PROJECT

SQL Capstone Project

Assignment

Announcements Reviews Live Classes Gradebook Certificate Course Info

Previous Next

Complete the course to unlock the certificate

SQL for Financial Analysis SQL Server

SQL for Financial Analysis