- Course info
- Course resources
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.