Skip to content
CBT Nuggets

Developing Databases in Microsoft SQL Server 2016

This intermediate Developing Databases in SQL Server 2016 training prepares learners to implement databases in SQL Server 2016 across organizations, ensuring high levels of data availability. This training helps you ensure that the data in your database is accessible at all times without sacrificing its timeliness or relevance if changes get made in short order.

Updated March 2021

4Skills
28Videos
10Virtual Labs
6h 43mTotal
28 videos10 labs6h 43m

Who This Course Is For

This Developing Databases in SQL Server 2016 training is considered associate-level Microsoft training, which means it was designed for database administrators and database developers. This SQL Server 2016 skills course is valuable for new IT professionals with at least a year of experience with database implementation best practices and experienced database administrators looking to validate their Microsoft skills.

Skills Your Team Will Gain

  • Accessing, changing and reporting on the data stored in your databases
  • Applying the programming concepts of SQL and T-SQL
  • Enhancing database performance with stored procedures
  • Easing administrative workload with programmable functions
  • Understanding the balance that lies between transaction isolation and reduced concurrency
  • Recognizing how to increase or decrease transaction isolation
  • Creating and modifying object statistics

Course Curriculum

  • Premium skill.Designing and Implementing Database Objects in SQL Server 20162h 37m + 5 labs
  • Premium skill.Implementing Programmability Objects in SQL Server 20161h 23m + 1 lab
  • Premium skill.Managing Database Concurrency in SQL Server 20161h 19m + 1 lab
  • Premium skill.Optimizing Database Objects and SQL Infrastructure1h 24m + 3 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 Databases in SQL Server 2016.

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.