Database Clients

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Staff

What you'll learn

Utilize Python code to create, populate and manipulate MySQL databases and tables.
Create a useful Python application capable of administration of a MySQL database.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Data Management expertise

This course is part of the Meta Database Engineer Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Meta

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

Explore how to write database driven applications in Python by creating various types of clients that connect to MySQL databases using Python code and Python-related MySQL features and tools.

By the end of this course, you’ll be able to: - Utilize Python code to create, populate and manipulate MySQL databases and tables - Access advanced functionality in MySQL using custom built Python clients - Develop working familiarity with advanced topics in MySQL - Apply the principles of advanced MySQL topics to problem solving using Python - Develop a working knowledge of the methods by which a MySQL database connects to the web via a Django API - Create a useful Python application capable of administration of a MySQL database You’ll gain experience with the following tools and software: - Python code - Python-related MySQL features and tools - Django REST framework - _meta API To take this course, you must have completed the previous course Advanced MySQL topics. You must also be eager to continue your journey with coding.

Learn to use Python code to create, populate and manipulate MySQL databases and tables.

What's included

9 videos12 readings6 assignments1 discussion prompt6 ungraded labs

9 videosTotal 41 minutes

Introduction to the course: Database clients4 minutesPreview module
Database engineering at Meta5 minutes
MySQL/Python connection3 minutes
Installation and setup5 minutes
Connecting to a MySQL database using a Python client3 minutes
Creating a database and tables in a MySQL database using Python4 minutes
Cursors and MySQL4 minutes
Cursor subclasses6 minutes
Module summary: Interacting with MySQL using Python4 minutes

12 readingsTotal 175 minutes

Database clients10 minutes
How databases are used in programming15 minutes
Course syllabus15 minutes
How to be successful in this course10 minutes
Course requirements10 minutes
Working with labs in this course10 minutes
Additional resources5 minutes
Overview of pip30 minutes
OS specific instructions30 minutes
Python and MySQL connections30 minutes
Additional resources5 minutes
Additional resources5 minutes

6 assignmentsTotal 116 minutes

Module Quiz: Interacting with MySQL Using Python50 minutes
Self review: Making your MySQL/Python connection12 minutes
Self review: Creating a table structure in a MySQL database using Python12 minutes
Knowledge check: Establishing a MySQL and Python connection and creating tables15 minutes
Self review: Working with cursors12 minutes
Knowledge check: Cursors15 minutes

1 discussion promptTotal 10 minutes

What do you hope to learn?10 minutes

6 ungraded labsTotal 360 minutes

Exercise: Making your MySQL/Python connection60 minutes
Solution: Making your MySQL/Python connection60 minutes
Exercise: Creating a table structure in a MySQL database using Python60 minutes
Solution: Creating a table structure in a MySQL database using Python60 minutes
Exercise: Working with cursors60 minutes
Solution: Working with cursors60 minutes

Access query functionality in MySQL using Python clients.

What's included

5 videos2 readings7 assignments8 ungraded labs

5 videosTotal 21 minutes

Creating and reading data in a MySQL database using Python5 minutesPreview module
Updating and deleting records in a MySQL database using python3 minutes
Filtering and sorting data in MySQL using Python4 minutes
Joining data from different tables in MySQL database using python3 minutes
Module summary: Performing advanced queries on a MySQL database using Python3 minutes

2 readingsTotal 10 minutes

Additional resources5 minutes
Additional resources5 minutes

7 assignmentsTotal 128 minutes

Module Quiz: Performing Advanced Queries in MySQL Using Python50 minutes
Self review: Creating and reading records in a MySQL database using Python12 minutes
Self review: Updating and deleting records in a MySQL database using Python12 minutes
Knowledge check: Performing create, read, update and delete (CRUD) operations15 minutes
Self review: Filtering and sorting data in a MySQL database using Python12 minutes
Self review: Performing different JOIN operations in MySQL databases using Python12 minutes
Knowledge check: Performing advanced queries on a MySQL database using Python15 minutes

8 ungraded labsTotal 480 minutes

Exercise: Creating and reading records in a MySQL database using Python60 minutes
Solution: Creating and reading records in a MySQL database using Python60 minutes
Exercise: Updating and deleting records in a MySQL database using Python60 minutes
Solution: Updating and deleting records in a MySQL database using Python60 minutes
Exercise: Filtering and sorting data in a MySQL database using Python60 minutes
Solution: Filtering and sorting data in a MySQL database using Python60 minutes
Exercise: Performing different JOIN operations in MySQL databases using Python60 minutes
Solution: Performing different JOIN operations in MySQL databases using Python60 minutes

Explore advanced topics in MySQL and apply these principles to problem solving using Python.

What's included

8 videos4 readings8 assignments8 ungraded labs

8 videosTotal 39 minutes

A quick review of MySQL Functions5 minutesPreview module
Accessing MySQL functions using Python5 minutes
Working with datetime functions in Python5 minutes
A quick review of stored procedures3 minutes
Accessing stored procedures using Python3 minutes
Database connection pooling3 minutes
Python / MySQL connection pool5 minutes
Module summary: Advanced Database Clients5 minutes

4 readingsTotal 45 minutes

Accessing functions30 minutes
Additional resources5 minutes
Additional resources5 minutes
Additional resources5 minutes

8 assignmentsTotal 140 minutes

Module Quiz: Advanced Database Clients50 minutes
Self review: Utilizing MySQL functions with Python12 minutes
Self review: Working with date and time functions in Python9 minutes
Knowledge check: Working with MySQL functions in Python15 minutes
Self review: Accessing stored procedures in a MySQL database using Python12 minutes
Knowledge Check: Accessing MySQL stored procedures using Python15 minutes
Self review: Working with connection pools12 minutes
Knowledge check: Working with connection pools15 minutes

8 ungraded labsTotal 480 minutes

Exercise: Utilizing MySQL functions with Python60 minutes
Solution: Utilizing MySQL functions with Python60 minutes
Exercise: Working with date and time functions in Python60 minutes
Solution: Working with date and time functions in Python60 minutes
Exercise: Accessing stored procedures in a MySQL database using Python60 minutes
Solution: Accessing stored procedures in a MySQL database using Python60 minutes
Exercise: Working with connection pools60 minutes
Solution: Working with connection pools60 minutes

Apply the skills you have learned in this course to create a useful Python application capable of administering a MySQL database.

What's included

2 videos6 readings3 assignments1 peer review2 discussion prompts

2 videosTotal 6 minutes

Course Recap: Database Clients4 minutesPreview module
Course wrap up2 minutes

6 readingsTotal 135 minutes

About the final project assessment30 minutes
Set up the database30 minutes
Implement and query stored procedures30 minutes
Little Lemon analysis and sales report30 minutes
Exemplar: Little Lemon analysis and sales report10 minutes
Next steps5 minutes

3 assignmentsTotal 156 minutes

Final Graded Quiz: Database Clients150 minutes
Readiness check: Have you completed the initial setup?3 minutes
Readiness check: Have you set up the stored procedures and run the queries?3 minutes

1 peer reviewTotal 60 minutes

Submit your Little Lemon Menu sales report project60 minutes

2 discussion promptsTotal 20 minutes

Share the challenges you encountered when working on the Little Lemon Sales Report10 minutes
Reflect on learning10 minutes

Instructor

Instructor ratings

4.7 (25 ratings)

Taught by Meta Staff

Offered by

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 86

4.4

86 reviews

5 stars
70.11%
4 stars
11.49%
3 stars
9.19%
2 stars
3.44%
1 star
5.74%

Reviewed on Sep 6, 2023

Reviewed on Mar 2, 2024

View more reviews

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Database Clients

What you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

Build your Data Management expertise

Earn a career certificate

There are 4 modules in this course

Interacting with a MySQL database using Python

What's included

9 videosTotal 41 minutes

12 readingsTotal 175 minutes

6 assignmentsTotal 116 minutes

1 discussion promptTotal 10 minutes

6 ungraded labsTotal 360 minutes

Performing queries in MySQL using Python

What's included

5 videosTotal 21 minutes

2 readingsTotal 10 minutes

7 assignmentsTotal 128 minutes

8 ungraded labsTotal 480 minutes

Advanced Database Clients

What's included

8 videosTotal 39 minutes

4 readingsTotal 45 minutes

8 assignmentsTotal 140 minutes

8 ungraded labsTotal 480 minutes

Working with a Database Client

What's included

2 videosTotal 6 minutes

6 readingsTotal 135 minutes

3 assignmentsTotal 156 minutes

1 peer reviewTotal 60 minutes

2 discussion promptsTotal 20 minutes

Instructor

Offered by

Why people choose Coursera for their career

Learner reviews

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business