3.9 out of 5
3.9
35 reviews on Udemy

MySQL Database Admin -DBA for Beginners

Learn Practical Hands-on MySQL DBA Skills
Instructor:
Bluelime Learning Solutions
2,289 students enrolled
English [Auto-generated]
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

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

MySQL Installation

1
Introduction
2
What is SQL
3
What is MySQL
4
MySQL Download and Installation (Windows)
5
What is MySQL Workbench
6
MySQL Installation (Mac)
7
Installing MySQL Workbench (Mac)
8
Basic Database Concepts
9
What is a Schema
10
Database Schema
11
MySQL Data Types

MySQL Workbench Configuration

1
User Accessibility Options
2
Preferences Options
3
General Editor Preferences
4
SQL Editor Preferences
5
Administration Preferences
6
Modelling Preferences
7
Fonts and Colors
8
SSH Preferences
9
Other Preferences
10
MySQL Workbench Home Screen

Database Modeling

1
Introduction to data modeling
2
Creating a model - part 1
3
Creating a model - part 2
4
Basic modeling

Performing Administrative tasks

1
Creating a new MySQL Connection
2
Managing Server Connections
3
Client Connections
4
Checking Server Status
5
Administration of users and Priviledges
6
Checking Performance Dashboard
7
Using MySQL Utilities
8
Using Object Browser
9
Showing existing databases
10
Showing list of tables
11
Create a Database
12
Create a Table
13
Using basic SQL Commands
14
Displaying table structure
15
Changing Table Structure

Creating MySQL Objects

1
MySQL Naming Convention
2
Creating a MySQL Database
3
Using IF NOT EXIST DROP
4
Creating a Table in MySQL
5
Setting up default database
6
Using MySQL Comments
7
Primary keys
8
Foreign keys

MySQL Statements

1
MySQL SELECT statement
2
MySQL INSERT Statement
3
MySQL UPDATE Statement
4
MySQL DELETE Statement

MySQL Access Privilege System

1
MySQL Access Privilege
2
What You can not do with MySQL privilege SYSTEM
3
Static and Dynamic priviledges
4
Applying dynamic priviledges
5
Migrating SUPER priviledges
6
MySQL Priviledges

MySQL Backup and Recovery

1
Introduction to MySQL Backup and Recovery
2
Backup and Recovery Types
3
Setting up backup directory with mysqldump
4
Export data from MySQL Database
5
Export result set of a query
6
Backing up databases with mysqldump
7
Restore database from backup
8
Backing up a single table
9
Restoring table from backup

MySQL Table Joins

1
MySQL INNER Join
2
MySQL LEFT JOIN
3
MySQL RIGHT Join
4
MySQL SELF join

MySQL Views

1
MySQL Views
2
Creating a MySQL View
3
Querying MySQL Views
4
Modifying a view
5
Dropping a view

MySQL Stored Procedures

1
What are stored procedures
2
Creating stored procedure
3
Modifying stored procedure
4
Creating an advanced stored procedure
5
Calling and deleting stored procedures

MySQL Subqueries

1
What is a subquery
2
Nested subqueries
3
Derived Tables

MySQL Clauses | Keywords | Some String Functions

1
DISTINCT keyword
2
GROUP BY Clause
3
HAVING clause
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
35 Ratings

Detailed Rating

Stars 5
12
Stars 4
9
Stars 3
7
Stars 2
3
Stars 1
2
ed50f62ab749fcf0bb0528451d01e9a8
30-Day Money-Back Guarantee

Includes

9 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion