SQL Command Center (MySQL + PostgreSQL) in Hindi

A Comprehensive Guide to MySQL and PostgreSQL for Data Analysis and Development

Master the world’s two most popular databases in one comprehensive journey.

Bridge the gap from beginner to expert with a hands-on curriculum designed for the modern data landscape. You will go beyond basic queries, learning to architect complex databases, optimize performance, and solve real-world data challenges using both MySQL and PostgreSQL.

No Prior SQL Knowledge Needed: This course starts with the absolute basics. You don’t need to have ever seen a line of code before.
Computer Access: A Mac, Windows, or Linux laptop/desktop with at least 4GB of RAM (to run the database software comfortably).
Software Installation: We will walk you through the free installation of MySQL, PostgreSQL, and their respective management tools (like MySQL Workbench and pgAdmin).
Basic Computer Literacy: You should be comfortable downloading files, installing software, and navigating your computer's folders.

Aspiring Data Analysts: Those who want to move beyond Excel and learn to extract insights from massive datasets.
Future Web Developers: Students looking to build robust backends for applications using industry-standard databases.
Career Switchers: Professionals moving into tech who need a high-demand skill that applies to almost every industry.
The "Self-Taught" Coder: Those who know a bit of SQL but want to formalize their knowledge and understand the nuances between MySQL and PostgreSQL.
Computer Science Students: Anyone looking for a practical, hands-on supplement to theoretical database classes.
Business Professionals: Managers or marketers who want to stop relying on tech teams and start pulling their own data reports.

Course Content

SQL Complete Course (MySQL + PostgreSQL)

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

A course by

Nikhil Agarwal

Senior Full Stack Engineer | Founder, Coding Technyks

Student Ratings & Reviews

No Review Yet

SQL Command Center (MySQL + PostgreSQL) in Hindi

What Will You Learn?

Requirements

Audience

Course Content

SQL Complete Course (MySQL + PostgreSQL)

Introduction

What is Data? What is Structured Data?

How to Keep Structured Data?

Why SQL is needed?

SQL vs. Excel. When to Use?

What is a Database?

Relational vs Non-Relational Database

What is SQL?

Overview of RDBMS (MySQL, PostgreSQL, SQLite, SQLServer, Oracle)

SQL vs. No-SQL

What is Schema

Install MYSQL and MYSQL Workbench in MacOS

Install MySQL and MySQL Workbench in Windows

Install Xampp (for MySQL in MacOS)

Install Xampp (for MySQL in Windows)

Install SQLite (DB Browser) in MacOS

Install SQLite (DB Browser) in Windows

Install PostgreSQL in MacOS

Install PostgreSQL (pgadmin) in Windows

Why Normalise Data – Real World Analogy with Examples

Understanding 1NF, 2NF, 3NF, BCNF with examples

What is ER Diagram – Understand Entities, Attributes, Relationships, Keys

Relationship Types – ER Diagram

Basic SQL Commands with Real World Examples

WHERE Clause Operators – Basic SQL Commands

Data Types in SQL

Create a Table – Table Operations

Create Table with on Delete Rules

Alter a Table – Table Operations

Drop a Table – Table Operations

Truncate a Table – Table Operations

SQL Constraints

DML – Insert Update, Delete, Replace, Truncate Records in a Table

Testing CRUD in PostgreSQL

What is JOIN in SQL? Why Use JOIN with Practical Examples

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL OUTER JOIN

SELF JOIN

CROSS JOIN

JOIN vs Subquery

JOIN Practice Problems

Aggregation Functions and Group By

What is Having Clause? Having vs Where

Using Aggregates with JOINs and Practice Problems

Subqueries in SELECT, WHERE, FROM

IN, NOT IN, EXISTS with Subqueries

Any, ALL with Subqueries

Views in SQL

Indexes in SQL

Types of Indexes

Performance Tips, Query Planning and Practice Problems

What is Transaction, SAVEPOINT, ROLLBACK TO with Examples

ACID Principles in Transaction

Stored Procedure in SQL

Triggers in SQL

User Defined Functions (UDF’s)

Practice Problems and Real-World Use Cases

Window Functions

Practice Problems

Why use Window Functions?

Common Table Expression (CTE) and Recursion

Create USER, ROLES, GRANT and REVOKE – Security and Access Control

SQl Injection and Parameterised Queries

Hashing and Encrypting Passwords

RBAC

E-Commerce Orders System Project

Practice Projects Queries

Hospital Appointment System Project

School Management System Project

Book Store Project

Online Food Delivery Project and Bonus Exercises

Interview Based Questions and Concepts