Introduction to SQL databases

Objectives (at the end of the course participants will be able to understand):
• What we mean by SQL
• The basics of SQL syntax
• Complex SELECT queries

Target audience: Personnel from production companies involved in working with SQL databases.

Duration: 2 days

Training agenda:
• Introduction
• Setup
• SQL language
• Tables (data, keys, structure)
• INSERT statement (RAW *)
• SELECT statement (CRUD)
• UPDATE statement (CRUD)
• DELETE instruction (RAW)
• Expressions, Conditions, Operators
• Clauses
• Table Composition (JOIN)
• SELECT statement (advanced)
• SQL optimization
• Advanced notions
• Discussions. Examination. End of course.
* Create, Read, Update, Delete

Tools presented:
• SQL (Languages)
• MS SQL Server

Trainer:
Over 15 years of experience in the industry and consulting with expertise in the use of course and training tools.

For more information, please contact us.