Monthly Subscription Starting at AED 99 + VAT

Database Clients
  • Level Professional
  • المدة 40 ساعات hours
  • الطبع بواسطة Meta
  • Offered by

عن

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.

الوحدات

Course Introduction

    • 2 Videos
    • 7 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • What do you hope to learn?

2 Videos

  • Introduction to the course: Database clients
  • Database engineering at Meta

7 Readings

  • Database clients
  • How databases are used in programming
  • Course syllabus
  • How to be successful in this course
  • Course requirements
  • Working with labs in this course
  • Additional resources

Establishing a MySQL/Python connection and creating tables

    • 4 Videos
    • 4 Readings
    • 4 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self review: Making your MySQL/Python connection
  • Self review: Creating a table structure in a MySQL database using Python
  • Knowledge check: Establishing a MySQL and Python connection and creating tables

4 Labs

  • Exercise: Making your MySQL/Python connection
  • Solution: Making your MySQL/Python connection
  • Exercise: Creating a table structure in a MySQL database using Python
  • Solution: Creating a table structure in a MySQL database using Python

4 Videos

  • MySQL/Python connection
  • Installation and setup
  • Connecting to a MySQL database using a Python client
  • Creating a database and tables in a MySQL database using Python

4 Readings

  • Overview of pip
  • OS specific instructions
  • Python and MySQL connections
  • Additional resources

Working with cursors

    • 3 Videos
    • 1 Readings
    • 2 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self review: Working with cursors
  • Knowledge check: Cursors
  • Module Quiz: Interacting with MySQL Using Python

2 Labs

  • Exercise: Working with cursors
  • Solution: Working with cursors

3 Videos

  • Cursors and MySQL
  • Cursor subclasses
  • Module summary: Interacting with MySQL using Python

1 Readings

  • Additional resources

Performing Create, Read, Update and Delete (CRUD) operations

    • 2 Videos
    • 1 Readings
    • 4 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self review: Creating and reading records in a MySQL database using Python
  • Self review: Updating and deleting records in a MySQL database using Python
  • Knowledge check: Performing create, read, update and delete (CRUD) operations

4 Labs

  • Exercise: Creating and reading records in a MySQL database using Python
  • Solution: Creating and reading records in a MySQL database using Python
  • Exercise: Updating and deleting records in a MySQL database using Python
  • Solution: Updating and deleting records in a MySQL database using Python

2 Videos

  • Creating and reading data in a MySQL database using Python
  • Updating and deleting records in a MySQL database using python

1 Readings

  • Additional resources

Advanced Queries in MySQL database using Python

    • 3 Videos
    • 1 Readings
    • 4 Lab
    • 4 Assignment
Show info about module content

4 Assignment

  • Self review: Filtering and sorting data in a MySQL database using Python
  • Self review: Performing different JOIN operations in MySQL databases using Python
  • Knowledge check: Performing advanced queries on a MySQL database using Python
  • Module Quiz: Performing Advanced Queries in MySQL Using Python

4 Labs

  • Exercise: Filtering and sorting data in a MySQL database using Python
  • Solution: Filtering and sorting data in a MySQL database using Python
  • Exercise: Performing different JOIN operations in MySQL databases using Python
  • Solution: Performing different JOIN operations in MySQL databases using Python

3 Videos

  • Filtering and sorting data in MySQL using Python
  • Joining data from different tables in MySQL database using python
  • Module summary: Performing advanced queries on a MySQL database using Python

1 Readings

  • Additional resources

Implementing MySQL functions using Python

    • 3 Videos
    • 2 Readings
    • 4 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self review: Utilizing MySQL functions with Python
  • Self review: Working with date and time functions in Python
  • Knowledge check: Working with MySQL functions in Python

4 Labs

  • Exercise: Utilizing MySQL functions with Python
  • Solution: Utilizing MySQL functions with Python
  • Exercise: Working with date and time functions in Python
  • Solution: Working with date and time functions in Python

3 Videos

  • A quick review of MySQL Functions
  • Accessing MySQL functions using Python
  • Working with datetime functions in Python

2 Readings

  • Accessing functions
  • Additional resources

Accessing MySQL stored procedures using Python

    • 2 Videos
    • 1 Readings
    • 2 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Self review: Accessing stored procedures in a MySQL database using Python
  • Knowledge Check: Accessing MySQL stored procedures using Python

2 Labs

  • Exercise: Accessing stored procedures in a MySQL database using Python
  • Solution: Accessing stored procedures in a MySQL database using Python

2 Videos

  • A quick review of stored procedures
  • Accessing stored procedures using Python

1 Readings

  • Additional resources

Working with connection pools

    • 3 Videos
    • 1 Readings
    • 2 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Self review: Working with connection pools
  • Knowledge check: Working with connection pools
  • Module Quiz: Advanced Database Clients

2 Labs

  • Exercise: Working with connection pools
  • Solution: Working with connection pools

3 Videos

  • Database connection pooling
  • Python / MySQL connection pool
  • Module summary: Advanced Database Clients

1 Readings

  • Additional resources

Final project

    • 1 Videos
    • 5 Readings
    • 1 Discussion
    • 1 PeerReview
    • 3 Assignment
Show info about module content

3 Assignment

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

1 Peer Review

  • Submit your Little Lemon Menu sales report project

1 Discussions

  • Share the challenges you encountered when working on the Little Lemon Sales Report

1 Videos

  • Course Recap: Database Clients

5 Readings

  • About the final project assessment
  • Set up the database
  • Implement and query stored procedures
  • Little Lemon analysis and sales report
  • Exemplar: Little Lemon analysis and sales report

Course wrap up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Course wrap up

1 Readings

  • Next steps

Auto Summary

Dive into "Database Clients" to master creating database-driven applications in Python, focusing on MySQL integration. This professional-level course, offered by Coursera, spans 2400 minutes and requires prior completion of Advanced MySQL topics. Gain expertise in Python, Django REST framework, and advanced MySQL functionalities. Available through Starter and Professional subscriptions, it's perfect for eager coders looking to enhance their database management skills.

Taught by Meta Staff
Instructor

Taught by Meta Staff