The labs for this course have been deprecated. Furthermore, the exams associated with this course have been retired. However, this course still retains value as a training resource.
In this expert Microsoft MCSE training, Garth Schulte and Knox Hutchinson cover the training objectives for a number of Microsoft certification exams, including 70-464, 70-465 and 70-762. Depending on what part of data management and analytics you as a database professional are looking to be certified in, these tests cover different parts of database administration and design.
70-464 focuses on developing Microsoft SQL databases, 70-465 is meant for those who create and design database solutions, and 70-762 focuses on implementing SQL databases across organizations. This training covers the learning objectives for all of those and can help you earn your MCSE: Data Management and Analytics certification. These are three of eight different certifying exams, any one of which you can take to earn the MCSE: Data Management and Analytics certification.
The MCSE: Data Management and Analytics certification is a versatile certification used to validate the database and SQL skills for a wide range of data professionals. After watching this Microsoft training, you'll be set to take the 70-464, 70-465 or 70-762 exams — plus you’ll be ready to progress as a database analyst, database designer, or business intelligence (BI) analyst.
This MCSE: Data training is considered professional-level Microsoft training, which means it was designed for database administrators who already have one of these associate-level Microsoft certifications: MCSA: SQL Server 2012/2014, MCSA: SQL 2016 Database Administration, MCSA: SQL 2016 Database Development, or MCSA: SQL 2016 Business Intelligence Development.
For anyone who manages IT training, this MCSE: Data training can be used for exam prep, on-boarding new database administrators, or part of a team training plan.
70-464, 70-465, and 70-762: What You Need to Know
This MCSE: Data Management and Analytics training maps to the Microsoft 70-464, 70-465, and 70-762 exam objectives and covers topics including:
- Implementing SQL in Azure
- Deploying Microsoft Azure SQL Databases
- Installing and configuring SQL servers
- Managing SQL servers and storage
- Performing database maintenance
- Developing, monitoring, and troubleshooting server databases
Who Should Take 70-464, 70-465, and 70-762 Training?
This 70-464, 70-465, and 70-762 course will validate the extensive experience most database administrators have with business data.
Experienced database administrators. If you have several years of experience in database planning, integration or optimization, different aspects of this training and certification may appeal to you -- either because it can validate the skills you’ve already gained, or help flesh out parts of your experience you may have missed out on. 70-464 and 70-762 both certify skills in building and implementing databases like creating database files, optimizing indexes, and managing transactions and locks. The difference between the two is that 70-464 tests for Microsoft SQL database expertise and 70-762 for SQL. Meanwhile, 70-465 is aimed at database administrators who design and build database solutions for an organization -- they create plans and designs for database implementation. No matter what track you test on, this training will prepare you for each.