Boost
Boost

Developing SQL Databases

IT-1098

Course Code

5 Days

Duration

4

Upcoming Dates

Download Brochure
Sector Logo

Sector Name

Information Technology

Send by WhatsApp
28 Dec 2026 | 01 Jan 2027
Online, Virtual
$2,150
Limited Seats
15 Mar 2027 | 19 Mar 2027
Dubai, UAE
$4,250
Upcoming
14 Jun 2027 | 18 Jun 2027
Dubai, UAE
$4,250
Upcoming
16 Aug 2027 | 20 Aug 2027
London, England
$4,950
Upcoming

Course Introduction

This training course is designed to provide students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. This MOC-OD will focus on using SQL Server 2016 product features and tools related to developing a database.

Course Objectives

  • 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.
  • Implement Managed Code in SQL Server.
  • Store and Query XML Data.
  • Work with Spatial Data.
  • Store and Query Blobs and Text Documents.
Download Brochure