PDP Url

Developing Microsoft SQL Databases (MS-20762)

The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database.

Virtual

Learning Style

Microsoft

Provider

Intermediate

Difficulty

5 Days

Course Duration

5

SATV Value

Course Info

Download PDF

Certificate

See Sample

SubscribeBuy Individually
empty table
tab
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1188 other popular courses
On Sale!
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00
/ Year
38 Learners Have Enrolled For This Course

You have already taken demo for this course.

If you want to get access to demo again, feel free to contact our support at (855) 800-8240

The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database.

Course Information

About this course:

This five-day instructor-drove course gives understudies the skills and information to build up an MS SQL Server database. The course aims around teaching individuals the way to utilize SQL Server product tools and features identified with developing a database. This course additionally readies the understudies for the MS 70-464: certification exam of Developing MS SQL Server Databases.

The normal pay for a SQL Developer is $81,714 every year.

Course Objectives:

  • Project and Implement Views.
  • Define indexes, including Columnstore and Optimized indexes
  • Confirm Data Integrity through Constraints.
  • Plan and Implement Tables.
  • Explain advanced table designs
  • Design and execute User Defined Functions.
  • React to data manipulation using triggers.
  • Execute Managed Code in SQL Server.
  • Query and Store XML Data.
  • Store and Query Text and Blobs Documents.
  • Design and apply In-Memory Tables.
  • Work with Spatial Data.

Audience:

  • The IT Professionals need to be an expert on SQL Server product features and technologies for database implementation are the primary audience of this course.
  • The secondary audience is individuals coming from other product platforms or past forms of SQL Server looking to become professional in the usage of a SQL Server database.

Prerequisites:

  • Fundamental information on the MS Windows operating framework and its core functionality.
  • Working information on Transact-SQL.
  • Working information on relational databases.

Outline

Frequently Asked Questions

What are the prerequisites to the Developing Microsoft SQL Databases (MS-20762) course?

In order to take the Developing Microsoft SQL Databases (MS-20762) course, one must have following technical knowledge:
  • Basic Knowledge of The Microsoft Windows Operating System and its core functionality.
  • Working knowledge of relational databases.
  • Working knowledge of Transact-SQL.

What is the Difficulty level of the Developing Microsoft SQL Databases (MS-20762) certification training?

  • Advance

How will the Developing Microsoft SQL Databases (MS-20762) certification training benefit me in my current job role?

This certification training will help you in your Job’s current role by knowing and getting hands on experience in the following areas:

  • How to measure and monitor performance of your SQL Server databases.
  • Implementing SQL Server Concurrency, what are its benefits and different ways you can configure and work with concurrency settings
  • XML in SQL Server. How to store and Query XML based data type and schema collections.
  • Managed Code usage and it’s implementation.
  • How to create in-memory-tables. What benefits it has and how we can remove transaction blocking.
  • Designing and implementation of Stored Procedures and Triggers. How these can be useful through Data Manipulation queries.
  • Create User defied functions. Know about Scalar and table-valued functions, and how can they lead to performance issues.
  • Learn about Views, its benefits, and implementation in SQL Server.
  • Learn about ColumnStore indexes, its benefits, implementation and performance when implemented on a table of a database.
  • Learn about Data Integrity using constraints.

What is the exam criteria for the Developing Microsoft SQL Databases (MS-20762) course?

