Database Structures and Management with MySQL (Coursera)

Database Structures and Management with MySQL (Coursera)
Course Auditing
Categories
Effort
Certification
Languages
None! Learners do not need prior web development experience. Only basic internet navigation skills and an eagerness to get started with coding.
Misc

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Database Structures and Management with MySQL (Coursera)
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.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

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

Course 3 of 9 in the Meta Database Engineer Professional Certificate.


What You Will Learn

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

- Create relationships between tables using primary and foreign keys .


Syllabus


WEEK 1

Intro to MySQL

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


WEEK 2

Updating databases and working with views

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


WEEK 3

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.


WEEK 4

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.



MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Course Auditing
46.00 EUR/month
None! Learners do not need prior web development experience. Only basic internet navigation skills and an eagerness to get started with coding.

MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.