MySQL Database Administration: Beginner SQL Database Design from Udemy

If you’re looking to develop practical, real-world data analytics & business intelligence skills and learn the foundations of database administration (DBA) and analysis, you’ve come to the right place.

This course is unlike anything you’ve seen before, guaranteed. We'll start from the ground up, teaching you the tools to get the job done, and most importantly how to you apply your skills to real projects and learn how to truly think like a Database Administrator.

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. Throughout the course, you’ll be working directly with the owners of various companies to help them manage data in their new and scaling enterprises. You will use the skills you learn to complete actual projects that database administration professionals work on every day.

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.

Creating, Altering, and Deleting Schemas & Tables
In this section we'll learn how to create schemas and tables using SQL code and with the Workbench UI tools. Then, we will learn how to alter tables by adding and removing columns. Finally, we will walk through dropping schemas and tables (be careful with this one).
Inserting, Updating, and Deleting Records
After we get up to speed creating and altering tables, we will learn how to populate those tables with records of data, and update and delete records as needed.
Database Design
Now that we have covered the basic mechanics, we will learn how tables relate to one another optimally, and discuss best practices for database design. We will explore the EER Diagram Editor, and you will have some opportunities to create your own database models.
MID-COURSE PROJECT: Normalize this database for your client.
Advanced ConceptsIn this section, we will get into concepts like adding an index to a column, imposing constraints, and creating stored procedures and triggers. This is powerful stuff.
Server & User ManagementIn our last section before the Final Project, we will learn how to monitor servers to make sure they are running, and how to restart them when needed. You will also get your hands on user management tools to assign roles and manage permissions, just like a real DBA.
FINAL COURSE PROJECT: Design and build an entire database from scratch.

IMPORTANT NOTE: This course does NOT cover data exploration and database analysis. Our goal here is to focus on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench (we cover data analysis in-depth in separate courses).

Enroll today and get LIFETIME access to:

7 hours of high-quality video
Downloadable MySQL ebook and cheat sheets
Quizzes and homework assignments
Mid-course and Final SQL projects
30-day money-back guarantee

If you’re looking for a hands-on, practical guide to mastering database administration skills using SQL/MySQL, this is the course for you.

Happy administering.

-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)

Looking for our full course library? Search "Maven Analytics" to browse our full collection of Excel, Power BI, SQL, Tableau, Python, Alteryx & Machine Learning courses.

See why John is one of the TOP-RATED SQL/MySQL Instructors on Udemy:

"I totally loved this course. Everything was easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning I wanted to keep charging on to the next lesson. "

- Ann S.

"This is an excellent advanced course. I've taken multiple SQL courses from Maven Analytics and recommend them all. The best part of this course is the detail they included by building a real world e-commerce database. It's much easier to grasp the concepts when you can see how they're literally applied to scenarios and outcomes as opposed to just theory. Great work. "

- Dan S.

"John's deep understanding of SQL and database analysis and ability to explain those tools is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the most effective. Excited to see more courses from John. "

- Steven M.

What's inside

Learning objectives

Write sql queries and use the mysql workbench ui to create databases and tables
Learn how to alter tables by adding and removing columns
Connect data between tables by creating primary and foreign key relationships
Assign user roles and permissions to database users, just like a real dba

Solve practical hands-on assignments and real-world business use cases
Master unique tips, tools and case studies that you won't find anywhere else
Understand common relational database management systems (rdbms)
Get lifetime access to resource files, quizzes, assignments, and expert support

Write sql queries and use the mysql workbench ui to create databases and tables
Learn how to alter tables by adding and removing columns
Connect data between tables by creating primary and foreign key relationships
Assign user roles and permissions to database users, just like a real dba
Solve practical hands-on assignments and real-world business use cases
Master unique tips, tools and case studies that you won't find anywhere else
Understand common relational database management systems (rdbms)
Get lifetime access to resource files, quizzes, assignments, and expert support

Syllabus

Getting Started

Introduction

READ ME: Important Notes for New Students

DOWNLOAD: Course Resources

Introducing The Course Project

Setting Expectations

SQL & Relational Database Overview

