Have you unlocked your potential?
Satisfaction Guaranteed.
Here at LearnLocker, we are committed to providing the best possible experience we can. If at any time you are not completely satisfied, we invite you to contact us with your comments and feedback. In addition, you have the right to cancel your membership at anytime. You can even cancel online through our website. Our cancellation policy and terms are covered in detail in the terms and conditions found in the LearnLocker Subscription Membership Agreement.

Oracle 10g for the Small Business

Instructor: George J. Trujillo Jr.
George has specialized in Oracle technologies such as RAC, Data Guard, Streams, JDeveloper, Oracle Application Server, RMAN, Forms and Reports for many years. George has written advanced Oracle and Java certification tests and is a major presenter at numerous International Oracle and Java Users Group conferences. In addition to his 20+ years of technical experience, George has delivered internationally over 250 technical training courses and seminars. George is the President and CEO of Trubix Inc., a company specializing in delivering leading edge technical training, consulting and courseware in Oracle10g, Linux, Internet strategies, Application Servers, XML, Java, .Net and Web services.
Course Outlines
Level 1
1.0 Oracle 10g Products
1.1 Core/Database and Standard Editions
2.0 Management of Oracle Databases
2.1 Managing Oracle Databases
2.2 Manual Management
2.3 Third Party Software
2.4 OEM Central Console
3.0 Key Installation Tools
3.1 Database Configuration Assistant
3.2 SQL Plus
3.3 Oracle Universal Installer
4.0 Installing Oracle
4.1 Creation of an Oracle Database
4.2 Validating the Installation
4.3 Finishing the Installation
4.4 Testing the Installation with OEM
4.5 Starting OEM by Ourselves
4.6 Testing the Installation With SQL Plus
4.7 Testing the Installation With
4.8 Launching the Database Manually
Level 2
1.0 Understanding the Database in OEM
1.1 Accessing Information
2.0 OEM Database Control Pages
2.1 OEM Home Page
2.2 OEM Performance Page
2.3 OEM Administration Page
2.4 OEM Maintenance Page
2.5 Environmental Variables
3.0 Components of Oracle
3.1 Main Components
4.0 Main Components Database
4.1 Main Components
5.0 Logical Storage Structures
5.1 Segments/Extents and Blocks
5.2 Tablespaces
5.3 Schemas
6.0 Sessions
6.1 Dedicated vs. Shared
6.2 Languages and Tools
Level 3
1.0 Simplified Management
1.1 Basic vs. Advanced
2.0 Automatic Memory Management(AMM)
2.1 AMM Parameters
3.0 Advisories and Statistics
3.1 Statistics
4.0 Automatic Workload Repository
4.1 Working Repository
5.0 Baselines
5.1 Baselines
6.0 ADDM
6.1 ADDM
7.0 Data Dictionary
7.1 Data Dictionary Views
8.0 Initialization Parameters
8.1 Parameter Dictionary Views
9.0 Using the SPFILE
9.1 The SPFILE
9.2 Backing UP the SPFILE
9.3 Creating an SPFILE
9.4 The SCOPE Clause
10.0 Starting an Oracle Server
10.1 Startup Process
10.2 Startup Commands
10.3 Alter Database Commands
10.4 Shutting Down a Database
11.0 Alert Logs and Trace Files
11.1 Alert Logs
Level 4
1.0 Different Tablespaces
1.1 Types of Tablespaces
2.0 System Tablespaces
2.1 System Tablespaces
3.0 Locally Managed Tablespaces
3.1 Extent Management
4.0 Altering Tablespaces
4.1 Adding a Datafile
4.2 Modifying Tablespaces
5.0 Automatic Segment Space
5.1 Automatic Segment Space Management
6.0 Managing Tablespaces
6.1 Read-only Tablespaces
6.2 Renaming Tablespaces
6.3 Dropping a Tablespace
7.0 Multiple Block Sizes
7.1 Standard Block Size
7.2 Non-standard Block Sizes
7.3 Tablespace Block Size Options
8.0 Before Image Data
8.1 Read Consistency
8.2 Before and After Image Blocks
9.0 Undo Tablespaces
9.1 Purposes of Undo Tablespaces
9.2 Setting Up Undo Management
9.3 Retention Guarantee
9.4 Defining Undo Tablespaces
10.0 Temporary Tablespaces
10.1 Using Temporary Tablespaces
10.2 Temporary Tablespace Groups
10.3 Managing Temporary Tablespace
10.4 Setting Tablespace Defaults
Level 5
1.0 Control File Information
1.1 Control File Contents
1.2 Creating Control Files
2.0 Understanding Redo Log Files
2.1 Writing to Redo Log Files
2.2 Redo Log Files
3.0 Instance Recovery
3.1 Log Sequence Numbers
3.2 Checkpoints
3.3 Instance Recovery
4.0 Archiving
4.1 Archive Log Mode
4.2 Log Parameters
4.3 The Archiving Process
Level 6
1.0 Creating Users
1.1 Creating Users
1.2 The System Tablespace
1.3 Working With Quotas
1.4 Modifying Users
2.0 Profiles
2.1 Working With Profiles
2.2 Using Password Management
2.3 Modifying Profiles
3.0 Privileges
3.1 Security Guidelines
3.2 Assigning System Privileges
3.3 Granting Object Privileges
3.4 More on Privileges
4.0 Roles
4.1 Role Based Security
4.2 Working With Roles
4.3 Default Roles
4.4 Enhanced Role Security
4.5 More on Roles
Reset Password
Sign In:


You will be sent a link to the Reset Password page. Please note that the link may only be used today.