Developing Microsoft SQL Databases (MS-20762)
When you subscribe, you get:
Master Subscription plan gives you access to this course and over 1180 other popular courses
Now Only $2,999.00 Regular Price $3,499.00
Now Only $2,999.00 Regular Price $3,499.00/ Year
About this course:
This five-day instructor-led 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 also prepares the students for the Microsoft 70-464: Developing Microsoft SQL Server Databases certification exam.
The average salary for a SQL Developer is $81,714 per year.
After completing this course, students will be able to:
- 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.
The primary audience for this course is IT Professionals who want to become skilled on SQL Server product features and technologies for implementing a database.
The secondary audiences for this course are individuals who are developers from other product platforms looking to become skilled in the implementation of a SQL Server database.
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Working knowledge of Transact-SQL.
- Working knowledge of relational databases
Frequently Asked Questions
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?
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.
Practice Certification Exam
|Subjects||IT Ops & Management|
|Learning Style||Virtual Classroom|
|Course Duration||5 Days|
|VPA Discount||VPA Discount|