This course is part of the Meta Database Engineer Professional Certificate

4.8
stars
124 ratings

Taught by Meta Staff

7,471 already enrolled

Offered By

Meta Database Engineer Professional CertificateMeta

About this Course

118,610 recent views

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

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 9 in the

Meta Database Engineer Professional Certificate

Beginner Level

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

Approx. 32 hours to complete

English

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 .

Skills you will gain

Data Management
Database (DBMS)
Relational Database
database administration
MySQL

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Course 3 of 9 in the

Meta Database Engineer Professional Certificate

Beginner Level

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

Approx. 32 hours to complete

English

Instructor

Instructor rating

4.91/5 (48 Ratings)

Taught by Meta Staff

298,162 Learners

90 Courses

Offered by

Syllabus - What you will learn from this course

Content Rating98%(1,735 ratings)

Week1

Week 1

9 hours to complete

Intro to MySQL

9 hours to complete

14 videos (Total 68 min), 18 readings, 8 quizzes

14 videos

Introduction to the program2mIntroduction to the course1mHow Meta uses MySQL5mFiltering data using AND, OR and NOT logical operators8mFiltering data using IN, BETWEEN and LIKE logical operators7mMySQL aliases8mJOINS5mINNER JOIN3mLEFT and RIGHT JOIN4mSELF-JOIN3mMySQL UNION operator4mMySQL GROUP BY6mMySQL HAVING4mModule summary: Intro to MySQL1m

18 readings

Course syllabus: Database structures and management with MySQL4mHow to be successful in this course5mRecap of Course 1 concepts5mHow to access MySQL Environment10mAdditional resources5mFiltering data (Exercise solution)10mAdditional resources5mReading exercise: Filtering data examples (Optional) 5mReading exercise: Filtering data examples (Exercise solution)10mReference sheet: Using operators and the WHERE clause10mJoining tables30m Practice using JOINS (Exercise solution)10mAdditional resources5mGrouping data (Exercise solution)10mAdditional resources5mReading exercise: Operators and clauses (Optional)10mReading exercise: Operators and clauses (Exercise solution)10mReference sheet: Operators and clauses10m

8 practice exercises

Knowledge check: Filtering data using logical operators15mSelf review: Filtering data15mKnowledge check: JOINS15mKnowledge check: MySQL UNION operator15mSelf review: JOINS15mKnowledge check: GROUP BY and HAVING clauses15mSelf review: Grouping data15mModule quiz: Intro to MySQL30m

Week2

Week 2

14 hours to complete

Updating databases and working with views

14 hours to complete

9 videos (Total 52 min), 24 readings, 11 quizzes

9 videos

MySQL REPLACE statement6mConstraints in MySQL5mConstraints in practice4mMySQL ALTER TABLE5mMySQL COPY TABLE7mSubqueries in MySQL5mSubqueries and complex comparison operators8mMySQL CREATE VIEW7mModule summary: Updating databases and working with views2m

24 readings

MySQL REPLACE statement in depth30mMySQL REPLACE statement (Exercise solution)10mAdditional resources5mReading exercise: REPLACE INTO statement (Optional)10mReading exercise: REPLACE INTO statement (Exercise solution)10mTypes of MySQL constraints30mWorking with constraints (Exercise solution)10mAdditional resources5mReading exercise: MySQL constraints (Optional)10mReading exercise: MySQL constraints (Exercise solution)10mChanging table structure (Exercise solution)10mAdditional resources5mReading exercise: ALTER TABLE statement (Optional)10mReading exercise: ALTER TABLE statement (Exercise solution)10mReference sheet: ALTER TABLE statement and its uses10mWorking with subqueries (Exercise solution)10mAdditional resources5mReading exercise: Practicing subqueries (Optional)10mReading exercise: Practicing subqueries (Exercise solution)10mReference sheet: Subqueries10mVirtual tables in depth30mWorking with views in MySQL (Exercise solution)10mAdditional resources5mReference sheet: Creating virtual tables in MySQL10m

11 practice exercises

Knowledge check: REPLACE15mSelf review: MySQL REPLACE statement15mKnowledge check: Constraints15mSelf review: Working with constraints15mKnowledge check: ALTER TABLE and COPY TABLE30mSelf review: Changing table structure15mKnowledge check: Subqueries in MySQL15mSelf review: Working with subqueries15mKnowledge check: Views in MySQL15mSelf review: Working with views in MySQL15mModule quiz: Updating databases and working with views30m

Week3

Week 3

7 hours to complete

Functions and MySQL stored procedures

7 hours to complete

7 videos (Total 36 min), 8 readings, 6 quizzes

7 videos

Numeric functions6mString functions7mDate functions4mComparison functions5mControl flow functions4mStored procedures in MySQL6mModule summary: Functions and MySQL stored procedures1m

8 readings

Working with MySQL functions (Exercise solution)10mAdditional resources30mReading exercise: Practicing with functions (Optional)10mReading exercise: Practicing with functions (Exercise solution)10mReference sheet: Functions in MySQL10mMySQL stored procedures in depth30mWorking with procedures (Exercise solution)10mAdditional resources5m

6 practice exercises

Knowledge check: MySQL functions15mKnowledge check: MySQL comparison and control flow functions30mSelf review: Working with MySQL functions15mKnowledge check: MySQL stored procedures15mSelf review: Working with procedures15mModule quiz: Functions and MySQL stored procedures 30m

Week4

Week 4

3 hours to complete

Graded assessment

3 hours to complete

2 videos (Total 6 min), 3 readings, 2 quizzes

Reviews

4.8

34 reviews

5 stars
81.81%
4 stars
15.90%
3 stars
0.75%
1 star
1.51%

TOP REVIEWS FROM DATABASE STRUCTURES AND MANAGEMENT WITH MYSQL

by LMDec 20, 2022

Amazing course and content, thanks to Meta and Coursera

by EAJan 13, 2023

Course comes with lots of hand-on and real-world practical examples and exercises. Loved it

by CSNov 21, 2022

Fantastic course, with invaluable hands on labs to put the syntax into action.

by JMNov 4, 2022

Great rigor to the coursework. If you take your time, study the materials, and do the labs, you will definitely learn everything you need to know to get start coding SQL Databases.

View all reviews

About the Meta Database Engineer Professional Certificate

Want to get started in the world of database engineering? This program is taught by industry-recognized experts at Meta. You’ll learn the key skills required to create, manage and manipulate databases, as well as industry-standard programming languages and software such as SQL, Python, and Django used for supporting outstanding websites and apps like Facebook, Instagram and more.

Upon completion, you’ll get access to the Meta Career Programs Job Board—a job search platform that connects you with 200+ employers who have committed to sourcing talent through Meta’s certificate programs, as well as career support resources to help you with your job search. In this program, you’ll learn: Core techniques and methods to structure and manage databases. Advanced techniques to write database driven applications and advanced data modeling concepts. MySQL database management system (DBMS) and data creation, querying and manipulation. How to code and use Python Syntax How to prepare for technical interviews for database engineer roles. Any third-party trademarks and other intellectual property (including logos and icons) referenced in the learning experience remain the property of their respective owners. Unless specifically identified as such, Coursera’s use of third-party intellectual property does not indicate any relationship, sponsorship, or endorsement between Coursera and the owners of these trademarks or other intellectual property.

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Database Structures and Management with MySQL

About this Course

What you will learn

Skills you will gain