SQL Databases: Advanced Training
This training is designed for technicians and engineers looking to further develop their SQL skills.
According to your needs
In-person
On your site or at Vouvry
6 participants
CHF On demand
Course
Objectives
Master advanced SQL concepts, tailored to your needs.
Course
Program
Customized program, tailored to your needs.
Below are some example topics that can be covered during the training:
- Advanced rights and permissions management using schemas
- Relationships between tables
- Functions and stored procedures
- Performance optimization using indexes
- Implementing a maintenance plan using SQL Agent
- Advanced queries (ranking functions, variables, conditions)
- Retrieving data from another SQL Server using Linked Servers
- Designing and architecting complex databases
- Using SQL Server Profiler to monitor queries executed on the SQL Server
- Querying an AVEVA Historian server
- Data Definition Language (DDL) queries – create, modify, and delete tables without using a user interface
This list is not exhaustive. Please feel free to contact us so we can best meet your specific needs.
Interested in one of our courses?
Complete the form today and a member of our team will contact you shortly.