% Off Udemy Coupon - CoursesWyn

Complete MySQL Database Administration Course

MySQL DBA Training to get your Dream IT Job

$9.99 (93% OFF)
Get Course Now

About This Course

<div>MySQL Server continues to be one of the world's most popular, FREE and top databases.&nbsp; Database is a heart of IT which is needed to stored all critical data and information.&nbsp;</div><div><br></div><div>MySQL is a DBMS, or database management system. It is developed, supported and distributed by Oracle, but since it is open-source it is freely available to anyone.&nbsp; MySQL databases are relational, meaning that the data is split up between tables. MySQL is very fast and lightweight so you can run it alongside your other applications on a desktop or laptop. It can also be scaled up to take advantage of all the CPU power and memory available on a dedicated machine</div><div><br></div><div>If you want to become an expert in SQL database administration then this is the course for YOU.</div><div><br></div><div>This training course will provide you all the necessary skills you need to be a successful database administrator.</div><div><br></div><div><span style="font-size: 1rem;">Here is the course outline:</span></div><div><br></div><div>Course Syllabus</div><div><br></div><div>Section 1:</div><div><ul><li><span style="font-size: 1rem;">Introduction to Database</span></li><li><span style="font-size: 1rem;">RDBMS</span></li><li><span style="font-size: 1rem;">What is SQL?</span></li><li><span style="font-size: 1rem;">Top 5 RDBMS</span></li><li><span style="font-size: 1rem;">Introduction to MySQL Server</span></li><li><span style="font-size: 1rem;">Different editions of MySQL</span></li></ul></div><div><span style="font-size: 1rem;">Section 2:</span></div><div><ul><li><span style="font-size: 1rem;">MySQL Server pre-requisite</span></li><li><span style="font-size: 1rem;">Lab design</span></li><li><span style="font-size: 1rem;">What is virtualization?</span></li><li><span style="font-size: 1rem;">Download and Install VMWare Workstation Player</span></li><li><span style="font-size: 1rem;">Optional - Download and Install Oracle VirtualBox</span></li><li><span style="font-size: 1rem;">Create a Virtual Machine</span></li><li><span style="font-size: 1rem;">Download and Install Linux Server</span></li><li><span style="font-size: 1rem;">Virtual Machine Management</span></li></ul></div><div><span style="font-size: 1rem;">Section 3:</span></div><div><ul><li><span style="font-size: 1rem;">Important things to remember in Linux</span></li><li><span style="font-size: 1rem;">Linux navigation commands</span></li><li><span style="font-size: 1rem;">What is root?</span></li><li><span style="font-size: 1rem;">Directory listing attributes</span></li><li><span style="font-size: 1rem;">Linux command syntax</span></li><li><span style="font-size: 1rem;">Creating files and directories and its permissions</span></li><li><span style="font-size: 1rem;">Changing password</span></li><li><span style="font-size: 1rem;">Help commands</span></li><li><span style="font-size: 1rem;">Adding text to files</span></li><li><span style="font-size: 1rem;">Pipes (|)</span></li><li><span style="font-size: 1rem;">File maintenance commands</span></li><li><span style="font-size: 1rem;">File display commands</span></li><li><span style="font-size: 1rem;">Linux file editor</span></li><li><span style="font-size: 1rem;">User account management and sudo access</span></li><li><span style="font-size: 1rem;">Process monitor commands</span></li><li><span style="font-size: 1rem;">Crontab</span></li><li><span style="font-size: 1rem;">Linux network files and commands</span></li><li><span style="font-size: 1rem;">Secure copy (SCP)</span></li><li><span style="font-size: 1rem;">System updates and repos (rpm and yum).</span></li></ul></div><div><span style="font-size: 1rem;">Section 4:</span></div><div><ul><li><span style="font-size: 1rem;">Forks of MySQL and Cloud Computing</span></li><li><span style="font-size: 1rem;">MySQL installation</span></li><li><span style="font-size: 1rem;">Download, Install and Configure MySQL</span></li><li><span style="font-size: 1rem;">Install MySQL Workbench</span></li><li><span style="font-size: 1rem;">Download and restore sample Sakila DB</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 5:</span></div><div><ul><li><span style="font-size: 1rem;">What is Data and Database and RDBMS?</span></li><li><span style="font-size: 1rem;">How is data stored?</span></li><li><span style="font-size: 1rem;">How is data saved in MySQL (Linux)</span></li><li><span style="font-size: 1rem;">MySQL Storage engine and Types</span></li><li><span style="font-size: 1rem;">What is a Table, COLUMN and ROW ?</span></li><li><span style="font-size: 1rem;">What is a Key?</span></li><li><span style="font-size: 1rem;">What is Primary Key, Foreign Key, Unique Key etc.</span></li><li><span style="font-size: 1rem;">What is a Transaction and ACID properties?</span></li><li><span style="font-size: 1rem;">Database Normalization AND its different forms</span></li><li><span style="font-size: 1rem;">Create your first Database, Table and Populate table with data</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 6:</span></div><div><ul><li><span style="font-size: 1rem;">SQL Statement and Types</span></li><li><span style="font-size: 1rem;">DML Statement with examples</span></li><li><span style="font-size: 1rem;">DDL Statements with examples</span></li><li><span style="font-size: 1rem;">DCL Statements with examples</span></li><li><span style="font-size: 1rem;">TCL Statements with examples</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 7:</span></div><div><ul><li><span style="font-size: 1rem;">Create TABLE(s) and Temp Table(s)</span></li><li><span style="font-size: 1rem;">SELECT Statement in detail</span></li><li><span style="font-size: 1rem;">Operators, Expressions and Conditions</span></li><li><span style="font-size: 1rem;">WHERE Clause, ORDER BY, HAVING BY, GROUP BY Clause</span></li><li><span style="font-size: 1rem;">Select from two tables – JOINS and different Types of JOINS</span></li><li><span style="font-size: 1rem;">What is a Sub Query?</span></li><li><span style="font-size: 1rem;">INSERT, UPDATE, and DELETE statements</span></li><li><span style="font-size: 1rem;">Load data from a CSV file to MySQL and vice versa</span></li><li><span style="font-size: 1rem;">Stored procedure</span></li><li><span style="font-size: 1rem;">What is view, function, trigger and index</span></li><li><span style="font-size: 1rem;">Clustered, non-clustered Indexes and Index Design considerations</span></li><li><span style="font-size: 1rem;">INDEX Cardinality, Table Fragmentation, USE INDEX, FORCE INDEX and LAB</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 8:</span></div><div><ul><li><span style="font-size: 1rem;">MySQL Architecture Overview</span></li><li><span style="font-size: 1rem;">MySQL Programs and invocation</span></li><li><span style="font-size: 1rem;">Specifying Program Options and Option Files</span></li><li><span style="font-size: 1rem;">How to edit the configuration file (.cnf)</span></li><li><span style="font-size: 1rem;">Options scope</span></li><li><span style="font-size: 1rem;">What options are in affect?</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 9:</span></div><div><ul><li><span style="font-size: 1rem;">MySQL Backups, why we need backup, RTO and RPO</span></li><li><span style="font-size: 1rem;">Type of Backups in MySQL, offsite storage, encryption and restore testing</span></li><li><span style="font-size: 1rem;">Binary logs</span></li><li><span style="font-size: 1rem;">The mysqldump utility</span></li><li><span style="font-size: 1rem;">Restore of database using mysql and Workbench</span></li><li><span style="font-size: 1rem;">Table level Backup and Restore</span></li><li><span style="font-size: 1rem;">Point In Time Recovery in MySQL</span></li><li><span style="font-size: 1rem;">XtraBackup Utility by Percona, Functionality and Installation</span></li><li><span style="font-size: 1rem;">Full Backup and Restore using Percona XtraBackup</span></li><li><span style="font-size: 1rem;">Lab for mysqldump and Backups using MySQL Workbench</span></li><li><span style="font-size: 1rem;">Incremental Backup and Restore using Percona XtraBackup</span></li><li><span style="font-size: 1rem;">Schedule backups (cronjobs)</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 10:</span></div><div><ul><li><span style="font-size: 1rem;">Understanding MySQL Security</span></li><li><span style="font-size: 1rem;">Root User in MySQL</span></li><li><span style="font-size: 1rem;">CREATE USER and ALTER USER Statement</span></li><li><span style="font-size: 1rem;">Create New User (MySQL Workbench)</span></li><li><span style="font-size: 1rem;">MySQL Privileges , Privileges Control and Some important Privileges in MySQL</span></li><li><span style="font-size: 1rem;">GRANT Statement , WITH GRANT Option and Granting Privileges to MySQL User</span></li><li><span style="font-size: 1rem;">GRANT Tables and Checking Privileges</span></li><li><span style="font-size: 1rem;">REVOKE Statement and Revoking Privileges</span></li><li><span style="font-size: 1rem;">DROP USER Statement</span></li><li><span style="font-size: 1rem;">Roles in MySQL</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 11:</span></div><div><ul><li><span style="font-size: 1rem;">MySQL Server Performance Monitoring Basics</span></li><li><span style="font-size: 1rem;">The General Query Log</span></li><li><span style="font-size: 1rem;">The Slow Query Log</span></li><li><span style="font-size: 1rem;">The Error Log</span></li><li><span style="font-size: 1rem;">Optimizing configuration for MySQL performance</span></li><li><span style="font-size: 1rem;">DB Engine Status</span></li><li><span style="font-size: 1rem;">Query Optimization TIPS, EXPLAIN Statement and Execution Plans</span></li><li><span style="font-size: 1rem;">Query Optimization Demo</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div><div><span style="font-size: 1rem;">Section 12:</span></div><div><ul><li>MySQL Replication and its Advantages</li><li><span style="font-size: 1rem;">MySQL Replication Methods</span></li><li><span style="font-size: 1rem;">Synchronization Types</span></li><li><span style="font-size: 1rem;">Replication Formats</span></li><li><span style="font-size: 1rem;">MySQL Replication Setup Demo</span></li><li><span style="font-size: 1rem;">Quiz</span></li></ul></div>

What you'll learn:

  • 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

More Course Deals

Check out more discounted courses on CoursesWyn.

Browse All Deals