| Each technology track
consists of multiple courses and each course is forty hours in length. To make
it convenient for students, classes
are conducted on weekdays, weekday evenings and weekends. Weekday and
weekend classes meet and one day a week for five weeks. Weekday evening classes meet two nights a week for five weeks.
Oracle
DBA Track
ORA-SQ: Oracle – SQL
Relational Database Concepts
Study of Data Manipulation Language (DML), Data Definition
Language (DDL) and Data Control Language (DCL)
Write SQL and SQL*Plus scripts and use iSQL*Plus.
Retrieve data using advanced techniques such as ROLLUP, CUBE,
set operators and hierarchical retrieval
ORA-PL: Oracle – PL/SQL
PL/SQL Language Study – Syntax, Anonymous blocks,
Application Blocks and Control Structures
PL/SQL Advanced: Triggers – Construct and Usage.
Functions – Constructs and Usage. Use in reporting and
intermediate procedural calculations.
Procedures and Packages – Study of PL/SQL variables, User
Defined variables, cursors and exception handling. Study of
Packages – Package Specification and package body.
Exception Handling – Using built-in
exceptions and user defined exceptions.
ORA-DB1: Oracle 10g Database Administration
I
Install, set up and create an Oracle Database.
Database Startup and Shutdown, manage control files and redo
logs.
Manage database storage (data files, table spaces, block space
utilization, extent management)
Manage Rollback segments and Temporary Tablespaces
Managing Tables, Indexes, and constraints
Set up users, roles, privileges and DB security.
Backup and recovery principles
ORA-DB2: Oracle 10g Database Administration
II
Planning and implementing Database
Backup strategy
Implement on-line and off-line backups.
Implement Database export backups – full, user and table
options.
Implement backups in Non-archive log mode and Archive log mode.
Setting up backups using RMAN. (Standalone and Recovery Catalog)
Open and closed database RMAN backups.
Backup, failure, restore and recovery lab scenarios using RMAN
Database tuning
Book Information
The Sybex Oracle DBA Certification Kit
books are used for the Oracle DBA track.
OCP: Oracle10g Certification Kit: Bob Bryla, Tim Buterbaugh, Chip Dawes,
et al. Sybex, 1st edition,
Published Feb 2005. (ISBN: 0-7821-4369-5)
Book for ORA-PL:
Oracle Database 10g PL/SQL Programming:
Scott Urman, Ron Hardman et al.; Oracle Press (ISBN 0072230665)
SQL
Server DBA
Track
SQL-TS1: Querying SQL Server 2005 with Transact-SQL
Querying SQL Server with T-SQL
Introduction to Transact-SQL
Transact SQL vs. ANSI SQL
Using Transact-SQL Querying tools
DDL, DML and DCL commands
Grouping and Summarizing data
Joins and Sub-queries
SQL-TS2: Programming SQL Server 2005
with Transact-SQL
Programming SQL Server with Transact-SQL
Transact SQL syntax
If-then-else blocks and loops
Cursors and record-sets
Writing Triggers, Functions and Stored Procedures
Indexes and Views
Working with XML
SQL-SA51: SQL Server 2005 (2780) – Database Administration
I
Install, configure and maintain SQL Server 2005
Manage database files.
Backup and restore databases
Manage security
Monitor SQL Server
Transfer data into and out of SQL Server
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.
SQL-SA52: SQL Server 2005 (2779) – Database Administration II
Create databases and database files.
Create data types, tables, indexes and views.
Use XML-related features in Microsoft SQL Server 2005.
Implement data integrity via constraints and triggers
Implement stored procedures, functions and managed code.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Use Notification Services to generate and send notifications.
SQL-SA81: SQL Server 2008 (6231) – Database Administration
I
Install and configure SQL Server
2008.
Manage database files.
Backup and restore databases.
Manage security.
Transfer data into and out of SQL Server.
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.
Monitor SQL Server.
SQL-SA82: SQL Server 2008 (6232) – Database Administration
II
Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2008.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2008 databases
by using constraints.
Implement data integrity in Microsoft SQL Server 2008 databases
by using triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Book Information
SQL-SA5 and SQL-DB5: Implementing and
Maintaining MS SQL Server 2005 (Exam 70-431)
ISBN: 073562271X
SQL-SA81, SQL-SA82: MCTS
Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server®
2008 - Implementation and Maintenance
ISBN13: 9780735626058
Database
Designer Track
DDT-DM: Data Modeling and Database
Design
Entity Relationship Modeling
Creating appropriate Names for Entities, Attributes and
Relationships
Representing a Model in Diagrams
Establishing the Basic Mapping of an ER Model to Table Model
Mapping Entities and Attributes
DDT-LP: Logical and Physical Data
Modeling
Develop logical data models
to satisfy business requirements
Physical model creation from Logical Models
Modify the resulting physical model to implement additional
requirements.
Forward engineer the resulting model into script files.
Use Data Modeling tool for model-based maintenance of the
database
VB.NET,
ASP, C# Track
VBS-PR:
Programming in VB.NET
Arrays, strings and Collections
Delegates, events, objects and classes
The Object Oriented Development Cycle
Reference Type Variables
Inheritance, Polymorphism and Encapsulation
Components and Assembly Deployment
Windows
Application Development and DB access
VBS-AS1:
Programming ASP.NET and ADO.NET using VB.NET I
Language
Fundamentals
Overview of ASP.NET
Web
Forms and Server Controls
Validation
and User Controls
User
Interface Error Handling
User
Authentication and Web Application Configuration
Data
binding in ASP.NET applications
VBS-AS2:
Programming ASP.NET and ADO.NET using VB.NET II
User
Authentication and Web Application Configuration
Data
binding in ASP.NET applications
Displaying data with
GridView control
Managing users and
state with ASP.NET's membership features
Debugging ASP.NET applications
New
features of DotNet
CSP-PR:
Programming in C#
Arrays, strings and Collections
Delegates, events, objects and classes
The Object Oriented Development Cycle
Reference Type Variables
Inheritance, Polymorphism and Encapsulation
Components and Assembly Deployment
Windows
Application Development and DB access
CSP-AS1:
Programming ASP.NET and ADO.NET using C# I
Language
Fundamentals
Overview of ASP.NET
Web
Forms and Server Controls
Validation
and User Controls
User
Interface Error Handling
User
Authentication and Web Application Configuration
Data
binding in ASP.NET applications
CSP-AS2:
Programming ASP.NET and ADO.NET using C# II
User
Authentication and Web Application Configuration
Data
binding in ASP.NET applications
Displaying data with
GridView control
Managing users and
state with ASP.NET's membership features
Debugging ASP.NET applications
New
features of DotNet
Book Information
Teacher will provide
course material and recommend reference books.
Windows
Server Track
MSF-SA: Microsoft Windows 2003 Server Administration
Installation,
configuration and administration of Windows 2003 server
Installing
and configuring Active Directory Services
Managing
user accounts using active directory
Managing
desktop environments and software by using group policy.
Installing
and configuring Terminal Services for remote access.
MCSA/MCSE Self-Paced Training Kit: Managing and Maintaining a Microsoft Windows Server 2003
Environment (Exam 70-290)
- Dan Holmes & Orin Thomas
(ISBN 0-7356-1437-7)
MSF-NA: Microsoft Windows 2003 Network
Infrastructure
Configure
and support remote access to a network
Use
DHCP to assign and manage IP addresses
Use
WINS to map NetBIOS names to IP addresses
Configuring
RIP and OSPF for IP routing
Installation,
configuration and administration of IIS
Implementing, managing and maintaining a Microsoft Windows
Server 2003 Network Infrastructure (Exam 70-291)
- JC Mackin and Ian McLean (ISBN 0-7356-1439-3)
MSF-AD: Microsoft Windows 2003 Active Directory
Administering
Active Directory Forest and Domain Structures
Organizing
Security Group Strategy, Placing Global Catalog Servers and
Preparing Organizational Unit (OU) Structure
Creating
and Troubleshooting Group Policy Strategies using Resultant Set
of Policy (RSoP)
Backing
Up, Restoring, and Maintaining Active Directory
Allocating
Assignment of Global Catalog, Servers, Domain Controllers, and
DNS Servers within Active Directory
Planning, Implementing and Maintaining a Microsoft Windows
Server 2003 Active Directory Infrastructure (Exam 70-294)
- Jill Spealman, Kurt Hudson, and Melissa Craft (ISBN
0-7356-1438-5)
MSF-EX: Microsoft Exchange 2003
Server
Installation
and configuration of Exchange 2003 Server
Outlook
installation and configuration
Internet
messaging protocols
SMTP
Configuration
Public
Folder Management and Replication
Management
console (MMC) Snap-ins
Microsoft Exchange 2003 Server: Implementing and Managing MS
Exchange Server 2003 (Exam 70-284)
-
Will Willis and Ian McLean (ISBN 0-7356-1899-2)
MSF-SA8: Microsoft Windows
2008 Server Administration
Installation,
configuration and administration of Windows 2008 server
Installing
and configuring Active Directory Services
Managing
user accounts using active directory
Managing
desktop environments and software by using group policy.
Installing
and configuring Terminal Services for remote access.
Windows Server 2008 Inside Out - William R. Stanek - ISBN: .
9780735624382
MSF-NA81: Microsoft Windows
2008 Network
Infrastructure I
Configure
and support remote access to a network
Use
DHCP to assign and manage IP addresses
Use
WINS to map NetBIOS names to IP addresses
Configuring
RIP and OSPF for IP routing
Installation,
configuration and administration of IIS
MCTS
Self-Paced Training Kit (Exam 70-642): Configuring Windows
Server 2008 Network Infrastructure. - Tony Northrup and J.C.
Mackin - ISBN: 9780735625129
MSF-NA82: Microsoft Windows
2008 Network
Infrastructure II
Network
Policy Server and Network Access Protection
PKI
and Certificate Services
Configuring
High Availability
Distributed
File Systems
Terminal
Services
Storage
Area Networks
MCITP Self-Paced Training Kit (Exam 70-646): Windows Server®
Administration - Orin Thomas and Ian McLean - ISBN-13:
978-0-7356-2510-5
MSF-AD81: Microsoft Windows
2008 Active Directory I
Administering
Active Directory Forest and Domain Structures
Organizing
Security Group Strategy, Placing Global Catalog Servers and
Preparing Organizational Unit (OU) Structure
Creating
and Troubleshooting Group Policy Strategies using Resultant Set
of Policy (RSoP)
Backing
Up, Restoring, and Maintaining Active Directory
Allocating
Assignment of Global Catalog, Servers, Domain Controllers, and
DNS Servers within Active Directory
MCTS Self-Paced Training Kit (Exam 70-640): Configuring
Windows Server® 2008 Active Directory - Dan Holme, Nelson Ruest,
and Danielle Ruest - ISBN: 9780735625136
MSF-AD82: Microsoft Windows
2008 Active Directory II
Administering
Active Directory Forest and Domain Structures
Organizing
Security Group Strategy, Placing Global Catalog Servers and
Preparing Organizational Unit (OU) Structure
Creating
and Troubleshooting Group Policy Strategies using Resultant Set
of Policy (RSoP)
Backing
Up, Restoring, and Maintaining Active Directory
Allocating
Assignment of Global Catalog, Servers, Domain Controllers, and
DNS Servers within Active Directory
MCTS Self-Paced Training Kit (Exam 70-640): Configuring
Windows Server® 2008 Active Directory - Dan Holme, Nelson Ruest,
and Danielle Ruest - ISBN: 9780735625136
MSF-EX7: Microsoft Exchange
2007
Server (70-236)
Installation
and configuration of Exchange 2007 Server
Outlook
installation and configuration
Internet
messaging protocols
SMTP
Configuration
Public
Folder Management and Replication
Management
console (MMC) Snap-ins
MCTS Self-Paced Training Kit (Exam 70-236): Configuring
Microsoft® Exchange Server 2007 - Orin Thomas and Ian McLean -
ISBN: 9780735624108
MSF-SP3: Microsoft
Sharepoint Server 2003 Administration
Install
Windows SharePoint Services (WSS) and SharePoint Portal Server (SPS)
Using
SharePoint with Microsoft Office and
Microsoft Outlook
Sharepoint
Backup and Restore Procedures
Performance
Tuning and Troubleshooting
Creating
and working with Intranets
MSF-SP7: Microsoft
Sharepoint Server 2007 Administration
Install
Windows SharePoint Services (WSS) and SharePoint Portal Server (SPS)
Using
SharePoint with Microsoft Office and
Microsoft Outlook
Sharepoint
Backup and Restore Procedures
Performance
Tuning and Troubleshooting
Creating
and working with Intranets
MSF-SEC:
Designing Security for Microsoft Networks (70-298)
Document
the impact of business and technical constraints on the security
design process
Create a security design for:
- Logical infrastructure
- Network infrastructure for physical security
- Network management and maintenance
- Basic network functions
- Wireless networks and Web servers
MCSE
Self-Paced Training Kit (Exam 70-298): Designing Security for a
Microsoft® Windows Server™ 2003 Network - Roberta Bragg -
ISBN: 9780735619692
MSF-PS1:
MS Windows Administration with Powershell I
Architecture
and Overview
Navigating
Your System
Key
Cmdlets for Windows Administration
The
PowerShell Pipeline; Objects in the Pipeline: Grouping, Sorting,
and More
Security
Features, WMI Overview and Use
AD
Overview and Use
Scripting
Overview
Objects,
Variables, Arrays, Escapes
Working
with Scope in PowerShell
Windows
Powershell Scripting Guide - Ed Wilson (Microsoft Press) - ISBN:
9780735622791
MSF-PS2:
MS Windows Administration with Powershell II
Advanced
Filtering and Cmdlet Techniques
Variables
and Literals are Objects; Exploring Data Types
Error
Trapping and Handling
Debugging
Techniques
Regular
Expressions
Advanced
Modularization – Filtering Functions and Custom Objects
Saving
and Exporting Objects
Working
with Databases
Custom
Format Views
Custom
Type Extensions
Introduction
to Windows Forms
Working
with Windows Forms
Working
with XML Data
Retrieving
data from the Web
MSF-XP: Microsoft
Windows XP Administration (70-270)
Install
and configure Microsoft Windows XP
Implementing
and Conducting Administration of Resources
Implementing, Managing, Monitoring, and Troubleshooting Hardware
Devices and Drivers
Monitoring and Optimizing System Performance and Reliability
Configuring and Troubleshooting the Desktop Environment
Implementing, Managing, and Troubleshooting Network Protocols
and Services
Configuring,
Managing, and Troubleshooting Security
MCSA/MCSE
Self-Paced Training Kit (Exam 70-270): Installing, Configuring,
and Administering Microsoft® Windows® XP Professional - Walter
Glenn and Tony Northrup - ISBN: 9780735621527
MSF-VI1: Microsoft
Vista Administration (70-620)
Install
and configure Microsoft Vista
Configure
User Access Control and security settings
Set up and troubleshoot network connections, Windows Firewall,
and remote access
Configure Windows Media Center, Windows Sidebar, and other
built-in applications
Set up mobile devices and Tablet PCs
Troubleshoot and optimize system performance and reliability
MCTS
Self-Paced Training Kit (Exam 70-620): Configuring Windows Vista
Client (Self Paced Training Kit 70-620) -
Ian McLean and Orin Thomas - ISBN:
9780735623903
MSF-VI2: Microsoft
Vista Administration (70-622)
Deploying
Windows Vista
Managing
Windows Vista Security
Managing
and Maintaining Systems That Run Windows Vista
Configuring
and Troubleshooting Networking
Supporting
and Maintaining Desktop Applications
MCITP
Self-Paced Training Kit (Exam 70-622): Supporting and
Troubleshooting Applications on a Windows Vista Client for
Enterprise Support Technicians - Tony Northrup and JC Mackin -
ISBN: 9780735624085
Java
Track
JAV-OO:
Object Oriented Programming in Java
Object
Oriented Programming
Java
Syntax
Classes
and Interfaces
Inheritance
and Polymorphism
Exceptions
and Threading
Files,
Streams and Serialization
Regular
Expressions
Collections
and Generics
JAV-AP:
Application Development in Java
Event
handling
JDBC,
Database Access and Rowsets
Graphics
using Java 2D
GUI
using JFC/Swing
Programming
Java Applets
JAV-AT1:
Advanced Topics in Java I
JSP
and Servlet Programming
Servlet
chaining and RMI
Network
Programming
Enterprise
Java Beans
JSTL,
Custom Tag Libraries
JAV-AT2:
Advanced Topics in Java II
JAXB,
JAXP, SAX, DOM, XML, XSL, XSD
SOAP, WSDL,
UDDI
Web
Services
JAAS
JAV-AT3:
Advanced Topics in Java III
Struts
JSF
Hibernate
Book Information
Instructor will provide
material. The following books are recommended:
JAV-OO and JAV-AP:
Java How to Program, Seventh Edition
Publisher: Prentice Hall,
Author: Deitel and Deitel
ISBN-10: 0132222205
ISBN-13: 978-0132222204
JAV-AT1:
Advanced Java 2 Platform, How to program,
Publisher: Prentice Hall,
Author: Deitel and Deitel,
ISBN-10: 0130895601
ISBN-13: 978-0130895608
Cisco
Track
CIS-ND1:
Configuring Cisco Network Devices I (ICND1 - 640-822)
TCP/IP and OSI networking models
Operating Cisco routers and LAN switches
LAN switching basics, VLANs, and
Trunking
IP addressing and
subnetting
Basic router configuration and
operation
Discovering information about an IP
network
Dynamic routing protocols and analog modems, PAP/CHAP, DSL and Cable.
CIS-ND2:
Configuring Cisco Network Devices II (ICND2 - 640-816)
Select,
connect, configure and troubleshoot Cisco Networking devices
Design
and build a multirouter, multigroup internetwork for LAN/WAN.
Configure
and troubleshoot LANs and VLANs
Configure
IP Addresses, subnet masks and gateway addresses on routers and
hosts
Configure
and troubleshoot Access Control lists
Assessing
network problems using the OSI
Troubleshooting
routing protocols
Deploying
and troubleshooting Cisco routers and switches using Cisco IOS
CIS-SC:
Configuring scalable Cisco Networks (CCNP-1)
Advanced
IP Addressing to Include VLSM
WAN
Serial Interfaces using Frame Relay PVCs
IPv6,
NAT, CIDR, and Route Summarization
Routing
Updates and Packet Flow
OSPF
Environment and Correct Operations
Scalable,
Routed Networks
CIS-ML:
Configuring Multi-layer Switched Cisco Networks (CCNP-2)
Planning
and configuring VLANs with VTP
Implementing
Spanning-Tree parameters including:
port priority, VLAN priority, root
bridge,
BPDU guard, PortFast and UplinkFast
Confirming
router redundancy using HSRP, VRRP, GLBP, SRM, and SLB
Building
and verifying ISL trunks
Assessing
and troubleshooting inter-VLAN routing
performance and scalability
Identifying
Enterprise Composite Model - Campus
Infrastructure, Server Farm
Enterprise
Edge, Network Management
Configuring
Fast EtherChannel and Gigabit EtherChannel
for interswitch connections
CIS-RA:
Configuring Remote Access Cisco Networks (CCNP-3)
Configure
WAN technologies; Frame Relay, ISDN, Cable Modem, and DSL
Configure
DSL and ISDN and implement NAT
Controlling
Network Access with PAP and CHAP
Design
a Remote Access Network
Plan
Traffic Shaping
Configure
and trouble shoot WAN broadband
technologies
CIS-TA:
Troubleshooting Advanced Cisco Networks (CCNP-4)
Planning
a network documentation scheme,
including standards & document
control
Charting
a baseline monitoring system
Isolating
and resolving system problems on specific OSI layers
Diagramming
and documenting system topology
Developing
documentation standards and the
requirements for document control
Restoring
optimal baseline service
Employing
IOS commands and applications to
resolve optimization & failure problems
Book Information
CIS-IN
(CCNA): CCNA INTRO Exam Certification Guide (CCNA Self Study)
- Wendell Odom (ISBN 1-58720-094-5)
CIS-ND
(CCNA): CCNA ICND Exam Certification Guide (CCNA Self Study)
- Wendell Odom (ISBN 1-58720-083-X)
CIS-SC,
CIS-ML, CIS-RA, CIS-TA (For the entire CCNP Series): CCNP
Certification Library (CCNP Self Study 642-801, 642-811,
642-821, 642-831), 3rd edition
- Clare Gough, Amir Ranjbar, David Hucaby, Craig Dennis, Brian
Morgan (ISBN 1-58720-104-6)
Security
Track
SEC-NI:
Securing Network Infrastructure and Communications (Security+ 1)
Common
network attacks
NAT
implementation
PKI
certificates
Cryptography
Kerberos,
CHAP and biometric authentication
Access
control methods
Firewall
configuration
SEC-AP:
Application, Operational and Organizational Security (Security+
2)
Web
vulnerabilities (active content, buffer overflows, cookies, CGI
and instant messaging)
File
sharing protocol (secure/Kerberized FTP, SMB, NFS)
vulnerabilities
Intrusion
and vulnerability detection tools
DOS
and DDOS attack prevention tools
HIDS,
application-based IDS and NIDS
Chain
of custody
SEC-AI:
Designing Security Architecture Infrastructures (CISSP 1)
Access
control models and administration
Network
and protocol security mechanisms
Common
network attacks and counter measures
Malicious
code and application attacks
Cryptography
and private key algorithms
Cryptographic
applications and common attacks
Physical
security threats and access controls
SEC-MA:
Designing Security Management Infrastructures (CISSP 2)
Automated
risk analysis methods
Security
policies, procedures, standards, baselines and guidelines
Information
classification methods
Business
continuity planning documentation
Checklist,
simulation, parallel and full-interruption tests
Incident
handling
Operations
security
SEC-ND:
Network Defense and Counter Measures
Course
details will be added soon
Book Information
SEC_NI:
Hack Attacks Revealed: A Complete Reference for UNIX, Windows,
and Linux with Custom Security Toolkit, Second Edition
- John Chirillo (ISBN: 0471232823)
SDLC
Project
Management
Track
PMT-SK:
Project Management Skills (aka SDLC Project Management I)
Comprehensive
PMBOK curriculum
Analyzing
the project environment
Determining
task dependencies and schedules
Defining
clear project goals and measurable deliverables
Creating
the work breakdown structure for the project activities
Estimating
task duration and work
Assigning
and analyzing costs and resource use
Developing
risk management plans
Producing
the implementation plan
PMT-MP:
Project Management using MS Project (aka SDLC Project Management II)
Project
Management Tools - MS Project, R, Minitab
Creating
project plans and templates
Defining
activities, costs, risks and overall project scope
Assigning
resources and resolving conflicts and over-allocations
Optimizing
and fine-tuning project plans to finish on time
Tracking
and recording project progress and responding to updates
Gauging
project performance and identifying trends and problem areas
Placing
tasks and projects back on schedule
PMT-SD:
Advanced topics in Project Management (aka SDLC Project Management III)
Project Management
- Advanced Topics IT
Project Management - Project phases and SDLC IT
Project Planning and scope Time
and cost management for IT Projects Quality
and risk management for IT Projects
PMT-TP:
PMP Test Preparation (aka SDLC Project Management IV)
Review
of PMP Test Preparation
Review
of Project Management (PMBOK) course material
Review
of Certification Test material and sample tests.
Book Information
PMT-SK Course: Project Management
Professional Study Guide, 2nd Edition
- Joseph Phillips (ISBN 0072262907)
PMT-MP Course: Microsoft
Office Project 2003 Step by Step
- Carl S. Chatfield, PMP and Timothy D. Johnson, MCP (ISBN
0-7356-1955-7)
PMT-SD Course:
Information Technology Project Management
- Kathy Schwalbe (ISBN 0-619-21526-7)
Linux
Track
LIN-SA1:
Linux System Administration I
Click
here for the syllabus PDF document
LIN-SA2:
Linux System Administration II
Click
here for the syllabus PDF document
Book Information:
Teacher will provide class notes.
Object
Oriented Design Track
OOD-UM: Object Oriented Design with
Unified Modeling Language
Unified Modeling Language
Use Case Model
Dynamic Model
Class Model
Component and Physical Deployment Model
Book Information:
Teacher will provide class notes and suggest reference books.
MySQL
DBA Track
MYS-DB: MySQL Database Administration
Installing and configuring MySQL
Managing users and databases
DDL and DML in MySQL
Queries, joins, subqueries and group functions
Backup and restore
Book Information:
Teacher will provide class notes and suggest reference books.
Crystal
Reports Track
CRY-RP: Programming Crystal Reports
Working in Design Mode
Managing Objects and Sections
Sorting, Grouping and TopN Reports
Totals and Summaries
Crosstabs, Formulas, Functions and Operators
Visual effects and presentation
Parameter fields, alerts and sub-reports
Running total fields and variables
Conditional Formatting and Specific Order Grouping
Advanced Formulas and split sections
Advanced crosstabs, advanced charts and maps
Using SQL within Crystal Reports
Book Information:
Teacher will provide class notes and suggest reference books.
Data
Warehousing and Informatica Track
DWH-IN1:
Data Warehousing Fundamentals
Business need for Data Warehousing
OLTP vs. DW Databases
DW Schema Design
Facts and Dimension tables
Star Schema and Snowflake schema
DWH-IN2: Programming Informatica
Data Mapping and ETL
Data Integration Concepts
Power Center components and User Interface
Source Qualifier and File lists
Debugger, Filter, Sorter and Aggregator
Cognos
Track
COG-PR1: Implementing BI with Cognos
Overview of Cognos 8 BI
Report Authoring
Ad hoc querying
Multi-dimensional report authoring
Data Mart design and ETL
Book Information:
Teacher will provide class notes and suggest reference books.
VMWare
Track
VMW-AD1: VMWare Infrastructure Administration
I
Introduction to Virtualization & ESX Server
Installing & Configuring ESX Server
Virtual Networking Concepts
Storage Concepts
Installation & Administration with Virtual Center
VM Creation and Cloning
Resource Management
VM Access Control
Disaster Recovery & Backup
Monitoring ESX Server
VMW-AD2: VMWare Infrastructure Administration
II
Click here for course syllabus
Book Information:
Teacher will provide class notes and suggest reference books.
|
