Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

A Cloud Guru

Database Administration and SQL Language Basics

via A Cloud Guru

Overview

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.

Syllabus

  • Course Introduction
  • General Administration
  • Data Types
  • Stored Objects
  • User Access
  • Modifying Data
  • Querying and Filtering Data
  • Final Steps

Taught by

Matthew Pearson

Reviews

Start your review of Database Administration and SQL Language Basics

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.