Display Density
Note! Payment is due at time of registration.

Oracle

XCDO 1000 - Oracle Database 11g Administrator I

Receive instruction using a real-world approach, combined with topics ranging from initialization parameters and table space storage to data integrity, constraints, and user profiles. Prep for the updated Oracle certification exam, #1Z0-052. This class can also be taken as part of the Oracle Database 11g Administrator Certified Associate Series. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Oracle Database 11g SQL Fundamentals or comparable knowledge.

CEU Hours: 2.8

Contact Hours: 28

Course Outline:

1.	Introduction to Oracle Server Technologies
2.	Exploring the Database Architecture
3.	Preparing the Database Environment
4.	Creating an Oracle Database
5.	Managing an Oracle Instance
6.	Configuring the Oracle Network Environment
7.	Managing Database Storage Structures
8.	Administering User Security
9.	Managing Schema Objects
10.	Managing Data and Concurrency
11.	Managing Undo Data
12.	Implementing Database Security
13.	Database Maintenance
14.	Performance Management
15.	Backup and Recovery Concepts
16.	Performing Database Backups and Recovery
17.	Moving Data
18.	Intelligent Infrastructure Enhancements
 
CRN Days Time Date Location Instructor Seats Open
53334 003 MTW---- 06:00-09:29 PM 09/22/14-10/01/14 RC 252 Ries W 7 of 10
MT----- 06:00-09:29 PM 10/06/14-10/07/14 RC 252    

XCDO 1001 - Oracle Database 11g Administrator II

Receive real-world instruction on the use of key tools and techniques for Oracle database backup, recovery and network administration. Prep for the updated Oracle certification exam, #1Z0-053. This class can also be taken as part of the Oracle Database 11g Administrator Certified Professional Series. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Oracle Database 11g Administrator Certified Associate Certification or comparable knowledge.

CEU Hours: 2.8

Contact Hours: 28

Course Outline:

1.	Database Architecture and ASM
2.	Configuring Database Recoverability
3.	Creating and Maintaining an RMAN Catalog
4.	Creating RMAN Backups
5.	Recovering Using RMAN Backups
6.	User Managed Backup and Recovery
7.	Miscellaneous RMAN Features
8.	Monitoring and Tuning RMAN
9.	Configuring and Using Flashback
10.	Memory Management Techniques
11.	Database Tuning Advisors
12.	Disk Space and Resource Management
13.	Configuring Database Diagnostics
14.	Using the Scheduler
15.	Database Globalization
 
CRN Days Time Date Location Instructor Seats Open
53335 003 MTW---- 06:00-09:29 PM 10/20/14-10/29/14 RC 252 Ries W 8 of 10
MT----- 06:00-09:29 PM 11/03/14-11/04/14 RC 252    

XCDO 1002 - Oracle 11g Performance Tuning

Get the most out of your Oracle Database 11g by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 11g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops. This class can also be taken as part of the Oracle Database 11g Administrator Certified Professional Series. For details visit our web page.E-book included in course fee and is distributed by the first course meeting via email. Prerequisite: Oracle Database 11g Administrator Certified Associate Certification or comparable knowledge.

CEU Hours: 3

Contact Hours: 30

Course Outline:

1.	Performance Tuning Overview
2.	Statistics and Wait Events
3.	Metrics, Alerts, and Baselines
4.	Using Statspack
5.	Using Automatic Workload Repository
6.	Reactive Tuning
7.	Tuning the Shared Pool
8.	Tuning the Buffer Cache
9.	Automatic Shared Memory Management
10.	Checkpoint and Redo Tuning
11.	Tuning I/O
12.	Tuning PGA and Temporary Space
13.	Tuning Block Space Usage
 
CRN Days Time Date Location Instructor Seats Open
53336 003 MTW---- 06:30-09:29 PM 11/17/14-11/19/14 RC 252 Ries W 9 of 10
MT----- 06:30-09:29 PM 11/24/14-11/25/14 RC 252    
MTW---- 06:30-09:29 PM 12/01/14-12/03/14 RC 252    
MT----- 06:30-09:29 PM 12/08/14-12/09/14 RC 252    

