Database Fundamentals: Database Administration Basics

Database    |    Beginner
  • 10 videos | 54m 57s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 141 users Rating 4.5 of 141 users (141)
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

  • 1m 52s
  • 5m 22s
    After completing this video, you will be able to describe the database administrator (DBA) role and its responsibilities. FREE ACCESS
  • Locked
    3.  Roles and Responsibilities in the RDBMS
    4m 35s
    In this video, you will compare and contrast the roles and responsibilities of database administrators and database developers. FREE ACCESS
  • Locked
    4.  Exploring GUI Admin Tools
    6m 27s
    In this video, you will learn how to install and configure the phpMyAdmin tool. FREE ACCESS
  • Locked
    5.  Performing User Administration
    7m 25s
    In this video, you will add and configure users and their roles. FREE ACCESS
  • Locked
    6.  Configuring Database Security
    6m 45s
    In this video, you will configure database security with password policies. FREE ACCESS
  • Locked
    7.  Migrating Data
    6m 15s
    In this video, you will learn steps to migrate data from one database to another. FREE ACCESS
  • Locked
    8.  Backing up and Restoring Databases
    6m 11s
    In this video, you will learn how to perform backup and restore procedures. FREE ACCESS
  • Locked
    9.  Performance Tuning
    6m 19s
    In this video, you will learn how to identify the need for performance tuning. FREE ACCESS
  • Locked
    10.  Course Summary
    3m 47s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Non-relational Data: Non-relational Databases
Rating 4.5 of 41 users Rating 4.5 of 41 users (41)
Course An Overview of Cloud Databases
Rating 4.5 of 147 users Rating 4.5 of 147 users (147)
Book Getting Started with SQL and Databases: Managing and Manipulating Data with SQL

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Course Database Fundamentals: Database Concepts
Rating 4.4 of 503 users Rating 4.4 of 503 users (503)
Course Traditional Data Architectures: Relational Databases
Rating 4.0 of 72 users Rating 4.0 of 72 users (72)