Introduction to SQL

Relational Databases

Relational Database Management Systems

QUIZ: SQL & Relational Database Overview

MySQL Intro & Setup

MySQL Installation Overview

Mac Download - MySQL Community Server

Mac Download - MySQL Workbench

PC Download - MySQL Community Server & MySQL Workbench

Connecting Workbench To The Server

MySQL Workbench Interface

Creating Initial Schemas

Creating and Altering Schemas & Tables

Creating A Schema Using The UI

Creating A Schema Using SQL Code

Creating A Table Using The UI

Creating A Table With A SQL Query

MySQL Data Types

Assignment: Creating Your Own Schema And Tables

Solution: Creating Your Own Schema And Tables

Adding and Removing Columns In The Editor

Adding And Removing Columns With SQL Code

Assignment: Adding And Removing Columns

Solution: Adding And Removing Columns

Dropping Schemas And Tables

Assignment: Dropping Schemas And Tables

Solution: Dropping Schemas And Tables

QUIZ: Creating and Altering Schemas & Tables

Inserting, Updating, and Deleting Records

Inserting Records Into A Table

Updating Data Records

Assignment: Inserting And Updating Records

Solution: Inserting And Updating Records

Deleting Specific Records

Deleting All Records With Truncate

Assignment: Deleting Records

Solution: Deleting Records

QUIZ: Inserting, Updating, and Deleting Records

Database Design

Primary Keys and Foreign Keys

Primary Keys and Foreign Keys Demo

Assignment: Table Relationships

Solution: Table Relationships

Database Normalization

Database Normalization Demo

Assignment: Normalization

Solution: Normalization

The EER Diagram Editor

Assignment: EER Diagram Editor

Solution: EER Diagram Editor

QUIZ: Database Design

Mid-Course Project

Assignment: Mid Course Project

Solution: Mid Course Project

Advanced Concepts

Creating An Index

The Unique Constraint

The Non Null Constraint

Assignment: Indexes And Constraints

Solution: Indexes And Constraints

Stored Procedures

Assignment: Stored Procedures

Solution: Stored Procedures

Triggers

Assignment: Triggers

Solution: Triggers

QUIZ: Advanced Concepts

Server & User Management

Server Management

Assignment: Server Management

Solution: Server Management

Managing Users And Permissions

Assignment: Managing Users And Permissions

Solution: Managing Users And Permissions

QUIZ: Server & User Management

Final Course Project

Assignment: Final Course Project

Solution: Final Course Project

Wrapping Up

Resources & Next Steps

BONUS LESSON

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Uses MySQL Workbench UI tools, which allows learners to visualize and interact with databases in a graphical environment, making database design and management more intuitive

Includes a mid-course project to normalize a database and a final project to design and build a database from scratch, providing practical experience

Covers server and user management, including monitoring servers, restarting them when needed, assigning roles, and managing permissions, which are essential DBA tasks

Focuses on building, altering, and maintaining SQL/MySQL databases using MySQL and MySQL Workbench, which is a specific and practical skillset

Requires downloading and installing MySQL Community Server & MySQL Workbench, which may require some technical proficiency for beginners

Does not cover data exploration and database analysis, which may be a drawback for learners seeking a comprehensive data skillset

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in MySQL Database Administration: Beginner SQL Database Design with these activities:

Review Relational Database Concepts

Show steps

Solidify your understanding of relational database concepts before diving into MySQL-specific implementations. This will make grasping the underlying principles easier.

Browse courses on Relational Databases

Show steps

Review the definition of a relation
Study the properties of relations
Review the concept of relational algebra

Read 'Database Design for Mere Mortals'

Show steps

Improve your database design skills with a comprehensive guide. This book will help you understand the principles of database design and how to apply them in practice.

View Patterns of Data Modeling on Amazon

Show steps

Obtain a copy of 'Database Design for Mere Mortals'
Read the chapters on normalization and data modeling
Apply the concepts to your own database projects

Read 'SQL Cookbook'

Show steps

Supplement your learning with a practical guide to SQL. This book will help you understand how to solve real-world problems using SQL.

