Database Administrators Tune and Stabilize Data Systems

Performance Tune Database

Make a previous slow query or system faster by learning how to index databases and tune hardware.

Ensure Systems Stay Online

Make sure systems are highly available and backed up in case disaster strikes.

Design Cloud Systems

Build the systems of tomorrow in the cloud and migrate on-prem data to the cloud.

automate repeating tasks

Find ways to eliminate manual processes.

READY TO BECOME
A DATABASE ADMINISTRATOR?
WE HAVE YOU COVERED.

Pragmatic Works’ On-Demand Learning is set up with your success in mind. We have made thousands of people and teams like yourself reach their highest potential and salary. Our author and MVP team is passionate about guiding you and your team to a new skill.

The average database administrator salary is $74,000.

Source: PayScale/ZipRecruiter Surveys

Database Administrator U.S. Average Salary

STEP-BY-STEP PLAN FOR DATABASE MASTERY

The Learning Path includes classes offered as part of your On-Demand Learning package.  More classes are being added each quarter and old ones are constantly being updated because of the amount of change in databases each month.

Start With The Free Community Plan​

Pragmatic Works free community plan gives you lifetime access to 7 Microsoft “in a day” courses.

Set Your
Learning Path

Set your Learning Path in the learning management system that guides you to accomplish your goals.

Achieve
Certifications

Prove you have the knowledge and the know-how with Microsoft certifications.

Database Administrator Plan

Pragmatic Works’ On-Demand Learning classes are constantly being updated and re-recorded to make sure you have the latest info about databases. Here’s a list of classes we recommend taking in the proper order:

Class
Class

Introduction To T-SQL

  • Understand the structure of a SQL Server database
  • Query tables and sort and filter the results
  • Write queries that involve multiple tables and summary queries
  • Learn to modify data and about the logical programming aspects of T-SQL

 

Class Info
Class
Class

Advanced T-SQL

  • This course has been designed using examples from real world scenarios
  • In many cases, the course demonstrates the different methods to solve a particular scenario and then explains why one may be better than another due to performance reasons
  • The course has a heavy emphasis on writing optimal queries

 

Class Info
Class
Class

DBA Fundamentals

  • SQL Server installation options, as well as hardware and virtualization considerations
  • SQL Server and database security, including backups and recoveries
  • How to query SQL Server and Business Intelligence administration of SSIS, SSAS and SSRS

 

Class Info
Class
Class

SQL Server Hardware And Software Configuration

  • Learn how hardware and software operate together so you can better understand what your systems can actually achieve
  • Configure hardware and software properly for SQL Server
  •  
Class Info
Class
Class

Introduction To PowerShell

  • Understand what PowerShell is and how it can be used
  • Understand and work with cmdlets
  • Navigate the PSProvider and work with the pipeline
  • Write your own scripts for managing SQL Server

 

Class Info
Class
Class

SQL Server Performance Tuning

  • SQL Server Index Tuning and Query Tuning best practices
  • Use tools such as Profiler, Extended Events and SQLIO
  • Create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns

 

Class Info
Class
Class

Administering Business Intelligence

  • Write queries that involve multiple tables and summary queries
  • Modify data and understand the logical programming aspects of T-SQL

 

Class Info
Exam
Exam

Exam 70-764: Administering A SQL Database Infrastructure

This exam is intended for database professionals who perform installation, maintenance, and configuration tasks. Other responsibilities include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access.

 

Exam Info
Certification Complete!
Certification Complete!

Mission Accomplished!

It was a challenging journey, but you have arrived and are certified.

RECOMMENDED BOOKS

Begin Your Journey to Become a Database Administrator

Get Our Special Offers Directly to Your Email