Introduction to SQL
Opis
This course offers the students an introduction to SQL’s basic capabilities which they can use in their work. It provides an understanding and skills of searching and modifying data in SQL databases.
It 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.
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