When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Specialization?

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Oracle DBA 21c: Design, Manage & Secure Databases

Économisez sur les compétences qui vous font briller avec 40 % de réduction sur 3 mois de Coursera Plus. Économisez maintenant

Ce cours n'est pas disponible en Français (France)

Nous sommes actuellement en train de le traduire dans plus de langues. Consultez les langues disponibles.

Oracle DBA 21c: Design, Manage & Secure Databases

Ce cours fait partie de Spécialisation "Oracle DBA 21c: Master Database Administration"

Instructeur : EDUCBA

Inclus avec

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

14 avis

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

5 modules

Obtenez un aperçu d'un sujet et apprenez les principes fondamentaux.

14 avis

2 semaines à compléter

à 10 heures par semaine

Planning flexible

Apprenez à votre propre rythme

Ce que vous apprendrez

Define Oracle 21c architecture and configure database instances.
Manage tablespaces, undo data, indexes, and user security.
Apply blockchain tables, auto indexing, and flashback features.

Compétences que vous acquerrez

Catégorie : Cyber Security Policies
Catégorie : Performance Tuning
Catégorie : Data Storage Technologies
Catégorie : Data Management
Catégorie : Data Storage
Catégorie : System Monitoring
Catégorie : Database Management
Catégorie : SQL
Catégorie : Database Design
Catégorie : Identity and Access Management
Catégorie : Data Integrity
Catégorie : Database Architecture and Administration
Catégorie : Security Controls
Catégorie : File Management
Catégorie : Database Administration
Catégorie : User Accounts

Outils que vous découvrirez

Catégorie : Database Management Systems
Catégorie : Relational Databases
Catégorie : Oracle Databases
Catégorie : Oracle SQL Developer

Détails à connaître

Certificat partageable

Ajouter à votre profil LinkedIn

Évaluations

19 devoirs

Enseigné en Anglais

Découvrez comment les employés des entreprises prestigieuses maîtrisent des compétences recherchées

En savoir plus sur Coursera pour les affaires

logos de Petrobras, TATA, Danone, Capgemini, P&G et L'Oreal

Élaborez votre expertise du sujet

Ce cours fait partie de la Spécialisation "Oracle DBA 21c: Master Database Administration"

Lorsque vous vous inscrivez à ce cours, vous êtes également inscrit(e) à cette Spécialisation.

Apprenez de nouveaux concepts auprès d'experts du secteur
Acquérez une compréhension de base d'un sujet ou d'un outil
Développez des compétences professionnelles avec des projets pratiques
Obtenez un certificat professionnel partageable

Il y a 5 modules dans ce cours

Learners will define Oracle database architecture, apply SQL commands to manage data, configure storage structures, implement security policies, and evaluate Oracle 21c innovations. By completing this Oracle DBA 21c course, they will gain hands-on expertise in managing instances, creating databases, monitoring performance, and securing enterprise environments.

This comprehensive program begins with foundational Oracle Database concepts, progresses through startup and shutdown procedures, data dictionary usage, tablespaces, control files, and undo management, and advances into working with tables, indexes, constraints, and user security. Learners also explore cutting-edge Oracle 21c features such as blockchain tables, automatic indexing, and flashback technologies. Designed for aspiring and practicing DBAs, this course provides real-world practical examples, step-by-step demonstrations, and structured module-based learning. By the end, learners will be equipped with the knowledge and applied skills to design efficient storage strategies, manage mission-critical databases, enforce security, and leverage Oracle 21c enhancements—setting them apart in the competitive field of database administration.

Détails du module

This module introduces the fundamentals of Oracle Database architecture, covering database servers, processes, memory structures, and administration basics. Learners gain the foundation required to understand how Oracle Database operates and is managed.

Inclus

14 vidéos4 devoirs

14 vidéosTotal 89 minutes

Introduction4 minutes
Oracle Server, Instance and Database10 minutes
SGA, Shared Pool, Library Cache12 minutes
Redo Log Buffer, Large Pool and Java Pool3 minutes
Program Global Area10 minutes
Database Writer (DBWn), Log Writer (LGWR)System Monitor (SMON)5 minutes
Checkpoint, Archiver9 minutes
Processing SQL Statements2 minutes
Checkpoint, Archiver and Logical Structure Summary1 minute
Getting Started with the Oracle Server8 minutes
Database Administrator Users, SQLPlus5 minutes
Oracle Enterprise Manager and Console7 minutes
Managing an Oracle Instance6 minutes
SPFILE spfileSID.ora8 minutes

4 devoirsTotal 60 minutes

Introduction and Basics10 minutes
Oracle Processes and Architecture10 minutes
Getting Started with Oracle Administration10 minutes
Oracle Database Foundations30 minutes

This module explains how to manage Oracle instances, startup and shutdown procedures, authentication methods, and database creation. It also explores data dictionaries and dynamic performance views essential for DBA operations.

Inclus

11 vidéos4 devoirs

