Dear users, due to the protests and the disorderly situation in Iran, there is a possibility of Internet interruption in Iran. We apologize in advance if there is a problem in updating the site. MahsaAmini WomanLifeFreedom

Download Complete MySQL DBA Training on Linux

Download Complete MySQL DBA Training on Linux

What you would learn in Complete MySQL DBA Training on Linux course?

MySQL Server continues to be among the world's most popular, popular, and FREE most popular databases. The database is the core of IT that is required to store all critical information and data.

MySQL is a DBMS which is a database management software. It was created, supported, and distributed through Oracle; however, since it's open-source, it's accessible to everyone. MySQL databases are relational, which means that data is divided into tables. MySQL is speedy and lightweight, which means it can be run alongside other programs on your laptop or desktop. MySQL can also be scaled to benefit from all the power of CPU and memory that is available on a dedicated machine.

This is the program to take if you want to master SQL database administration.

This training course will give you the essential knowledge you require to become successful as a database administrator.

Here is the course outline:

Course Syllabus

Section 1:

  • Introduction to Database

  • RDBMS

  • What is SQL?

  • Top 5 RDBMS

  • Introduction to MySQL Server

  • Different editions of MySQL

Section 2:

  • MySQL Server 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

  • Virtual Machine Management

Section 3:

  • Important things to remember in Linux

  • Linux navigation commands

  • What is root?

  • Directory listing attributes

  • Linux command syntax

  • Creating files and directories and their permissions

  • Changing password

  • Help commands

  • Adding text to files

  • Pipes (|)

  • File maintenance commands

  • File display commands

  • Linux file editor

  • User account management and sudo access

  • Process monitor commands

  • Crontab

  • Linux network files and commands

  • Secure copy (SCP)

  • System updates and repos (rpm and yum).

Section 4:

  • Forks of MySQL and Cloud Computing

  • MySQL installation

  • Download, Install and Configure MySQL

  • Install MySQL Workbench

  • Download and restore sample Sakila DB

  • Quiz

Section 5:

  • What are Data and Database and RDBMS?

  • How is data stored?

  • How is data saved in MySQL (Linux)

  • MySQL Storage engine and Types

  • What are 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 its different forms

  • Create your first Database, Table and Populate the table with data

  • Quiz

Section 6:

  • SQL Statement and Types

  • DML Statement with examples

  • DDL Statements with examples

  • DCL statements with examples

  • TCL Statements with examples

  • Quiz

Section 7:

  • Create TABLE(s) and Temp Table(s)

  • SELECT Statement in detail

  • Operators, Expressions, and Conditions

  • WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause

  • Select from two tables - JOINS and different Types of JOINS

  • What is a Sub Query?

  • INSERT, UPDATE, and DELETE statements

  • Load data from a CSV file to MySQL and vice versa

  • Stored procedure

  • What are view, function, trigger, and index

  • Clustered, non-clustered Indexes and Index Design considerations

  • INDEX Cardinality, Table Fragmentation, USE INDEX, FORCE INDEX, and LAB

  • Quiz

Section 8:

  • MySQL Architecture Overview

  • MySQL Programs and invocation

  • Specifying Program Options and Option Files

  • How to edit the configuration file (.cnf)

  • Options scope

  • What options are in effect?

  • Quiz

Section 9:

  • 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

  • XtraBackup Utility by Percona, Functionality, and Installation

  • Complete Backup and Restore using Percona XtraBackup

  • Lab for mysqldump and Backups using MySQL Workbench

  • Incremental Backup and Restore using Percona XtraBackup

  • Schedule backups (cronjobs)

  • Quiz

Section 10:

  • Understanding MySQL Security

  • Root User in MySQL

  • CREATE USER and ALTER USER Statement

  • Create New User (MySQL Workbench)

  • MySQL Privileges, Privileges Control and Some necessary 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

  • Quiz

Section 11:

  • MySQL Server Performance Monitoring Basics

  • The General Query Log

  • The Slow Query Log

  • The Error Log

  • Optimizing configuration for MySQL performance

  • DB Engine Status

  • Query Optimization TIPS, EXPLAIN Statement, and Execution Plans

  • Query Optimization Demo

  • Quiz

Course Content:

  • 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

Download Complete MySQL DBA Training on Linux from below links NOW!

Similar cases