Introduction to SQL - course RUB 19,900. from IBS Training Center, training 16 hours, Date: December 3, 2023.
Miscellaneous / / December 06, 2023
Topics covered:
Module 1. Introduction to relational databases. Normalization
(theory – 1.1 hours)
Module 2. DDL Basics. Creating tables and indexes. Basic SQL Data Types
(theory – 1 hour)
Module 3. Referential integrity. Limiting the allowed values for a column based on the reference table. REFERENCES expression
[theory – 0.3 hours)
Module 4. Queries on one table, SELECT expression, checking conditions on attribute values of one WHERE record, built-in functions
(theory – 1.1 hours)
Lab “Setting up” (practice – 0.2 hours)
Lab "Data sampling" and solution review (practice - 0.4 hours)
Module 5. Table joins. Retrieving data from multiple related tables
(theory – 0.9 hours)
Module 6. Subqueries. Using the results of one query to select records and calculate additional columns in another query
(theory – 0.4 hours)
Module 7. Sorting and grouping data
(theory – 0.3 hours)
Module 8. Aggregate functions (COUNT, MIN, MAX, SUM)
(theory – 0.7 hours)
Lab "Joins, subqueries, aggregation functions" and solution overview
(practice – 0.4 hours)
Lab "Grouping and sorting" and review of the solution (practice - 0.4 hours)
Module 9. Window functions
(theory – 0.9 hours)
Lab "Window functions" and overview of the solution (practice - 0.6 hours)
Module 10. How are SQL queries processed? Query Execution Plan
(theory – 0.3 hours)
Module 11. Adding, updating and deleting data (INSERT, UPDATE, DELETE). Using these operations with subqueries
(theory – 0.9 hours)
Lab "INSERT, UPDATE, DELETE" and solution overview (practice – 0.4 hours)
Module 12. Transaction concept. COMMIT and ROLLBACK. ACID transaction properties
(theory – 0.7 hours.)
Lab "Additional tasks" setting (practice – 0.3 hours.)
Lab "Additional tasks" (practice – 3.6 hours)
Lab "Additional tasks" solution overview ([0.9 hours)
The course covers the basics of Cassandra 4-x architecture, development of conceptual, logical and physical data models. Covers all the necessary technical details for using Cassandra for scalable storing data in Java projects, as well as for monitoring, configuration and configuration productivity.
4
51 500 ₽