Skip to content
Courses
Data Engineering and Analytics
Microsoft Dynamics 365
Animation Tools
Network and Security
Professional Development
Marketing
Graphic Design
Sales
Oracle Cloud
Communication Skills
IT Trending Courses
Cyber Security
Full Stack Engineer
E-Commerce
Data Engineering and Analytics
Programming
Career Path
Instructor Registration
Login/Register
Courses
Data Engineering and Analytics
Microsoft Dynamics 365
Animation Tools
Network and Security
Professional Development
Marketing
Graphic Design
Sales
Oracle Cloud
Communication Skills
IT Trending Courses
Cyber Security
Full Stack Engineer
E-Commerce
Data Engineering and Analytics
Programming
Career Path
Instructor Registration
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
0%
Complete
Mark as Complete
Sign in
Sign up
Sign in
Don’t have an account?
Sign up
Remember me
Lost your password?
Sign up
Already have an account?
Sign in