Course Overview
Schedule Dates
Curriculum
-
Module 1: An Introduction to Database Development
-
Module 2: Designing and Implementing Tables
-
Module 3: Advanced Table Designs
-
Module 4: Ensuring Data Integrity Through Constraints
-
Module 5: Introduction to Indexes
-
Module 6: Designing Optimized Index Strategies
-
Module 7: Columnstore Indexes
-
Module 8: Designing and Implementing Views
-
Module 9: Designing and Implementing Stored Procedures
-
Module 10: Designing and Implementing User-Defined Functions
-
Module 11: Responding to Data Manipulation Via Triggers
-
Module 12: Using In-Memory Tables
-
Module 13: Implementing Managed Code in SQL Server
-
Module 14: Storing and Querying XML Data in SQL Server
- Lesson 1: Introduction to XML and XML Schemas
- Lesson 2: Storing XML Data and Schemas in SQL Server
- Lesson 3: Implementing the XML Data Type
- Lesson 4: Using the Transact-SQL FOR XML Statement
- Lesson 5: Getting Started with XQuery
- Lesson 6: Shredding XML
- Lab: Storing and Querying XML Data in SQL Server
-
Module 15: Storing and Querying Spatial Data in SQL Server
-
Module 16: Storing and Querying BLOBs and Text Documents in SQL Server
-
Module 17: SQL Server Concurrency
-
Module 18: Performance and Monitoring
If you have the 20762C: Developing SQL 2016 Databases certification, you can pursue a career in database administration, database development, or data analysis. Some potential job roles that you can apply for include:
Database Administrator
Database Developer
Data Analyst
Business Intelligence Developer
Organizations that hire professionals with SQL Server certifications include technology companies, consulting firms, healthcare organizations, financial institutions, and government agencies.
Database Administrator
Database Developer
Data Analyst
Business Intelligence Developer
Organizations that hire professionals with SQL Server certifications include technology companies, consulting firms, healthcare organizations, financial institutions, and government agencies.
After completing this course, you can take the Microsoft Certification Exam 70-762: Developing SQL Databases. This exam measures your ability to accomplish technical tasks related to developing and implementing SQL Server databases. If you pass the exam, you will earn the Microsoft Certified Solutions Associate (MCSA): SQL 2016 Database Development certification.
It's important to note that this course covers the topics and skills that are measured in the exam, so attending the course can be helpful in preparing for the exam. If you have prior experience and knowledge of SQL Server database development, you may be able to prepare for the exam on your own.
To attend the 20762C course, you should have a good understanding of basic relational database concepts, as well as experience creating and managing database objects, such as tables, views, and indexes. Additionally, you should be comfortable working with T-SQL, which is the programming language used for SQL Server databases. Some familiarity with programming concepts, such as variables, control flow, and error handling, is also helpful. Prior experience with SQL Server is not required, but it can be helpful.