Description

SQL Database Administration: Advanced MySQL Workbench. This course develops SQL database administration skills with a focus on MySQL Workbench and covers advanced concepts such as replication, automation, and database security. Participants will be introduced to installing MySQL Community and Workbench and will learn key database administration tasks, including creating and editing tables, importing data, and normalization concepts. They will then move on to more advanced topics such as backups, data recovery, and using stored procedures, triggers, and scheduled events. During the course, participants will simulate the role of a senior database administrator in an e-commerce startup and will design and manage a database from the ground up through hands-on projects. Course topics include importing large amounts of data, managing primary and foreign keys, designing EER diagrams, and securing your database. Finally, a final project tests all the skills learned in the form of restructuring tables, creating views, designing a security program, and automating processes. This course is designed for those who want to strengthen their database administration skills in the MySQL Workbench environment.

What you will learn

• Write SQL queries and use MySQL Workbench to create new databases from scratch.
• Explore database security threats and practice techniques such as Replication, Backup, and Recovery.
• Utilize advanced automation tools such as Triggers, Stored Procedures, and Scheduled Events.
• Create and modify EER Diagrams to understand the structure and relationships of tables.
• Work on practical, real-world assignments and projects that you won’t find anywhere else.
• Permanent access to resource files, tests, assignments, and expert support.

This course is suitable for people who:

• Analysts or BI (business intelligence) professionals seeking a deeper understanding of database management.
• DBAs (Database Administrators) who want to learn advanced database management and automation tools.
• Anyone looking to master one of the most popular database programming languages in the world.
• Students looking for an in-depth, practical, project-based exploration of database management with MySQL.
• Note: This course does not cover database analysis (data analysis is covered in a separate course).

SQL Database Administration: Advanced MySQL Workbench Course Details

• Publisher : Udemy
• Teacher : Maven Analytics • 1,500,000 Learners , John Pauler
• Language: English
• Level : All Levels
• Lectures : 81
• Duration : 7 hours and 56 minutes

Course topics

Prerequisites for the SQL Database Administration: Advanced MySQL Workbench course

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

Course images

Sample course video

The 2025/5 version has increased the number of lessons by 3 and the duration increased by 27 minutes compared to 2020/3.

Download link

Downloadly

Download Part 1 – 1 GB

Download Part 2 – 442 MB

Rapidgator

Download Part 1 – 1 GB

Download Part 2 – 442 MB

File(s) password: www.downloadly.ir

File size

1.43 GB