Oracle Database Administration Fundamentals | Brainmatics

Back

Home
About Us
Account
Careers
- Specialist Internship
- Study Internship
Cart
Cart
Certification
Checkout
Checkout
Collections
Courses
Facilities
Forgot Password
Gallery
Instructor
Personnel
Profile
Terms of Service
Training Quotation Request
Training Registration

Login | Register | Cart

header

20 Sections
107 Lessons
32 Hours

Expand all sectionsCollapse all sections

PERSIAPAN
2
- 1.1
  Pre-Test
  10 Minutes10 Questions
- 1.2
  Download Materi
1. INSTALLING THE ORACLE BINARIES
3
- 2.1
  1.1 Understanding the OFA
- 2.2
  1.2 Installing Oracle
- 2.3
  1.3 Installing in the Cloud
2. CREATING A DATABASE
7
- 3.1
  2.1 Using the Database Configuration Assistant
- 3.2
  2.2 Database vs Instance
- 3.3
  2.3 Stopping and Starting the Database
- 3.4
  2.4 Configuring the LISTENER
- 3.5
  2.5 Database Instance Configuration in Oracle
- 3.6
  2.6 Dropping a Database
- 3.7
  2.7 Creating the Database in the Cloud
3. CONFIGURING AN EFFICIENT ENVIRONMENT
7
- 4.1
  3.1 Customizing OS Command Prompt
- 4.2
  3.2 Customizing SQL Prompt
- 4.3
  3.3 Creating Shortcuts for Frequently Used Commands
- 4.4
  3.4 Rerunning Commands Quickly
- 4.5
  3.5 Developing Standard Scripts
- 4.6
  3.6 Organizing Scripts
- 4.7
  3.7 Automating Scripts
4. TABLESPACES AND DATA FILES
9
- 5.1
  4.1 Understanding the First Five
- 5.2
  4.2 Need for More Tablespaces
- 5.3
  4.3 Container Tablespaces
- 5.4
  4.4 Creating Tablespaces
- 5.5
  4.5 Using Oracle Managed Files
- 5.6
  4.6 Displaying the Tablespace Size
- 5.7
  4.7 Altering Tablespace Size
- 5.8
  4.8 Additional Data File Operations
- 5.9
  4.9 Using ASM for Tablespaces
5. MANAGING CONTROL FILES, ONLINE REDO LOGS, AND ARCHIVELOGS
4
- 6.1
  5.1 Managing Control Files
- 6.2
  5.2 Online Redo Logs
- 6.3
  5.3 Controlling the Generation of Redo
- 6.4
  5.4 Implementing Archivelog Mode
6. USERS AND BASIC SECURITY
4
- 7.1
  6.1 Types of Users
- 7.2
  6.2 Managing Default Users
- 7.3
  6.3 Creating Users
- 7.4
  6.4 Managing Privileges
7. TABLES AND CONSTRAINTS
4
- 8.1
  7.1 Understanding Table Types
- 8.2
  7.2 Understanding Data Types
- 8.3
  7.3 Creating a Table
- 8.4
  7.4 Modifying a Table
8. INDEXES
5
- 9.1
  8.1 Vector Indexes
- 9.2
  8.2 Deciding When to Create an Index
- 9.3
  8.3 Planning for Robustness
- 9.4
  8.4 Creating Indexes
- 9.5
  8.5 Maintaining Indexes
9. VIEWS, DUALITY VIEWS, AND MATERIALIZED VIEWS
3
- 10.1
  9.1 Implementing Views
- 10.2
  9.2 JSON Relational Duality Views
- 10.3
  9.3 Materialized Views
10. DATA DICTIONARY FUNDAMENTALS
5
- 11.1
  10.1 Data Dictionary Architecture
- 11.2
  10.2 A Different View of Metadata
- 11.3
  10.3 A Few Creative Uses of the Data Dictionary
- 11.4
  10.4 The Dual Table
