This program focuses on database administration, backup recovery, networking, and performance tuning. Included are theory and hands-on practice using the Oracle database engine, Oracle server, Oracle NET, Oracle Enterprise Manager, and tuning tools.
14.0 Continuing Education Units (CEUs) will be provided upon request as a permanent record of one's attendance, if requested by the last class meeting.
Course fees include textbooks, notes, materials, and lab fees.
CSULB's University College and Extension Services is now part of the Oracle Academic Initiative (OAI). Our program courses qualify for Oracle's Certification requirement of "exam candidates must complete at least one course from an OAI school." You will receive one 40% discount voucher good on any OCP certification exam after you complete each course in our program.
This hands-on module provides you with comprehensive information on Oracle database architecture and practical experiences in Oracle 11g server installation and administration. It also prepares you for the Certified Database Associate Exam IZ0-052 (Administration I).
· Oracle 11g installation and configuration
· Installing the Oracle grid infrastructure
· Preparing the database environment
· Creating and administering an Oracle database
· Configuring and managing an Oracle network
· Managing users / schema objects and data
· Implementing Oracle security features
· Monitoring performance and data concurrency
· Performing basic backup and recovery of a database
This hands-on module provides you with comprehensive information and hands-on experiences on RMAN backup and recovery, disaster recovery and performance tuning. It also prepares you for the Certified Database Professional (OCP) Exam IZ0-053 (Administration II).
· Implementing and configuring recovery manager (RMAN)
· Backup and recovery databases with RMAN
· Advanced topics with RMAN: duplicate databases and point in time recovery
· Understanding and using flashback technology
· Using scheduler to automate tasks
· Monitoring and managing storage
· Diagnosing database and tuning performance
· Working with globalization support
This hands-on module provides students with comprehensive skills for SQL language as well as introduction to PL/SQL. You will learn to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data. You will also learn the concepts of relational and object database model. It also prepares you for the Certified Database Associate Exam IZ0-051 (SQL Fundamentals 1).
· Building basic as well as extensive SQL statements
· Using Oracle supplied SQL functions
· Using SQL with joins and sub-queries in multi-table environment
· Using SQL99 join syntax and techniques
· Using set operators
· Maintaining data integrity with constraints
· Formatting SQL*Plus reports
· Retrieve, insert, update, and delete data
· Controlling user access
· Managing schema objects
This hands-on module provides students with an extensive knowledge and development skill in PL/SQL language. You will learn to develop, debug, execute and manage anonymous PL/SQL blocks as well as stored program units like procedures, functions, packages and database triggers. It also prepares you for the Certified Exam IZ0-147 (Program with PL/SQL).
· Writing, debugging and compiling stored procedures, functions, and packages for efficiency
· Writing and using database triggers to resolve business challenges
· Scheduling PL/SQL jobs
· Working with Oracle-supplied packages
· Working with programming unit dependencies
· Writing dynamic SQL for code flexibility
· Performance tuning on PL/SQL
