Description
Training objective: The learner will be able to write SQL statements and use language extensions. They will also be able to modify structures, define integrity constraints, load data, and utilize transactions.
Learning Objectives
- Create database tables, primary keys, and uniqueness constraints
- Develop various database update queries
- Understand the SQL Server Management Studio environment
- Implement indexes on the database to improve performance
- Add exception handling and transactions in triggers and stored procedures
- Load multiple data sets into the database
Target Audience
System Engineers
Developers
Prerequisites
Strong knowledge of the SQL language
Program Outline
Informations
Duration
5 jour(s)
35h
Tarif
3250 € HT
HT
Similar Trainings
IA & Data
Cloud Migration
2 jour(s)
Sur demande
IA & Data
AI Agents – Designing Autonomous Systems with LangChain and LangGraph – Advanced
3 jour(s)
Sur demande
IA & Data
European AI Act — Understanding your obligations and ensuring compliance — Beginner level
1 jour(s)
Sur demande
IA & Data
Data Analysis with Microsoft Power BI (4-167)
3 jour(s)
2200 € HT