Introduction to SQL
Description
This course offers participants an introduction to SQL’s basic capabilities which they can then use in their work. It provides an understanding and skills for searching and modifying data in SQL databases.
Overall, 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.
is issued on the Luxoft Training form
Objectives
Upon the completion of training, students will be able to perform database operations using SQL.
- Perform a simple search operation;
- Perform a search using several tables;
- Perform a search with sorting;
- Use basic aggregate and window functions;
- Modify data in a database.
Target Audience
Test designers, Test analysts, Test engineers, Test consultants, Test managers, and other specialists who need to learn SQL basics.
Prerequisites
High-school knowledge of mathematics and PC skills. Basic knowledge of English.
Roadmap
- Module 1. Introduction to relational databases. Normalization [theory – 50 min]
- Module 2. Basics of DDL. Creating tables and indexes. SQL Data types [theory – 45 min, practice – 15 min]
- Module 3. Referential integrity. Restricting column values to values present in referenced table only. Foreign keys and REFERENCES clause [theory – 15 min, practice – 10 min]
- Module 4. Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries [theory – 40 min, practice – 15 min]
- Module 5. Queries. SELECT statement for single table, filtering rows with WHERE, built-in functions [theory – 50 min, practice – 15 min]
- Module 6. Table joins. Selecting data from multiple linked tables [theory – 40 min, practice – 20 min]
- Module 7. Subqueries. Using other query results in filtering rows and calculating additional columns [theory – 20 min, practice – 15 min]
- Module 8. Sorting and grouping data [theory – 15 min, practice – 15 min]
- Module 9. Aggregate functions (COUNT, MIN, MAX, SUM) [theory – 30 min, practice – 20 min]
Lab "Additional tasks" setup [practice – 15 min]
Lab "Additional tasks" [practice – 160 min]
Lab "Additional tasks" solution review [practice – 40 min]
Theory – 5.15h; Practice – 5.30h