Course Content
Introduction to SQL
0/8
Introduction to SQL
07:57
SQL Server
04:42
The Installation
07:12
SSMS Interface
07:41
Create Database
05:14
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
00:00
BULK INSERT Dataset
00:00
GROUP BY and ORDER BY Clauses
00:00
WHERE Clause
00:00
UPDATE Statement
00:00
Constraints
This module includes an accompanying file
0/8
Accompanying File – DOWNLOAD !
Why CONSTRAINTS ?
00:00
Types of Constant (Introduction)
19:16
NOT NULL Primary Key Defaut Constraints
00:00
How to ALTER Table with Constraints
00:00
FOREIGN KEY Constraints
00:00
CHECK Constraints
00:00
UNIQUES Constraints
00:00
JOINS
This module includes an accompanying file
0/7
Accompanying File – DOWNLOAD !
Introduction to JOINS
00:00
Movie Database (For JOIN Practice)
00:00
First Challenge Using JOINS
00:00
Second Challege Using JOINS
00:00
RIGHT and FULL OUTER JOIN Uses
00:00
SELF JOIN Use Case
00:00
SQL Functions
0/11
Introduction to Functions
SQL Server Operations
How to use NUL, ISNULL, and COALESCE to Handle NULL VALUE
00:00
Using UNION, UNIONALL, INTERCEPT, EXCEPT
19:11
Finding Duplicate on Dataset
00:00
How to Use SELECT INTO to Clean Dataset with Duplicates
00:00
How to Change Data Types
00:00
More Data Cleaning and Analysis
00:00
How to Use Wildcards in SQL Server
00:00
CASE Statement in SQL Server
00:00
Handling NULL Value
00:00
Subqueries
This module includes an accompanying file
0/9
Accompanying File – DOWNLOAD !
Introduction to SQL Subqueries
10:02
Subqueries Exercise (Actual)
00:00
Subquery Exercise
00:00
Correlated Subquery
00:00
Subquery in Having Clause
00:00
CommonTable Expressions (CTEs) – Execise I
00:00
CommonTable Expressions (CTEs) – Execise II
00:00
CommonTable Expressions (CTEs) – Execise III
00:00
Views
0/5
Demonstration of VIEWS
00:00
Introduction to VIEW in SQL Server
00:00
How to ALTER and DROP a VIEW
00:00
How to SECURE a VIEW
00:00
Restricting Operations in VIEW
00:00
Stored Procedures
0/5
Introduction to STORED PROCEDURES
00:00
Creating First STORED PROCEDURES
00:00
Introducing Parameters in STORED PROCEDURES
24:43
If… Else… Statement
00:00
Introducing OUTPUT Parameters in STORED PROCEDURES
00:00
Windows Functions
0/7
Introduction to SQL Server Window Functions
00:00
Aggregate Window Functions
00:00
Ranking Window Functions
00:00
Value Window Functions
00:00
Window Functions Exercise I
00:00
Window Functions Exercise II
00:00
Window Functions Exercise III
00:00
CAPSTONE PROJECT
0/1
SQL Capstone Project
SQL for Data Analysis
Previous
Next
0% Complete