Course details
Through hands-on experience in administering an oracle 9i Database you can understand the Oracle Server architecture, expand the size of the database, implement security, and know why and how specific database administration tasks are performed.
- Knowledge of SQL
- Introduction to Oracle 9i SQL and SQL *Plus course or equivalent experience
- Introduction to oracle 9i PL/SQL course or equivalent experience is highly recommended.
- Oracle RDBMS Components
- DBA Responsibilities
- Introduction to Datatypes and Tables
- Integrity Constraints
- Temporary tables, partitioned tables (range, hash, list), external tables, IOTs
- Indexes and Skip Scanning
- Online reorganisation
- Database workspace management
- DDL Commands used
- Views, Materialised views
- Sequences, Synonyms, Database Links
- Outlines, Dimensions, Hierarchies
- PL/SQL Program Units
- Supplied Packages
- Oracle Data Dictionary
- Storage of Large Objects (BFILEs, BLOBs, CLOBs)
- What Tool to Use?
- Connecting as a Privileged User
- Password file authentication
- Starting and Shutting Down a Database
- Reading the Alert Log / Trace Files
- Quiescing the database
- SPFILE / Parameter management
- Basic Definitions
- Blocks & Extents
- Fragmentation / Deallocation
- How Space is Logically Consumed - Segments:
- Introduction to Segments
- Managing Undo Segments
- Automatic Undo Management
- Managing sort activity, and Data and Index Segments
- Monitoring database segments
- Tablespace Overview
- System Tablespace
- Types of Tablespaces
- Creating additional tablespaces
- Altering tablespaces
- Temporary Tablespaces
- Tablespace Quotas
- Monitoring Tablespaces
- Architecture Overview
- Database and Process structures
- Memory structures - SGA, PGA
- Alternative configurations
- Basic Structures of an Oracle RDBMS
- Data Files, Redo Log Files
- Archived Redo Log Files
- Control Files, Oracle-Managed Files (OMF)
- Managing Database Users
- System and Object Privilages
- Managing Roles, Profiles and Passwords
- Resource Manager
- The Virtual Private Database
- OEM Configuration and Console
- Oracle Management Server Configuration, and Other OEM Console Tools
- Apache Server
- ORADIM
- Universal Installer
- Benefits of OFA
- Planning a database
- Creating a Database
- The CREATE DATABASE Command
- Using the Database Configuration Assistant
- Types of Auditing
- Establishing an audit trail repository
- Auditing options, Audit results
- DBMS_DDL
- DBMS_JOB
- DBMS_PCLXUTIL
- DBMS_RESOURCE_MANAGER
- DBMS_ROWID
- DBMS_SESSION
- DBMS_SHARED_POOL
- DBMS_SPACE
- DBMS_SPACE_ADMIN
- DBMS_TTS
- DBMS_UTILITY
- Character sets supported
- Choosing a character set
- Multi-byte character sets
- National Language Support (NLS)
- Defining time zones
Course Location
About Professional Training Solutions Ltd
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Meeting Management Diploma Lead AcademyEUR 23
EUR 364Duration: Upto 1 Hour - Oracle Forms (Video-Based) UplatzEUR 12Duration: Upto 10 Hours