ORACLE DATABASE 10G: INTRODUCTION TO SQL
CSE 5282 |
| (Course 09/27/08 - 12/20/08) |
THIS COURSE INTRODUCES ORACLE DATABASE 10G TECHNOLOGY AND THE RELATIONAL DATABASE CONCEPTS AND THE POWERFUL SQL PROGRAMMING LANGUAGE. THIS COURSE PROV IDES THE LEARNERS WITH THE ESSENTIAL SQL SKILLS OF QUERYING THE DATABASE, THE META DATA, AND CREATING DATABASE OBJECTS. IN ADDITION, IT DELVES INTO ADVANCE D QUERYING AND REPORTING TECHNIQUES, DATA WAREHOUSING CONCEPTS, AND MANIPULATI ON OF LARGE DATA SETS IN DIFFERENT TIME ZONES.
|
|
ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP I
CSE 5283 |
| (Course 01/10/09 - 03/28/09) |
STUDENTS ARE OFFERED A CONCEPTUAL UNDERSTANDING OF THE ORACLE DATABASE ARCHITE CTURE AND HOW ITS COMPONENTS INTERACT WITH ONE ANOTHER. THEY ALSO WILL LEARN H OW TO CREATE AN OPERATIONAL DATABASE AND PROPERLY MANAGE THE VARIOUS STRUCTURE S IN AN EFFECTIVE AND EFFICIENT MANNER, INCLUDING PERFORMANCE MONITORING, DATA BASE SECURITY, USER MANAGEMENT, AND BACKUP/RECOVERY TECHNIQUES. THE TOPICS ARE REINFORCED WITH STRUCTURED HANDS-ON PRACTICE. THIS COURSSE IS DESIGNED TO PR EPARE PARTICIPANTS FOR THE CORRESPONDING ORACLE CERTIFIED ASSOCIATE EXAM.
|
|
ORACLE DATABASE 10G: ADMINISTRATION WORKSHOP II
CSE 5284 |
| (Course 04/18/09 - 07/18/09) |
LEARN HOW TO CONFIGURE AN ORACLE DATABASE FOR MULTILINGUAL APPLICATIONS. STUDE NTS WILL PRACTICE VARIOUS METHODS OF RECOVERING THE DATABASE USING RMAN, SQL, AND FLASHBACK TECHNOLOGY. TOOLS TO MONITOR DATABASE PERFORMANCE AND WHAT STEPS TO TAKE TO IMPROVE DATABASE PERFORMANCE ARE ALSO COVERED. STUDENTS WILL ALSO LEARN HOW TO USE VARIOUS DATABASE TECHNOLOGIES, SUCH AS RESOURCE MANAGER, THE SCHEDULER, AND AUTOMATIC STORAGE MANAGEMENT (ASM). TOPICS ARE REINFORCED WIT H STRUCTURED HANDS-ON PRACTICES AND A WORKSHOP. THIS COURSE IS DESIGNED TO PR EPARE PARTICIPANTS FOR THE CORRESPONDING ORACLE CERTIFIED PROFESSIONAL EXAM.
|
|
INTRODUCTION TO DATA MODELING AND PL/SQL
CSE 5220 |
| (Course 04/22/09 - 05/20/09) |
A CONTINUATION OF THE SUBJECT MATTER STARTED IN THE INTRODUCTION TO SQL COURSE . CREATE DATABASE LEVEL APPLICATIONS AND PL/SQL OBJECT CONSTRUCTS SUCH AS STO RED DATABASE PROCEDURES, FUNCTIONS, PACKAGES, AND DATABASE TRIGGERS. ENFORCE BUSINESS RULES WITHIN THE DATABASE AND PERFORM VALUE-BASED AUDITING. INCLUDES HANDS-ON EXPERIENCE. NOTE: THE BOOK FOR INTRO TO SQL WILL BE USED IN THIS C OURSE. PREREQUISITES: INTRODUCTION TO SQL AND RELATIONAL DATABASE DESIGN.
|
|
|