Aperiam - Developing SQL Databases


This five-day instructor-led course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database. This course is a prerequisite for the Microsoft Certification Exam n. 70-762.


After completing this course (74-MOC-20762) students will be able to:

  • 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
  • Enhance reports with charts and parameters
  • Manage report execution and delivery
  • Implement a dashboard in SharePoint Server with PerformancePoint Services
  • Use Data Mining for Predictive Analysis


  • Modulo 1: Introduction to Database Development
  • Modulo 2: Designing and Implementing Tables
  • Modulo 3: Advanced Table Designs
  • Modulo 4: Ensuring Data Integrity through ConstraintsThis
  • Modulo 5: Introduction to Indexes
  • Modulo 6: Designing Optimized Index Strategies
  • Modulo 7: Columnstore Indexes
  • Modulo 8: Designing and Implementing Views
  • Modulo 9: Designing and Implementing Stored Procedures
  • Modulo 10: Designing and Implementing User-Defined Functions
  • Modulo 11: Responding to Data Manipulation via Triggers
  • Modulo 12: Using In-Memory Tables
  • Modulo 13: Implementing Managed Code in SQL Server
  • Modulo 14: Storing and Querying XML Data in SQL Server
  • Modulo 15: Working with SQL Server Spatial Data
  • Modulo 16: Storing and Querying Blobs and Text Documents in SQL Server


This course requires that you meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases