jcg
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.
COURSE OUTLINE:
SQL Intro & MySQL Setup
For students who haven’t completed one of our other SQL courses, we’ll demonstrate exactly how to download and install the tools that we’ll need to access MySQL, including MySQL Community Server & MySQL Workbench. We’ll share download guides for both Mac & PC, and run our first piece of SQL code to generate the project database that we’ll analyze throughout the course.
Specification: Advanced SQL Database Administration with MySQL Workbench
|
6 reviews for Advanced SQL Database Administration with MySQL Workbench
Add a review
| Price | $13.99 |
|---|---|
| Provider | |
| Duration | 8 hours |
| Year | 2022 |
| Level | All |
| Language | English ... |
| Certificate | Yes |
| Quizzes | Yes |
$13.99
Rajnish Rajput –
The content is good for beginners, to the point, crisp and precise.
George Jay Johnson –
Excellent class!
Piyush Agarwal –
Expected more on advanced DBA stuff like db engines, command line tools and utilities, privilege management, backup and recovery, replication, data extraction to files, information schemas, table partitions, optimization and tuning process in mysql, indexing, etc. It has more of developer content but i found that quite useful too. Lot of repetitions are there in the exercises, perhaps that could have been avoided.
Claire Dyard –
Excellent cours, des informations importantes, des exercices proches de la r alit , une grande r activit (r ponse rapide lors de probl mes). A recommander ceux et celles qui d sirent devenir administrateurs / administratrices de bases de donn es.
Gabriel R Rice –
I needed to brush up on and learn more about SQL. This course gave me a taste of automation with triggers, events and stored procedures. It was structured well and I appreciated the attempt to emulate real world scenarios.
Bab Alemzadeh –
Not as good as advertised. Towards the end he rushes through complicated subjects.