Course description
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.
Upcoming start dates
Who should attend?
Prerequisites
High-school knowledge of mathematics and PC skills. Basic knowledge of English.
Training content
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
Certification / Credits
Objectives
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
Quick stats about Luxoft Training Center?
More than 200 training courses
Conducted over 1,500 training sessions
Customized training solutions for business
Contact this provider
Luxoft Training Center
Luxoft Training Center — an essential part of the global technology leader, Luxoft, a DXC Technology Company. We play a pivotal role in propelling B2B businesses forward by delivering customized training solutions. Emphasizing the significance of learning and employee development,...