ProgramGuru
DS
DSA
Python
Java
SQL
Login
SQL Course
Chapter 1:
Basics of SQL
8
❯
1
Introduction to SQL
2
Installing SQL and SQL Tools
3
SQL Syntax and Statements
4
SQL Data Types
5
SQL CREATE TABLE Statement
6
SQL INSERT INTO Statement
7
SQL UPDATE Statement
8
SQL DELETE Statement
Chapter 2:
Querying Data
10
❯
1
SQL SELECT Statement
2
SQL WHERE Clause
3
SQL ORDER BY Clause
4
SQL GROUP BY Clause
5
SQL HAVING Clause
6
SQL LIMIT / TOP Clause
7
SQL DISTINCT Keyword
8
SQL Operators
9
SQL Aliases
10
SQL CASE Statement
Chapter 3:
SQL Joins
6
❯
1
SQL INNER JOIN
2
SQL LEFT JOIN
3
SQL RIGHT JOIN
4
SQL FULL OUTER JOIN
5
SQL SELF JOIN
6
SQL CROSS JOIN
Chapter 4:
Intermediate SQL
6
❯
1
SQL Subqueries
2
SQL Views
3
SQL Indexes
4
SQL Constraints
5
SQL Functions
6
SQL NULL Handling – IS NULL, COALESCE, IFNULL
Chapter 5:
Advanced SQL
7
❯
1
SQL Stored Procedures
2
SQL User Defined Functions (UDF)
3
SQL Triggers
4
SQL Transactions
5
SQL Cursors
6
SQL Error Handling
7
Dynamic SQL
Chapter 6:
Database Design
5
❯
1
SQL Database Normalization
2
SQL Denormalization
3
ER Diagrams and Schema Design
4
SQL Primary Key vs Unique Key
5
SQL Foreign Keys and Relationships
Chapter 7:
Optimization
3
❯
1
SQL Performance Tuning
2
SQL Execution Plans
3
Index Optimization in SQL
Chapter 8:
Security
2
❯
1
SQL Injection and Security
2
SQL User Management and Permissions
Chapter 9:
Advanced Querying
4
❯
1
SQL Common Table Expressions
2
SQL Window Functions
3
SQL Pivot and Unpivot
4
SQL Recursive Queries
Chapter 10:
Integrations
4
❯
1
SQL with Python
2
SQL with Java
3
SQL with Excel
4
Connecting to SQL Databases via JDBC/ODBC
Player Settings
Speed:
2s
Show Pseudocode
Show Output
Reset
Close