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

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

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

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

SQL Database Applications and Development

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

О курсе

Learn how to design, build, and manage database applications using SQL, Oracle database concepts, relational structures, triggers, and stored procedures. This course provides practical skills for learners who want to understand database systems and develop reliable database-driven applications. The course begins with the foundations of database development, including the role of SQL, Oracle environment setup, and essential database concepts that support reliable data management. Learners will understand how database systems organize, store, and manage information for real-world applications. As the course progresses, learners explore core database principles such as ACID properties, database creation, tablespaces, and table structures. The course also covers data modeling, data types, constraints, and table management techniques that help ensure accuracy, consistency, and integrity in relational databases. Advanced modules focus on database programming using triggers and stored procedures. Learners will understand how these tools automate processes, improve performance, and manage business logic directly within the database environment. What makes this course unique is its structured progression from database fundamentals to advanced SQL programming. By the end of the course, learners will be able to create structured tables, enforce data integrity, automate database operations, and build practical database applications confidently for backend development, data management, and software roles.

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

Oracle SQL DeveloperData IntegrityTransaction ProcessingSQLData ModelingDatabase DesignStored ProcedureDatabase TheoryDatabase ApplicationPL/SQLDatabase DevelopmentRelational DatabasesDatabase Management SystemsData StorageDatabase Architecture and AdministrationDatabase ManagementOperational DatabasesOracle Databases

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

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

01Foundations of Database Development14 материалов

Introduction to Databases & Applications

Course OverviewВидеоWhat Is Database And ApplicationВидеоLanguages Used For DevelopmentВидеоIntroduction to Databases & ApplicationsЗадание

Setting Up the Oracle Environment

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

EDUCBA

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

SQL Database Applications and Development
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 10.6 ч

4 модулей

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

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский

Часть программы вашего университета
Environment For Oracle DatabaseВидео
Languages And Tools For Oracle DatabaseВидео
Structured Query LanguageВидео
Setting Up the Oracle EnvironmentЗадание

SQL Fundamentals & Benefits

Advantages Of SQLВидеоDatabase, SQL PropertiesВидеоSQL Fundamentals & BenefitsЗаданиеAnalyzing Database Needs and Applying SQL FundamentalsDIALOGUEGraded - Foundations of Database DevelopmentЗаданиеApplying SQL and Database Concepts to Design a Business Data SystemDIALOGUE
02Core Database Concepts & Setup13 материалов

Understanding Database Reliability (ACID)

ACID propertyВидеоCase Study for Atomic PropertyВидеоDatabase Application OperationВидеоUnderstanding Database Reliability (ACID)Задание

Creating Database Infrastructure

Creation of DatabaseВидеоCreation of database user tablespaceВидеоCreation of database user tablespace continuedВидеоCreating Database InfrastructureЗадание

Table Creation & Data Basics

Creation of TablesВидеоCreation of Tables continuedВидеоData TypesВидеоTable Creation & Data BasicsЗаданиеGraded - Core Database Concepts & SetupЗадание
03Data Modeling & Integrity13 материалов

Data Types & Constraints Overview

Data Types continuedВидеоTypes Of ConstraintВидеоDefine ConstraintВидеоData Types & Constraints OverviewЗадание

Applying Constraints in Databases

Foreign Key ConstraintВидеоNot null, unique and check constraintВидеоCreating and Altering Table exampleВидеоApplying Constraints in DatabasesЗадание

Managing Tables Effectively

Displaying and droping the table columns and tableВидеоWhat is TriggerВидеоDesigning TriggersВидеоManaging Tables EffectivelyЗаданиеGraded - Data Modeling & IntegrityЗадание
04Advanced Database Programming13 материалов

Working with Triggers

Naming and creating TriggersВидеоTypes of Trigger and restrictionsВидеоCompiling TriggersВидеоWorking with TriggersЗадание

Trigger Applications & Stored Procedures

Examples of Trigger ApplicationВидеоStored ProcedureВидеоStored Procedure Creation with ExampleВидеоTrigger Applications & Stored ProceduresЗадание

Executing and Managing Procedures

Calling Procedure and featuresВидеоReturn value of procedure and restrictionВидеоExecuting and Managing ProceduresЗаданиеGraded - Advanced Database ProgrammingЗаданиеDesigning and Managing a Database Application Using SQLDIALOGUE