OD20762C: Developing SQL Databases SQL Server 2016 MOD

  • Live Vritual Classroom
  • Classroom Training
  • On-Site Training

Enquire Details & Pricing

Key Features MONEY BACK GUARANTEE

How this works :

At Learnfly, we greatly value the trust of our patrons. Our courses are designed to deliver an effective learning experience, and have helped over half a million find their professional calling. But if you feel your course is not to your liking, we offer a 7-day money-back guarantee. Just send us a refund request within 7 days of purchase, and we will refund 100% of your payment, no questions asked!

For Instructor Led Training :

Raise refund request within 7 days of commencement of the first batch you are eligible to attend. Money back guarantee is void if the participant has accessed more than 25% content of an e-learning course or has attended Online Classrooms for more than 1 day.

  • Learn with practical projects and hands on real tools.
  • Official Curriculum & Courseware Content.
  • Online Interactive Lab's Access.
  • Adaptive e-Learning with trainer's support.
  • Access Class via PC, Mobile App or on a large screen.
  • Attend Live HD Training Sessions via Go To MeetingTM. Interact with trainer and peers like in a real classroom via voice, video conference and live chat.

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.

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

Course Curriculum

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

See what our Alumni says

Our alumni’s are hired by top brands

Hundreds of employers — have maximized their talent with us.

Ready to enroll for this Course? Book your slot now: