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

Welcome to the lab design and setup

Lab Setup Pre-requisite

What is Virtualization?

Download and Install VMWare Workstation Player

Optional: Download and Install Oracle Virtualbox

Create a Virtual Machine

Download and Install Linux server (CentOS 8)

Download and Install Linux Server (CentOS 9 Stream)

Virtual machine management

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

Welcome To Download, Install, and Configure MySQL Section

Brief History, Forks of MySQL, and Cloud Computing

MySQL installation steps (prerequisites, distribution, versions, etc.)

Download, Install, and Configure MySQL (CentOS 9 Stream)

Install MySQL Workbench (CentOS 8)

Download, Install, and Configure MySQL (CentOS 8)

Install MySQL Workbench (CentOS 9 Stream)

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

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

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 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, Non-Clustered Indexes and Index Design Considerations

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 Effect?

MySQL Architecture and Option Files

Welcome to MySQL Backups and Restore Section

MySQL Backups: Why We Need Backup, RTO and RPO

Types 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

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

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

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

Welcome to MySQL Replication Sections

MySQL Replication and Its Advantages

MySQL Replication Methods, Synchronization Types, and Replication Formats

MySQL Replication Setup Demo

MySQL DBA program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

Why Should You Learn MySQL DBA Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches

DSP & Microcontrollers

Computer Hardware

Cisco

Cisco & Networking Certifications

MySQL DBA program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

# Introduction

# Lab design and setup

# Linux Basics for a DB Administrator

# Download, Install and Configure MySQL

# Database Fundamentals and Design

# Introduction to SQL Commands

# Query and Data Manipulation

# MySQL Architecture and Option Files

# MySQL Backups and Recovery

# Users and Privileges Management

# Monitoring MySQL Server

# MySQL Replication

Why Should You Learn MySQL DBA Training?

Request more information

What you will get at Zeblearnindia Learning?

() 60 Minutes WEBINAR with CERTIFICATE

Explore Our Courses Across India - Flexible batches