Target Group

This course is designed for those who would like to implement a database on the basis of an existing design with the help of Microsoft SQL Server. Or those who would like to add code to existing SQL Server databases.

(Pre) Knowledge

Knowledge of relational database models (Database Design training) is required. As well as knowledge of (ANSI) SQL (training SQL).

Global Contents

During this course the capabilities and tools of Microsoft SQL Server will be discussed. After course completion the attendee will be able to create a completely new database with the help of SQL Enterprise Manager. Attendees will learn how to use constraints, transactions and how to guarantee the integrity of database by using the programming power of Transact SQL with stored procedures and triggers.

Methods

ATS courses are given by highly qualified trainers, with practical knowledge, in professional ATS training centres or On-Site. Prior to the course an intake conversation can take place to define the participant(s) and the company's requirements. Presentations (theory and examples) as well as practical exercises bring the courses to life. ATS courses are interactive, the trainer will always make sure the training contents link back to your situation.

Specific Contents

• Create a new database
• Create database objects like tables, index, and views
• Constraints
• Rules
• Stored procedures
• Triggers
• Transactions
• Cursors
• Query performance

Remarks

In this course the emphasis lies with the specific qualities and methods of the product Microsoft SQL Server. The course can be combined with the SQL course when the knowledge of ANSI SQL is not sufficient.