FREE Course
Self-paced course
Self-paced course
MySQL Database Administration
MySQL Database Administration
Course Description
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 learn how to design, optimize, and administer relational databases using MySQL Workbench.
You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases.
Your job is to work with the owners of various companies to help them manage data in their new and scaling enterprises. You’ll use the skills you learn to complete actual projects that database administration professionals work on every day.
We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.
From there we’ll work through more advanced DBA concepts using real-world projects and case studies, including stored procedures, triggers and indexes, user permissions, and more.
If you’re looking for a unique and highly engaging way to develop SQL database administration skills, this is the course for you.
Course Description
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 learn how to design, optimize, and administer relational databases using MySQL Workbench.
You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases.
Your job is to work with the owners of various companies to help them manage data in their new and scaling enterprises. You’ll use the skills you learn to complete actual projects that database administration professionals work on every day.
We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.
From there we’ll work through more advanced DBA concepts using real-world projects and case studies, including stored procedures, triggers and indexes, user permissions, and more.
If you’re looking for a unique and highly engaging way to develop SQL database administration skills, this is the course for you.
Course Content
12 course hours
7 assignments & solutions
6 quizzes
2 skills assessments
12 CPE credits
Who should take this course
Analysts or BI professionals looking to build or manage relational database systems
SQL users who want to develop advanced skills and master one of the world's most popular and powerful database programming languages
Anyone looking for a hands-on, practical, and highly engaging way to learn database administration using MySQL
Meet your instructors
John Pauler
Partner & CRO
John brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early-stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Featured review
"Really great course. Great explanations with really practical examples. I was able to go through the course alongside the instructor and type/execute everything he did. Feeling way more confident about general DBA skills than I did before the course!"
Taylor P.
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
MySQL Database Administration
MySQL Database Administration
CPE Accreditation
CPE Credits:
12
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
Course Description
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 learn how to design, optimize, and administer relational databases using MySQL Workbench.
You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases.
Your job is to work with the owners of various companies to help them manage data in their new and scaling enterprises. You’ll use the skills you learn to complete actual projects that database administration professionals work on every day.
We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.
From there we’ll work through more advanced DBA concepts using real-world projects and case studies, including stored procedures, triggers and indexes, user permissions, and more.
If you’re looking for a unique and highly engaging way to develop SQL database administration skills, this is the course for you.
Course Description
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 learn how to design, optimize, and administer relational databases using MySQL Workbench.
You’ll be playing the role of a Database Administration Consultant for Maven Consulting, a firm that helps businesses create, maintain, and optimize their databases.
Your job is to work with the owners of various companies to help them manage data in their new and scaling enterprises. You’ll use the skills you learn to complete actual projects that database administration professionals work on every day.
We’ll start by introducing the course structure, installing MySQL Community and Workbench, and reviewing key database administration (DBA) tasks; including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.
From there we’ll work through more advanced DBA concepts using real-world projects and case studies, including stored procedures, triggers and indexes, user permissions, and more.
If you’re looking for a unique and highly engaging way to develop SQL database administration skills, this is the course for you.
Curriculum
Meet your instructors
John Pauler
Partner & CRO
John brings over 15 years of business intelligence experience to the Maven team, having worked with companies ranging from Fortune 500 to early-stage startups. As a MySQL expert, he has played leadership roles across analytics, marketing, SaaS and product teams.
Student reviews
Really great course. Great explanations with really practical examples. I was able to go through the course alongside the instructor and type/execute everything he did. Feeling way more confident about general DBA skills than I did before the course!
Taylor P.
In the beginning I was like 'this is for geeks only' , 'way over my head' and things like this. Now I am on fire, deep into DBA and going for Advanced things. The versatility and Reliability of MySQL has made me love it. The more deep I go, the more I like it. Maven & John Pauler, a big THANKS for making this journey so thrilling and fun!!!
Apostolos Goulandris
This is my first time enrolling in SQL database administration course and it feels different than learning all SQL course altogether combining data analysis and data administration. This course is a must for those who want to understand database administration better. It did cover normalization and database design part too.
Fauzan Ghazi
Included learning paths
Course credential
You’ll earn the course certification by completing this course and passing the assessment requirements
MySQL Database Administration
MySQL Database Administration
CPE Accreditation
CPE Credits:
12
Field of Study:
Information Technology
Delivery Method:
QAS Self Study
Maven Analytics LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
For more information regarding administrative policies such as complaints or refunds, please contact us at admin@mavenanalytics.io or (857) 256-1765.
*Last Updated: May 25, 2023
More courses you may like
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
FOR INDIVIDUALS
Master data & AI skills
Build data & AI skills to launch or accelerate your career (start for free, no credit card required).
FOR COMPANIES & TEAMS
Transform your workforce
Assess your team's data & AI skills and follow personalized learning plans to close the gaps.
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER
Empowering everyday people with life-changing data skills.
DISCOVER