11 vidéosTotal 93 minutes

Starting up database, Alter database11 minutes
Shutting Down Database9 minutes
Managing and Organizing a Database6 minutes
Using Password File Authentication & Creating a Database6 minutes
Create Database Using DCA And Manually12 minutes
Creating a Database using OMF, Troubleshooting and After Database Creation11 minutes
Creating a Database 018 minutes
Creating a Database 028 minutes
Data Dictionary10 minutes
Dynamic Performance Tables7 minutes
Practical Examples 55 minutes

4 devoirsTotal 60 minutes

Instance and Database Startup/Shutdown10 minutes
Database Creation and Authentication10 minutes
Data Dictionary and Dynamic Views10 minutes
Managing Oracle Instances and Databases30 minutes

This module covers Oracle storage architecture, including control files, redo logs, tablespaces, datafiles, and undo management. Learners will manage database structures and ensure integrity with effective storage administration.

Inclus

24 vidéos4 devoirs

24 vidéosTotal 183 minutes

Maintaining the Control File8 minutes
Maintaining the Control File Count5 minutes
Practical Examples 66 minutes
Maintaining Redo Log Files10 minutes
Dropping Online Redo Log Files7 minutes
Managing Online Redo Log Files7 minutes
Practical Examples 74 minutes
Types of Tablespaces10 minutes
Locally Managed Tablespaces5 minutes
Undo, Temporary and Read Only Tablespace6 minutes
Default Temporary Tablespace9 minutes
Tablespace offline, Storage Settings and Resizing Tablespace10 minutes
Resizing, Dropping and Obtaining Tablespace information11 minutes
Managing Tablespaces and Datafiles-Practical 016 minutes
Managing Tablespaces and Datafiles-Practical 026 minutes
Types of Segments8 minutes
Storage Clause Precedence7 minutes
Non Standard Block Size, Database Block Contents11 minutes
Manual Data block Management and Practical Examples12 minutes
Managing Undo Data6 minutes
Types of Undo Segments7 minutes
Automatic Undo Management Altering an UNDO Tablespace8 minutes
Automatic Undo Management Sizing an UNDO Tablespace6 minutes
Practical Example Session 108 minutes

4 devoirsTotal 60 minutes

Control Files and Redo Logs10 minutes
Tablespaces and Datafiles10 minutes
Segments, Blocks and Undo10 minutes
Storage Structures and Control Management30 minutes

This module teaches how to manage user data, create and modify tables, implement indexes, and enforce constraints. Learners will apply Oracle SQL techniques to ensure data efficiency, integrity, and security.

Inclus

18 vidéos4 devoirs

18 vidéosTotal 130 minutes

Storing User Data8 minutes
Oracle Built-in Data Types8 minutes
ROWID Format, Structure of a Row9 minutes
Creating a Table7 minutes
Truncating , Dropping Table6 minutes
Dropping a Table7 minutes
Practical Example Session 116 minutes
Btree Index8 minutes
Bitmap Indexes5 minutes
Creating Btree and Bitmap Index10 minutes
Changing Storage Parameters for Indexes7 minutes
Changing Storage Parameters for Indexes Count7 minutes
Practical Examples 126 minutes
Types of Constraints , Constraints States8 minutes
Types of Constraints , Constraints States Count7 minutes
Defining Constraints8 minutes
Enabling Constraints7 minutes
Practical Examples 139 minutes

4 devoirsTotal 60 minutes

Tables and Data Storage10 minutes
Indexing Techniques10 minutes
Constraints and Security Basics10 minutes
Working with User Data, Indexes, and Constraints30 minutes

This module introduces advanced Oracle DBA topics including security management, profiles, resource directives, and enhancements in Oracle 21c. Learners will evaluate and apply modern features such as blockchain tables and automatic indexing.

Inclus

18 vidéos3 devoirs

18 vidéosTotal 129 minutes

Profiles and Password Management7 minutes
Profiles and Password Management Count9 minutes
Alter, Drop Profile7 minutes
Resource Plan Directives9 minutes
Practical Examples 146 minutes
Users and Security8 minutes
Creating a New User Operating System Authentication6 minutes
Practical Examples 156 minutes
Granting and Revoking System Privileges13 minutes
What is Database Server9 minutes
PGA and Background Process7 minutes
Database Buffer Cache8 minutes
Database System Files7 minutes
Application Container8 minutes
LREG and SMON4 minutes
Checkpoint Process6 minutes
RVWR5 minutes
Oracle 21c New Features5 minutes

3 devoirsTotal 50 minutes

Security, Profiles, and Resource Management10 minutes
Oracle 21c Processes and Enhancements10 minutes
Advanced Administration and Oracle 21c Features30 minutes

Obtenez un certificat professionnel

Ajoutez ce titre à votre profil LinkedIn, à votre curriculum vitae ou à votre CV. Partagez-le sur les médias sociaux et dans votre évaluation des performances.