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
Sign Up
Duration
16 hours
Location
Online
Language
English
Code
DEV-010
Schedule and prices
€ 315
Training for 7-8 or more people? Customize trainings for your specific needs
Introduction to SQL
Sign Up
Duration
16 hours
Location
Online
Language
English
Code
DEV-010
Schedule and prices
€ 315
Training for 7-8 or more people? Customize trainings for your specific needs

Description

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.
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
Schedule and prices
View:
Register for the next course
Registering in advance ensures you have priority. We’ll notify you when we schedule the next course on this topic
+
Courses you may be interested in
Oracle® 11g: Performance Tuning of SQL Expressions
The course describes the methodology that can be used for solving various performance problems related to Oracle® SQL – more specifically the 11g version.
DB-002
32 hours
Sign Up
Oracle® 11g, Basics of PL/SQL Language
The course is an introduction to the Oracle PL/SQL procedural language. The language version used in DBMS 11g is considered in this training.
DB-018
24 hours
Sign Up
Introduction to SQL for Testers
This 16 hour course aims to teach participants how to use the SQL programming language to query a database for testing purposes.
View Catalog
Your benefits
Expertise
Our trainers are industry experts, involved in software development project
Live training
Facilitated online so that you can interact with the trainer and other participants
Practice
A focus on helping you practice your new skills
Still have questions?
Connect with us
Thank you.
Your request has been received.
Thank you!
The form has been submitted successfully.