Introduction to SQL

This course is designed to equip you with both the theoretical knowledge and hands-on experience needed to excel in database management. Whether you are a beginner or looking to strengthen your existing skills, this course will guide you through the essential concepts and advanced techniques used in the industry today.

What You'll Learn:

• Relational Database Foundations: Start with an introduction to relational databases, understanding the theory behind normalization and why it’s crucial for data integrity.
• SQL Essentials: Explore the core operations of SQL, including creating tables and indexes, inserting, updating, and deleting data, all while learning the importance of data types and referential integrity.
• Advanced Query Techniques: Learn how to select and filter data using subqueries, joins, and built-in SQL functions. Master aggregate functions, sorting, grouping, and even window functions for complex data aggregations.
• Database Management and Optimization: Delve into the execution plan of SQL queries and how the database processes them. Understand how to maintain data integrity through transactions, learning the importance of COMMIT, ROLLBACK, and ACID properties.

Course Highlights:

• Hands-On Training: Each module combines theoretical lectures with practical exercises based on the covered material. You'll have the opportunity to apply what you learn in real time, reinforcing key concepts throughout the course.
• Real-World Application: In the final part of the course, you'll engage in several practical exercises that will bring everything together. These labs are designed to challenge you with tasks that test your understanding of the entire course, ensuring you can apply SQL effectively in real-world scenarios.

By the end of this course, you will:

1. Understand relational database theory, including normalization and data integrity.
2. Be able to perform complex SQL operations, including creating, modifying, and querying databases.
3. Apply advanced techniques such as subqueries, joins, and window functions to solve complex data problems.
4. Optimize SQL queries and manage transactions effectively, ensuring data accuracy and performance in large-scale databases.

This course is perfect for anyone looking to build a solid foundation in SQL and relational databases, with practical applications that will take your data management skills to the next level.

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

1. Perform a simple search operation
2. Perform a search using several tables
3. Perform a search by sorting
4. Use basic aggregate and window functions
5. Modify data in a database.

1. Module 1. Introduction to relational databases​. Normalization [theory – 50 min]
2. Module 2. Basics of DDL​. Creating tables and indexes. SQL Data types [theory – 45 min, practice – 30 min]
3. Module 3. Referential integrity​. Restricting column values to values present in the referenced table only. Foreign keys and REFERENCES clause [theory – 15 min, practice – 15 min]
4. Module 4. Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries [theory – 40 min, practice – 20 min]
5. Module 5 Queries. SELECT​ statement for a single table, filtering rows with WHERE, built-in functions [theory – 50 min, practice – 20 min]
6. Module 6. Table joins. Selecting data from multiple linked tables [theory – 40 min, practice – 30 min]
7. Module 7. Subqueries​. Using other query results in filtering rows and calculating additional columns [theory – 20 min, practice – 20 min]
8. Module 8. Aggregate functions (COUNT, MIN, MAX, SUM)​ [theory – 15 min, practice – 20 min]
9. Module 9. Sorting and grouping data [theory – 30 min, practice – 30 min]
10. Module 10. Window functions​. Complex aggregations [theory – 40 min, practice – 30 min]
11. Module 11. How are SQL queries handled?​ Execution plan [theory – 15 min]
12. Module 12. General concepts of transactions and data integrity. COMMIT and ROLLBACK statements. ACID properties of transactions [theory – 30 min]

Lab "Additional tasks" setup [practice – 15 min]

Lab "Additional tasks" [practice – 150 min]

Lab "Additional tasks" solution review [practice – 40 min]

Theory – 6.5h; Practice – 7h

In total 16 Academic hours