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