Course Content
SQL Complete Course (MySQL + PostgreSQL)
0/75
Introduction
00:58
What is Data? What is Structured Data?
03:46
How to Keep Structured Data?
02:30
Why SQL is needed?
03:50
SQL vs. Excel. When to Use?
04:28
What is a Database?
02:53
Relational vs Non-Relational Database
06:04
What is SQL?
04:17
Overview of RDBMS (MySQL, PostgreSQL, SQLite, SQLServer, Oracle)
02:48
SQL vs. No-SQL
08:40
What is Schema
02:41
Install MYSQL and MYSQL Workbench in MacOS
10:16
Install MySQL and MySQL Workbench in Windows
07:58
Install Xampp (for MySQL in MacOS)
04:46
Install Xampp (for MySQL in Windows)
07:47
Install SQLite (DB Browser) in MacOS
05:28
Install SQLite (DB Browser) in Windows
04:26
Install PostgreSQL in MacOS
06:59
Install PostgreSQL (pgadmin) in Windows
07:47
Why Normalise Data – Real World Analogy with Examples
08:50
Understanding 1NF, 2NF, 3NF, BCNF with examples
15:27
What is ER Diagram – Understand Entities, Attributes, Relationships, Keys
07:37
Relationship Types – ER Diagram
16:09
Basic SQL Commands with Real World Examples
30:16
WHERE Clause Operators – Basic SQL Commands
21:42
Data Types in SQL
10:34
Create a Table – Table Operations
07:50
Create Table with on Delete Rules
05:32
Alter a Table – Table Operations
06:15
Drop a Table – Table Operations
01:17
Truncate a Table – Table Operations
00:30
SQL Constraints
06:12
DML – Insert Update, Delete, Replace, Truncate Records in a Table
13:11
Testing CRUD in PostgreSQL
02:27
What is JOIN in SQL? Why Use JOIN with Practical Examples
20:58
INNER JOIN
03:15
LEFT JOIN
07:35
RIGHT JOIN
07:56
FULL OUTER JOIN
07:04
SELF JOIN
02:19
CROSS JOIN
07:43
JOIN vs Subquery
06:08
JOIN Practice Problems
04:21
Aggregation Functions and Group By
27:38
What is Having Clause? Having vs Where
27:38
Using Aggregates with JOINs and Practice Problems
03:29
Subqueries in SELECT, WHERE, FROM
13:21
IN, NOT IN, EXISTS with Subqueries
12:56
Any, ALL with Subqueries
12:03
Views in SQL
05:53
Indexes in SQL
04:47
Types of Indexes
09:20
Performance Tips, Query Planning and Practice Problems
08:36
What is Transaction, SAVEPOINT, ROLLBACK TO with Examples
21:03
ACID Principles in Transaction
10:52
Stored Procedure in SQL
24:03
Triggers in SQL
13:30
User Defined Functions (UDF’s)
17:53
Practice Problems and Real-World Use Cases
07:07
Window Functions
25:56
Practice Problems
03:11
Why use Window Functions?
01:16
Common Table Expression (CTE) and Recursion
00:00
Create USER, ROLES, GRANT and REVOKE – Security and Access Control
13:54
SQl Injection and Parameterised Queries
03:28
Hashing and Encrypting Passwords
05:33
RBAC
09:58
E-Commerce Orders System Project
31:12
Practice Projects Queries
06:15
Hospital Appointment System Project
06:57
School Management System Project
09:40
Book Store Project
06:30
Online Food Delivery Project and Bonus Exercises
17:15
Interview Based Questions and Concepts
25:18
Resources
SQL Command Center (MySQL + PostgreSQL) in Hindi
Previous
Next
0% Complete