Complete MySQL Database Administration Course
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
Requirements
- Positive attitude and desire to learn
- Passion to become SQL database administrator
- A PC or MAC with at least 4-8G of RAM
Description
MySQL Server continues to be one of the world's most popular, FREE and top databases. Database is a heart of IT which is needed to stored all critical data and information.
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. 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
If you want to become an expert in SQL database administration then this is the course for YOU.
This training course will provide you all the necessary skills you need to be a successful 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 its 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 is Data and Database and 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 its different forms
Create your first Database, Table and Populate 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 is 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 affect?
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
Full 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 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
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
Section 12:
MySQL Replication and its Advantages
MySQL Replication Methods
Synchronization Types
Replication Formats
MySQL Replication Setup Demo
Quiz
Who this course is for:
- Anyone who wants to start a career in SQL database administration
- Anyone who wants to have complete SQL database training to get a job in IT
- Anyone who wants to advance his/her career
- Anyone who wants to master the SQL command line skills
- College students
- IT professionals, teachers and instructors
Instructors
- 4.6 Instructor Rating
- 118,419 Reviews
- 767,576 Students
- 45 Courses
Imran Afzal, CEO of UTCLI Solutions and a best-selling IT instructor, has trained over a million students worldwide in IT, systems administration, and career development. An educator, mentor, and entrepreneur, he brings over 20 years of experience in systems engineering, leadership, and training across Fortune 500 companies in finance, fashion, and tech media.
His IT journey began in 2001 at Time Warner, NYC, and has since included leading major projects like data center migrations, VMware deployments, monitoring tools implementation, and Amazon cloud migrations. Imran holds a Computer Information Systems degree from Baruch College (CUNY) and an MBA from NYIT.
Certified in Linux System Administration, VMware, UNIX, and Windows Server, Imran has been training students since 2010 through top-rated online courses and onsite programs. His mentorship has helped thousands secure IT jobs.
Beyond IT, Imran is dedicated to education and community service, founding a non-profit school for children (Pre-K to 10th grade).
==========================================
Here is what students have to say:
Hi Imran, I have completed this course twice. It was more than just wonderful. It proved to be life changer for me, I had zero knowledge about Linux and now i am working as Linux SysAdmin as i have acquired my dream job.
Thank you so much for the wonderful course. I am looking forward to see some more exciting courses from you.
Regards, -- Hasan Raza
To all of you that are looking for a REALLY GOOD LINUX course, THIS IS IT, SERIOUSLY I promise you won't find a course on LINUX here that is THIS GOOD. -- T.J. Marstiller
Hi Imran, I am so glad to inform you that i got two offers as a Linux engineer. Through your course I gained lot of confidence and your interview tips really helped me a lot to crack the technical rounds. I have recommended your courses to my friends as well. Thank you so much for your efforts in sharing your knowledge to learners like us. -- Subhasree
Hi Sir Imran,
Greetings to you. I am writing this email to give good feedback regarding your course materials that I have watched from Udemy. I have completed your Linux course and I would like to mention that it has been nothing but awesome. Your course has allowed me to obtain a Linux certification and I would like to give a big thanks you for that. Please continue what you're doing and I wish you the very best. -- Yusuf Ishkandersha
Imran is a very knowledgeable and engaging instructor. As others have said, you can tell that he is not just trying to sell a course, but that he is invested in giving his students a strong career foundation with a positive and approachable attitude. He is also entertaining with his use of pop culture and practical work examples. It really feels like you're in a classroom with him. I'm taking this course mainly as a hobbyist, but got a lot from it already. The homework assignments, quizzes, and handouts help reinforce the material. -- Raymond B.
- Main thing about course is its simplicity and the hierarchy. Design is very good and easy which helps to understand things better. -- Akash Garg (Udemy Student)
- I just love the teaching ad the learning experience I am getting -- Jacob Samba (Udemy Student)
- Imran Afzal might be my favorite teacher I've EVER had. He is funny, and engaging. The course was easy to follow, and with no experience starting I am now extremely comfortable with Linux, and actually really like it. He does make you do your googles, but this is not a bad thing especially considering the nature of IT and documentation to solve your own problems. I highly recommend. -- Vanessa Diaz-Goumond (Udemy Student)
- The course is run very well and I really like the handouts and the homework that is assigned. The homework helps me learn and continue with the learning process even when adult life is still progressing forward. -- Thomas Rogers (Udemy Student)
- Such an amazing instructor. Imran must have put in a lot of effort in structuring the course and taking the student step by step, he takes his time in explaining everything, from what Linux is, how to down load it, coding, etc. I have taken other courses from Imran. I am a student for life. Keep it up and please keep preparing more courses for please like us who can benefit from your way of teaching, knowledge and experience. Thank you. -- Ali Shiekh (Udemy Student)
- In the first place I say a big thank you to the instructor for making such a great course. I was afraid to learn Linux. I now feel very comfortable with Linux. I have understood both the concept behind and the practical as well. I would recommend every one who is NEW to Linux and wants to grab it once and for all without wasting time to go ahead and ERNOLL. You will not regret it. I would like the instructor to do same for WINDOWS SERVER ADMIN., I don't seem to find any better and beginner oriented course out there that could be matched with this course. To me, it is the BEST Linux Course on Online. I just started some real world projects with Linux after this great course, I was new to Linux and in just a month I am on the command line always playing. -- Opoku Bright (Udemy Student)
- I genuinely look forward to additional courses in the future. This has been so informative. You hear the name oracle all the time, but this was well put in layman’s terms -- Atoofa Hasan (Classroom Student)
- Imran Afzal eats, breathes and sleeps Linux! He really knows his stuff. I feel like he has brought me from a novice level education to masters level in a short time period. Anyone who is looking to get a job in Linux should definitely take this course. -- TJ Walker (Mentor)
- I find it very easy to understand & learn Linux. Even if you are beginner in Linux you will understand the material. Imran has done a great job explaining every topic in detail in each course. This course has provided me with a great deal of knowledge about Linux. This course is worth every penny of yours. -- Mohammad Jalani (Classroom Student)
- 4.6 Instructor Rating
- 11,696 Reviews
- 89,478 Students
- 5 Courses
I am working in IT since 2005 in various roles , I started my career as System Engineer and later worked as a developer. Couple of years after working as .net developer I finally changed my career to be Data Base Administrator which was my specialization in my MS . I did MS in CS from CUNY. In last 15 years I have worked with Government and Private organization in different capacities mostly working on Data Base administration and development.