Introduction to SQL

Introduction to SQL

This course offers an introduction to SQL and gives participants the understanding and skills for searching and modifying data in SQL databases. Upon the completion of training, students will be able to perform database operations using SQL. The learning of theory is supported by examples and tasks performed by trainees under the instructor’s guidance.

Продолжительность
14 часы
Тип курсу
Онлайн
Мова
Англійська
Продолжительность
14 часы
Місцезнаходження
Онлайн
Мова
Англійська
Код
DEV-010_QA
етикетки
Intermediate
Тренінг для 7-8 чи більше людей? Налаштуйте тренінги для ваших конкретних потреб
Introduction to SQL
Продолжительность
14 часы
Місцезнаходження
Online
Мова
English
Код
DEV-010_QA
етикетки
Intermediate
€ 350 *
Тренінг для 7-8 чи більше людей? Налаштуйте тренінги для ваших конкретних потреб

опис

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.

сертифікат
Після проходження курсу видається сертифікат
на бланку Luxoft Training

Цілі

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.

Цільова аудиторія

Test designers, Test analysts, Test engineers, Test consultants, Test managers, and other specialists who need to learn SQL basics.

передумови

High-school knowledge of mathematics and PC skills. Basic knowledge of English.

Дорожня карта

  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 – 15 min]
  3. 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]
  4. Module 4. Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries [theory – 40 min, practice – 15 min]
  5. Module 5. Queries. SELECT​ statement for single table, filtering rows with WHERE, built-in functions [theory – 50 min, practice – 15 min]
  6. Module 6. Table joins. Selecting data from multiple linked tables [theory – 40 min, practice – 20 min]
  7. Module 7. Subqueries​. Using other query results in filtering rows and calculating additional columns [theory – 20 min, practice – 15 min]
  8. Module 8. Sorting and grouping data [theory – 15 min, practice – 15 min]
  9. 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

Залишилися запитання?
Зв'яжітьсяз нами