Database Admin. Course outline

To get certified in Database Administrator you have to take 9 core exam. For your convenience each module outline is listed below. This outline focus which class you need to take to get certified and what curriculum and skill level you will learn during the session. This page describes each class, duration, credit units, skill sets, prerequisites for the class.

Database Admin. Nine Core Exam

1.

Module #:

MOUS - 101

Module Name:

Microsoft Office Word 2003 Expert

Duration:

24 hrs. (3 Weeks)

Credit Unit:

1 Units

Skill Sets:

Create custom styles for text, tables and lists, Control pagination, Format, position and resize graphics using advanced layout features, Insert and modify objects, Create and modify diagrams and charts using data from other sources, Sort content in lists and tables, Perform calculations in tables, Modify table formats, Summarize document content using automated tools, Use automated tools for document navigation Merge letters with other data sources, Merge labels with other data sources, Structure documents using XML, Create and modify forms Create and modify document background, Create and modify document indexes and tables, Insert and modify endnotes, footnotes, captions, and cross-references Create and manage master documents and subdocuments, Modify track changes options, Publish and edit Web documents Manage document versions, Protect and restrict forms and documents, Attach digital signatures to documents Customize document properties, Create, edit, and run macros, Customize menus and toolbars, Modify Word default settings

Prerequisites:

Before attending this course, students must have: Basic knowledge about computer and operating system.

2.

Module #:

MOUS - 102

Module Name:

Microsoft Office Excel 2003 Expert

Duration:

24 hrs.(3 Weeks)

Credit Unit:

1 Units

Skill Sets:

Use subtotals, Define and apply advanced filters, Group and outline data, Use data validation, Create and modify list ranges, Add, show, close, edit, merge and summarize scenarios, Perform data analysis using automated tools, Create PivotTable and PivotChart reports, Use Lookup and Reference functions, Use Database functions, Trace formula precedents, dependents and errors, Locate invalid data and formulas, Watch and evaluate formulas, Define, modify and use named ranges, Structure workbooks using XML, Create and modify custom data formats, Use conditional formatting, Format and resize graphics, Format charts and diagrams, Protect cells, worksheets, and workbooks, Apply workbook security settings, Share workbooks, Merge workbooks, Track, accept, and reject changes to workbooks, Import data to Excel, Export data from Excel, Publish and edit Web worksheets and workbooks, Create and edit templates, Consolidate data, Define and modify workbook properties, Customize toolbars and menus, Create, edit, and run macros, Modify Excel default settings

Prerequisites:

Before attending this course, students must have: Basic knowledge about computer and operating system.

3.

Module #:

MOUS - 103

Module Name:

Microsoft Office PowerPoint 2003

Duration:

24 hrs.(3 Weeks)

Credit Unit:

1 Units

Skill Sets:

Create new presentations from templates, Insert and edit text-based content, Insert tables, charts and diagrams, Insert pictures, shapes and graphics, Insert objects, Format text-based content, Format pictures, shapes and graphics, Format slides, Apply animation schemes, Apply slide transitions, Customize slide templates, Work with masters, Track, accept and reject changes in a presentation, Add, edit and delete comments in a presentation, Compare and merge presentations, Organize a presentation, Set up slide shows for delivery, Rehearse timing, Deliver presentations, Prepare presentations for remote delivery, Save and publish presentations, Print slides, outlines, handouts, and speaker notes, Export a presentation to another Microsoft Office program

Prerequisites:

Before attending this course, students must have: Basic knowledge about computer and operating system.

4.

Module #:

MOUS - 104

Module Name:

Microsoft Office Access 2003

Duration:

24 hrs.(3 Weeks)

Credit Unit:

1 Units

Skill Sets:

Create Access databases, Create and modify tables, Define and modify field types, Modify field properties, Create and modify one-to-many relationships, Enforce referential integrity, Create and modify queries, Create forms, Add and modify form controls and properties, Create reports, Add and modify report control properties, Create a data access page, Enter, edit and delete records, Find and move among records, Import data to Access, Create and modify calculated fields and aggregate functions, Modify form layout, Modify report layout and page setup, Format datasheets, Sort records, Filter records, Identify object dependencies, View objects and object data in other views, Print database objects and data, Export data from Access, Back up a database, Compact and repair databases

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements) and operating system.

