Explanation
MySQL is a powerful tool for managing and analyzing relational databases, and a skill that every analyst and BI professional should have in their arsenal. In this course, you’ll take your data management skills to the next level, expanding on advanced concepts like replication, automation, and database protection. We will begin by introducing the structure of the course, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; creating and editing schemas & tables, inserting and deleting records, and reviewing key principles of common databases. There we will work on more advanced concepts such as replication, backup and recovery, and learn how to leverage automation through stored procedures, triggers, and scheduled events.
During the course, you will play the role of Lead Database Administrator of an e-commerce startup, and learn how to build and deploy an entire database using real-world projects and activities. The course does not go in-depth on data exploration and data analysis. Our goal here is to focus on building, modifying, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover deep database analysis in separate courses).
What will you learn?
- Write SQL queries and use MySQL Workbench to create new databases from scratch
- Explore database risks and replication techniques such as replication, backup and recovery
- Take advantage of advanced automation tools like triggers, stored procedures, and scheduled events
- Create and modify EER diagrams to understand table structure and relationships
- Work on practical tasks, assignments and projects that you won’t find anywhere else
- Get LIFETIME access to resource portfolios, FAQs, jobs, and expert support
Who is this course for?
- Analysts or BI professionals looking to gain a deeper understanding of data management
- DBAs who want to learn advanced database management and automation tools
- Anyone who wants to master one of the world’s most popular database programming languages
- Students looking for a hands-on and project-based dive into MySQL database management
- NOTE: This course does not cover data analysis (we cover data analysis in a separate course)
Specializing in Advanced SQL Database Administration with MySQL Workbench
Includes 2022/11
SQL Database Administration Requirements with MySQL Workbench
- MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free installation)
- If you are new to MySQL or database management, we recommend that you first take our “SQL Database for Beginners” course.
Pictures
Sample Clip
Installation Guide
Extract files and watch your favorite player
Subtitle : English
Quality: 720p
Download Links
Password file: free download software
file size
2.05 GB