Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Mastering SQL: From Basics to Advanced Techniques
Introduction to SQL
Introduction to SQL (18:30)
MYSQL Workbench Installation
MySQL Workbench Installation for Windows (5:04)
MySQL Workbench Installation for MAC (5:27)
Importing SQL files in Workbench
Importing SQL files in Workbench (3:25)
Create Database
Create Database (33:51)
Import Export - DB Backup
Import Export - DB Backup (17:38)
Alter
Alter (16:51)
Select
Select (31:47)
SQL Functions - Order By, Limit
SQL Functions - Order By, Limit (5:02)
Group By
Group By (4:05)
Having
Having (3:59)
Union
Union (4:17)
Insert
Insert (8:46)
Update and Delete Document
Update and Delete Document (6:14)
Like and ILike (Wildcards)
Like and ILike (Wildcards) (6:30)
SQL Joins
SQL Joins (4:58)
Joins
Joins (13:23)
Inner Join
Inner Join (7:47)
Full Outer Join
Full Outer Join (4:08)
Left Outer Join
Left Outer Join (5:27)
Right Outer Join
Right Outer Join (4:18)
SQL Query Optimization
SQL Query Optimization (8:40)
Common Table Expression (CTE)
Common Table Expression (CTE) (4:24)
Clustered and Non Clustered Index
Clustered and Non Clustered Index (3:28)
Aggregate Functions in SQL
Aggregate functions in SQL (5:21)
Numeric and Temporal Functions
Numeric and Temporal Functions (21:40)
String Functions
String Functions (26:48)
Window Functions
Window Functions - Part 1 (9:51)
Window Functions - Part 2 (8:12)
Window Functions - Part 3 (11:03)
Window Functions - Part 4 (14:08)
Window Functions - Part 5 (9:44)
Subqueries
Subqueries (5:24)
Temporary Tables
Temporary Tables (5:47)
Types of Normal Forms
Types of Normal Forms - Part 1 (10:07)
Types of Normal Forms - Part 2 (5:23)
Collections and Documents
Collections and Documents (11:56)
Coalesce & IFnull
Coalesce & IFnull (4:31)
AWS RDS
AWS RDS (19:08)
Database Normalization
Database Normalization (5:48)
Introduction to MongoDB (Installation)
Introduction to MongoDB (Installation) (12:15)
Datatypes, Insert and Query Documents in MongoDB Database
Datatypes, Insert and Query Documents in MongoDB Database (9:11)
Introduction to NoSQL and its Significance
Introduction to NoSQL and its Significance (10:57)
Introduction to Reliability
Introduction to Reliability (34:03)
JSON & its Features
JSON & its Features (9:31)
JSON Datatypes
JSON Datatypes (11:04)
Large Databases and Clustering
Large Databases and Clustering (29:15)
Metadata
Metadata (29:15)
Privileges and Roles
Privileges and Roles (14:55)
Server Client Configurations
Server Client Configurations (18:48)
SQL Views
SQL Views (5:23)
Transactions and Locking
Transactions and Locking - Part 1 (6:51)
Transactions and Locking - Part 2 (5:39)
Transactions and Locking - Part 3 (14:38)
Transactions and Locking - Part 4 (11:39)
Triggers
Triggers - Part 1 (5:21)
Triggers - Part 2 (12:05)
Triggers - Part 3 (10:15)
Triggers - Part 4 (9:44)
Cloud Exposure Fetching data
Cloud Exposure Fetching data (7:59)
Case Statement
Case Statement (6:41)
Quiz
Quiz
Update and Delete Document
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock