Relational Database Administration (DBA)
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.
What you'll learn
- Describe common database administration tasks.
- Define database security measures and create users, groups and roles.
- Perform full and incremental backup and restore procedures.
- Configure a database server including various database parameters and logging.
- Create and manage database objects including tables, schemas, keys and indexes.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 8 weeks |
Effort | 8 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructor | Rav Ahuja |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Learn-to-Swim Instructor $45k
Learn iOS Development $53k
Learn Android Development $66k
Epic LEARN Administrator 2 $104k
Content Editor - Creative Cloud Learn Contractor $119k
Senior Content Editor - Creative Cloud Learn $157k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 8 weeks |
Effort | 8 weeks, 2–3 hours per week |
Starts | On Demand (Start anytime) |
Cost | $99 |
From | IBM via edX |
Instructor | Rav Ahuja |
Download Videos | On all desktop and mobile devices |
Language | English |
Subjects | Programming |
Tags | Computer Science |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course