MySQL Database Administration (Beginner)

MySQL for Database Administrators course enables DBAs and other database professionals to maximize their organization’s investment in MySQL. Participants will learn how to configure the MySQL Server, set up replication and security, perform database backups and recoveries, optimize query performance, and configure for high availability.

The MySQL for Database Administrators training course discusses: Install and configure MySQL Server and client programs, recognize the key components of the MySQL architecture, Manage user accounts and secure your server, Troubleshoot server slowdowns and other issues, Backup, and recovery MySQL database, Configure and administer a variety of replication topologies

What you’ll learn

Write SQL queries and use the MySQL Workbench UI to create databases and tables
Learn how to alter tables by adding and removing columns
Connect data between tables by creating primary and foreign key relationships
Assign user roles and permissions to database users, just like a real DBA
Solve practical hands-on assignments and real-world business use cases
Master unique tips, tools and case studies that you won’t find anywhere else
Understand common Relational Database Management Systems (RDBMS)
Get LIFETIME access to resource files, quizzes, assignments, and expert support

Course Content:

Module1: My SQL Overview

Introduction to SQL
Relational Databases
Relational Database Management Systems
QUIZ: SQL & Relational Database Overview

Module2: My SQL Intro& Setup

MySQL Installation Overview
Mac Download – MySQL Community Serve
Mac Download – MySQL Workbench
PC Download – MySQL Community Server & MySQL Workbench
Connecting Workbench To The Serve
MySQL Workbench Interface
Creating Initial Schemas

Module3: Creating and Altering Schemas& Table

Creating A Schema Using The U
Creating A Schema Using SQL Cod
Creating A Table Using The U
Creating A Table With A SQL Quer
MySQL Data Type
Adding and Removing Columns In The Edito
Adding And Removing Columns With SQL Cod
Assignment: Adding And Removing Column
Solution: Adding And Removing Column
Dropping Schemas And Table
Assignment: Dropping Schemas And Table
Solution: Dropping Schemas And Table

Module5: Database Deign

Primary Keys and Foreign Key
Primary Keys and Foreign Keys Dem
Assignment: Table Relationship
Solution: Table Relationship
Database Normalization
Database Normalization Demo
Assignment: Normalization
Solution: Normalization
The EER Diagram Editor
Assignment: EER Diagram Editor
Solution: EER Diagram Editor

Module6: Advanced Concepts

Creating An Index
The Unique Constrain
The Non Null Constrain
Assignment: Indexes And Constraint
Solution: Indexes And Constraint
Stored Procedure
Assignment: Stored Procedure
Solution: Stored Procedure
Trigger
Assignment: Trigger
Solution: Triggers

Module7: Server Management

Server Management
Assignment: Server Management
Solution: Server Management
Managing Users And Permissions
Assignment: Managing Users And Permission
Solution: Managing Users And Permission
QUIZ: Server & User Management

Who this course is for:

Analysts or BI professionals looking to improve their understanding of relational database systems
Excel users looking to shift into a broader business intelligence or database-focused role
Anyone seeking to learn one of the world’s most popular and powerful database programming languages (SQL)
Students looking for a hands-on and highly engaging introduction to MySQL for database administration
Anyone looking to pursue a career as a database administrator

International Student Fee: 300$

Job Interview Preparation (Soft Skills Questions & Answers)

Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

Flexible Class Options