5.

Module #:

MOUS - 105

Module Name:

Microsoft Office Outlook 2003

Duration:

24 hrs.(3 Weeks)

Credit Unit:

1 Units

Skill Sets:

Organizing, Attach files to items, Create and modify a personal signature for messages, Modify e-mail message settings and delivery options, Create and edit contacts, Accept, decline, and delegate tasks, Create and modify appointments, meetings, and events, Update, cancel, and respond to meeting requests, Customize Calendar settings, Create, modify, and assign tasks, Create and modify distribution lists, Link contacts to other items, Create and modify notes, Organize items, Organize items using folders, Search for items, Save items in different file formats, Assign items to categories, Preview and print items

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of basic internet fundamental and operating system.

6.

Module #:

OCP - 801

Module Name:

Oracle 8i Foundation - Data Modeling and Design, SQL Statement

Duration:

40 hrs.(5 Weeks)

Credit Unit:

2 Units

Skill Sets:

General Concept of Database Management System. How to Design Database. Concept covers all aspect of Relation Database Management System. Advantage and Disadvantage in System. Also, Provides basics knowledge of Structure Query Language.

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of database management system and operating system.

7.

Module #:

OCP - 802

Module Name:

Oracle 8i Foundation - Advance SQL, PL/SQL and Form & Report

Duration:

40 hrs.(5 Weeks)

Credit Unit:

2 Units

Skill Sets:

Advance SQL. Section deals with Advanced SQL and it Languages. Specific modules designed for Programmer how having a basic knowledge of Basic SQL and Database Modeling. This course helps Programmer to handle Database and its Object. Also he/she can write Query on Database. Continue with this course, dealing with Basic knowledge PL SQL. This course helps to write basic program into Oracle. This course introduces basic terminology and concept of Programming. Main tasks what data type available into Oracle and How you can interact with Database in Oracle with PL SQL. And finally, in design, course introduces Oracle Developer Tools comes with Oracle. Main feature of module is to write GUI Application and Interact with Database using GUI Application. This will helps to create Forms, Connecting Database with Forms, and Navigating Object through form, Property Sheet of form, Calling stored procedure and adding trigger in form.

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of database management system, programming fundamental and operating system.

8.

Module #:

OCP - 803

Module Name:

Oracle 8i DBA: SQL & PL/SQL, Performance Turning (1Z0-001 & 1Z0-024)

Duration:

40 hrs.(5 Weeks)

Credit Unit:

2 Units

Skill Sets:

Advance step into PL/SQL. This program introduces composite Data Types, Exception Handling. It is important in any programming language to work with complex data structure and handling error. In this you are working with different records type, Collections, Exception and Error, Customizing Exception. Continues on with Database it's important to tune database for fast I/O performance, Reducing size of database, and Distributing data for simultaneous accessing. A focus is Tuning Concept, Application Tuning, Buffer Tuning, Resource Management, and Optimizing Database.

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of relation database management system, programming fundamental and operating system.

9.

Module #:

OCP - 804

Module Name:

Oracle 8i DBA - Network Administration, Architecture and Administration, and Backup & Recovery (1Z0-026, 1Z0-023 and 1Z0-025)

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Design of the Network Administration in Oracle 8i. This session deals with Network Design, Configuration, Stack Architecture, Connection, Listener, Net8 assistant, OSI Model, Security feature, Names Server, MTS Dispatchers. It also introduced next version of Oracle and basic PL SQL programming. This course focuses on main era of Oracle. It helps to installation and Management of Oracle Database, and its Object. This covers architecture and Administrative task involved into Oracle. Its helps to understand logical and physical structure of database, How you can manage Tables, Indexes and constraints on tables? Its also cover different Data Utilities to Load Data, Direct-Load, SQL*Loader, NLS. Finally, It also provides hand-on on the Backup and Recovery of Database in Oracle, its objects to protection against system failure. This covers available terms for backup and recovery. It deals with different topic of Backup Strategy and Recovery point. It introduces with different tools and strategy for backing up database And Restoring them after failure

Prerequisites:

Before attending this course, students must have: Basic computer knowledge, Knowledge of relation database management system, programming fundamental and operating system.