Database Management Program
Computer Oracle Database SQL Expert /Certification Prep Program Description
IITA Mission: Our mission as project managers is to achieve all outlined project goals and objectives while working within the project constraints to optimize the allocation and integration of inputs necessary to meet these goals. We carry out all these with the outmost sense of professionalism, personal/corporate integrity, honesty and commitment to seeing through whatever we start or become part of.
We are a reflection of the ever changing global business environment that has become more challenging than ever. We have adopted modern methodologies and business practice formats and these placed us ahead of others and we constantly design quality improvements in all projects we undertake.
Objectives of This Course
This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available and provide Oracle Database Administration Training which will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA),configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.
IITA Advantage
This course considers subjects applicable to certification as an Oracle Database Certified SQL Expert. The topics considered are included within "Exam 1Z0-047: Oracle Database: SQL Certified Expert". One must also complete the companion volume ORACLE DATABASE 11G: SQL FUNDAMENTALS II and the course ORACLE DATABASE
11G: NEW & ADVANCED FEATURES FOR DEVELOPERS to prepare for this certification.
Audience and Participants:
- Business users and non-technical end users
- Application designers and developers
- Non Database administrators
- System Administrators, Business users and non-technical senior end users
Course Content
(SQL)
- RELATIONAL DATABASES & SQL
- CHOOSING A SQL & PL/SQL INTERFACE
- BUILDING A SELECT STATEMENT
- RESTRICTING DATA WITH THE WHERE CLAUSE
- SORTING DATA WITH THE ORDER BY CLAUSE
- PSEUDO COLUMNS & FUNCTIONS
- JOINING TABLES
- USING THE SET OPERATORS
- SUMMARY FUNCTIONS
- USING SUB-QUERIES
- AGGREGATING DATA WITHIN GROUPS
- BUILD SIMPLE SQL*PLUS REPORTS
- USE DATA DEFINITION LANGUAGE TO CREATE & MANAGE TABLES
- USE DATA MANIPULATION LANGUAGE TO MANIPULATE DATA
- SQL99 JOIN TECHNIQUES
- ENHANCING GROUPS WITH ROLLUP & CUBE
- SQL FUNCTIONS: CHARACTER
- SQL FUNCTIONS: NUMERIC
- SQL FUNCTIONS: DATE
- DATABASE OBJECTS: RELATIONAL VIEWS
- DATABASE OBJECTS: DATA DICTIONARY STORAGE
- DATABASE OBJECTS: INDEXES
- DATABASE OBJECTS: OTHER OBJECTS
- DATABASE OBJECTS: SECURITY
- DATA INTEGRITY USING CONSTRAINTS
- MANAGING CONSTRAINT DEFINITIONS
- ADVANCED SQL*PLUS REPORTS
- OPTIONAL - ADVANCED SQL*PLUS REPORTS
(Oracle Database Administration)
- Overview of Oracle Database
- Starting and Shutting Down an Oracle Database
- Using The Oracle Data Dictionary
- Oracle Database Users and Schemas
- Oracle System Privileges
- Parameter Files
- Datafiles and Tablespaces
- Control Files
- Oracle Physical Structures — Online Redo Logs
- Oracle Physical Structures — Undo Segments
- Segment Space Management
- Tables
- Indexes
- Constraints
- Views .
- Object Privileges
- Synonyms
- The Optimizer and Statistics
- Oracle Net Services
- Data Pump
- SQL*Loader and External Tables
- Back Up Your Database
- Recover Your Database
- Oracle Enterprise Manager
- Appendix A – Installing Oracle Software
- Appendix B – Creating a Database Using the DBCA
- Appendix C – Manual Database Creation
- Manual Database Creation
- Prepare the System
- Creating the Parameter File
Course Details
- Format: Classroom Setting and/or Online Classroom accessible via wiziq.com
- Prerequisites: Basic Computer knowledge
**Our Oracle Prep course is taught by veteran Oracle Exam Prep instructor (s) and graduates. Apart from the textbooks, every student is kitted with various and relevant materials to enhance his success at first attempt.