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

Note: The exams associated with this course have been retired. However, this course still retains value as a training resource.

Taught by

Garth Schulte

UPDATED: March 15, 2019

Intermediate

Virtual Labs

This intermediate Microsoft MCSA: SQL 2016 training will teach learners T-SQL, database design, query optimization, and performance monitoring. Ideal for onboarding new database administrators, this Microsoft training will help you advance as a database administrator and improve your SQL Server skills.

Start a free week

Subscription options

$59.00

Access all premium content with a free week!

Quizzes
CyberVista® IT practice exams
Coaching
IT learner community

Start a free week

See training reviews

What you'll learn

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

FAQs

What will you learn in this SQL 2016 database development course?

You'll learn how to optimize your company's data and build better databases with this course that used to help prepare learners for passing MCSA exams. This course is all about managing and querying data with Transact-SQL and designing database objects and SQL infrastructure in the SQL Server 2016 environment.

Who should take this course in SQL 2016 database development?

Any database professional who works with Microsoft SQL Server 2016 should take this course in database development. Microsoft now focuses their training on Azure – where they'd like all their clients to go – but SQL 2016 is still extremely prevalent, and database professionals have to know how to use it.

Is this MCSA SQL 2016 training associated with any certifications?

No, this MCSA training is no longer associated with any valid certifications. Microsoft retired the MCSA: SQL 2016 Database Development cert in January 2021, and this training used to help prepare learners to pass it. The information remains perfectly valid, it's just the certification itself you can't earn any longer.

Are there any certifications to consider after taking this SQL 2016 database development course?

The only database administration certifications Microsoft supports are ones related to Azure. The Microsoft Certified: Azure Database Administrator Associate and Azure Data Fundamentals will both be much easier after taking this course, but this course is focused on an older version of SQL Server.

Why should you take this SQL 2016 database development course?

You should take this MCSA SQL 2016 training if you have ever or will ever encounter Microsoft SQL Server 2016 in your database career. It might be nice to imagine you'll only ever work in the cloud or only on the most up-to-date technology, but that's extremely unlikely.

Who is this for?

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.

What our learners say

You constantly have to invest in training for your people.
Rick N. | CEO
CBT Nuggets is exactly what I needed.
Thomas S. | Systems Engineer & Consultant
When learning a new technology, people sometimes build a wall that complicates the learning process because of the unknown. I like tearing down that wall — and having people fall in love with that technology.
Lalo Nunez | CBT Nuggets trainer since 2020

Study plan

Download the free MCSA: SQL 2016 Database Development (70-761 and 70-762) Online Training study plan to complete this course in about 16 hours.

Download study plan