Database Administration and SQL Language Basics

By Matthew Pearson

Use MySQL to learn about administering a database and the basics of the SQL language.

14 hours
  • 47 Lessons
  • 10 Hands-On Labs

About the course

Welcome to the Database Administration and SQL Language Basics course! In this course, we will be using MySQL to learn about administering a database and the basics of the SQL language. The first half of the course begins with installing a MySQL server, then covers common administrative tasks such as creating databases and tables, inserting and viewing data, and running backups for recovery.

We will also cover the different data types that are allowed in MySQL, and wrap up the administrative side by discussing user access and privileges.

The second half of the course focuses on using the SQL language to view and manipulate data. This will include creating and deleting various database objects, adding and altering data within tables, and viewing and sorting data. After completing this course, you will have hands-on experience in administering a database and know how to use the SQL language to manage it.

  • Chapter 1 5 Lessons Course Introduction 14:04

    An Important Note About A Cloud Guru and Linux Academy Courses

    1:19

    Course Overview

    4:24

    About the Author

    0:27

    Databases

    3:29

    Relational Database Management Systems (RDBMS)

    4:25
  • Chapter 2 12 Lessons General Administration 1:11:32

    MySQL Installation on CentOS

    9:10

    MySQL Installation on Ubuntu

    7:09

    Creating Databases

    7:54

    Creating Tables

    10:33

    Inserting, Viewing, and Deleting Data

    14:31

    Connectors and APIs

    3:00

    Constraints

    4:11

    Backups and Recovery

    15:04

    Install and Configure MySQL Server (CentOS)

    0:00 Hands-On Lab

    Install and Configure MySQL Server (Ubuntu)

    0:00 Hands-On Lab

    Creating a Database and Table in MySQL

    0:00 Hands-On Lab

    Backup and Restore Databases in MySQL

    0:00 Hands-On Lab
  • Chapter 3 4 Lessons Data Types 18:57

    Numeric Types

    4:47

    Date and Time Types

    8:18

    String Types

    5:52

    Working with Dates and Times in MySQL

    0:00 Hands-On Lab
  • Chapter 4 4 Lessons Stored Objects 25:54

    Views

    5:35

    Triggers

    8:06

    Stored Routines

    7:21

    Events

    4:52
  • Chapter 5 5 Lessons User Access 31:57

    Creating and Deleting Users

    6:46

    Granting Privileges

    14:37

    Creating and Assigning Roles

    10:34

    Creating Users and Managing Privileges in MySQL

    0:00 Hands-On Lab

    Creating and Assigning Roles in MySQL

    0:00 Hands-On Lab
  • Chapter 6 10 Lessons Modifying Data 54:27

    Creating a Table with Constraints

    7:08

    Inserting

    5:49

    Updating

    4:19

    Altering Tables Part 1

    8:59

    Altering Tables Part 2

    8:27

    Deleting

    5:56

    Dropping

    6:18

    Creating an Index

    7:31

    Creating Tables and Inserting Data in MySQL

    0:00 Hands-On Lab

    Creating Indexes in MySQL

    0:00 Hands-On Lab
  • Chapter 7 6 Lessons Querying and Filtering Data 39:17

    Selecting

    5:57

    Clauses and Operators

    8:07

    GROUP BY and ORDER BY

    8:47

    Unions

    6:56

    Joins

    9:30

    Viewing and Sorting Data in MySQL

    0:00 Hands-On Lab
  • Chapter 8 1 Lesson Final Steps 3:31

    What's Next

    3:31

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Get Started
Who’s going to be learning?
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!