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:
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
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
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
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
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
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
Administering Business Intelligence
- Write queries that involve multiple tables and summary queries
- Modify data and understand the logical programming aspects of T-SQL
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.
Mission Accomplished!
It was a challenging journey, but you have arrived and are certified.