************************
|
Oracle Database Training and Software Development in Ranchi
- Coaching for IGNOU BCA MCA BSc MSc in IT by experience teachers
- Project Level Software Training in C, C++, Data Structure, Operating Systems, Microprocessor, Oracle, SQL Server, .Net & Java
- University education for BCA, MCA, BSc & MSc in IT, MBA in Telecom, MBA in IT, Marketing & HR
Address :
Institute of Chartered Telecom Professionals - ICTP
Laxmi Complex, 1st Floor
Circular Road, Lalpur Chowk
Ranchi - 834001
E-mail : info@ictpi.org Website : www.ictpi.org
Phone Nos : 0651 - 6452032 / 09939131537
-------------------------------------------------------------------------------------------------
Oracle Database Administration Fundamentals I
Welcome
Welcome
Prerequisites for this Course
About this Course
Technet Database Administration Manuals
Database Administration
Oracle Database Administration? pt. 1
Oracle Database Administration? pt. 2
The Basic Architecture of Oracle
Oracle Database Administration Tools
What are the Tools?
SQL*Plus
SQL*Plus Worksheet
iSQL*Plus
All the Other Oracle Tools
Database Configuration Assistant pt. 1
Database Configuration Assistant pt. 2
Oracle Enterprise Manager Console pt. 1
Oracle Enterprise Manager Console pt. 2
The Management Server and the Agent
Net Configuration Assistant and Net Manager
Oracle Enterprise Manager Console pt. 3
Oracle Enterprise Manager Console pt. 4
The Architecture of Oracle
Oracle Database Architecture
Memory Structures
Processes
Datafiles/Tablespaces/Objects
Control Files/Logging/Archiving/Recovery
COMMIT vs ROLLBACK
Rollback and Undo
Temporary Sort Space
How it all Fits Together
Oracle Managed Files
Partitioning
Installing Oracle and Creating a Database
The Oracle Installer pt. 1
The Oracle Installer pt. 2
The Oracle Installer pt. 3
Configuration Parameter Files pt. 1
Configuration Parameter Files pt. 2
SQL*Net Configuration Files
Oracle Optimal Flexible Architecture
Windows Specifics pt. 1
Windows Specifics pt. 2
Creating a Database with a Script pt. 1
Creating a Database with a Script pt. 2
Starting Up and Shutting Down a Database
Connecting to a Database
STARTUP Command pt. 1
STARTUP Command pt. 2
SHUTDOWN Command pt. 1
SHUTDOWN Command pt. 2
Combining STARTUP and ALTER DATABASE
The Oracle Enterprise Manager Console
Configuration Parameters
What is the Parameter File?
Looking at Parameters
The Parameters and What They Do pt. 1
The Parameters and What They Do pt. 2
The Parameters and What They Do pt. 3
DDL and the Physical Database
DDL and the Physical Database?
The ALTER DATABASE Command
Looking at the Database
Changing Datafiles
Sizing of Datafiles
Datafiles and Tempfiles
Control Files
Logfiles and Archives pt. 1
Logfiles and Archives pt. 2
The ALTER SYSTEM Command pt. 1
The ALTER SYSTEM Command pt. 2
Automated Undo/Manual Rollback pt. 1
Automated Undo/Manual Rollback pt. 2
Metadata Views
DDL and the Logical Database
What is the Logical Database?
Tablespace Management pt. 1
Tablespace Management pt. 2
Tablespace Management pt. 3
Metadata Views
Expanding Database Objects
Tables pt. 1
Tables pt. 2
Tables pt. 3
Indexes pt. 1
Indexes pt. 2
Clusters
Index Organized Tables
Sequences
UNDROP, PURGE and the Recycle Bin
Partitioning
Metadata Views pt. 1
Metadata Views pt. 2
Expanding Security for Database Administration
Types of Users
Grants and Revokes
Create and Alter User Syntax
Administration Users
Database Auditing
Scheduling
The DBMS_JOB Package
Job Scheduling in Oracle
Scheduling/Executing Jobs in Windows and Unix
Utilities
Export
Import
SQL*Loader
ORAPWD and ORADIM
Built-In Packages
Supplied Packages
Scripting for Automation
Some Example Scripts
Credits
About the Author
-------------------------------------------------------------------------------------------------
|
|
|
