Introduction to SQL

This training offers an introduction to SQL and helps participants develop the necessary skills for searching and modifying data in SQL databases. It is aimed at developers, analysts and other specialists who need to learn SQL basics.

16 hours

Online

English

DEV-010

Introduction to SQL

Duration

16 hours

Location

Online

Language

English

Code

DEV-010

Schedule and prices

400.00 *

Training for 7-8 or more people? Customize trainings for your specific needs

Introduction to SQL

Duration

16 hours

Location

Online

Language

English

Code

DEV-010

Schedule and prices

400.00 *

Training for 7-8 or more people? Customize trainings for your specific needs

Description

After completing the course, a certificate
is issued on the Luxoft Training form

Objectives

Perform simple search operations
Perform search using several tables
Perform search with sorting
Modify data in a database

Target Audience

Developers, analysts and other specialists who need to learn SQL basics.

Roadmap

Introduction to relational databases. Normalization
Basics of DDL. Creating tables and indexes. SQL Data types
Referential integrity. Restricting column values to values present in referenced table only. Foreign keys and REFERENCES clause
Queries. SELECT statement for single table, filtering rows with WHERE, built-in functions
Practice
Table joins. Selecting data from multiple linked tables
Subqueries. Using other query results in filtering rows and calculating additional columns
Sorting and grouping data
Aggregate functions (COUNT, MIN, MAX, SUM)
Practice
Window functions. Complex aggregations
Practice
How are SQL queries handled? Execution plan
Insert, update, and delete data (INSERT, UPDATE, DELETE). Using these operations with subqueries
Practice
General concepts of transactions and data integrity. COMMIT and ROLLBACK statements. ACID properties of transactions
Practice