К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Database Clients · LearnSpace
Назад в каталог
courseraIT и технологии

Database Clients

Курс от Meta
Средний≈ 40.6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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.

Навыки, которые вы освоите

SQLStored ProcedureMySQLApplication Programming Interface (API)Database DevelopmentDatabase ManagementPython ProgrammingQuery LanguagesDatabase ApplicationBack-End Web DevelopmentData ManagementDjango (Web Framework)Databases

Программа курса

4 модулей · 98 учебных материалов

01Interacting with a MySQL database using Python34 материалов

Course Introduction

Introduction to the course: Database clientsВидеоDatabase clientsЧтениеHow databases are used in programmingЧтениеDatabase engineering at MetaВидео

Учитесь у экспертов

Taught by Meta Experts

Преподаватель курса

Database Clients
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 40.6 ч

4 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Китайский (Китай), Греческий, Бразильский португальский, Вьетнамский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Азербайджанский, Испанский, Дари, Хинди, Венгерский

Часть программы вашего университета
Envisioning Your Python-MySQL Development JourneyDIALOGUE
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

MySQL/Python connectionВидеоOverview of pipЧтениеInstallation and setupВидеоOS specific instructionsЧтениеConnecting to a MySQL database using a Python clientВидеоPython and MySQL connectionsЧтениеExercise: Making your MySQL/Python connectionЛабораторнаяSolution: Making your MySQL/Python connectionЛабораторнаяSelf review: Making your MySQL/Python connectionЗаданиеCreating a database and tables in a MySQL database using PythonВидеоExercise: Creating a table structure in a MySQL database using PythonЛабораторнаяSolution: Creating a table structure in a MySQL database using PythonЛабораторнаяSelf review: Creating a table structure in a MySQL database using PythonЗаданиеKnowledge check: Establishing a MySQL and Python connection and creating tablesЗаданиеAdditional resourcesЧтение

Working with cursors

Cursors and MySQLВидеоCursor subclassesВидеоExercise: Working with cursorsЛабораторнаяSolution: Working with cursorsЛабораторнаяSelf review: Working with cursorsЗаданиеKnowledge check: CursorsЗаданиеModule summary: Interacting with MySQL using PythonВидеоModule Quiz: Interacting with MySQL Using PythonЗаданиеAdditional resourcesЧтение
02Performing queries in MySQL using Python22 материалов

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

Creating and reading data in a MySQL database using PythonВидеоExercise: Creating and reading records in a MySQL database using PythonЛабораторнаяSolution: Creating and reading records in a MySQL database using PythonЛабораторнаяSelf review: Creating and reading records in a MySQL database using PythonЗаданиеUpdating and deleting 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ЛабораторнаяSelf review: Updating and deleting records in a MySQL database using PythonЗаданиеKnowledge check: Performing create, read, update and delete (CRUD) operationsЗаданиеAdditional resourcesЧтение

Advanced Queries in MySQL database using Python

Filtering and sorting data in MySQL using PythonВидеоExercise: Filtering and sorting data in a MySQL database using PythonЛабораторнаяSolution: Filtering and sorting data in a MySQL database using PythonЛабораторнаяSelf review: Filtering and sorting data in a MySQL database using PythonЗаданиеJoining data from different tables in MySQL database using pythonВидеоExercise: Performing different JOIN operations in MySQL databases using PythonЛабораторная
03Advanced Database Clients28 материалов

Implementing MySQL functions using Python

A quick review of MySQL FunctionsВидеоAccessing MySQL functions using PythonВидеоAccessing functionsЧтениеExercise: Utilizing MySQL functions with PythonЛабораторнаяSolution: Utilizing MySQL functions with PythonЛабораторнаяSelf review: Utilizing MySQL functions with PythonЗаданиеWorking with datetime functions in PythonВидеоExercise: Working with date and time functions in PythonЛабораторнаяSolution: Working with date and time functions in PythonЛабораторнаяSelf review: Working with date and time functions in PythonЗаданиеKnowledge check: Working with MySQL functions in PythonЗаданиеAdditional resourcesЧтение

Accessing MySQL stored procedures using Python

A quick review of stored proceduresВидеоAccessing stored procedures using PythonВидеоExercise: Accessing stored procedures in a MySQL database using PythonЛабораторнаяSolution: Accessing stored procedures in a MySQL database using PythonЛабораторнаяSelf review: Accessing stored procedures in a MySQL database using PythonЗаданиеKnowledge Check: Accessing MySQL stored procedures using PythonЗадание

Working with connection pools

Database connection poolingВидеоPython / MySQL connection poolВидеоExercise: Working with connection poolsЛабораторнаяSolution: Working with connection poolsЛабораторнаяSelf review: Working with connection poolsЗаданиеKnowledge check: Working with connection poolsЗадание
04Working with a Database Client14 материалов

Final project

Course Recap: Database ClientsВидеоAbout the final project assessmentЧтениеSet up the databaseЧтениеReadiness check: Have you completed the initial setup?ЗаданиеImplement and query stored proceduresЧтениеReadiness check: Have you set up the stored procedures and run the queries?ЗаданиеLittle Lemon analysis and sales reportЧтениеSubmit your Little Lemon Menu sales report projectВзаимная проверкаExemplar: Little Lemon analysis and sales reportЧтениеShare the challenges you encountered when working on the Little Lemon Sales ReportОбсуждениеFinal Graded Quiz: Database ClientsЗадание

Course wrap up

Course wrap upВидеоReflect on learningОбсуждениеNext stepsЧтение
Solution: Performing different JOIN operations in MySQL databases 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 summary: Performing advanced queries on a MySQL database using PythonВидео
Module Quiz: Performing Advanced Queries in MySQL Using PythonЗадание
Additional resourcesЧтение
Additional resourcesЧтение
Module summary: Advanced Database ClientsВидео
Module Quiz: Advanced Database ClientsЗадание
Additional resourcesЧтение