Implementing databases with SQL Server

Course outline

As a developer you learn the essentials of how to implement a Microsoft SQL Server database. You learn how to create tables and other objects like views, functions, stored procedures and trigger. This training also includes indexing tables, in-memory tables and using constraint for data integrity.

During this course you have extra time to explore the many SQL Server capabilities on your own.

This training is provided in 4 days (MS20762E) and 5 days (MS20762). At day 5 we discuss the topics Managed Code, XML, Spatial Data and File Store. When you're interested in these topics or you're preparing for the Microsoft exam, we advise you to follow all 5 days.

After completing this course, you will be able to: - Design and Implement Tables, Views, Stored Procedures, User Defined Functions, Triggers and In-Memory Tables- Ensure Data Integrity through Constraints- Describe indexes, including Optimized and Columnstore indexes

If you want to follow this course in Mechelen, please contact us at this email adress or call +32 (0)15 28 63 70.

Course Contents

Introduction Database Development

Design and Implement Tables

Describe advanced table designs

Ensure Data Integrity through Constraints

Describe indexes, including Optimized and Columnstore indexes

Design and Implement Views

Design and Implement Stored Procedures

Design and Implement User Defined Functions

Respond to data manipulation using triggers

Design and Implement In-Memory Tables

Course prerequisites

Before attending this course, students must have basic knowledge of the Microsoft Windows operating system and its core functionality, working knowledge of Transact-SQL, working knowledge of relational databases and some experience with database design.