20762C - Developing SQL Databases

20762C - Developing SQL Databases


This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server database. The course focuses on teaching individuals how to use SQL Server product features and tools related to developing a database.


5 Days

Target Audience

The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.


Introduction to Database Development

Designing and Implementing Tables

Advanced Table Designs

Ensuring Data Integrity through Constraints

Introduction to Indexes

Designing Optimized Index Strategies

Columnstore Indexes

Designing and Implementing Views

Designing and Implementing Stored Procedures

Designing and Implementing User-Defined Functions

Responding to Data Manipulation via Triggers

Using In-Memory Tables

Implementing Managed Code in SQL Server

Storing and Querying XML Data in SQL Server

Storing and Querying Spatial Data in SQL Server

Storing and Querying BLOBs and Text Documents in SQL Server

SQL Server Concurrency

Performance and Monitoring

A more comprehensive course outline is available in the Course Download section, to the right of this page.

Course Details

Course Ref:


Course Duration:

5 Days

Course Location:


Course Dates:

Please call for dates...

Course Price (Excl VAT):


Course Downloads

Send course details to a colleague


   To book or for further information, please telephone 0191 515 3355 or e-mail us at sales@mtc-training.co.uk