Opleiding: Developing Databases using SQL Server

Learn the essentials to implementing databases with SQL Server

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

AI-Boosted: Students are encouraged to explore the use of AI tools (such as copilot) to avoid repetitive tasks and accelerate understanding of complex concepts.
- 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 Implem…