Database Clients

Ends in 3 days! Save 40% on your access to 10,000+ programs and make a real impact in your career. Save now.

Database Clients

This course is part of Meta Database Engineer Professional Certificate

Instructor: Taught by Meta Experts

11,818 already enrolled

Included with Learn more

Ask Coursera

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

4 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

4 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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 videosTotal 41 minutes

Introduction to the course: Database clients4 minutes
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 Python5 minutes

12 readingsTotal 180 minutes

Database clients10 minutes
How databases are used in programming15 minutes
Course syllabus15 minutes
How to be successful in this course15 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

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 22 minutes

Creating and reading data in a MySQL database using Python6 minutes
Updating and deleting records in a MySQL database using python3 minutes
Filtering and sorting data in MySQL using Python5 minutes
Joining data from different tables in MySQL database using python4 minutes
Module summary: Performing advanced queries on a MySQL database using Python4 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 minutes
Accessing MySQL functions using Python6 minutes
Working with datetime functions in Python6 minutes
A quick review of stored procedures4 minutes
Accessing stored procedures using Python4 minutes
Database connection pooling4 minutes
Python / MySQL connection pool6 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 minutes
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

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

Taught by Meta Experts

Offered by

Explore more from Data Management

IBM
Django Application Development with SQL and Databases
Course
Status: Free Trial
Google Cloud
Google Cloud Database Engineer
Specialization
Status: Free Trial
EDUCBA
SQL Database Applications and Development
Course
Status: Free Trial
EDUCBA
Django with MySQL: Build & Deploy Web Apps
Course
Category: Preview

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."

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.