20762C – Developing SQL Databases

20762C

Overview

About the course

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.

Audience Profile

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.

Course Details

  • Course Ref: 20762C
  • Course Duration: 5 days
  • Course Location: Sunderland
  • Course Dates: TBC
  • Course Price: £1,995 (Excl VAT)
Enquire about this course

Modules

  • 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

Course Outline

20762C Course Outline

Find out how MTC training can benefit you, join our mailing list today.

Consent(Required)
Woman in chair at computer

Exciting News
We’re merging with Access Training!

We're excited to announce that MTC Training is now merging with Access Training, to create a more powerful, innovative, and accessible training experience. For updates on this exciting next chapter follow @Access Training

From the 1st April 2025 this website will no longer be managed, please use the Access Training website

MTC Training
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.