Overview
Exam Number: 70-762
Course Instructor: Doug Perez
Course Outline
- Introduction to database development
- Designing and implementing tables
- Advanced table designs
- Ensuring data integrity through constraints
- Introduction to Indexes
- Designing optimized Index strategies
- Columnstore Indexes
- Designing and implementing Views
- Designing and implementing stored procedures
- Designing and implementing user-defined functions
- Responding to data manipulation via Triggers
- Using in-memory tables
- Implementing managed code in SQL Server
- Storing and querying XML data in SQL Server
- Storing and querying spatial data in SQL Server
- Storing and querying BLOBs and text documents in SQL Server
- Performance and monitoring
Skills Learned
After completing this online training course, students will be able to:
- Design and implement tables.
- Advanced table designs.
- Ensure data integrity through constraints.
- Indexes, including optimized and column store 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