Introduction to SQL

This training will help students acquire practical skills required to use SQL. The learning of theory is supported by examples and tasks performed by trainees under the instructor’s guidance.

Upon the completion of training, students will be able to perform database operations using SQL.

They will be able to:

• Perform simple search operation
• Perform search using several tables
• Perform search with sorting
• Use basic aggregate and window functions
• Modify data in a database

Module 1. Introduction to relational databases​. Normalization [theory – 1.1 h]

Module 2. Basics of DDL​. Creating tables and indexes. SQL Data types [theory – 1h]

Module 3. Referential integrity​. Restricting column values to values present in referenced table only. Foreign keys and REFERENCES clause [theory – 0.3h]

Module 4 Queries. SELECT​ statement for single table, filtering rows with WHERE, built-in functions [theory – 1.1h]

Lab Setup [practice – 0.2h]

Lab "Select" and solution review [practice – 0.4h]

Module 5. Table joins. Selecting data from multiple linked tables [theory – 0.9h]

Module 6. Subqueries​. Using other query results in filtering rows and calculating additional columns [theory – 0.4h]

Module 7. Sorting and grouping data [theory – 0.3h]

Module 8. Aggregate functions (COUNT, MIN, MAX, SUM)​ [theory – 0.7h]

Lab "Join, subqueries, and aggregate functions" and solution review [practice – 0.4h]

Lab "GROUP BY and HAVING, ORDER BY" and solution review [practice – 0.4h]

Module 9. Window functions​. Complex aggregations [theory – 0.9h]

Lab "Window functions" and solution review [practice – 0.6h]

Module 10. How are SQL queries handled?​ Execution plan [theory – 0.3h]

Module 11. Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries [theory – 0.9h]

Lab "INSERT, UPDATE, DELETE" and solution review [practice – 0.4h]

Module 12. General concepts of transactions and data integrity. COMMIT and ROLLBACK statements. ACID properties of transactions [theory – 0.7h]

Lab "Additional tasks" setup [practice – 0.3h]

Lab "Additional tasks" [practice – 3.6h]

Lab "Additional tasks" solution review [practice – 0.9h]

Theory – 8.7h; Practice – 7.3h