Description
Advanced SQL Database Administration with MySQL Workbench, course Advanced SQL Database Management with MySQL Workbench is published by Udemy Academy. MySQL is a powerful tool for managing and analyzing relational databases and a skill that every BI analyst and specialist should have. In this course you will improve your database management skills and gain advanced concepts such as replication, automation and database security. Introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; We begin by creating and editing schemas and tables, inserting and deleting records, and reviewing the key principles of normalized databases.
Then we’ll work with more advanced concepts like replication, backup, and restore, and learn how to use automation through stored procedures, triggers, and scheduled events. During this course, you will take on the role of a master database administrator at an e-commerce startup and learn how to build and populate a complete database from the ground up using real projects and assignments. Our goal here is to focus on building, modifying, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in separate courses).
What you will learn
- Writing SQL queries and using MySQL Workbench to create new databases from scratch
- Examining database security threats and practical techniques such as replication, backup and recovery
- Advanced automation tools such as triggers, stored procedures, and scheduled events
- Create and modify EER diagrams to understand table structures and relationships
- Work on missions and projects that you won’t find anywhere else.
Who is this course suitable for?
- Analysts or BI professionals looking to gain a deeper understanding of database management
- Database administrators who want to learn advanced database management and automation tools
- People looking to master one of the world’s most popular database programming languages
- Students looking to manage databases with MySQL
- This course does not cover database analysis (we cover data analysis in a separate lesson).
Advanced SQL Database Administration with MySQL Workbench course specifications
- Publisher: Udemy
- teacher : Maven Analytics , John Pauler
- English language
- Education level: all levels
- Number of courses: 81
- Training duration: 7 hours and 55 minutes
At the beginning of the course chapters on 11/2022
Advanced SQL Database Administration with MySQL Workbench course prerequisites
- 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
Pictures
Sample video
Installation guide
After Extract, view with your favorite Player.
English subtitle
Quality: 720p
download link
File(s) password: www.downloadly.ir
Size
2.05 GB