Microsoft MCSA - 70-761 - 70-762 - SQL 2016 Database Development - Microsoft Certification Training Training | CBT Nuggets

MCSA: SQL 2016 Database Development (70-761 and 70-762) Online Training


Garth Schulte


MCSA: SQL 2016 Database Development (70-761 and 70-762) Online Training

In this intermediate Microsoft MCSA: SQL 2016 training, Garth Schulte covers the objectives in the 70-761 and 70-762 exams, which are the two exams required to earn the MCSA: SQL 2016 Database Development certification.

The MCSA: SQL 2016 certification is a versatile certification used to validate database and SQL skills for a wide range of data professionals. The 70-761 training is a deep dive into T-SQL. For anyone who already knows SQL, much of this training may be review. However, T-SQL has a slightly more complex syntax than vanilla SQL. It’s only by knowing the intricacies of the T-SQL query language that you can fully benefit from its modularity, security, and efficiency.

The second part of the training is dedicated to designing and managing Server 2016 databases. Databases have a lot of moving parts and database administrators need to adhere to best practices to ensure data moves smoothly. This 70-762 training covers concurrency, optimization, and the detail-oriented work of storing and moving data for business applications.

Demand for database administrators has steadily risen in the past decade, and demand for the MCSA: SQL 2016 Database Development has followed. With the right experience, database administrators who complete this SQL Server 2016 training will be more marketable as a database administrator, and better prepared to step into more senior DBA roles.

This MCSA: SQL 2016 training can be used for 70-761 and 70-762 exam prep, on-boarding new database administrators, or part of a team training plan.

70-761 and 70-762: What You Need to Know

This MCSA: SQL 2016 Database Development training goes step-by-step through the 70-761 and 70-762 exam objectives, and readies you to:

  • Gain a deeper understanding of SQL databases
  • Learn about the certification exams, 70-761 and 70-762
  • Design, normalize, and implement database tables
  • Design and implement indexes and constraints
  • Analyze and Troubleshoot Query Plans
  • Manage and monitor SQL Server Performance
  • Work with data types and handling NULL values
  • Query many different tables
  • Work with different types of data, such as temporal and non-relational data

Who Should Take 70-761 and 70-762 Training?

This MCSA: SQL 2016 training is considered associate-level Microsoft training, which means it was designed for database administrators. This 70-761 and 70-762 course is valuable for new IT professionals with at least a year of experience with SQL database and experienced database administrators looking to validate their Microsoft skills.

New or aspiring database administrators. Relational databases can initially be a little confusing, particularly structuring data for retrieval. But Garth starts from the ground up in this SQL course. By using the hands-on labs in this SQL course, learners will know how to both query data from existing databases and also create and maintain new SQL databases — even if they’re starting from zero knowledge.

Experienced database administrators. The MCSA: SQL 2016 course is technically entry-level material, which means Garth starts with the basics, like joins, expressions, and queries. But this SQL Server 2016 course quickly moves into advanced entry-level SQL topics like user-defined functions, data aggregation, error handling, and troubleshooting. Use the hands-on virtual labs to practice with dummy data before hitting the production environment. Experienced database administrators seeking to diversify their skillset in Microsoft database tools (both in the cloud and on-premise) can stand to benefit greatly from this MCSA: SQL 2016 training.

Skills You'll Learn in this Course

  • Microsoft MCSA SQL Server 2016 (70-761)

    Intermediate6 hrs 12 mins34 videos
  • Microsoft MCSA SQL Server 2016 (70-762)

    Intermediate6 hrs 5 mins33 videos
  • 70-761 and 70-762 Learning Resources

    Our MCSA: SQL 2016 Database Development training includes videos, in-video quizzes, virtual labs hand-built by Garth Schulte, and complete Kaplan IT 70-761 and 70-762 practice tests.

    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.