VOOZH about

URL: https://www.coursera.org/learn/database-clients

⇱ Database Clients | Coursera

Database Clients

Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Database Clients

11,739 already enrolled

Included with

Ask Coursera

Gain insight into a topic and learn the fundamentals.
4.3

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
Gain insight into a topic and learn the fundamentals.
4.3

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.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 assignments

Taught in English

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
  • Module Quiz: Interacting with MySQL Using Python•50 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
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
  • Module Quiz: Performing Advanced Queries in MySQL Using Python•50 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
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
  • Module Quiz: Advanced Database Clients•50 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
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
  • Final Graded Quiz: Database Clients•150 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 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
4.7 (28 ratings)
Meta
136 Courses•1,343,122 learners

Offered by

Explore more from Data Management

Why people choose Coursera for their career

👁 Image

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

Jennifer J.

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

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

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

IC
·

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

AA
·

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.

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.

Financial aid available,