View SQL Cookbook: Query Solutions and Techniques... on Amazon

Show steps

Obtain a copy of the SQL Cookbook
Read the chapters relevant to the course topics
Try out the examples in MySQL Workbench

Four other activities

Expand to see all activities and additional details

Show all seven activities

Practice SQL Queries on Sample Databases

Show steps

Reinforce your SQL skills by practicing writing queries on publicly available sample databases. This will help you become more comfortable with SQL syntax and database design.

Show steps

Download a sample database like 'employees' or 'sakila'
Write SQL queries to retrieve and manipulate data
Experiment with different SQL functions and operators

Create a SQL Cheat Sheet

Show steps

Consolidate your knowledge by creating a cheat sheet of common SQL commands and syntax. This will serve as a useful reference for future projects.

Show steps

Identify the most important SQL commands
Write down the syntax for each command
Organize the cheat sheet for easy reference

Design a Database for a Small Business

Show steps

Apply your knowledge by designing a database for a hypothetical small business. This will test your understanding of database design principles and SQL syntax.

Show steps

Choose a small business type (e.g., bookstore, restaurant)
Identify the data requirements of the business
Design the database schema with tables and relationships
Implement the database in MySQL Workbench

Contribute to a MySQL Open Source Project

Show steps

Deepen your understanding of MySQL by contributing to an open-source project. This will give you hands-on experience with real-world database administration tasks.

Show steps

Find a MySQL open-source project on GitHub
Identify a bug or feature to work on
Submit a pull request with your changes

Career center

Learners who complete MySQL Database Administration: Beginner SQL Database Design will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator is responsible for the performance, integrity, and security of a database. This course is designed to help learners think like a database administrator, providing a strong foundation in SQL and MySQL. The course covers essential skills such as creating, altering, and deleting schemas and tables, and managing users and permissions, all of which are critical for a Database Administrator. The practical focus, with projects mimicking real-world scenarios, makes this course invaluable for anyone seeking a role as a database administrator.

See salaries and explore the career path for Database Administrator

Database Consultant

A database consultant provides expert advice to businesses on how to manage their databases, and this course is designed with that specific role in mind. By simulating real-world scenarios in Maven Consulting, this course offers an opportunity to understand the responsibilities of a database consultant. The curriculum helps build skills in creating, maintaining, and optimizing databases using MySQL, making this course a great choice for anyone interested in a career as a database consultant. The course projects are also particularly important, as these are exactly the kinds of projects a database consultant would work on.

See salaries and explore the career path for Database Consultant

Data Engineer

Data engineers build and maintain the infrastructure that enables data analysis, and this often includes databases. This course introduces the fundamentals of database design and administration, particularly in MySQL, that a data engineer needs to be effective. Skills taught include creating tables, managing data, and understanding database relationships. A data engineer would find this course helpful as it emphasizes practical application, allowing them to gain experience managing databases at the level of schemas and tables. This gives them the experience to create optimized databases ready for analysis.

See salaries and explore the career path for Data Engineer

Data Architect

A Data Architect designs and manages an organization's data infrastructure, including databases. This course is particularly relevant as it dives into database design, relationships, and best practices, all of which are fundamental to the role of a data architect. The course provides a thorough understanding of how to design efficient database models and how to use the EER Diagram Editor, critical skills for any data architect. Someone pursuing this role may find that this course helps to build a foundation in core database principles and mechanics.

See salaries and explore the career path for Data Architect

Systems Analyst

Systems analysts work to improve computer systems within an organization, and this often includes making recommendations for database improvements. This course helps build a basic understanding of database setup, design, and best practices, all critical for any systems analyst. The course work emphasizes hands-on skills with MySQL and SQL, focusing on how to create tables, manage data, and manipulate databases, and these are important capabilities for a systems analyst. The course also helps create a useful understanding of relational database management systems.

See salaries and explore the career path for Systems Analyst

Information Technology Specialist

An Information Technology specialist often manages and maintains an organization's computer systems, which includes databases. This course is helpful as it provides the specific knowledge required to install, set up, and maintain MySQL databases, a skill that is important for an Information Technology specialist. The course work includes practical experience installing MySQL and creating schemas, tables, and users, which are important skills for their day to day work. This course helps build a practical foundation for database management.

