Product Image

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

Timezone
empty table
tab

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
Querying Data with Microsoft Transact-SQL (MS-20761)
Querying Data with Microsoft Transact-SQL (MS-20761)
60%
  • Virtual Classroom
  • 5 Days
$2,995.00
Course Expert:

Author

Tom Robertson
(Data Science Enthusiast)

Tom is an innovator first, and then a Data Scientist & Software Architect. He has integrated expertise in business, product, technology and management. Tom has been involved in creating category defining new products in AI and big data for different industries, which generated more than hundred million revenue cumulatively, and served more than 10 million users.
As a Data Scientist and Software Architect Tom has extensive experience in data science, engineering, architecture and software development. To date Tom has accumulated over a decade of experience in R, Python & Linux Shell programming.

Tom has expertise on Python, SQL, and Spark. He has worked on several libraries including but not limited to Scikit-learn, Pandas, NumPy, Matplotlib, Seaborn, SciPy, NLTK, Keras, and Tensorflow.

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