YoVDO

Database Administration and SQL Language Basics

Offered By: A Cloud Guru

Tags

SQL Courses MySQL Courses Relational Databases Courses Data Filtering Courses Data Manipulation Courses Database Administration Courses

Course Description

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

Related Courses

Managing Big Data with MySQL
Duke University via Coursera
Database Management Essentials
University of Colorado System via Coursera
Business Metrics for Data-Driven Companies
Duke University via Coursera
Bases de données relationnelles : Comprendre pour maîtriser
Inria (French Institute for Research in Computer Science and Automation) via France Université Numerique
Базы данных (Databases)
Saint Petersburg State University via Coursera