Udemy – Advanced SQL Database Administration with MySQL Workbench 2022-2

MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in the arsenal. In this course, you’ll take your database administration skills to the next level, expanding into advanced concepts like replication, automation, and database security. We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing the key principles of normalized databases. From there we’ll work through more advanced concepts like replication, backup and recovery, and learn how to leverage automation via stored procedures, triggers, and scheduled events.

Throughout the course, you’ll be playing the role of Lead Database Administrator for an e-commerce startup, and learn how to build and populate an entire database from the ground up using real-world projects and assignments. This course does NOT go deep on data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

What you’ll learn

• Write SQL queries and use MySQL Workbench to create new databases from scratch
• Explore database security threats and practice techniques like replication, backup and recovery
• Leverage advanced automation tools like triggers, stored procedures, and scheduled events
• Create and modify EER diagrams to understand table structures and relationships
• Work through practical, real-world assignments and projects you won’t find anywhere else
• Get LIFETIME access to resource files, quizzes, assignments, and expert support

Who this course is for

• Analysts or BI professionals looking to gain a deeper understanding of database management
• DBAs who want to learn advanced database management & automation tools
• Anyone seeking to master one of the world’s most popular database programming languages
• Students looking for a hands-on and project-based deep dive into database administration with MySQL
• NOTE: This course does NOT cover database analysis (we cover data analysis in a separate course)

Specificatoin of Advanced SQL Database Administration with MySQL Workbench

• Publisher : Udemy
• Teacher : Maven Analytics , John Pauler
• Language : English
• Level : All levels
• Number of Course : 81
• Duration : 7 hours and 55 minutes

Content on 2022/11

Requirements of Advanced SQL Database Administration with MySQL Workbench

• MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk through the free install)
• If you are new to MySQL or database administration, we recommend taking our “SQL Database for Beginners” course first

Pictures

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720p

Download Links

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 55.7 MB

File size

2.05 GB