|
Module
|
Topics
|
Hrs
|
Prerequisites |
| EC1- Introduction to Programming
- 50 hours |
| Introduction to Programming
|
- Introduction to Data Processing, Web and Application Development (Principles, Terminology, Variables, Data Types, Statements, Operators,
Functions); Database concepts
- Introduction to Web Programming using HTML and Java Script
- Development Environments using Visual Interdev; MSDN Library
- Application development using Java Script
- Java Script Application Project
|
|
Computer
literacy
and/or
Aptitude
Test
|
| Total |
50 |
| EC2- Object-Oriented Programming & Relational Databases
- 40 hours |
| Programming with Objects
and
Introduction to Relational Databases
|
Basics/Concepts of Object oriented language using Visual Basic
- Building VB Classes, Windows Forms and Data controls.
- Learning OOP constructs: Polymorphism, Inheritance, Overloading and Overriding methods.
|
30 |
Experience
with
high level
programming
languages
or
Software
Testing
Experience
or
EC Module 1
|
- Concepts of Relational Database
- Microsoft SQL Server;
- Learning ADO library.
- Overview of SQL: DML, DDL, SQL syntax
|
10 |
| Total |
40 |
| DB1 - Database Module 1
- 44 hours |
| Relational Databases
and
Microsoft SQL Server
|
Relational Database Basics; Client Server Environment and Multi-tier Architecture |
8 |
IT application
development
experience
with
relational
databases
in the
Client-Sever
Environment
or
EC Module 2
|
| Introduction to Relational Databases with Microsoft Access. MS Access 97 and 2000. Tables, queries, forms, reports and data access pages and their integration into desktop solutions. |
8 |
| Microsoft SQL Server. Comprehensive technical information and tools for deploying, managing and supporting SQL Server 7.0 and 2000. |
24 |
| Oracle, Sybase, Informix and DB2 – architectural differences and similarities. |
4 |
| Total 44 |
44 |
| DB2a - Database Module 2SQLS
- 36 hours |
| SQL Server Database Administration
|
Role of the DBA. Installing and Upgrading SQL Server. Backup and restore. Using BCP. Distributed Transaction Coordinator. |
8 |
Hands-on DBA
experience
administering
relational
databases
or
Significant
hands-on
experience
developing
applications
for
SQL Server
or
DB Module 1
|
| Managing SQL Sever Users and Security. |
8 |
| SQL Server stored procedures and replication, performance, tuning, monitoring, configuring and maintenance. Automatic database administration tasks. |
12 |
| Data warehousing. Using Data Transformation Services. OLAP Services. DBCC |
8 |
| Total |
36 |
| DB2b - Database Module 2ORCL
- 50 hours |
| Oracle Database Administration
|
Building an Oracle Database Creating the Database; Starting and Stopping the
database Managing Users and Resources Creating users accounts; Allocating space quotas; Maintaining security |
8 |
Hands-on
DBA
experience
administering
relational
databases
or
Significant
hands-on
experience
developing
applications
for Oracle
or
DB Module 1
or
Oracle
Module 3
|
| Controlling Disk
Storage Logical and physical disk structure; Allocating disk storage for database objects; Partitioning to support Very Large Databases
(VLDBs) Backup and Recovery Safeguarding the database; Selecting a backup strategy; Performing recovery; Automating backup and recovery |
10 |
| Troubleshooting the Oracle
Database Diagnostics utilities Analyzing information in the log files Fundamental
Tuning Techniques Tuning memory structures; Configuring disk usage; Improving performance with Enterprise Manager toolset; Diagnosing problems and tuning |
16 |
| Data Warehousing Using Oracle
Databases Oracle data warehouse architecture; Developing and populating the
data warehouse; Reporting, OLAP and data mining tools |
16 |
| Total |
50 |
