Explore

MySQL Database Admin -DBA for Beginners

9.5 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Learn Practical Hands-on MySQL DBA Skills

Description

The MySQL is the world's most popular open source database.

This course will teach you a lot to start using this incredibly popular MySQL database and gain useful skills in the process. In learning about MySQL you will also gain an understanding of relational databases in general. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.

You will learn how to use the MySQL Workbench which is a very powerful administrative tool that contains a lot of useful features that will enable you perform various administrative tasks on MySQL Server installations.

What You will learn includes:

Installation and configuration of MySQL Server
Creating Databases
Creating Tables
Creating Views
Creating Stored Procedures
Using subqueries
Managing users and proviledges
Performing backups and restore
Checking client connections
Checking Server Status
Perform table joins
Explore and use MySQL Workbench
Use MySQL Command line client
Execute Common MySQL Commands
Query databases
Update databases
Delete records
Perform aggregate functions
Using SQL Editors

Requirements

Requirements
Should be knowledgeable with relational database concepts
Should be comfortable using the mysql command-line client
Should be knowledgeable with MySQL data types

Knowledge

Perform backups of your data
Manage users and privileges
Install the MySQL server
Configure MySQL server
Create Views
Create stored procedures
Perform table joins
Create databases
Create tables
Explore and use MySQL Workbench
Use MySQL Command line client
Execute Common MySQL Commands
Query databases
Update databases
Delete records
Perform aggregate functions

Recommended for you

The Complete PHP MYSQL Professional Course with 5 Projects

Learn PHP MYSQL by building 5 Projects including PHP Regular Expressions & CMS | Become a Full Stack Back-End Developer.  For example the basic videos, Free starter content etc....

Save Course

Projects in PHP and MySQL

Master PHP-MySQL by Building 10 Projects This is the ultimate course for all web developers who want to learn web programming while building practical projects along with the instructor....

Save Course

Introduction to Data Extraction Using SQL

Master the basics of querying databases using SQL - The World's most popular database language In this course, we will focus on ANSI(American National Standards Institute) SQL that works on...

Save Course