OD20762C: Developing SQL Databases SQL Server 2016 MOD|

Enquire for more information

By submiting, you agree to our terms and policy

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

Developing SQL Databases SQL Server 2016 MOD

Exam : Developing SQL Databases SQL Server 2016 MOD

Download Syllabus

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.

Paul Spranger

Very comprehensive materials with a clear presentation. I have been teaching digital forensics for over 10 years and I found this training to be very interesting and on-point

Rami Khalife

I have completed the course 20778 Analyzing data with Power BI. The instructor Mr. Abhishek Kumar delivered interactive sessions which were impressively informative. He went through the content in detail which showcased that he has a thorough knowledge of the subject matter. He set up a collaborative medium between instructor and students. You can ask questions and he will give you a presenter view where you can share what you have learnt.
Instructor Abhishek Kumar is a terrific subject expert. I will be happy to take more courses with Learnfly Live from this experience and recommend it to everyone as well. A job well done! I am now going to practice the content taught by Mr. Abhishek so that I can deliver it in my career pursuits.

Miaozi Guo

Cisco training has given me ample exposure to the field. The trainers were good and provided conceptual understanding for core concepts and technology. They supported me throughout the training and even guided me for job opportunities. I would surely recommend SkillCertified™ Live to everyone.

Uno Lapimaa

I've attended SkillCertified™ Live Microsoft SQL Server Self-Paced. It was very useful and enlightening. The training session was great – interactive as well as informative. Trainers were very helpful and offered personal assistance during the training and career guidance after it.