Oracle 10g Fundamentals
This course introduces Oracle Database 10g technology and the relational database concepts and the powerful SQL programming language and provides the learners with the essential SQL skills of querying the database. As for the PL/SQL course it introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages.
1. Oracle 10g: Java Programming
- Introducing the Java and Oracle Platforms
- Defining Object Oriented Principles
- Basic Java Syntax and Coding Conventions
- Exploring Primitive Data Types and Operators
- Controlling Program Flow
- Building Java Using Oracle JDeveloper
- Creating Classes and Objects
- Class Loading, Object Life Cycle and Inner Classes
- Using Strings, String Buffer, Wrapper and formatting Classes
- Reusing Code with Inheritance and Polymorphism
- Using Arrays and Collections
- Structuring Code Using Abstract Classes and Interfaces
- Throwing and Catching Exceptions
- User Interface Design: Planning a Form Layout
- Adding User Interface Components and Event Handling
- Accessing the Database with JDBC
- Deploying Applications Using Java Web Start
2. Oracle 10g: Build J2EE Applications
- J2EE Overview
- Architecting J2EE Applications
- Creating the web tier: Servlets
- Access the database with Servlets
- Utilizing additional Servlet techniques
- Maintaining state within J2EE Applications
- Creating the web tier: JavaServer Pages
- Modularizing JavaServer Pages Development with Tags
- Communication in J2EE
- Creating the business tier: Enterprise Java Beans
- Implementing business tasks with Session EJBs
- Managing persistent data in the business tier: Entity EJBs
- Achieving State Management in the Business Tier
- Specifying Relationships in CMP Entity beans
- Creating Message Driven Beans
- Integrating J2EE Components
- Distributing Modular Applications: Introduction to Web Services
- Distributing Modular Applications: Developing Web Services
- Implementing Security in J2EE Applications
3. Oracle JDeveloper 10g: Build Applications with ADF
- Application Development Framework
- The ADF Development Process
- Getting Started with ADF Business Components
- Building the Business Logic
- Exposing Business Data
- Adding Custom Validation
- Providing for Efficient Queries
- Making the Model Secure
- Controlling an Application with Struts
- Building ADF View Components
- Customizing Actions
- Using ADF Struts Components
- Adding Validation and Error Handling
- Enhancing the User Interface
- Adding JAAS Security to the Client
- Building ADF UIX View Components
- Deploying an ADF Application
Oracle Database 10g
1. Administration Workshop I
- Introduction
- Installing Oracle Database 10g Software
- Create an Oracle Database
- Database interfaces
- Controlling the database
- Storage Structures
- Administering users
- Managing Schema Objects
- Managing Data
- PL/SQL
- Oracle Database Security
- Oracle Net Services
- Oracle Shared Server
- Performance Monitoring
- Proactive Maintenance: Objectives
- Undo Management
- Monitoring and Resolving Lock Conflicts
- Backup and Recovery Concepts
- Database backups
- Database Recovery
2. Administration Workshop II
- Using Globalization Support
- Securing the Oracle Listener
- Configuring Recovery Manager
- Using Recovery Manager
- Diagnostic Sources
- Recovering from non-critical losses
- Database Recovery
- Flashback database
- Recovering from User Errors
- Dealing with Database Corruption
- Automatic Database Management
- Monitoring and Managing Storage
- Automatic Storage Management
- Monitoring and Managing Memory
- Managing Resources
- Automating Tasks with the Scheduler