MySQL Database Admin -DBA for Beginners

Learn Practical Hands-on MySQL DBA Skills

4.50 (288 reviews)
Udemy
platform
English
language
Databases
category
17,070
students
9.5 hours
content
Jun 2021
last update
$74.99
regular price

What you will learn

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

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


SQL is the language used to interact with databases like MySQL  and others

SQL is a standard language for accessing and manipulating databases.


What is SQL?

SQL stands for Structured Query Language

SQL lets you access and manipulate databases

SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

SQL can execute queries against a database

SQL can retrieve data from a database

SQL can insert records in a database

SQL can update records in a database

SQL can delete records from a database

SQL can create new databases

SQL can create new tables in a database

SQL can create stored procedures in a database

SQL can create views in a database

SQL can set permissions on tables, procedures, and views

SQL is a Standard - BUT....

Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.

Content

MySQL Installation

Introduction
What is SQL
What is MySQL
MySQL Download and Installation (Windows)
What is MySQL Workbench
MySQL Installation (Mac)
Installing MySQL Workbench (Mac)
Basic Database Concepts
What is a Schema
Database Schema
MySQL Data Types

MySQL Workbench Configuration

User Accessibility Options
Preferences Options
General Editor Preferences
SQL Editor Preferences
Administration Preferences
Modelling Preferences
Fonts and Colors
SSH Preferences
Other Preferences
MySQL Workbench Home Screen

Database Modeling

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

Performing Administrative tasks

Creating a new MySQL Connection
Managing Server Connections
Client Connections
Checking Server Status
Administration of users and Priviledges
Checking Performance Dashboard
Using MySQL Utilities
Using Object Browser
Showing existing databases
Showing list of tables
Create a Database
Create a Table
Using basic SQL Commands
Displaying table structure
Changing Table Structure

Creating MySQL Objects

MySQL Naming Convention
Creating a MySQL Database
Using IF NOT EXIST DROP
Creating a Table in MySQL
Setting up default database
Using MySQL Comments
Primary keys
Foreign keys

MySQL Statements

MySQL SELECT statement
MySQL INSERT Statement
MySQL UPDATE Statement
MySQL DELETE Statement

MySQL Access Privilege System

MySQL Access Privilege
What You can not do with MySQL privilege SYSTEM
Static and Dynamic priviledges
Applying dynamic priviledges
Migrating SUPER priviledges
MySQL Priviledges

MySQL Backup and Recovery

Introduction to MySQL Backup and Recovery
Backup and Recovery Types
Setting up backup directory with mysqldump
Export data from MySQL Database
Export result set of a query
Backing up databases with mysqldump
Restore database from backup
Backing up a single table
Restoring table from backup

MySQL Table Joins

MySQL INNER Join
MySQL LEFT JOIN
MySQL RIGHT Join
MySQL SELF join

MySQL Views

MySQL Views
Creating a MySQL View
Querying MySQL Views
Modifying a view
Dropping a view

MySQL Stored Procedures

What are stored procedures
Creating stored procedure
Modifying stored procedure
Creating an advanced stored procedure
Calling and deleting stored procedures

MySQL Subqueries

What is a subquery
Nested subqueries
Derived Tables

MySQL Clauses | Keywords | Some String Functions

DISTINCT keyword
GROUP BY Clause
HAVING clause
ORDER BY clause
WHERE Clause
LIMIT Clause
CHARACTER Function
CONCAT Function

MySQL Aggregate Functions

Introduction to Aggregate Functions
AVG Aggregate Functions
COUNT Aggregate Functions
SUM Aggregate Functions
MIN Aggregate Functions
MAX Aggregate Functions

Some Basic MySQL Operators

BETWEEN Operator
IN Operator
LIKE Operator
UNION Operator

Screenshots

MySQL Database Admin  -DBA for Beginners - Screenshot_01MySQL Database Admin  -DBA for Beginners - Screenshot_02MySQL Database Admin  -DBA for Beginners - Screenshot_03MySQL Database Admin  -DBA for Beginners - Screenshot_04

Reviews

Ragul
November 11, 2022
Missed Topics : Index, CLI for My SQL in other open source platforms Need more clarity about stored procedures All the basic operators and functions should have been in the beginning of the Video.
Luke
October 6, 2022
I used this as a SQL refresher, but also to learn use of MySQL Workbench. Easy to follow along and is relevant with the latest version of MySQL.
Jahidul
May 30, 2022
As I am a beginner at databases, I learn many things in this course. the course instructor is also good.
Kotla
May 23, 2022
All is well, but some topics like privileges, and backups to be explained with example, that would be good to understand.
Igor
May 3, 2022
A number of explanations are repetitive; introduction to e.g. SELECT statement (the theory) should be step by step with expanding example; the demonstrations could be better organizied, like select before insert/insert/select after insert (or describe table/create/describe table). And some explanations are somewhat lacking logical path or are incomplete. I understand that you put a lot of effort in preparing the course, I am just telling points where to improve. I am working in IT for 30 years now, am DB Senior Admin for Oracle, so I might have high expectations.
Jose
April 29, 2022
Well explained! Instructor goes over very important topics needed to become a database administrator and goes above an beyond by also teaching how to use the MySQL client to connect to your database and administer your database server. Thank you!
Giedrius
January 17, 2022
Too short videos where introduction to it and goodbye takes most of the lesson time. Should be combined to one video for single chapter. Content for most of video usually is already covered in previous examples and already explained so that's to boring to listen to the same thing again and again.
Naim
November 29, 2021
Yes I needed some advanced stuff , like master slave replication and how to check the logs and troubleshooting
Ritam
October 24, 2021
Experience were quite helpfull but it could be made if certain special things are elaborated just like stored procedure , union. trigger were not found in the topic it must be included. Apart from that it went well.
Howard
May 27, 2021
the course has introductory materila which is not suitable for an intermediate or advanced DBA, howevr, it is good to review anyway just to confirm differences between MYSQL and Microsoft SQL. The instructor does an excellent job in presenting critical details
Julian
August 7, 2019
So far its been a good course to identify the many topics related to DBA. However, more in-depth explanations and use cases related to topics would have been beneficial. Often he would read word-for-word from the MySQL Workbench application and say "This is where you would set [ ___ ]" but not explain what [ ___ ] does nor why it's important. So far I would recommend setting this on a higher playback rate to take a tour around MySQL Workbench, then research specific topics/settings on your own.
Ben
July 5, 2019
Wasn't really a Database Admin course. Much of the content was SQL. Didn't really cover what I wanted.
Mark
December 20, 2018
The course covers the basic aspects of MySQL. Although there are no exercises and the videos are sometimes out of focus, following the lessons is straightforward. The instructor assumes that the student has no prior experience in this area and steps through each lesson quite deliberately. I like his English accent and he is easy to understand.

Coupons

DateDiscountStatus
4/2/2021100% OFF
expired
4/26/202384% OFF
expired

Charts

Price

MySQL Database Admin  -DBA for Beginners - Price chart

Rating

MySQL Database Admin  -DBA for Beginners - Ratings chart

Enrollment distribution

MySQL Database Admin  -DBA for Beginners - Distribution chart
1860694
udemy ID
8/16/2018
course created date
11/20/2019
course indexed date
Bot
course submited by