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