MySQL Database Administration

MySQL is a powerful tool for managing and analyzing relational databases—a skill that every analyst and BI professional should have in their tool kit. In this course, learn how to design, optimize, and administer relational databases using MySQL Workbench.

Play the role of a database administration (DBA) consultant for Maven Consulting, where your job is to work with the owners of various companies to help them manage data for new and scaling enterprises.

Use the skills you learn in the course to complete actual projects and tasks that database administration professionals work on every day, including creating and editing schemas and tables, inserting and deleting records, and designing efficient, normalized databases.

You’ll also get a chance to practice applying more advanced DBA concepts on real-world projects and case studies, such as stored procedures, triggers, indexes, user permissions, and more.

Learning objectives
Identify key components of the broader SQL landscape, including history, common tools, common flavors, and benefits.
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.
Interpret the core statements used to INSERT, UPDATE, and DELETE rows of data.
Apply key principles of database design, including EER diagrams, normalization, cardinality, and primary to foreign key mapping.
Leverage concepts used for data integrity preservation and performance, including constraints and indexes.
Analyze the functionality of advanced automation techniques, including triggers and stored procedures.
Utilize techniques and best practices for user management and server management.