- 11.5
  10.5 Annotations
11. LARGE OBJECTS
4
- 12.1
  11.1 Describing LOB
- 12.2
  11.2 Creating a Table with a LOB Column
- 12.3
  11.3 Maintaining LOB Columns
- 12.4
  11.4 Loading LOBS
12. CONTAINERS AND PLUGGABLES
8
- 13.1
  12.1 Paradigm Shift
- 13.2
  12.2 Administrating the Root Container (CDB)
- 13.3
  12.3 PDB Open Modes
- 13.4
  12.4 Creating a Pluggable Database Within a CDB
- 13.5
  12.5 Administrating Pluggable Databases
- 13.6
  12.6 Limiting the Amount of Space Consumed by PDB
- 13.7
  12.7 Restricting Changes to SYSTEM at PDBl
- 13.8
  12.8 Viewing PDB History
13. RMAN BACKUPS AND REPORTING
7
- 14.1
  13.1 Understanding RMAN
- 14.2
  13.2 Staning RMAN
- 14.3
  13.3 RMAN Architectural Decisions
- 14.4
  13.4 Check for Corruption
- 14.5
  13.5 Using a Recovery Catalog
- 14.6
  13.6 Querying for Output in the Data Dictionary
- 14.7
  13.7 RMAN Reporting
14. RMAN RESTORE AND RECOVERY
15
- 15.1
  14.1 Determining Whether Media Recovery is Required
- 15.2
  14.2 Determining What to Restore
- 15.3
  14.3 Using Data Recovery Advisor
- 15.4
  14.4 Complete Recovery
- 15.5
  14.5 Restoring and Recovering the Entire Database
- 15.6
  14.6 Restoring and Recovering Data Files
- 15.7
  14.7 Performing Block-Level Recovery
- 15.8
  14.8 Restoring a Container Database and Its Pluggable Databases
- 15.9
  14.9 Restoring Archivelog Files
- 15.10
  14.10 Restoring a Control File
- 15.11
  14.11 Using an Autobackup
- 15.12
  14.12 Restoring the Spfile
- 15.13
  14.13 Incomplete Recovery
- 15.14
  14.14 Flashback
- 15.15
  14.15 Restoring and Recovering to a Different Server
15. EXTERNAL TABLES
6
- 16.1
  15.1 SQL*Loader vs. External Tables
- 16.2
  15.2 External Table Types
- 16.3
  15.3 Creating External Tables
- 16.4
  15.4 Inline SQL from External Table
- 16.5
  15.5 Unloading and Loading Data Using an External Table
- 16.6
  15.6 Oracle Data Pump
16. AUTOMATION AND TROUBLESHOOTING
4
- 17.1
  16.1 Automating Jobs with Oracle Scheduler
- 17.2
  16.2 Examples of Automated DBA Job
- 17.3
  16.3 Autonomous Database
- 17.4
  16.4 Database Troubleshooting
17. MIGRATION TO MULTITENANT AND FLEET MANAGEMENT
2
- 18.1
  17.1 Migration to Multitenant
- 18.2
  17.2 Fleet Management
18. DATA MANAGEMENT
8
- 19.1
  18.1 Models
- 19.2
  18.2 JSON
- 19.3
  18.3 Graph
- 19.4
  18.4 Machine Learning & Al
- 19.5
  18.5 Data Studio
- 19.6
  18.6 DBMS_CLOUD
- 19.7
  18.7 REST & ORDS
- 19.8
  18.8 Data Sharing
PENUTUPAN
2
- 20.1
  Post-Test
  10 Questions
- 20.2
  Kuesioner

This content is protected, please login and enroll in the course to view this content!

Download Materi

info@brainmatics.com

About

Careers
Personnel
About Us

Social Media

Partners

Brainmatics Curriculum Booklet (PDF)

Login with your site account

Lost your password?

Remember Me

Not a member yet? Register now

Register a new account

Are you a member? Login now

Modal title

Main Content