sql

Basics of SQL8

❯

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

Querying Data10

❯

1. 1SELECT Statement in SQL
2. 2SQL WHERE Clause
3. 3ORDER BY Clause in SQL
4. 4GROUP BY Clause in SQL
5. 5HAVING Clause in SQL
6. 6LIMIT / TOP Clause in SQL
7. 7DISTINCT Keyword in SQL
8. 8SQL Operators - AND, OR, NOT, IN, BETWEEN, LIKE
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 – String, Numeric, Date & Aggregate
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 – COMMIT, ROLLBACK, SAVEPOINT
5. 5SQL Cursors
6. 6SQL Error Handling – BEGIN...HANDLER, SIGNAL
7. 7Dynamic SQL

Database Design5

❯

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

Optimization3

❯

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

Security2

❯

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

Advanced Querying4

❯

1. 1Common Table Expressions in SQL
2. 2Window Functions in SQL – RANK, ROW_NUMBER, LEAD, LAG
3. 3SQL Pivot and Unpivot
4. 4Recursive Queries in SQL

Integrations4

❯

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