Skip to content
CBT Nuggets

Microsoft MCSA: SQL 2016 Database Development (70-761 & 70-762)

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.

Updated March 2019

2Skills
67Videos
37Virtual Labs
16h 8mTotal
67 videos37 labs16h 8m

Who This Course Is 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.

Skills Your Team Will Gain

  • 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

Course Curriculum

  • Premium skill.Microsoft MCSA SQL Server 2016 (70-761)8h 13m + 19 labs
  • Premium skill.Microsoft MCSA SQL Server 2016 (70-762)7h 55m + 18 labs

Readiness check

Confirm prerequisite knowledge before training begins

A short placement assessment on the CBT Nuggets assessments platform measures whether a learner already has the foundation this course assumes. IT Directors use it to put the right people in the right training — and any learner can take it right now to make sure they'll get full value from day one.

  • Questions generated from this course's own lesson transcripts — what gets measured is exactly what gets taught
  • Instant, per-learner results that show whether the prerequisite foundation is in place
  • Results roll up into team readiness reporting, so training hours go where they change outcomes

Runs on assessments.cbtnuggets.com — sign in with an Adept account so results roll up into team readiness reporting. Need one? Create an Adept account.

This course is included with every subscription

Get your team access to all 559 courses, virtual labs, and practice exams.

Most Popular

Team

$749per seat / year

5+ learner seats

Get Started

Enterprise

Customannual contracts

Any size

Contact Enterprise Sales

Just need this course?

Single-course enrollment — $99 for 1 year of access to MCSA: SQL 2016 Database Development (70-761 and 70-762) Online Training.

Enroll in This Course
Calculate the ROI of training your team

Trusted by 23,000+ organizations

Frequently Asked Questions

Ready to upskill your team?

Talk to our sales team to find the right plan for your organization.