Most popular programs
Trending now
This course helps you develop the foundational skills required to perform the role of a Database Administrator (DBA) including designing, implementing, securing, maintaining, troubleshooting and automating databases such as MySQL, PostgreSQL and Db2.
Managing databases is a critical skill for Data Engineers and Database Administrators to ensure data is reliable, protected and easily accessible for organizations to make better decisions, solve problems and create business value.
With the amount of data continually expanding and business leaders focused on building data-literate organizations, it’s no surprise that Database Administrators are in high demand and earn a median salary of US $98,860 per year according to the US Bureau of Labor Statistics.
This course provides you with the knowledge and hands-on experience to manage and maintain databases, understand database security, design and define database schemas, tables, views, and other database objects, describe storage, perform backups and recovery, troubleshoot errors, monitor and optimize performance and automate tasks.
This course includes hands-on practice labs and a real-world inspired project to add to your portfolio that will demonstrate your ability to perform the Database Administration tasks using relational databases (RDBMSes) such as MySQL, PostgreSQL and IBM Db2.
Prior knowledge of database fundamentals and SQL is required to complete this course.
Module 1: Introduction to Database Management
Day in the Life of a Database Administrator
Database Management Lifecycle
Database Objects
System Objects and Database Configuration
Database Storage
Module 2: Managing Databases
Types of Backup
Backup Policies
Using Database Transaction Logs for Recovery
Overview of Database Security
Users, Groups, and Roles
Managing Access to Databases and Their Objects
Auditing Database Activity
Encrypting Data
Module 3: Monitoring and Optimization
Overview of Database Monitoring
Monitoring Usage and Performance - Part 1
Monitoring Usage and Performance - Part 2
Using Indexes
Module 4: Troubleshooting and Automation
Troubleshooting Common Issues
Using Status Variables, Error Codes, and Documentation
Using Logs for Troubleshooting
Overview of Automating Database Tasks
Automating Reports and Alerts
Module 5: Final Project
Who can take this course?
Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.
Who can take this course?
Unfortunately, learners residing in one or more of the following countries or regions will not be able to register for this course: Iran, Cuba and the Crimea region of Ukraine. While edX has sought licenses from the U.S. Office of Foreign Assets Control (OFAC) to offer our courses to learners in these countries and regions, the licenses we have received are not broad enough to allow us to offer this course in all locations. edX truly regrets that U.S. sanctions prevent us from offering all of our courses to everyone, no matter where they live.
