Developing SQL Databases


Course Code:

MS20762

Duration:
5 days
9.00am to 5.00pm
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$3,000 (excl of G.S.T)
2019 Course Dates
15 – 19 Jul 2019
9 – 13 Sep 201
11 – 15 Nov 2019
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.

Course Overview

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.

Program Objectives

After completing this course, 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

Course Outline

 

• Module 1: Introduction to Database Development

• Module 2: Designing and Implementing Tables

• Module 3: Advanced Table Designs

• Module 4: Ensuring Data Integrity through Constraints

• Module 5: Introduction to Indexes

• Module 6: Designing Optimized Index Strategies

• Module 7: Columnstore Indexes

• Module 8: Designing and Implementing Views

• Module 9: Designing and Implementing Stored Procedures

• Module 10: Designing and Implementing User-Defined Functions

• Module 11: Responding to Data Manipulation via Triggers

• Module 12: Using In-Memory Tables

• Module 13: Implementing Managed Code in SQL Server

• Module 14: Storing and Querying XML Data in SQL Server

• Module 15: Storing and Querying Spatial Data in SQL Server

• Module 16: Storing and Querying BLOBs and Text Documents in SQL Server

• Module 17: SQL Server Concurrency

• Module 18: Performance and Monitoring

Click Here for full course Outline

Take the Next Step

It Takes Less Than 5 Min