Following is the Criteria/Format of 70-762 Exam:

  • The Exam will cover topics from 4 sections namely: Design and Implement Database objects, Implement Programmability objects, Manage database concurrency, and Optimize database objects and SQL infrastructure.
  • From the first section, 25-30% questions will be covered (Weightage may very). From second section, 20-25% questions will be covered (Percentage may vary), third section has the percentage of 25-30% which might vary, and last section might cover 20-25% questions.
  • Topics that might come in the exam from Design and implement database objects are but not limited to the following: MCQ’s (tables and schemas designing, normalization of tables, which data type to use in the provided scenario of exam, indexes and plans designing, difference between indexed and included columns, Views and ColumnStore indexes) Questions might be also be asked as Drag and drop best choices, dry running code to check output, and scenario-based questions.
  • Topics that might come in exam from Implement programmability objects section, might include but not limited to the following: MCQ’s (Table and foreign key constraints, Adding constraints to table through T-SQL queries. Stored Procedures designing with input and output parameters, table-valued parameters, error handling and transaction control logic via Stored Procedures). Questions might be based on Drag and Drop, Scenario-based And/ OR, writing complete/partial T-SQL queries.
  • From the Third Section (Manage Databases Concurrency), Topics might include but not limited to the following: MCQ’s (Transactions, DML statements output identification, difference and identify implicit and explicit transactions, role of transactions In high concurrency, Locking issues troubleshooting, types of lock escalation, identify ways to remediate deadlocks). T-SQL queries might also be asked in the exam to create memory optimized table and how to enable collection of execution statistics for natively compiled stored procedures.
  • Last section might include questions from the following topics but not limited to: MCQ’s (Difference between different isolation levels. Determining the output of concurrent queries based on isolation levels and determine the resource and performance impact of specified isolation levels.
  • To pass the exam you have to score 700 marks out of 100.Please note that: each question contains distinct weightage and percentage define for each section may vary.

What you will learn?

  • Database Development fundamentals
  • Designing and Implementation of tables.
  • Create Advanced Table Designs.
  • Data Integrity assurance through constraints
  • What are indexes, How to design Optimized Index Strategies and ColumnStore indexes
  • How to create and design views and Stored Procedures
  • Create and design User-Defined Functions.
  • Learn how to write DML queries Via Triggers.
  • Advantages and writing In memory optimized table queries
  • Managed code in SQL Server and it’s programming.
  • How to store and query XML Data in SQL Server
  • Concurrency in SQL Server and Performance and Monitoring of SQL Server.

Do I have to prepare anything before attending the Developing Microsoft SQL Databases (MS-20762) course?

You must know about following topics in depth before taking this course:

  • Strong knowledge about Microsoft Windows operating system and its core functionalities.
  • What are Relational Databases and hands on experience on it.
  • How to write T-SQL Queries. Working knowledge is required.

More Information

More Information
BrandMicrosoft
SubjectsIT Ops & Management
Lab AccessYes
TechnologyMicrosoft
Learning StyleVirtual Classroom
Learning TypeCourse
DifficultyIntermediate
Course Duration5 Days
LanguageEnglish
SATV Value5
VPA DiscountVPA Discount

Reviews

Write Your Own Review
Only registered users can write reviews. Please Sign in or create an account

Course Prerequisites
Sale
Querying Data with Microsoft Transact-SQL (MS-20761)
Querying Data with Microsoft Transact-SQL (MS-20761)
60%
  • Virtual Classroom
  • 5 Days
Now Only $2,595.00 Regular Price $2,995.00
Information
Virtual instructor Led

Virtual Classroom Courses

Our virtual instructor-led courses give you access to live instructors training you with other live students in a virtual classroom environment.

200+ Virtual Classroom Courses
Information
Self-Paced

Online Self-Paced Courses

Take self-paced online courses at your convenience and own pace, with unlimited access to courses in various emerging technologies.

700+ Self-Paced Courses
Information
College

E-books blogs, case studies, ariticles

As part of informal learning, our platform will recommend E-books, whitepapers, case studies, articles, and videos. This is AI curated content closely aligned with your learning objectives.

E-books blogs, case studies,...
Information
College

College Accredited Courses

QuickStart courses are accredited by several top schools and universities, including Texas A&M and University of Phoenix. You can print out certificates and also apply them towards your degree plan with them.

College Accredited
Information
Dashboard

Full Learning Dashboard & Analytics

Access all your enrolled, completed, course statistics, and community discussions from one centralized and intuitive learning dashboard with built in analytics, course tracking, time spent, and more.

Analytics/Reporting
Information
Social

QuickStart Discussions

Engage with other learners where you can directly chat, ask questions, and socialize with other learners experts and instructors on a course subject.

Community Access Community Access
Information
Labs

Virtual Labs

Videos and lectures only go so far. Get real world, hands-on practice with virtual labs (not available for all courses).

Virtual Labs Virtual Labs
Information
Live Instructor Support

Live Instructor Mentoring & Support

Get your IT problems solved through a community of mentors, experts and peers. Get live help from experts to answer questions on course material or guidance on a project.

Mentoring & Discussions Mentoring & Discussions
Information
Dashboard

Career Paths

Start a learning pathway towards understanding and mastering your career. With QuickStart career paths, you can fully understanding and being the best in your field.

Learning Paths Learning Paths
Information
Dashboard

Informal Learning

Access to AI curated content from various content publishers which can help in self-directed learning.

Informal Learning Informal Learning
Customer Reviews
  1. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  2. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  3. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  4. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  5. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  6. MS-20762 Developing Microsoft SQL Databases - Dec 21, 2018 - Live Online PST
    Course Quality
    100%
    Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    I really liked the separation of lecture and labs. Especially for a 5 day course, it can be difficult to set aside 5 straight days for training and disconnect from work the full day. This format gave me the flexibility to attend required work-meetings in the afternoon knowing I wouldn't be missing out on lecture.

    Review by

    Posted on

  7. Course Value
    80%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    Jeff is a good instructor. I like his approach of doing all the training in the morning and all the labs in the afternoon. I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  8. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    100%

    Review by

    Posted on

  9. Course Value
    100%
    Quality of Instructor
    80%
    Overall Satisfaction
    80%
    More real world experiences would be great. More examples please =) I have worked over 10 years in the IT industry when taking this training.

    Review by

    Posted on

  10. Course Value
    100%
    Quality of Instructor
    100%
    Overall Satisfaction
    80%
    The instructor was very knowledgeable in the subject matter. I have worked 1-3 years in the IT industry when taking this training.

    Review by

    Posted on

click here