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

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

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

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

Database Structures and Management with MySQL

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

О курсе

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ability to complete a database normalization project You’ll gain experience with the following tools and software: - MySQL DBMS - Joins and Unions - SQL statements, clauses and data types - Primary and foreign keys - Database normalization

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

SQLMySQLStored ProcedureData IntegrityDatabase AdministrationData MaintenanceDatabase DevelopmentDatabase Management SystemsData ManagementData EntryRelational DatabasesDatabase DesignQuery LanguagesDatabase Management

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

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

01Intro to MySQL44 материалов

Course Introduction

Introduction to the programВидеоIntroduction to the courseВидеоHow Meta uses MySQLВидеоFrom Basic Queries to Advanced Database ChallengesDIALOGUE

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

Taught by Meta Experts

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

Database Structures and Management with MySQL
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 32.1 ч

4 модулей

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

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

Часть программы вашего университета
Course syllabus: Database structures and management with MySQLЧтение
How to be successful in this courseЧтение
Recap of Course 1 conceptsЧтение
Additional resourcesЧтение

Filtering data

Filtering data using AND, OR and NOT logical operatorsВидеоFiltering data using IN, BETWEEN and LIKE logical operatorsВидеоKnowledge check: Filtering data using logical operatorsЗаданиеHow to access MySQL EnvironmentЧтениеExercise: Filtering dataЛабораторнаяFiltering data (Exercise solution)ЧтениеSelf review: Filtering dataЗаданиеAdditional resourcesЧтениеReading exercise: Filtering data examples (Optional) ЧтениеReading exercise: Filtering data examples (Exercise solution)ЧтениеReference sheet: Using operators and the WHERE clauseЧтение

Joining Tables

MySQL aliasesВидеоJoining tablesЧтениеJOINSВидеоKnowledge check: JOINSЗаданиеINNER JOINВидеоLEFT and RIGHT JOINВидеоSELF-JOINВидеоMySQL UNION operatorВидеоKnowledge check: MySQL UNION operatorЗаданиеExercise: Practice using JOINSЛабораторная Practice using JOINS (Exercise solution)ЧтениеSelf review: JOINSЗаданиеAdditional resourcesЧтение

Grouping Data

MySQL GROUP BYВидеоMySQL HAVINGВидеоKnowledge check: GROUP BY and HAVING clausesЗаданиеExercise: Grouping dataЛабораторнаяGrouping data (Exercise solution)ЧтениеSelf review: Grouping dataЗаданиеModule summary: Intro to MySQLВидеоModule quiz: Intro to MySQLЗаданиеAdditional resourcesЧтениеReading exercise: Operators and clauses (Optional)ЧтениеReading exercise: Operators and clauses (Exercise solution)ЧтениеReference sheet: Operators and clausesЧтение
02Updating databases and working with views49 материалов

Updating and inserting data

MySQL REPLACE statementВидеоKnowledge check: REPLACEЗаданиеMySQL REPLACE statement in depthЧтениеExercise: MySQL REPLACE statementЛабораторнаяMySQL REPLACE statement (Exercise solution)ЧтениеSelf review: MySQL REPLACE statementЗаданиеAdditional resourcesЧтениеReading exercise: REPLACE INTO statement (Optional)ЧтениеReading exercise: REPLACE INTO statement (Exercise solution)Чтение

Constraints

Constraints in MySQLВидеоConstraints in practiceВидеоKnowledge check: ConstraintsЗаданиеTypes of MySQL constraintsЧтениеExercise: Working with constraintsЛабораторнаяWorking with constraints (Exercise solution)ЧтениеSelf review: Working with constraints

Changing table structure

MySQL ALTER TABLEВидеоMySQL COPY TABLEВидеоKnowledge check: ALTER TABLE and COPY TABLE ЗаданиеExercise: Changing table structureЛабораторнаяChanging table structure (Exercise solution)ЧтениеSelf review: Changing table structureЗадание

Subqueries

Subqueries in MySQLВидеоSubqueries and complex comparison operatorsВидеоKnowledge check: Subqueries in MySQLЗаданиеExercise: Working with subqueriesЛабораторнаяWorking with subqueries (Exercise solution)ЧтениеSelf review: Working with subqueriesЗадание

Virtual Tables

MySQL CREATE VIEWВидеоVirtual tables in depthЧтениеKnowledge check: Views in MySQLЗаданиеWorking with views in MySQLЛабораторнаяWorking with views in MySQL (Exercise solution)ЧтениеSelf review: Working with views in MySQLЗадание
03Functions and MySQL stored procedures23 материалов

Functions in MySQL

Numeric functionsВидеоString functionsВидеоDate functionsВидеоKnowledge check: MySQL functionsЗаданиеComparison functionsВидеоControl flow functionsВидеоKnowledge check: MySQL comparison and control flow functionsЗаданиеExercise: Working with MySQL functionsЛабораторнаяWorking with MySQL functions (Exercise solution)ЧтениеSelf review: Working with MySQL functionsЗаданиеAdditional resourcesЧтениеReading exercise: Practicing with functions (Optional)ЧтениеReading exercise: Practicing with functions (Exercise solution)ЧтениеReference sheet: Functions in MySQLЧтение

Procedures

Stored procedures in MySQLВидеоMySQL stored procedures in depthЧтениеKnowledge check: MySQL stored proceduresЗаданиеExercise: Working with proceduresЛабораторнаяWorking with procedures (Exercise solution)ЧтениеSelf review: Working with proceduresЗадание
04Graded assessment10 материалов

Graded Assessment: Final project

Course RecapВидеоAbout the final graded assessmentЧтениеMySQL database projectЛабораторнаяMySQL database project (Exercise solution)ЧтениеSelf review: MySQL database projectЗаданиеCourse final graded quizЗаданиеShare some of the things you learned building the project.Обсуждение

Course wrap up

Course wrap upВидеоReflect on learningОбсуждениеNext stepsЧтение
Задание
Additional resourcesЧтение
Reading exercise: MySQL constraints (Optional)Чтение
Reading exercise: MySQL constraints (Exercise solution)Чтение
Additional resourcesЧтение
Reading exercise: ALTER TABLE statement (Optional)Чтение
Reading exercise: ALTER TABLE statement (Exercise solution)Чтение
Reference sheet: ALTER TABLE statement and its usesЧтение
Additional resourcesЧтение
Reading exercise: Practicing subqueries (Optional)Чтение
Reading exercise: Practicing subqueries (Exercise solution)Чтение
Reference sheet: SubqueriesЧтение
Module summary: Updating databases and working with viewsВидео
Module quiz: Updating databases and working with viewsЗадание
Additional resourcesЧтение
Reference sheet: Creating virtual tables in MySQLЧтение
Module summary: Functions and MySQL stored proceduresВидео
Module quiz: Functions and MySQL stored procedures Задание
Additional resourcesЧтение