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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Oracle DBA Training: Architecture, SQL & User Admin · LearnSpace
Назад в каталог
courseraАнализ данных

Oracle DBA Training: Architecture, SQL & User Admin

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

О курсе

Build practical skills in Oracle Database architecture and administration with a structured introduction to Oracle Database 11g. You’ll explore how memory structures, background processes, control files, and storage components work together to process requests and support reliable database operations. You’ll prepare a database environment, create databases with DBCA, and use SQL Developer, SQL*Plus, and Oracle’s management framework to administer databases and explore metadata. You’ll also configure initialization parameters, startup modes, parameter files, and alert logs, then apply Oracle Net Services and listener settings to establish secure, efficient client-database connections. As you progress, you’ll design and manage tablespaces, extents, data blocks, tables, indexes, and views to support effective storage and schema management. Designed for aspiring database administrators and enterprise systems professionals, this course combines foundational concepts with practical configuration and management tasks. Enroll to build the skills to create, configure, and manage Oracle databases with greater confidence while supporting performance, scalability, and reliability.

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

Oracle DatabasesSQLDatabase Architecture and AdministrationOracle SQL DeveloperDatabase ManagementDatabasesDatabase DesignOperationsDatabase SoftwareDatabase AdministrationData StorageReliabilityScalabilityDatabase Management SystemsNetwork Administration

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

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

01Oracle Architecture & Fundamentals13 материалов

Introduction to Oracle Architecture

Introduction to Oracle 11g Architecture and AdministrationВидеоOracle Database Processes and Architecture DiagramВидеоUnderstanding the Data Dictionary in OracleВидеоFundamental Oracle Request and Response ProcessesВидео

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

EDUCBA

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

Oracle DBA Training: Architecture, SQL & User Admin
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 10.5 ч

4 модулей

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

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

Часть программы вашего университета
User Interaction and Connection Processes in OracleВидео
Introduction to Oracle ArchitectureЗадание

Oracle Memory & Background Processes

Oracle Memory Structures: SGA and PGA ExplainedВидеоBackground Processes: Log Writer and Redo Log ManagementВидеоControl Files and Data Files in Oracle ArchitectureВидеоOracle Memory & Background ProcessesЗаданиеExploring Oracle Architecture and Memory StructuresDIALOGUEOracle Architecture & FundamentalsЗаданиеInvestigating Oracle Database Architecture and Instance OperationsDIALOGUE
02Database Creation & Tools13 материалов

Preparing the Database Environment

Preparing Database EnvironmentВидеоPreparing Hardware RequirementВидеоCreating a Database Using DBCA: Initial SetupВидеоConfiguring Enterprise Manager During DBCAВидеоDBCA Features: Grid Computing, Availability, and StorageВидеоPreparing the Database EnvironmentЗадание

Oracle Management Tools

Oracle Management Framework Part 1ВидеоOracle Management Framework Part 2ВидеоIntroduction to SQL Developer and SQL*Plus ToolsВидеоExploring Table Structures and Metadata in SQL DeveloperВидеоManaging Database Connections in SQL DeveloperВидеоOracle Management ToolsЗадание
03Initialization & Networking12 материалов

Initialization Parameters & Startup

Introduction to Initialization Parameter Files (PFILE & SPFILE)ВидеоUnderstanding Initialization Parameters and Control FilesВидеоModifying Initialization Parameters in OracleВидеоStartup Modes: NOMOUNT, MOUNT, and OPENВидеоAlert Log and Dictionary InformationВидеоInitialization Parameters & StartupЗадание

Oracle Networking Basics

Introduction to Oracle Network ConfigurationВидеоManaging Oracle Listener: Version, Status, and SecurityВидеоNet Service Administration and Listener ConfigurationВидеоAdvanced Connection Options: Local and Directory NamingВидеоOracle Networking BasicsЗаданиеInitialization & NetworkingЗадание
04Module 4: Storage & Schema Management15 материалов

Tablespaces and Storage Structures

Introduction to Database Storage StructuresВидеоUnderstanding Oracle Data Blocks and Block HeadersВидеоCreating and Managing Tablespaces in OracleВидеоManual Database Creation Using SQL ScriptsВидеоPreconfigured Tablespaces in Oracle DatabasesВидеоGenerating DDL Statements for TablespacesВидеоTablespaces and Storage StructuresЗадание

Schema Objects and Table Management

Viewing and Managing Data Files in OracleВидеоIntroduction to Schema Objects in OracleВидеоCreating Tables Manually Using SQL CommandsВидеоAssigning Default and Temporary Tablespaces to UsersВидеоCreating Schema Objects in OracleВидеоSchema Objects and Table ManagementЗадание
Database Creation & ToolsЗадание
Module 4: Storage & Schema ManagementЗадание
Preparing and Administering a New Oracle Database EnvironmentDIALOGUE