Preview

OD20762C: Developing SQL Databases SQL Server 2016 MOD

 
  • Home
  • Database
  • OD20762C: Developing SQL Databases SQL Server 2016 MOD

OD20762C: Developing SQL Databases SQL Server 2016 MOD

Key Features

  • Learn from anywhere in the world. Connect with an Instructor in real time.
  • Attend Live Class from a PC or Mobile.
  • Ask questions from an Instructor in real time over voice & chat.
  • Includes Certificate of Completion.
  • Official Exam & Certification Assitance.
  • Get 30 Days free after class support.

Join a next available Live Class:

This course training is available on request only. Send us your request with preferred date & Time & our training advisor will get back to you within 24 business hours.


Request for a Live Class

as per your availability

Enquire for more information

Course Description

About the Course

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

 

This course incorporates materials from the Official Microsoft Learning Product 20762: Developing SQL Databases SQL Server 2016.

 

Taking a Microsoft on-demand (MOD) course is an integrated on-line training experience that includes video, labs, exercises, text and knowledge checks. Attendees experience all of this through an on-demand course player.

 

High-quality content, direct from the source. MOC On-Demand is brought to you by the people who write the software. The content is based on the same official courseware we use in our instructor-led training, and videos feature engaging experts hand-selected by Microsoft.

 

Live hands-on labs. Unlike other on-demand offerings that offer simulated labs, MOC On-Demand gives you a live, real-time environment for hands-on training.

 

HD Videos High quality HD videos are designed by subject matter experts in order to give you all knowledge that is required.

 

Knowledge Check Available throughout the course in order to assess your learnings.

 

SATV can also be used to buy the MOD.

 

2 SATV days are needed for a MOD course. 5 SATV days are needed for a MOD course with Digital MOC option.

 

Note On Access Duration:

- MOC On-Demand access code will be valid for activation for 6 months from the date of purchase. Once activated, it will by DEFAULT allow for 90 days of access duration.

- MOD 180 days access duration OPTION is also now available. This is non-refundable, and must be opted at the time of original purchase at an additional cost of $100.

Course Curriculum

Course # : OD20762C
Exam : Developing SQL Databases SQL Server 2016 MOD

OD20762C: Developing SQL Databases SQL Server 2016 MOD

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

Target Audience

  • IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database
  • Individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database

Prerequisites

  • Required: Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Required: Working knowledge of relational databases
  • Required: Working knowledge of Transact-SQL
Be Amazed with Online Learning Experience
Future is fast forwarding towards online learning & now it’s becoming easy for everyone to take a world class training from anywhere in the world. Listen from Learnfly Live recent alumni’s studying around the globe.

Get an e-Certificate of Completion

Get a e-Certificate of Course Completion after successfully completing your live class with Learnfly. Share & showcase your proud achievement with your friends & colleagues. Join a live class today & start learning online from anywhere: