Database Clients

Seize the savings! Get 40% off 3 months of Coursera Plus and full access to thousands of courses.

Database Clients

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Experts

11,423 already enrolled

Included with

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

98 reviews

Intermediate level

Recommended experience

Flexible schedule

4 weeks at 10 hours a week

Learn at your own pace

91%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

98 reviews

Intermediate level

Recommended experience

Flexible schedule

4 weeks at 10 hours a week

Learn at your own pace

91%

Most learners liked this course

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.

Skills you'll gain

Tools you'll learn

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

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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 assignments6 ungraded labs

9 videos Total 41 minutes

Introduction to the course: Database clients 4 minutes
Database engineering at Meta 5 minutes
MySQL/Python connection 3 minutes
Installation and setup 5 minutes
Connecting to a MySQL database using a Python client 3 minutes
Creating a database and tables in a MySQL database using Python 4 minutes
Cursors and MySQL 4 minutes
Cursor subclasses 6 minutes
Module summary: Interacting with MySQL using Python 5 minutes

12 readings Total 180 minutes

Database clients 10 minutes
How databases are used in programming 15 minutes
Course syllabus 15 minutes
How to be successful in this course 15 minutes
Course requirements 10 minutes
Working with labs in this course 10 minutes
Additional resources 5 minutes
Overview of pip 30 minutes
OS specific instructions 30 minutes
Python and MySQL connections 30 minutes
Additional resources 5 minutes
Additional resources 5 minutes

6 assignments Total 116 minutes

Self review: Making your MySQL/Python connection 12 minutes
Self review: Creating a table structure in a MySQL database using Python 12 minutes
Knowledge check: Establishing a MySQL and Python connection and creating tables 15 minutes
Self review: Working with cursors 12 minutes
Knowledge check: Cursors 15 minutes
Module Quiz: Interacting with MySQL Using Python 50 minutes

6 ungraded labs Total 360 minutes

Exercise: Making your MySQL/Python connection 60 minutes
Solution: Making your MySQL/Python connection 60 minutes
Exercise: Creating a table structure in a MySQL database using Python 60 minutes
Solution: Creating a table structure in a MySQL database using Python 60 minutes
Exercise: Working with cursors 60 minutes
Solution: Working with cursors 60 minutes

Access query functionality in MySQL using Python clients.

What's included

5 videos2 readings7 assignments8 ungraded labs

5 videos Total 22 minutes

Creating and reading data in a MySQL database using Python 6 minutes
Updating and deleting records in a MySQL database using python 3 minutes
Filtering and sorting data in MySQL using Python 5 minutes
Joining data from different tables in MySQL database using python 4 minutes
Module summary: Performing advanced queries on a MySQL database using Python 4 minutes

2 readings Total 10 minutes

Additional resources 5 minutes
Additional resources 5 minutes

7 assignments Total 128 minutes

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

8 ungraded labs Total 480 minutes

Exercise: Creating and reading records in a MySQL database using Python 60 minutes
Solution: Creating and reading records in a MySQL database using Python 60 minutes
Exercise: Updating and deleting records in a MySQL database using Python 60 minutes
Solution: Updating and deleting records in a MySQL database using Python 60 minutes
Exercise: Filtering and sorting data in a MySQL database using Python 60 minutes
Solution: Filtering and sorting data in a MySQL database using Python 60 minutes
Exercise: Performing different JOIN operations in MySQL databases using Python 60 minutes
Solution: Performing different JOIN operations in MySQL databases using Python 60 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 videos Total 39 minutes

A quick review of MySQL Functions 5 minutes
Accessing MySQL functions using Python 6 minutes
Working with datetime functions in Python 6 minutes
A quick review of stored procedures 4 minutes
Accessing stored procedures using Python 4 minutes
Database connection pooling 4 minutes
Python / MySQL connection pool 6 minutes
Module summary: Advanced Database Clients 5 minutes

4 readings Total 45 minutes

Accessing functions 30 minutes
Additional resources 5 minutes
Additional resources 5 minutes
Additional resources 5 minutes

8 assignments Total 140 minutes

Self review: Utilizing MySQL functions with Python 12 minutes
Self review: Working with date and time functions in Python 9 minutes
Knowledge check: Working with MySQL functions in Python 15 minutes
Self review: Accessing stored procedures in a MySQL database using Python 12 minutes
Knowledge Check: Accessing MySQL stored procedures using Python 15 minutes
Self review: Working with connection pools 12 minutes
Knowledge check: Working with connection pools 15 minutes
Module Quiz: Advanced Database Clients 50 minutes

8 ungraded labs Total 480 minutes

Exercise: Utilizing MySQL functions with Python 60 minutes
Solution: Utilizing MySQL functions with Python 60 minutes
Exercise: Working with date and time functions in Python 60 minutes
Solution: Working with date and time functions in Python 60 minutes
Exercise: Accessing stored procedures in a MySQL database using Python 60 minutes
Solution: Accessing stored procedures in a MySQL database using Python 60 minutes
Exercise: Working with connection pools 60 minutes
Solution: Working with connection pools 60 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 videos Total 6 minutes

Course Recap: Database Clients 4 minutes
Course wrap up 2 minutes

6 readings Total 135 minutes

About the final project assessment 30 minutes
Set up the database 30 minutes
Implement and query stored procedures 30 minutes
Little Lemon analysis and sales report 30 minutes
Exemplar: Little Lemon analysis and sales report 10 minutes
Next steps 5 minutes

3 assignments Total 156 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
Final Graded Quiz: Database Clients 150 minutes

1 peer review Total 60 minutes

Submit your Little Lemon Menu sales report project 60 minutes

2 discussion prompts Total 20 minutes

Share the challenges you encountered when working on the Little Lemon Sales Report 10 minutes
Reflect on learning 10 minutes

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Instructor ratings

(28 ratings)

Taught by Meta Experts

Offered by

Explore more from Data Management

Status: Free Trial
IBM
Django Application Development with SQL and Databases
Course
Status: Free Trial
Google Cloud
Google Cloud Database Engineer
Specialization
Status: Preview
EDUCBA
Django with MySQL: Build & Deploy Web Apps
Course
Status: Free Trial
University of Michigan
Using Databases with Python
Course

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

5 stars
68.36%
4 stars
12.24%
3 stars
9.18%
2 stars
5.10%
1 star
5.10%

Showing 3 of 98

Reviewed on Sep 6, 2023

a lot can be learned from this course, material is not that easy, but combination of mysql and python is powerful

Reviewed on Mar 2, 2024

as is always Meta content is very well organized and excellent. but there could have more real life implementation was possible to show.

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,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

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.

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.