Latest Courses
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
Git &Github Practice Tests & Interview Questions (Basic/Adv)Check course
Machine Learning and Deep Learning for Interviews & ResearchCheck course
Laravel | Build Pizza E-commerce WebsiteCheck course
101 - F5 CERTIFICATION EXAMCheck course
Master Python by Practicing 100 QuestionCheck course
ISTQB Artificial Intelligence Tester Sample ExamsCheck course
JAVA Programming Online Practice ExamCheck course
Programming for Kids and Beginners: Learn to Code in PythonCheck course
Practice Exams | Codeigniter 4 developer certificationCheck course
WordPress Practice Tests & Interview Questions (Basic/Adv)Check course
- 87% Advanced SQL Database Administration with MySQL Workbench

Advanced SQL Database Administration with MySQL Workbench

$13.99Track price

Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

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

Duration

8 hours

Year

2022

Level

All

Certificate

Yes

Quizzes

Yes

6 reviews for Advanced SQL Database Administration with MySQL Workbench

3.8 out of 5
2
2
1
1
0
Write a review
Show all Most Helpful Highest Rating Lowest Rating
  1. Rajnish Rajput

    The content is good for beginners, to the point, crisp and precise.

    Helpful(0) Unhelpful(0)You have already voted this
  2. George Jay Johnson

    Excellent class!

    Helpful(0) Unhelpful(0)You have already voted this
  3. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  4. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  5. 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.

    Helpful(0) Unhelpful(0)You have already voted this
  6. Bab Alemzadeh

    Not as good as advertised. Towards the end he rushes through complicated subjects.

    Helpful(0) Unhelpful(0)You have already voted this

    Add a review

    Your email address will not be published.

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    Advanced SQL Database Administration with MySQL Workbench
    Advanced SQL Database Administration with MySQL Workbench

    $13.99

    Price tracking

    Java Code Geeks
    Logo
    Register New Account
    Reset Password
    Compare items
    • Total (0)
    Compare