Shopping Cart

No products in the basket.
Course Content
Introduction to SQL
0/8
Introduction to SQL
07:57
SQL Server
04:42
The Installation
07:12
Create Database
05:14
SSMS Interface
07:41
First SELECT Query
07:34
Data Types
15:29
SQL Command and Types
10:48
SQL Basics
This module includes an accompanying file
0/10
Accompanying File – DOWNLOAD !
Introduction to TABLES
10:07
Creating TABLES
10:09
Inserting ROWS of Data
11:13
Retreiving Data from Table
06:07
DELETE, TRUNCATE, & DROP Keywords
16:43
BULK INSERT Dataset
12:32
GROUP BY and ORDER BY Clauses
17:03
WHERE Clause
10:58
UPDATE Statement
17:03
Constraints
This module includes an accompanying file
0/8
Accompanying File – DOWNLOAD !
Why CONSTRAINTS ?
05:44
Types of Constant (Introduction)
19:16
NOT NULL Primary Key Defaut Constraints
10:57
How to ALTER Table with Constraints
23:40
FOREIGN KEY Constraints
26:47
CHECK Constraints
21:06
UNIQUES Constraints
26:47
JOINS
This module includes an accompanying file
0/7
Accompanying File – DOWNLOAD !
Introduction to JOINS
17:10
Movie Database (For JOIN Practice)
05:08
First Challenge Using JOINS
20:04
Second Challege Using JOINS
17:32
RIGHT and FULL OUTER JOIN Uses
12:00
SELF JOIN Use Case
13:53
SQL Functions
0/11
Introduction to Functions
SQL Server Operations
How to use NUL, ISNULL, and COALESCE to Handle NULL VALUE
20:47
Using UNION, UNIONALL, INTERCEPT, EXCEPT
19:11
Finding Duplicate on Dataset
17:59
How to Use SELECT INTO to Clean Dataset with Duplicates
14:01
How to Change Data Types
23:30
More Data Cleaning and Analysis
20:36
How to Use Wildcards in SQL Server
18:40
CASE Statement in SQL Server
30:31
Handling NULL Value
20:43
Subqueries
This module includes an accompanying file
0/9
Accompanying File – DOWNLOAD !
Introduction to SQL Subqueries
10:02
Subqueries Exercise (Actual)
25:10
Subquery Exercise
15:24
Correlated Subquery
25:41
Subquery in Having Clause
23:49
CommonTable Expressions (CTEs) – Execise I
23:21
CommonTable Expressions (CTEs) – Execise II
31:30
CommonTable Expressions (CTEs) – Execise III
17:15
Views
0/5
Demonstration of VIEWS
07:00
Introduction to VIEW in SQL Server
06:30
How to ALTER and DROP a VIEW
11:46
How to SECURE a VIEW
11:39
Restricting Operations in VIEW
15:26
Stored Procedures
0/5
Introduction to STORED PROCEDURES
10:08
Creating First STORED PROCEDURES
18:30
Introducing Parameters in STORED PROCEDURES
24:43
If… Else… Statement
10:33
Introducing OUTPUT Parameters in STORED PROCEDURES
24:46
Windows Functions
0/7
Introduction to SQL Server Window Functions
10:02
Aggregate Window Functions
23:24
Ranking Window Functions
16:56
Value Window Functions
13:18
Window Functions Exercise I
13:18
Window Functions Exercise II
23:50
Window Functions Exercise III
20:22
CAPSTONE PROJECT
0/1
SQL Capstone Project
SQL for Financial Analysis
Previous
Next
0% Complete