We may earn an affiliate commission when you visit our partners.

Database Structures and Management with MySQL

Taught by Meta Staff

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types.

By the end of this course, you’ll be able to:

- Utilize the MySQL DBMS to build and modify relational databases with SQL

- Add records to a MySQL database

- Perform intricate queries on database records with filters and groupings

- Create simple joins and unions within a database

- Create relationships between tables using primary and foreign keys

- Demonstrate the ability to complete a database normalization project

You’ll gain experience with the following tools and software:

- MySQL DBMS

- Joins and Unions

- SQL statements, clauses and data types

- Primary and foreign keys

- Database normalization

Enroll now

Or subscribe to Coursera Plus

And get unlimited access to Coursera

What's inside

Syllabus

Intro to MySQL

In this module, you will learn to use the MySQL DBMS to build, modify and query relational databases with SQL.

Updating databases and working with views

In this module you'll learn how update databases and work with views.

Functions and MySQL stored procedures

In this third module, you'll explore different types of functions and learn how to work with MySQL stored procedures.

Graded assessment

In this module, you’ll have an opportunity to recap what you learned and identify your strengths as well as target topics that you would like to revisit in this course.

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Teaches MySQL DBMS, which is a standard in database management industry

Taught by Meta Staff instructors who are recognized for their work in MySQL DBMS

Develops SQL skills and database building and modification skills, which are core skills for database management

Covers a range of topics including updates, views, functions, and stored procedures, making it a comprehensive course

May require learners to come in with some background knowledge of database management

Requires updated version of MySQL DBMS than what is taught in the course

Save this course

Save Database Structures and Management with MySQL to your list so you can find it easily later:

Save

Career center

Learners who complete Database Structures and Management with MySQL will develop knowledge and skills that may be useful to these careers:

Database Administrator

Database Administrators set up, maintain, and ensure the efficiency of organizational databases. Increasingly, Database Administrators are required to be proficient in MySQL, the most popular open-source database management system. This course covers all of the core MySQL functionalities that are sure to help you build a solid foundation in MySQL. This course can give you the skills and knowledge you need to implement MySQL databases to increase operational efficiency.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers design, develop, and maintain software applications. Many software applications use MySQL to manage their data. This course will teach you how to use MySQL to store and retrieve data, as well as how to write queries to retrieve specific information from a database. This course can help you develop the skills you need to become a successful Software Engineer.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites. Many websites use MySQL to manage their data. This course will teach you how to use MySQL to store and retrieve data, as well as how to write queries to retrieve specific information from a database. This course can help you develop the skills you need to become a successful Web Developer.

See salaries and explore the career path for Web Developer

Data Analyst

Data analysts collect, clean, and analyze data to identify trends and patterns. They use this information to help businesses make better decisions. MySQL is one of the most popular database management systems used by businesses today. This course will teach you how to use MySQL to query data, create reports, and build data models. This course can help you develop the skills you need to become a successful Data Analyst.

See salaries and explore the career path for Data Analyst

Data Scientist

Data Scientists use data to solve business problems. They use a variety of tools and techniques to analyze data, including MySQL. This course will teach you how to use MySQL to query data, create reports, and build data models. This course can help you develop the skills you need to become a successful Data Scientist.

See salaries and explore the career path for Data Scientist

Business Analyst

Business Analysts use data to understand business needs and develop solutions. They use a variety of tools and techniques to analyze data, including MySQL. This course will teach you how to use MySQL to query data, create reports, and build data models. This course can help you develop the skills you need to become a successful Business Analyst.

See salaries and explore the career path for Business Analyst

Project Manager

Project Managers plan and execute projects. They use a variety of tools and techniques to manage projects, including MySQL. This course can teach you how to use MySQL to store and track project data, as well as how to write queries to retrieve specific information from a database. This course can help you develop the skills you need to become a successful Project Manager.

See salaries and explore the career path for Project Manager

Marketing Analyst

Marketing Analysts use data to understand marketing campaigns and develop strategies. They use a variety of tools and techniques to analyze data, including MySQL. This course will teach you how to use MySQL to query data, create reports, and build data models. This course can help you develop the skills you need to become a successful Marketing Analyst.

See salaries and explore the career path for Marketing Analyst

Financial Analyst

Financial Analysts use data to analyze financial performance and make investment recommendations. They use a variety of tools and techniques to analyze data, including MySQL. This course will teach you how to use MySQL to query data, create reports, and build data models. This course may help you develop the skills you need to work with financial data.

See salaries and explore the career path for Financial Analyst

Operations Research Analyst

Operations Research Analysts use data to solve business problems. They use a variety of tools and techniques to analyze data, including MySQL. This course may help you develop the skills you need to enter or advance your career.

See salaries and explore the career path for Operations Research Analyst

Statistician

Statisticians use data to analyze trends and patterns. They use a variety of tools and techniques to analyze data, including MySQL. This course may help you develop the skills you need for this role.

See salaries and explore the career path for Statistician

Data Engineer

Data Engineers design, build, and maintain data pipelines. They use a variety of tools and techniques to work with data, including MySQL. This course may help you develop the skills you need for this role.

See salaries and explore the career path for Data Engineer

Machine Learning Engineer

Machine Learning Engineers design and build machine learning models. They use a variety of tools and techniques to work with data, including MySQL. This course may help you develop some of the skills you need to work in this field.

See salaries and explore the career path for Machine Learning Engineer

Database Architect

Database Architects design and manage databases. They use a variety of tools and techniques to work with data, including MySQL. This course may help you develop some of the skills you need to work as a Database Architect.

See salaries and explore the career path for Database Architect

Information Security Analyst

Information Security Analysts protect computer systems and networks from unauthorized access. They use a variety of tools and techniques to secure data, including MySQL. This course may help you develop some of the skills you need to protect MySQL databases.

See salaries and explore the career path for Information Security Analyst

Reading list

We've selected four books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Database Structures and Management with MySQL.

Database Systems: The Complete Book

Save

Comprehensive textbook on database systems. It covers the basics of database systems, as well as more advanced topics such as data modeling, query optimization, and transaction management.

Database Systems: The Complete Book

Kindle Edition

$$$

Database Systems The Complete Book

Paperback

Database Systems: The Complete Book

Hardcover

$$$$

Goal Student Access Code Card for Database Systems:...

Printed Access Code

MySQL Reference Manual

Save

Comprehensive guide to MySQL administration. It covers the basics of MySQL administration, as well as more advanced topics such as performance tuning, replication, and security.

MySQL Reference Manual: Documentation from the...

Paperback

High Performance MySQL

Save

Practical guide to optimizing MySQL performance. It covers a wide range of topics, from basic performance tuning to advanced topics such as replication and clustering.

High Performance MySQL: Optimization, Backups, and...

Paperback

High Performance MySQL: Optimization, Backups,...

Paperback

(中文) High Performance MySQL ( 3rd Edition ) (MySQL...

Paperback

MySQL Cookbook

Save

Collection of recipes for solving common MySQL problems. It covers a wide range of topics, from basic data manipulation to advanced performance tuning.

MySQL Cookbook: Solutions for Database Developers...

My SQL Cookbook: Solutions and Examples for MySQL...

Paperback

$$$$

Help others find this course page by sharing it with your friends and followers: