course
Developing SQL Databases
Learn the essentials to implementing databases with SQL Server
Description
As a developer you learn how to implement a Microsoft SQL Server database. The course focuses on hans on experience with all common database objects and concepts. You learn how to create tables and other objects like views, functions, stored procedures and triggers. This training also includes indexing, execution plans, concurrency and using constraint for data integrity.
After completing this course, you will be able to:
- Design and Implement Tables, Views, Stored Procedures, User Defined Functions and Triggers
- Ensure Data Integrity through Constraints
- Describe, implement and optimize indexes, including Columnstore indexes
- Understand and implement concurrency in SQL Server
Prior Knowledge
Subjects of Querying Data with Transact-SQL
Subjects
- Introduction Database Development
- Design and Implement Tables
- Ensure Data Integrity through Constraints
- Describe indexes, including Columnstore indexes
- Understand, monitor and optimize Query Execution Plans and Statistics
- Design and Implement Views
- Design and Implement Stored Procedures
- Design and Implement User Defined Functions
- Respond to data manipulation using triggers
- Understand and handle concurrency, including locking and blocking
Read more
Schedule
| Start date | Duration | Location | |
|---|---|---|---|
April 28, 2025April 29, 2025April 30, 2025 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
May 19, 2025May 20, 2025May 21, 2025 | 3 days | Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
July 14, 2025July 15, 2025July 16, 2025 | 3 days | Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
September 10, 2025September 11, 2025September 12, 2025 | 3 days | Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information Utrecht / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
October 20, 2025October 21, 2025October 22, 2025 | 3 days | Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information Veenendaal / Remote This is a hybrid training and can be followed remotely. More information | Sign up |
All courses can also be conducted within your organization as customized or incompany training.
Our training advisors are happy to help you provide personal advice or find Incompany training within your organization.
Trainers
Prior knowledge courses
Follow-up courses
"Trainer who knows his profession!"Marc
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten