Introduction to SQL
Opis
wydawany jest certyfikat
Cele
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
Grupa docelowa
Developers, analysts, and other specialists who need to learn SQL basics.
Warunki wstępne
High-school knowledge of mathematics and PC skills. Basic knowledge of English.
Plan działania
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