Oracle Oracle DATABASE Admin DBA 1 Course

Oracle DATABASE Admin DBA 1 Course

Catalog: Oracle
Short name: DATABASE Admin DBA
Course start date: 2024-07-02
Paystack
Enroll Me

Description

Oracle Server, Instance, and Database: Here you will learn about the Oracle server, instance and database in a better manner and the benefits in an enhanced fashion

Database Administrator Users, SQLPlus: Here you will learn about Database Administrator Users, SQLPlus in a comprehensive manner

Managing an Oracle Instance: This section will help you understand how to manage an Oracle instance

Using Password File Authentication & Creating a Database: In this section, you will learn the importance of using password file authentication & creating a database

Maintaining the Control File: Here you will learn about maintenance of the control file

Storing User Data: This section will help you understand how to store user data in a better manner

Profiles and Password Management: Here you will learn about profiles and password management

Course Duration:-9h 45m

Sections

General
0 activities

Introduction
Oracle Server‚ Instance and Database
SGA‚ Shared Pool‚ Library Cache
Redo Log Buffer‚ Large Pool and Java Pool
Program Global Area
Database Writer (DBWn)‚Log Writer (LGWR)System Monitor (SMON)
Checkpoint‚ Archiver
Processing SQL Statements
Checkpoint‚ Archiver and Logical Structure Summary
Getting Started with the Oracle Server
Database Administrator Users‚SQLPlus
Oracle Enterprise Manager and Console
Managing an Oracle Instance
SPFILE spfileSID.ora
Starting up database‚ Alter database
Shutting Down Database
Managing and Organizing a Database
Using Password File Authentication & Creating a Database
Create Database Using DCA And Manually
Creating a Database using OMF‚ Troubleshooting and After Database Creation
Creating a Database 01
Creating a Database 02
Data Dictionary
Dynamic Performance Tables
Practical Examples session 5
Maintaining the Control File
Maintaining the Control File Count
Practical Examples Session 6
Maintaining Redo Log Files
Dropping Online Redo Log Files
Managing Online Redo Log Files
Practical Examples Session 7
Types of Tablespaces
Locally Managed Tablespaces
Undo‚ Temporary and Read Only Tablespace
Default Temporary Tablespace
Tablespace offline‚ Storage Settings and Resizing Tablespace
Resizing‚ Dropping and Obtaining Tablespace information
Managing Tablespaces and Datafiles-Practical 01
Managing Tablespaces and Datafiles-Practical 02
Types of Segments
Storage Clause Precedence
Non Standard Block Size‚ Database Block Contents
Manual Data block Management and Practical Examples
Managing Undo Data
Types of Undo Segments
Automatic Undo Management Altering an UNDO Tablespace
Automatic Undo Management Sizing an UNDO Tablespace
Practical Example Session 10
Storing User Data
Oracle Built-in Data Types
ROWID Format‚Structure of a Row
Creating a Table
Truncating ‚ Dropping Table
Dropping a Table
Practical Example Session 11
Btree Index
Bitmap Indexes
Creating Btree and Bitmap Index
Changing Storage Parameters for Indexes
Changing Storage Parameters for Indexes Count
Practical Examples Session 12
Types of Constraints ‚ Constraints States
Types of Constraints ‚ Constraints States Count
Defining Constraints
Enabling Constraints
Practical Examples Session 13
Profiles and Password Management
Profiles and Password Management Count
Alter‚ Drop Profile
Resource Plan Directives
Practical Examples Session 14
Users and Security
Creating a New User Operating System Authentication
Practical Examples Session 15
Granting and Revoking System Privileges
Course Certificate
Secure Video
76
Certificate
1
Cost: 5000
Enroll Me

Tag

Course Duration:-9h 45m