MOC On-Demand: Developing SQL Databases

MOC On-Demand

MOC On-Demand is an integrated blend of video, text, hands-on labs, and knowledge checks, designed to help IT professionals and developers build their skills on Microsoft technologies. The courses provide a self-paced, stand-alone training alternative for those who prefer to learn at their own convenience. They can also be used in conjunction with instructor-led training to provide a blended classroom experience or be used as a foundation for a training solution that includes mentoring and other learning services.

Developing SQL Databases

About this course

This 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.

Audience Profile

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

The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server 2016 data-base.

At Course Completion:

At the completion of this course participants will be able to:

  • design and implement tables
  • describe advanced table designs
  • ensure data integrity through constraints.
  • describe indexes, including optimised and column-store 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.
Install and configure Windows Server 2012.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: OD20762
  • Duration: 90 Days
  • Price: $1,089.00

Next Step

Enquire Now
Tell a Friend