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

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

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

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

Introduction to SQL and relational databases

Курс от Universitat Politècnica de València
Начальный≈ 22.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

In the modern business landscape, information represents the most valuable resource for organizations, with the majority of this critical data housed within digital relational database systems. The overwhelming majority of database management platforms currently deployed across industries rely on SQL as their primary language for data manipulation and retrieval operations. As a globally recognized standard, SQL empowers users to execute sophisticated data analysis and aggregation operations through an intuitive command structure that maximizes efficiency. For professionals pursuing careers in data analytics, software development, or any field requiring database interaction capabilities, SQL proficiency serves as a fundamental prerequisite. This comprehensive course will guide you through essential database management principles while providing hands-on experience with SQL implementation. Beginning with fundamental data retrieval techniques from single tables, you'll progress to advanced multi-table operations that enable comprehensive data analysis—all practiced using our cloud-based SQL simulation environment throughout your learning journey.

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

SQLRelational DatabasesData ManipulationWeb ApplicationsDatabase SystemsDatabase DesignDatabasesQuery LanguagesData IntegrityDatabase TheoryBack-End Web DevelopmentDatabase Management SystemsDatabase ManagementDatabase AdministrationSecure CodingApplication Security

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

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

01Week 1: Databases14 материалов

Slides of the course

Download course slidesЧтение

Fundamental concepts

Database BasicsPLUGINDatabase BasicsЗадание

Relational databases

relational databasesPLUGIN

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

Nacho Despujol

Jefe de proyecto

Introduction to SQL and relational databases
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 22.1 ч

5 модулей

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

Часть программы вашего университета
relational databasesЗадание
Relationships between tables in relational databasesPLUGIN
Relationships between tables in relational databasesЗадание
Database Management Systems (DBMS)PLUGIN
Database Management Systems (DBMS)Задание

SQL language

SQL languagePLUGINSQL languageЗаданиеSQL PracticePLUGIN

Test exam week 1

Test exam week 1Задание

Exam week 1

Module Exam Задание
02Week 2: Introduction to SQL23 материалов

SQL general concepts

GeneralitiesPLUGINGeneralities exerciseЧтениеGeneralities exerciseЗадание

Basic SQL queries

Select commandPLUGINSelect commandЧтениеSelect command exercisesЗаданиеLimit, Distinct(), Count()PLUGINLimit, Distinct(), Count() exercisesЧтениеLimit, Distinct(), Count() exercisesЗадание

Creating and modifying databases and tables in SQL

Data typesPLUGINData types exercisesЧтениеData types exercisesЗаданиеCreate, Drop, AlterPLUGINCreate, Drop, Alter exercisesЧтениеCreate, Drop, Alter exercisesЗадание

Inserting and deleting data in SQL

Insert, Update, DeletePLUGINInsert, Update, Delete exercisesЧтениеInsert, Update, Delete exercisesЗадание

Structures to increase productivity in SQL

Indexes, Views, and Stored ProceduresPLUGINIndexes, Views, and Stored Procedures exercisesЧтениеIndexes, Views, and Stored Procedures exercisesЗадание

Test exam week 2

Test exam week 2Задание

Exam week 2

Module ExamЗадание
03Week 3: Improving SQL queries23 материалов

Enhancing SQL queries with data patterns, ranges, and sets

Select with string patterns, ranges, and setsPLUGINSelect with string patterns, ranges, and sets exercisesЧтениеSelect with string patterns, ranges, and sets exercisesЗадание

Sorting and grouping the results returned by an SQL query

Order result sets with ORDER BYPLUGINOrder result sets with ORDER BY exercisesЧтениеOrder result sets with ORDER BY exercisesЗаданиеGrouping result sets with GROUP BYPLUGINGrouping result sets with GROUP BY exercisesЧтениеGrouping result sets with GROUP BY exercisesЗадание

Creating conditional fields in SQL

SELECT CASEPLUGINSELECT CASE exercisesЧтениеSELECT CASE exercisesЗадание

Built-in functions in SQL

Aggregate and per-row functionsPLUGINAggregate and per-row functions exercisesЧтениеAggregate and per-row functions exercisesЗаданиеIntegrated date and time functionsPLUGINIntegrated date and time exercisesЧтениеIntegrated date and time functions exercisesЗадание

Subqueries in SQL

Subqueries and nested SELECTsPLUGINSubqueries and nested SELECTs exercisesЧтениеSubqueries and nested SELECTs exercisesЗадание

Test exam week 3

Test exam week 3Задание

Exam week 3

Module examЗадание
04Week 4: Queries that consolidate data from several tables11 материалов

The JOIN command to return data from multiple tables in the same record

Implicit JOIN and JOIN typesPLUGINImplicit JOIN and JOIN types exercisesЧтениеImplicit JOIN and JOIN types exercisesЗаданиеINNER, LEFT, RIGHT and OUTER JOINPLUGININNER, LEFT, RIGHT and OUTER JOIN exercisesЧтениеINNER, LEFT, RIGHT and OUTER JOIN exercisesЗадание

The SELECT UNION command to join the results of multiple queries

SELECT UNIONPLUGINSELECT UNION exercisesЧтениеSELECT UNION exercisesЗадание

Test exam week 4

Test exam week 4Задание

Exam week 4

Module examЗадание
05Week 5: Advanced queries and other topics9 материалов

Advanced multi-table queries

Advanced multi-table queriesPLUGINAdvanced multi-table queries exercisesЧтениеAdvanced multi-table queries exercisesЗадание

SQL injection attacks

SQL injection attacksPLUGINSQL injection attacksЗадание

Clients to perform SQL queries

SQL ClientsPLUGINSQL ClientsЗадание

Test exam week 5

Test exam week 5Задание

Exam week 5

Module examЗадание