XCDO 1005 - Oracle Database 11g SQL Fundamentals

The Oracle Database 11g SQL Fundamentals class explores the complete set of skills required for working with the powerful SQL programming language and mastering the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects. Maps to exam 1Z0-051. This class can also be taken as part of the Oracle Database 11g Administrator Certified Associate Series. For details visit our web page.Class textbook included in course fee. Textbooks distributed in first course meeting. Prerequisite: Comfortable with Windows and database functions and concepts.

CEU Hours: 2.8

Contact Hours: 28

Course Outline:

1.	Oracle Server Technologies and the Relational Paradigm
2.	Data Retrieval Using SQL SELECT Statement
3.	Restricting and Sorting Data
4.	Single-Row Functions
5.	Using Conversion Functions and Conditional Expressions
6.	Reporting Aggregated Data Using Group Functions
7.	Displaying Data from Multiple Tables
8.	Using Subqueries to Solve Problems
9.	Using the Set Operators
10.	Manipulating Data
11.	Using DDL Statements to Create and Manage Tables
12.	Creating Other Schema Objects
13.	PL/SQL Overview
14.	PL/SQL Language
15.	PL/SQL Control Structures
16.	 PL/SQL Error Management
17.	PL/SQL Programming
 
CRN Days Time Date Location Instructor Seats Open
53337 003 MTW---- 06:00-09:29 PM 08/25/14-08/27/14 RC 252 Ries W 4 of 10
-TW---- 06:00-09:29 PM 09/02/14-09/03/14 RC 252    
MTW---- 06:00-09:29 PM 09/08/14-09/10/14 RC 252    
Clinic Courses (CLI) provide practical application and are offered on or off campus. Instructors supervise/direct student in a simulated or on-site setting.
Face-to-Face Courses (F2F) take place in a classroom. Based on JCCC's Statement of General Education. Students in all classes, including face-to-face classes, are expected to use technology appropriate to the course content and as needed to access web-based course materials. Face-to-face classes typically require access to computer equipment (either at home or in college labs provided for student use) and computing skills utilizing standard office, business and web browsing applications.
Hybrid Courses (HYB) combine face-to-face classroom instruction and the convenience of online web-based learning, resulting in a reduction of the amount of time spent in the face-to-face classroom and a significant increase of time spent studying online materials. Students registered in hybrid courses must attend class meetings as listed in the JCCC Schedule of Classes.
Internships (INT) provide experience to students for on-the-job training with cooperating businesses, agencies, and organizations. The number of hours for each internship varies.
Lab Courses (LAB) are face-to-face classes where students perform tasks as directed by faculty. Faculty members monitor the activity and provide individual and/or group instruction/assistance
Media Courses (MED) deliver all or a portion of instruction through either cable broadcast or pre-recorded video lessons. The videos are available in DVD format from the Billington Library.
Online Courses (ONLNE) use the Internet and a Learning Management System (D2L) to deliver course materials and to facilitate student-instructor, student-content, and student to student interaction. To participate in online courses, the student should have a good understanding of computer hardware and software applications and the Internet.
Continuing Education Online Courses (CEONL) and materials are delivered via the Internet. To participate in online courses, the student should have a good understanding of computer applications and Internet navigation. For more information about this course and other online learning options visit CE Online.
Private (PLV) lessons for credit are available from beginning to advanced in voice, piano, guitar, brass, woodwind and percussion. Lessons are scheduled by arrangement with private music instructors.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Self-Paced Courses (SEL) and Self-Paced Online (SPO) are offered on a schedule of study that allows students more flexible scheduling options. Course interaction is based upon a contract between student - instructor and in some cases can take up to one calendar year to complete. Some courses may use online delivery to facilitate the learning experience.
Travel Courses (TRV) may require in-class activities as well as traveling to a destination. Students will be responsible for the cost of the travel as well as the course costs.
Seats Open is an approximation of the number of seats available and may not represent the actual number of seats open at the time of registration.