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.
Access all premium content with a free week!Start a free week
12 HOURS OF TRAINING
30 VIRTUAL LABS
0 PRACTICE EXAMS
Nugget trainer since 2002Read the full bio
What is it like to train with us?
Our learners say it best.
Helps me learn the skills I need when I need themTHOMAS S. | SYSTEMS ENGINEER & CONSULTANT
Microsoft MCSA: SQL 2016 Database Development (70-761 & 70-762) FAQs: Cost, Training, Value
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.
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.
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.
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.