SQL Course

Basics of SQL8

❯

1. 1Introduction to SQL
2. 2Installing SQL and SQL Tools
3. 3SQL Syntax and Statements
4. 4SQL Data Types
5. 5SQL CREATE TABLE Statement
6. 6SQL INSERT INTO Statement
7. 7SQL UPDATE Statement
8. 8SQL DELETE Statement

Querying Data10

❯

1. 1SQL SELECT Statement
2. 2SQL WHERE Clause
3. 3SQL ORDER BY Clause
4. 4SQL GROUP BY Clause
5. 5SQL HAVING Clause
6. 6SQL LIMIT / TOP Clause
7. 7SQL DISTINCT Keyword
8. 8SQL Operators
9. 9SQL Aliases
10. 10SQL CASE Statement

SQL Joins6

❯

1. 1SQL INNER JOIN
2. 2SQL LEFT JOIN
3. 3SQL RIGHT JOIN
4. 4SQL FULL OUTER JOIN
5. 5SQL SELF JOIN
6. 6SQL CROSS JOIN

Intermediate SQL6

❯

1. 1SQL Subqueries
2. 2SQL Views
3. 3SQL Indexes
4. 4SQL Constraints
5. 5SQL Functions
6. 6SQL NULL Handling – IS NULL, COALESCE, IFNULL

Advanced SQL7

❯

1. 1SQL Stored Procedures
2. 2SQL User Defined Functions (UDF)
3. 3SQL Triggers
4. 4SQL Transactions
5. 5SQL Cursors
6. 6SQL Error Handling
7. 7Dynamic SQL

Database Design5

❯

1. 1SQL Database Normalization
2. 2SQL Denormalization
3. 3ER Diagrams and Schema Design
4. 4SQL Primary Key vs Unique Key
5. 5SQL Foreign Keys and Relationships

Optimization3

❯

1. 1SQL Performance Tuning
2. 2SQL Execution Plans
3. 3Index Optimization in SQL

Security2

❯

1. 1SQL Injection and Security
2. 2SQL User Management and Permissions

Advanced Querying4

❯

1. 1SQL Common Table Expressions
2. 2SQL Window Functions
3. 3SQL Pivot and Unpivot
4. 4SQL Recursive Queries

Integrations4

❯

1. 1SQL with Python
2. 2SQL with Java
3. 3SQL with Excel
4. 4Connecting to SQL Databases via JDBC/ODBC