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.

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?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!
Thanks for reaching out!

You’ll hear from us shortly. In the meantime, why not check out what our customers have to say about ACG?