|
|
Course Criteria
Add courses to your favorites to save, share, and find your best transfer school.
-
6.00 Credits
This course provides an introduction to the ORACLE database management system platform and to Structured Query Language (SQL) and ORACLE PL/SQL. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: SCT 100, CIS 105, CIS 106, Programming Language
-
6.00 Credits
This course enables the database student to be able to fine tune Oracle databases. Topics include: Oracle architectural components, Oracle administration tools, Oracle instances, creation of an Oracle database, construct Data Dictionary views, Maintain the control file, Maintain the Redo Log File, Manage table spaces and data files, Understand relationships and impacts on storage structures, Manage tables, indexes and segments, maintain data integrity, manage users, profiles, privileges, roles, understand and use database auditing options, using National Language Support (NLS). Topics include: understand Oracle architectural components, understand and use Oracle administration tools, manage Oracle instances, be able to create an Oracle database, construct Data Dictionary views, maintain the control file, maintain the Redo Log File, manage table spaces and data files, understand relationships and impacts on storage structures, manage tables, indexes and segments, maintain data integrity, manage users, profiles, privileges, roles, understand and use database auditing options, using National Language Support (NLS), and establish competencies for Oracle Database Administration Exam. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: CIS 105, CIS 106, CIS 214, and SCT 100
-
6.00 Credits
This course introduces participants to the critical task of planning and implementing database backup and recovery strategies. The class addresses backup and recovery techniques and examines various backup, failure, restore and recovery scenarios. Generic backup, restore and recovery operations. Through hands-on exercises, participants will examine backup methodologies based on business requirements in a mission critical enterprise. Participants wil utilize multiple strategies and Oracle tools such as Recovery Manager to perform backups, and restore and recovery operations. Topics include: understand needs for backup and recovery, be able to understand and implement essential elements of a disaster recovery plan, understand Oracle recovery structures, understand and be able to implement Oracle Backup and Recovery operations, understand database recovery modes, be able to know when to utilize RMAN, be able to register, resync and reset an Oracle database, understand and be able to implement database backup procedures, troubleshooting database failures, understand and be able to use Oracle import and export utilities, and establish competencies for ORACLE Backup and Recovery Exam. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: CIS 2129, Architecture and Administration Page 215
-
6.00 Credits
This course enables the database student to be able to fine tune ORACLE databases. Topics include: Tuning overview, Oracle Alert and Trace Files, Utilities and Dynamic Performance Views, Tuning the Shared Pool, Tuning the Buffer Cache, Tuning the Redo Log Buffer, Database Configuration and I/O Issues, Using Oracle Blocks Efficiently, Optimizing Sort Operations, Tuning Rollback Segments, Monitoring and Detecting Lock Contention, SQL Issues and Tuning Considerations for different applications, Managing a Mixed Workload, Tuning with oracle Expert, Multithreaded Server Tuning Issues. This course enables participant to be able to fine tune ORACLE databases. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: CIS 2130
-
4.00 Credits
Oracle Network Administration covers the tools and techniques used when configuring an Oracle8i Database Management System in a network environment. Upon completion of this course, the students will have the skills necessary to configure and troubleshoot network connections to the Oracle8i database. Hours: Class/Week 4 D.Lab/Week 4 Credit 6 Prerequisite: CIS 2130 Database Performance Tuning
-
4.00 Credits
Provides an overview of the skills and knowledge of database application systems which are used in business, government, and industry. Topics include: models, structures, physical database, logical database, and accessing techniques. Hours: Class/Week 4 D.Lab/Week 4 Credit 6 Prerequisite: Advanced language which requires random file accessing Techniques
-
4.00 Credits
Provides the ability to implement, administrator, and troubleshoot Windows Professional as a desktop operating system in any network environment. Hours: Class/Week 4 D.Lab/Week 4 Credit 6 Prerequisite: CIS XXXX, an operating system course and CIS 1140 or Advisor Approval
-
6.00 Credits
Reinforces and extends the concepts and applications provided in COBOL II. Topics include: random file processing, advanced table processing, and advanced sorting. Hours: Class/Week 4 D.Lab/Week 6 Credit 7 Prerequisite: CIS 114
-
4.00 Credits
Provides the ability to implement, administrator, and troubleshoot Windows 2000 Server as a member server of a domain in an Active Directory. Hours: Class/Week 4 D.Lab/Week 4 Credit 6 Prerequisite: CIS 2149
-
4.00 Credits
Provides students with knowledge and skil s necessary for new-to-product support professionals who wil be responsible for instal ing, configuring, managing, and supporting a network infrastructure that uses the Microsoft Windows server family of products. Hours: Class/Week 4 D.Lab/Week 4 Credit 6 Prerequisite: CIS 2150 or CIS 2152
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|