SQL Database: Basic Training
This training is designed for technicians and engineers looking to learn the fundamental principles of database systems.
1 day
In-person
On your site or at Vouvry
6 participants
CHF 800
Course
Objectives
Understand the architecture of a database and the different objects it contains. Master database data management based on the CRUD principle:
- Create: add data
- Read: efficiently query data
- Update: update existing data
- Delete: delete data
Course
Program
- Introduction to databases
- Database structure
- Overview of SSMS (SQL Server Management Studio – tool for managing a SQL Server database)
- Managing database structure
- Data Manipulation Language (DML) queries
- Querying data – basic concepts
- Querying data – filtering results
- Querying data – sorting results
- Querying data – grouping results
- Adding / modifying / deleting data
- Joins and useful functions
Practical exercises are provided throughout the training to apply and reinforce the concepts presented.
Interested in one of our courses?
Complete the form today and a member of our team will contact you shortly.