Microsoft 70-762: Developing SQL Databases
Advanced
25h
By: Doug Perez
Overview
In this instructor-led, online training course, students will be given 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.
Exam Number: 70-762
Modules
1. Chapter 1-1
1.1 Introduction to Developing and Improving Table Design in SQL1h 6m
1.2 Write Table Create Statements and Most Efficient Data Types in SQL44 min
2. Chapter 1-2
2.1 Design New Indexes and Distinguish Indexed and Included Columns in SQL58 min
2.2 Implement Clustered Index Columns and Recommending New Indexes in SQL51 min
3. Chapter 1-3
3.1 Design a View Structure and Updateable View in SQL30 min
3.2 Implement Partitioned and Indexed Views in SQL31 min
4. Chapter 1-4
4.1 Use Cases for Columnstore, Clustered, and Non-clustered Indexes in SQL1h 5m
4.2 Design Standard Non-clustered Indexes and Maintain Columnstore Indexes in SQL53 min
5. Chapter 2-1
5.1 Table, Foreign Key Constraints, and Write Transact-SQL Statements58 min
5.2 Data Manipulation Language (DML) and Usage of Primary Key Constraints in SQL56 min
6. Chapter 2-2
6.1 Design Stored Procedure Components and Implement Input and Output Parameters in SQL1h 5m
6.2 Streamline Existing Stored Procedure Logic and Implement Error Handling in SQL1h 2m
7. Chapter 2-3
7.1 Design Trigger Logic and When to Use DML Triggers in SQL52 min
7.2 Data Definition Language (DDL) Triggers and Recognize Results Based on Execution in SQL41 min
7.3 Scalar, Table Valued User-defined, and Deterministic and Non-deterministic Functions in SQL47 min
8. Chapter 3-1
8.1 Identify DML Statements Results and Explicit and Implicit Transactions in SQL53 min
8.2 Implement Savepoints and High-concurrency Database Transactions in SQL1h
9. Chapter 3-2
9.1 Differences Between Isolation Levels and Concurrent Queries base on Isolation Levels in SQL1h 4m
9.2 Resource and Performance Impact of Isolation Levels in SQL29 min
10. Chapter 3-3
10.1 Troubleshoot Locking Issues and Identify Lock Escalation Behaviors in SQL36 min
10.2 Capture and Analyze Deadlock Graphs and Ways to Remediate Deadlocks in SQL42 min
11. Chapter 3-4
11.1 Use Cases for Memory-optimized Tables and Optimizing In-memory Tables in SQL1h 2m
11.2 Usage Scenarios for Natively Compiled Stored Procedures and Enabling Collection of Execution Statistics in SQL28 min
12. Chapter 4-1
12.1 Determine the Accuracy and Design Statistic Maintenance Tasks in SQL50 min
12.2 Use Dynamic Management Objects and Consolidate Overlapping Indexes in SQL39 min
13. Chatper 4-2
13.1 Capture and Identify Poorly Performing Query Plans in SQL1h
13.2 Compare Estimated and Actual Query Plans With Database Insight in SQL42 min
14. Chapter 4-3
14.1 Manage Database Workload and Design Elastic Scales in SQL Server44 min
14.2 Select an Appropriate SQL Service Tier or Edition and Optimize Database Files22 min
14.3 Optimize SQL Memory Configuration and Manage Object Monitoring31 min
14.4 Troubleshoot Various Issues and Monitor Azure Queries in SQL16 min
15. Chapter 4-4
15.1 SQL Server and Database Monitoring and Extended Events37 min
Ready to Elevate Your Team's Learning?
Talk with our sales team to see how StormWind can transform the way your organization trains and grows.
CONTACT SALES