About ACT

Oracle Development and Administration

Module	Hrs	Prerequisites
MS3 - UNIX Introduction to UNIX
1. Introduction What is special about UNIX File Access Permissions 2. Login, Logout Customizing the Shell Changing Account Setup Identifying Login Shell Running Commands when you Log Out Automatic File Cleanup 3. Organizing Your Home Directory 4. Setting Up your Terminal Terminal Database Setting your Erase, Jill, and Interrupt Characters Finding what Terminal Names you can use Predefined Environment Variables What the Shell Does Shell Variables UNIX Command line and Aliases 5. Job Control Job Control and autowrite: Real Time Servers Notification when Job Change State 6. Working with Files Wildcards Finding Oldest or Newest Files Backing Up Files Managing Files, File Security, Ownership, and Sharing Removing Files Searching though Files, Comparing Files 7. Working with Processes Starting, Stopping, and Killing Process Delayed Execution 8. Printing on UNIX		Computer literacy and /or Aptitude Test
Total	40
OR1 - Oracle Development Module 1 - 30 hours Introduction to Oracle
1. Designing relational databases Why is Design SO Important? Data Modeling Denormalization Choosing Datatypes, Nulls, Keys, and Indexes Designing for Specific Architecture 1.SQL Types of SQL statements Working with database objects		Training/experience in IT application development in UNIX environment or EC Module 1 and Intro to UNIX (MS3)
Total	30
OR2 - Oracle Development Module 2 - 50 hours PL/SQL Basics
1. PL/SQL Language Fundamentals Designing the Code Modules Introduction to Code Design Determining Where to Locate the Processing Locking PL/SQL Character Set, Identifiers, Literals, Block Structure Formatting SQL Statement, Control Structure, PL/SQL Blocks, Packages 2. PL/SQL Language Elements Variables and Program Data Conditional and Sequential Control Database Interaction and Cursors Controlling implicit and explicit cursors Cursor Attributes and Parameters Cursor Variables Loops Exception Handlers Records in PL/SQL PL/SQL Tables 3. Built-In Functions Character Date Numeric, LOB, and Miscellaneous Conversion 4. Modular Code Procedures and Functions Packages Calling PL/SQL Functions in SQL 5. Developing event-driven code as triggers Trigger Types Implementing complex business rules Avoiding common trigger pitfalls		Training/experience with Oracle or Oracle Module1 (OR1)
Total	50
OR3 - Oracle Development Module 3-50 hours Advanced PL/SQL
1. Using Built-In Packages Introduction to Built-In Packages Application Development Packages: 1.Executing Dynamic SQL and PL/SQL 2.Intersession Communication 3.User Lock and Transaction Management 4.Oracle Advance Queuing 2. Object Types Introduction to Oracle8 Objects Syntax for Creating Object Types Manipulating Objects in PL/SQL Types Modifying Persistent Objects 3. Nested Tables and VARRAY's Types of Collections Using Collections Collection Pseudo-Functions and Built-Ins PL/SQL-to-Server Integration 4. Object Views Using Object Views Differences Between Object Views and Object Tables Object Views Housekeeping 5. External Procedures Steps in Creating External Procedures Mapping Parameters OCI Service Routines External Procedures Housekeeping 6. Oracle and XML Combining XML and Oracle Processing XML with PL/SQL Transforming XML with XSLT Generating Datagrams with PL/SQL Storing XML Datagrams Searching XML		Training/experience with Oracle or Oracle Module2 (OR2)
Total	60
DB2b - Database Module 2ORCL-50 hours Oracle Database Administration
1.Building an Oracle Database Creating the Database Starting and Stopping the database 2. Managing Users and Resources Creating users accounts Allocating space quotas Maintaining security 3. Controlling Disk Storage Logical and physical disk structure Allocating disk storage for database objects Partitioning to support Very Large Databases (VLDBs) 4. Backup and Recovery Safeguarding the database Selecting a backup strategy Performing recovery Automating backup and recovery 5. Troubleshooting the Oracle Database Diagnostics utilities Analyzing information in the log files 6. Fundamental Tuning Techniques Tuning memory structures Configuring disk usage Improving performance with Enterprise Manager toolset Diagnosing problems and tuning 7. Data Warehousing Using Oracle Databases Oracle datawarehouse architecture; Developing and populating the datawarehouse; Reporting, OLAP and data mining tools		Hands-on DBA experience administering relational databases; or Significant hands-on experience developing applications for Oracle or DB Module 1 or Oracle Module 3 (OR3)
Total Module 4	50