IIRF Online > Office Productivity > Oracle > Database Administration > Complete MySQL Database Administration Course
Complete MySQL Database Administration Course by Udemy
MySQL DBA Training to get your Dream IT Job
Course Highlights
- You will be able to apply for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
- You will learn 150+ SQL queries
- Administration of SQL database through Linux Operating System
- You will manage SQL servers in a corporate environment
- Troubleshoot everyday SQL database related issues
- Know how to answer specific business questions by using SQL’s aggregate functions
Skills you will learn!
Curriculum
9 Topics
Introduction
Course overview
Introduction to database
What is RDBMS?
What is SQL?
Top 5 RDBMS using SQL
Introduction to MySQL Server
Editions of MySQL Server
Introduction
11 Topics
Welcome to the lab design and setup
Lab Setup Pre-requisite
Lab design
What is Virtualization?
Download and Install VMWare Workstation Player
Optional - Download and Install Oracle Virtualbox
Create a Virtual Machine
Download and Install Linux server (CentOS8)
Download and Install Linux Server (CentOS9 Stream)
Virtual machine management
Lab design & setup
23 Topics
Welcome to Linux basic administration
Important Things to Remember in Linux
Linux navigation commands (cd pwd and ls)
What is root?
Directory Listing Attributes
Linux Command Syntax
Creating Files and Directories (touch cp vi mkdir)
Changing Password
Files and Directory Permissions (chmod)
Help Commands
Adding Text to Files
Pipes ( | )
File Maintenance Commands (cp rm mv mkdir rmdir)
File Display Commands (cat less more head tail)
Linux File Editor (vi)
User Account Management (useradd groupadd usermod userdel groupdel)
Switch Users and Sudo Access (su sudo)
Process monitor commands (ps and top)
crontab command
Linux network files and commands
SCP - Secure Copy Protocol
System Updates and Repos (rpm yum)
Linux Basics for a DB Administrator
9 Topics
Weclome To Download Install and Configure MySQL Section
Brief History Forks of MySQL and Cloud Computing
MySQL installation steps (prereq distribution versions etc)
Download Install and Configure MySQL (CentOS8)
Download Install and Configure MySQL (CentOS9 Stream)
Install MySQL Workbench (CentOS8)
Install MySQL Workbench (CentOS 9 Stream)
Download and restore sample Sakila DB
Download Install and Configure MySQL
14 Topics
Welcome To Database Fundamentals and Design Section
What is Data?
What is Database?
What is Relational Database and Relational Database Management System (RDBMS) ?
How is data stored ?
How is Data Saved in MySQL (linux)
MySQL Storage engine and Types
What is a Table COLUMN and ROW ?
What is a Key?
What is Primary Key Foreign Key Unique Key etc ?
What is a Transaction and ACID properties?
Database Normalization AND Different forms of Database Normalization
Create your first Database Table and Populate table with data
Database Fundamentals and Design
7 Topics
Welcome to Basic SQL Commands Section
SQL Statement and Types
DML Statement with examples
DDL Statements with examples
DCL Statement with examples
TCL Statement with examples
Introduction to SQL Commands
21 Topics
Welcome to Query and Data Manipulation Sections
Create TABLE(s) and Temp Table(s)
SELECT Statement in detail
Operators Expressions and Conditions
WHERE Clause ORDER BY Clause HAVING By Clause GROUP BY Clause
Select from two tables - JOINS
Different Types of JOINS
What is a Sub Query?
INSERT Statement in detail
Load Data from a CSV file to MySQL
Export data from MySQL to a CSV
UPDATE Statement in detail
DELETE Statement in detail
What is a Stored Procedure
What Is a View?
What is a Function?
What is a Trigger?
What is an INDEX?
Clustered NonClustered Indexes and Index Design considerations
INDEX Cardinality Table Fragmentation USE INDEX FORCE INDEX and LAB
Query and Data Manipulation
6 Topics
Welcome to MySQL Architecture and Option Files Section
MySQL Architecture Overview
MySQL Programs and invocation Specifying Program Options and Option Files
my.cnf file and How to edit my.cnf (LAB)
Options Scope and What options are in affect ?
MySQL Architecture and Option Files
13 Topics
Welcome to MySQL Backups and Restore Section
MySQL Backups why we need backup RTO and RPO
Type of Backups in MySQL Offsite Storage Encryption and Restore Testing
Binary Logs
The mysqldump Utility
Restore of database using mysql and Workbench
Table level Backup and Restore
Point In Time Recovery in MySQL and Lab
XtraBackup Utility by Percona Functionality and Installation
Full Backup and Restore using Percona Xtrabackup
Incremental Backup and Restore using Percona XtraBackup
Schedule backups (cronjobs)
MySQL Backups and Restore
13 Topics
Lab for mysqldump and Backups using MySQL Workbench
Welcome to Users and Privileges Management Section
Understanding MySQL Security
Root User in MySQL
CREATE USER and ALTER USER Statement
Create New User (MySQL Workbench)
MySQL Privileges Privileges Control and Some important Privileges in MySQL
GRANT Statement WITH GRANT Option and Granting Privileges to MySQL User
GRANT Tables and Checking Privileges
REVOKE Statement and Revoking Privileges
DROP USER Statement
Roles in MySQL
Users and Privileges Management
10 Topics
Welcome to Monitoring MySQL Server Section
MySQL Server Performance Monitoring Basics
The General Query Log
The Slow Query Log
The Error Log
Optimizing my.cnf for MySQL performance
InnoDB Engine Status
Query Optimization TIPS EXPLAIN Statement and Execution Plans
Query Optimization Demo
Monitoring MySQL Server
6 Topics
Welcome to MySQL Replication Sections
MySQL Replication and Its Advantages
MySQL Replication Methods Synchronization Types and Replication Formats
MySQL Replication Setup Demo
Congratulations
MySQL Replication
Complete MySQL Database Administration Course
Related Database Administration Courses
.webp)
Thank You!
Your review has been submitted successfully.