Microsoft MCSE: Data Management and Analytics - Microsoft Training Training | CBT Nuggets

MCSE: Data Management and Analytics (70-464, 70-465, and 70-762) Online Training


Garth Schulte


MCSE: Data Management and Analytics (70-464, 70-465, and 70-762) Online Training

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. In this expert Microsoft MCSE: Data training, Garth Schulte and Knox Hutchinson cover the objectives in the 70-464, 70-465, and 70-762 exams, which are the three exams required 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 and 70-762 exams — plus you’ll be and 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. This advanced Microsoft training is designed for experts in the field of database administration, so it is ideal for database administrators with five to ten years of experience in the field. Gain more insight into the intricacies of SQL server installation, configuration, and data deployment. Learn more about data access, permissions, encryption, auditing, and backups in Microsoft Azure. And finally, learn about how to create, manage, and maintain SQL databases. Expand and refresh your skills working with SQL databases in Microsoft Azure settings and work towards earning the MCSE: Data Management and Analytics certification.

Skills You'll Learn in this Course

  • Microsoft SQL Server 2012: Developing Databases (70-464)

    Advanced10 hrs 35 mins24 videos
  • Microsoft SQL Server 2014: Developing Databases (70-464)

    Advanced10 hrs 32 mins36 videos
  • Microsoft SQL Server 2012: Designing Database Solutions (70-465)

    Advanced7 hrs 10 mins20 videos
  • Microsoft SQL Server 2014: Designing Database Solutions (70-465)

    Advanced1 hr 19 mins5 videos
  • Microsoft MCSA SQL Server 2016 (70-762)

    Intermediate6 hrs 5 mins33 videos
  • 70-464, 70-465, and 70-762 Learning Resources

    Our MCSE: Data Management and Analytics training includes videos, in-video quizzes, and 70-464, 70-465, and 70-762 virtual labs hand-built by Garth Schulte.

    More on our blog

    More on our YouTube channel

    Intro to Databases

    More and more data is being collected and used. As a result, databases are more important than ever. CBT Nuggets trainer Garth Schulte covers databases and their many benefits. What are Intro to IT courses? We all have to start somewhere. Intro to IT courses allow aspiring and seasoned IT pros alike to explore the different corners of the IT career field. These free, open courses are taught at a level anyone can understand by the same great CBT Nuggets trainers. Here's how it works.