SQL Database Administration: Advanced MySQL Workbench

SQL Database Administration: Advanced MySQL Workbench
Last updated 11/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz, 2 Ch

Learn advanced SQL for database administration (DBA) & analytics, and practice building SQL databases w/ real projects!

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

Requirements
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

Description
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)