Database Administrator Course Outline

To receive a certificate in Database Administrator you must complete all core subjects and elective subjects with an average grade of "C" or better. 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. In addition the outline describes each module, duration, credit units & skill sets needed for career success!

Database Administrator Core Subjects

1.

Module #:

ORCL - 901

Module Name:

Data Modeling I& Database Design: Introduction to SQL

Duration:

40 hrs. (5 Weeks)

Credit Unit:

3 Units

Skill Sets:

general Concept of Database Management System. Main focus is aware 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.

2.

Module #:

ORCL - 902

Module Name:

Advance SQL

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

3.

Module #:

ORCL - 903

Module Name:

PL-SQL - I

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

4.

Module #:

ORCL - 904

Module Name:

PL-SQL - II

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Introduction to 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.

5.

Module #:

ORCL - 905

Module Name:

Forms

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

6.

Module #:

ORCL - 906

Module Name:

Architecture and Administrations

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

7.

Module #:

ORCL - 907

Module Name:

Backup and Recovery

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

8.

Module #:

ORCL - 908

Module Name:

Performance Tuning

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

9.

Module #:

ORCL - 909

Module Name:

Networking, Oracle 9i PL SQL -I

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

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.

10.

Module #:

ORCL - 910

Module Name:

Oracle 9i PL SQL -I

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

PL-SQL in Oracle Next Version 9i. It also covers system failure protection steps. It deals with more added feature in backup and Recovery, system performance tuning, database tuning, and networking. The main focused to upgrade from old version to new version.

Database Administrator Elective Subjects

1.

Module #:

SQL - 601

Module Name:

Administering a SQL Server 2000

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

starting, stopping, pausing, and modifying MS SQL 2000 Services. Also, upgrade to newer versions, performing an online DB upgrade, transferring and transforming data and the backup and restoration process in SQL.

2.

Module #:

SQL - 602

Module Name:

Manging a SQL Server 2000

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Standby server usage, and Fail-over Clustering, and planning for replication and administering replication. Create Multi-server jobs, a DB Maintenance Plan and designing an Access and Permissions Plan.Also deals with file-groups, drop user tables, column values, and scripts.

3.

Module #:

SQL - 603

Module Name:

Programming a SQL Server 2000 Database

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

The SQL Server environment, the installation and configuring of a SQL Database. Discuss Relational database architectures and security architectures. Perform remote installations of a SQL DB. Discuss the Query Analyzer, the Enterprise manager, and the Transaction Log Architecture and Database Catalogs and DTS Services.

4.

Module #:

SQL - 604

Module Name:

Quering SQL Server 2000 with Transact-SQL

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

The creation of a User Database, DB options, managing the size of the DB, placing DB files on multiple Disks, and the Bulk Copy and Insert Programs and Data Restoration issues. Show the authentication process, creating and managing logins and developing a performance-monitoring Plan.

5.

Module #:

LIN - 901

Module Name:

Theory of Operation and Basic Fundamental

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Knowledge of Computer. Basic concept is to aware about fundamental knowledge of Linux operating System. Also get knowledge for Networking Technology and Hardware introduction and Planning to implement the Linux System.

6.

Module #:

LIN - 902

Module Name:

Installation and Configuration

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Installing and Configuring Linux system. Basic aspect to perform new Linux instillation and configuring Hardware Devices, Accessing built-in application, Running text editing tools, Accessing internet, use entertainment tools - X-Game and multimedia, Startup, Shutdown and go to various run-levels.

7.

Module #:

LIN - 903

Module Name:

Basic Linux Administration

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Perform basic administrative task on Linux System. As a basic Administrator logging into system as a root, performing root operation, becoming super user from normal user, learning about Linux File System. Issues various command to check system status and history, performing I/O Operation in System.

8.

Module #:

LIN - 904

Module Name:

Advance Linux Administration

Duration:

40 hrs.(5 Weeks)

Credit Unit:

3 Units

Skill Sets:

Perform advance administrative task on Linux System. As a basic Administrator logging into system as a root, performing root operation, becoming super user from normal user, learning about Linux File System. Issues various command to check system status and history, performing I/O Operation in System.