SQL Command Center (MySQL + PostgreSQL) in Hindi
Introduction
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
More
Announcements
Reviews
Course Info
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
Finish Course Early?
You have not completed all required lessons and assessments.
Your Progress
0%
Go Back to Course
Complete Anyway
