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

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

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

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

Foundations of Relational Databases and SQL

Курс от John Wiley & Sons
Начальный≈ 8.4 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This course introduces the core principles of relational databases and SQL, highlighting their role in managing and organizing critical business and technical data. Learners will understand how database design and querying skills drive efficiency and accuracy in data-driven environments. Students will explore relational modeling, system analysis, and SQL syntax to build functional, optimized databases. The course emphasizes practical application, guiding learners from conceptual design to real-world SQL implementation. What sets this course apart is its integration of theory with hands-on exercises, covering both database architecture and detailed SQL operations. Learners gain insight into balancing performance, correctness, and usability in database systems. Ideal for beginners, IT professionals, and aspiring database developers, this course requires basic familiarity with computers and logical reasoning. No prior SQL experience is necessary. This course is part one of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization. From SQL All-in-One For Dummies Copyright © 2024 by John Wiley & Sons, Inc., Hoboken, New Jersey Used by arrangement with John Wiley & Sons, Inc.

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

Relational DatabasesSQLDatabase DesignData IntegrityDatabase SystemsRequirements AnalysisNetwork ModelSystems DevelopmentData ModelingData ArchitectureMicrosoft SQL ServersSystems Development Life CycleData StoreData ManipulationDatabase DevelopmentDatabase TheoryPerformance TuningDatabase Management SystemsDatabase Architecture and AdministrationDatabase Management

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

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

01Understanding Relational Databases8 материалов

Journey Through Database Models and SQL Essentials

OverviewВидеоIntroductionЧтениеManaging data with simple programsЧтениеRetrieving the data you want — and only the data you wantЧтение

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

Wiley Skills Network

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

Foundations of Relational Databases and SQL
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 8.4 ч

10 модулей

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

Часть программы вашего университета
The hierarchical database modelЧтение
The network database modelЧтение
The object-oriented database modelЧтение
Foundations of Relational DatabasesЗадание
02Modeling a System7 материалов

From User Needs to Entity-Relationship Diagrams: Building the Foundation of Database Design

OverviewВидеоIntroductionЧтениеTranslating the Users' Data Model to a Formal Entity-Relationship ModelЧтениеDrawing Entity-Relationship diagramsЧтениеUnderstanding advanced ER model conceptsЧтениеA simple example of an ER modelЧтениеSystem Modeling FundamentalsЗадание
03Getting to Know SQL6 материалов

Tracing the Evolution of SQL and Its Modern Implementations

OverviewВидеоIntroductionЧтениеThe ISO/IEC SQL StandardЧтениеMicrosoft AccessЧтениеMicrosoft SQL ServerЧтениеExploring SQL and Database SystemsЗадание
04SQL and the Relational Model6 материалов

Unpacking Relational Databases: From Theory to Practice

OverviewВидеоIntroductionЧтениеFunctional DependenciesЧтениеViewsЧтениеCatalogsЧтениеRelational Database FundamentalsЗадание
05Knowing the Major Components of SQL9 материалов

Mastering SQL Structure, Data Operations, and Security Controls

OverviewВидеоIntroductionЧтениеCreating other objectsЧтениеModifying tablesЧтениеAdding data to a tableЧтениеUpdating data in a tableЧтениеDeleting data from a tableЧтениеMaintaining Security in the Data Control Language (DCL)ЧтениеFoundations of SQL Database StructureЗадание
06Drilling Down to the SQL Nitty-Gritty13 материалов

Mastering SQL Foundations: Data Types, Syntax, and Constraints

OverviewВидеоIntroductionЧтениеEmbedded SQLЧтениеUsing Reserved Words CorrectlyЧтениеApproximate numericsЧтениеCharacter stringsЧтениеDatetimesЧтениеXML typeЧтениеREF typesЧтениеData type summaryЧтениеApplying ConstraintsЧтениеForeign key constraintsЧтениеExploring SQL Data Types and Database StructuresЗадание
07System Development Overview8 материалов

From Requirements to Implementation: Navigating the Database Development Journey

OverviewВидеоIntroductionЧтениеThe System Development Life CycleЧтениеESTABLISHING REQUIREMENTS: AN EXAMPLE:ЧтениеEvaluation phaseЧтениеDesign phaseЧтениеImplementation phaseЧтениеSystem Development FundamentalsЗадание
08Building a Database Model8 материалов

From Stakeholder Needs to Robust Relational Models

OverviewВидеоIntroductionЧтениеThe standards organizationЧтениеArriving at a consensusЧтениеKeysЧтениеEliminating anomaliesЧтениеExamining the higher normal formsЧтениеFoundations of Database ModelingЗадание
09Balancing Performance and Correctness12 материалов

Optimizing Databases: Navigating Trade-offs Between Speed and Accuracy

OverviewВидеоIntroductionЧтениеNormalizing a relational modelЧтениеHandling binary relationshipsЧтениеA sample conversionЧтениеDomain integrityЧтениеSpeeding Data RetrievalsЧтениеWorking with IndexesЧтениеQuery type dictates the best indexЧтениеIndexes, sparse and denseЧтениеReading SQL Server Execution PlansЧтениеBalancing Performance and Correctness in Database SystemsЗадание
10Creating a Database with SQL5 материалов

Building Robust Databases: Keys, Constraints, and Table Creation in SQL

OverviewВидеоIntroductionЧтениеUsing the CREATE TABLE statementЧтениеKeys and IndexesЧтениеFoundations of Relational Database StructureЗадание