See salaries and explore the career path for Information Technology Specialist

Software Developer

Software developers often interact with databases, and while this course doesn't focus on coding applications, it does build a foundational understanding of how databases work. Understanding how to create tables, manage relationships, and work with data through SQL is important for any software developer. A software developer would find that this course provides practical experience in database management, which is important for creating effective software applications that rely on database interactions. By getting hands on experience with the MySQL Workbench, a software developer learns the concepts that are important to any database architecture.

See salaries and explore the career path for Software Developer

Business Intelligence Analyst

Business intelligence analysts need to understand where data comes from and how it is organized, which often includes databases. While this course does not focus on data analysis, it does provide practical experience building and maintaining databases. Skills covered include creating schemas and tables, managing records, and understanding the relationships between databases. This course helps a business intelligence analyst by providing the foundational knowledge of database management and design, which will help them better utilize the data in them. They will better understand the data that they are analyzing.

See salaries and explore the career path for Business Intelligence Analyst

Data Quality Analyst

Data Quality Analysts focus on ensuring the data in an organization is accurate and usable, which often involves understanding how it is organized. This course can help a data quality analyst understand the structure of a database, and the work in this course can provide them a lens for how to approach their work. While this course does not touch on data analysis, a data quality analyst would benefit from understanding the design considerations of databases, and how data is inserted, updated, and managed, and this course focuses on those concerns.

See salaries and explore the career path for Data Quality Analyst

Technical Support Specialist

Technical support specialists often help users with database-related issues, such as software installations, and this course can aid with that. The courses provides hands-on experience with MySQL and teaches how to install and manage databases, skills that are useful for anyone in a technical support role. By taking this course, a technical support specialist can gain a better understanding of the basics of database administration. This can be useful in troubleshooting end-user issues.

See salaries and explore the career path for Technical Support Specialist

Project Manager

Project Managers often oversee projects that involve database design and implementation. While this course does not teach project management skills, it can help a project manager understand the underlying processes and challenges involved in database implementation. This can improve communication with technical teams. This course may be useful because it provides a clear overview of the steps involved in database creation, and this knowledge can be helpful for a project manager in charge of database related projects.

See salaries and explore the career path for Project Manager

Solutions Architect

Solutions architects are involved in designing and implementing technology solutions for businesses. While this course does not cover all aspects of solution architecture, it provides a solid foundation in database management, especially with the MySQL database. This can be a useful skill for a solutions architect to have as it provides practical experience with how data is stored and managed. The course also covers database design principles which are critical for a solutions architect to understand. This course may be useful for solutions architects who want a better grasp of database technologies.

See salaries and explore the career path for Solutions Architect

Technical Writer

Technical writers often produce documentation and training materials for technical systems, including databases. By learning the concepts of database administration, a technical writer can effectively document database systems and processes. This course offers hands-on experience in database design and administration. This will equip a technical writer with the knowledge to write accurate and useful documentation. This course may be useful for a technical writer who wishes to improve their grasp of database concepts.

See salaries and explore the career path for Technical Writer

Quality Assurance Analyst

Quality assurance analysts ensure that software and systems meet quality standards, which can include evaluating database systems. Understanding database design and how data is managed can be a helpful skill for a quality assurance analyst. This course provides an introduction to database administration, along with hands-on experience with MySQL. A quality assurance analyst may find this useful in understanding the underlying data structures of their software.

See salaries and explore the career path for Quality Assurance Analyst

Management Consultant

Management consultants provide strategic and business advice to organizations. This course may be useful for a management consultant as databases are crucial for many organizations. The course covers the fundamentals of database administration, which can provide helpful insights into how data is managed. This course may also help consultants engage in more technical aspects of business strategy if they wish to do so. While not directly related, this course may be helpful for a management consultant.

See salaries and explore the career path for Management Consultant

MySQL Database Administration

Beginner SQL Database Design

What's inside

Learning objectives

Syllabus

Good to know

Save this course

Activities

Career center

Reading list

Share

Similar courses