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:
Introduction to Database
What is SQL?
Top 5 RDBMS
Introduction to MySQL Server
Different editions of MySQL
MySQL Server 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
Virtual Machine Management
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
Adding text to files
File maintenance commands
File display commands
Linux file editor
User account management and sudo access
Process monitor commands
Linux network files and commands
Secure copy (SCP)
System updates and repos (rpm and yum).
Forks of MySQL and Cloud Computing
Download, Install and Configure MySQL
Install MySQL Workbench
Download and restore sample Sakila DB
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
SQL Statement and Types
DML Statement with examples
DDL Statements with examples
DCL statements with examples
TCL Statements with examples
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
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
MySQL Architecture Overview
MySQL Programs and invocation
Specifying Program Options and Option Files
How to edit the configuration file (.cnf)
What options are in effect?
MySQL Backups, why we need backup, RTO and RPO
Type of Backups in MySQL, offsite storage, encryption, and restore testing
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)
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
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
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!
Write your comment!
Access Permission Error
You do not have access to this product!
Dear User! To download this file(s) you need to purchase this product or subscribe to one of our VIP plans.