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 course
    describe the database administrator (DBA) role and their responsibilities
    compare and contrast roles and responsibilities of database administrators and database developers
    install and configure the phpMyAdmin tool
    add and configure users and their roles
  • configure database security with password policies
    steps to migrate data from one database to another
    perform backup and restore procedures
    identify the need for performance tuning
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    1m 52s
    UP NEXT
  • Playable
    2. 
    The Database Administrator (DBA)
    5m 22s
  • Locked
    3. 
    Roles and Responsibilities in the RDBMS
    4m 35s
    FREE ACCESS
  • Locked
    4. 
    Exploring GUI Admin Tools
    6m 27s
    FREE ACCESS
  • Locked
    5. 
    Performing User Administration
    7m 25s
    FREE ACCESS
  • Locked
    6. 
    Configuring Database Security
    6m 45s
    FREE ACCESS
  • Locked
    7. 
    Migrating Data
    6m 15s
    FREE ACCESS
  • Locked
    8. 
    Backing up and Restoring Databases
    6m 11s
    FREE ACCESS
  • Locked
    9. 
    Performance Tuning
    6m 19s
    FREE ACCESS
  • Locked
    10. 
    Course Summary
    3m 47s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

BOOK Introduction to DBMS: Designing and Implementing Databases from Scratch for Absolute Beginners
BOOK SQL for Data Scientists: A Beginner's Guide for Building Data Sets for Analysis
COURSE Performance Engineering: Optimizing Database Performance