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 | |
|---|---|---|---|
December 9, 2024December 10, 2024December 11, 2024 | 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 |
January 20, 2025January 21, 2025January 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 |
February 17, 2025February 18, 2025February 19, 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 |
April 28, 2025April 29, 2025April 30, 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 |
Keep me posted on new sessions
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.
Prior knowledge courses
Follow-up courses
"The instructor was clearly very experienced and had a lot of knowledge about the subject."Mika
-
Hoge waardering
-
Praktijkgerichte trainingen
-
Gecertificeerde trainers
-
Eigen docenten