Database Fundamentals: Database Administration Basics
Database
| Beginner
- 10 Videos | 54m 57s
- Includes Assessment
- Earns a Badge
Once a database is part of your IT infrastructure, you need to protect and maintain it. You also have to ensure that it is operating at optimal capacity. This course focuses on the database administrator (DBA), the individual charged with building, maintaining, and backing up the database. Explore key responsibilities and tasks performed by the DBA involving the security, migration, troubleshooting, and configuration of databases. Discover how the role of the DBA compares to that of a database developer. Finally, learn about common maintenance functions performed for a database such as backup and restore, user management, and performance tuning. Upon completion of this course, you'll understand the role of a DBA and how the DBA's day-to-day responsibilities differ from those of a database developer.
WHAT YOU WILL LEARN
-
discover the key concepts covered in this coursedescribe the database administrator (DBA) role and their responsibilitiescompare and contrast roles and responsibilities of database administrators and database developersinstall and configure the phpMyAdmin tooladd and configure users and their roles
-
configure database security with password policiessteps to migrate data from one database to anotherperform backup and restore proceduresidentify the need for performance tuningsummarize the key concepts covered in this course
IN THIS COURSE
-
1.Course Overview1m 52sUP NEXT
-
2.The Database Administrator (DBA)5m 22s
-
3.Roles and Responsibilities in the RDBMS4m 35s
-
4.Exploring GUI Admin Tools6m 27s
-
5.Performing User Administration7m 25s
-
6.Configuring Database Security6m 45s
-
7.Migrating Data6m 15s
-
8.Backing up and Restoring Databases6m 11s
-
9.Performance Tuning6m 19s
-
10.Course Summary3m 47s
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform
Digital badges are yours to keep, forever.