MySQL Database Administration
Learn how to build, optimize, and administer relational databases using MySQL and MySQL Workbench.
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.
7.0 hours on-demand video (11.5 CPE credits)
7 homework assignments
2 skills assessments (1 benchmark, 1 final)
- Welcome to the Course!
- Benchmark Assessment
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Introducing the Course Project
- Setting Expectations
- Introduction to SQL
- Relational Databases
- Relational Database Management Systems
- QUIZ: SQL & Relational Database Overview
- MySQL Installation Overview
- Download Community Server & Workbench
- Connecting Workbench to the Server
- MySQL Workbench Interface
- IMPORTANT: Prepare Workbench for the Course
- Creating the Initial Schemas
- Creating a Schema
- Creating a Table
- MySQL Data Types
- Adding & Removing Columns
- Dropping Schemas & Tables
- ASSIGNMENT: Creating and Altering Schemas & Tables
- SOLUTION: Creating and Altering Schemas & Tables
- QUIZ: Creating and Altering Schemas & Tables
- Inserting Records into Tables
- Updating Data Records
- Inserting & Updating Records
- Deleting Specific Records
- Deleting All Records with TRUNCATE
- ASSIGNMENT: Inserting, Updating, and Deleting Records
- SOLUTION: Inserting, Updating, and Deleting Records
- QUIZ: Inserting, Updating, and Deleting Records
- Primary Keys & Foreign Keys
- Table Relationships
- Database Normalization
- The EER Diagram Editor
- ASSIGNMENT: Database Design
- SOLUTION: Database Design
- QUIZ: Database Design
- ASSIGNMENT: Mid-Course Project
- SOLUTION: Mid-Course Project
- Creating an Index
- The UNIQUE Constraint
- The NON NULL Constraint
- Stored Procedures
- ASSIGNMENT: Advanced Concepts
- SOLUTION: Advanced Concepts
- QUIZ: Advanced Concepts
- Server Management
- Managing Users & Permissions
- ASSIGNMENT: Server & User Management
- SOLUTION: Server & User Management
- QUIZ: Server & User Management
- ASSIGNMENT: Final Project
- SOLUTION: Final Project
- Final Assessment
- Course Feedback Survey
- Share the love!
- Next Steps
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
WHAT ARE THE COURSE REQUIREMENTS?
- MySQL Workbench and Community Server (we'll walk you through the install process)
- If you are new to MySQL, we recommend completing the basic MySQL for Data Analysis course first
WHAT ARE THE COURSE OBJECTIVES?
Identify key components of the broader SQL landscape, including history, common tools, common "flavors", and benefits
Identify and interpret the core statements used to CREATE, ALTER and DELETE schemas and tables
Identify MySQL data types and their proper usage, including DECIMAL, FLOAT, ENUM, DATE, TEXT, and VARCHAR
Identify and interpret the core statements used to INSERT, UPDATE, and DELETE rows of data
Identify key principles of database design, including EER diagrams, normalization, cardinality, and primary to foreign key mapping
Identify and interpret concepts used for data integrity preservation and performance, including constraints and indexes
Identify the functionality of advanced automation techniques, including triggers and stored procedures
Identify techniques and best practices for user management and server management
CPE ACCREDITATION DETAILS:
CPE Credits: 11.5
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 firstname.lastname@example.org or (857) 256-1765.
*Last Updated: December 1, 2021
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
Start learning for free, no credit card required!