Specialized Programme on eGovernance
Application Development
|
A) NAME OF INSTITUTE
|
Centre
For Development of Advanced Computing
|
|
B) NAME/TITLE OF THE COURSE
|
Specialized Programme on eGovernance Application Development |
|
C) PROPOSED DATES AND DURATION OF THE COURSE IN WEEKS /
MONTHS |
From Nov
17th, 2008 to Feb 6th, 2009
12
Weeks / 3 Months |
|
D) ELIGIBILITY CRITERIA FOR PARTICIPANTS:
I) EDUCATIONAL
II) WORK EXPERIENCE
III) AGE LIMIT |
I) Two
years Technical Course or Graduate in Electronics/
Telecommunication/ Computer Science with 12 years of
Schooling.
II)
-------
III)
------
|
|
E) AIM, OBJECTIVE AND CONTENTS OF THE COURSE |
Objective:
Explain
the fundamental principles of object-orientation
·
Design and Develop well engineered Java classes
· Have
an in-depth understanding of the core Java API including
I/O, Collections and JDBC
Content
of The Course:
Introduction
to OOAD for Java Developers, Fundamental Programming
Structures in Java, Classes and Objects in Java, Java
Interfaces, Java Exception Handling, Java Input/Output API,
SQL/PLSQL, JDBC, Java Servlets, Java Beans, JSP
|
|
F) MODE OF EVALUATION OF PERFORMANCE OF THE TRAINEE |
Technical
Test, Case Studies and Project Work |
Start Date: Nov 17th, 2008
End Date: Feb 6th, 2009
Duration :12
weeks
Objective
At the end of the course, Students will be able to:
-
Develop an
e-Governance Application with the knowledge of an Object
Oriented Programming using Java and Oracle as a Database.
-
Explain the
fundamental principles of object-orientation
Course Content
1.
Introduction to OOAD for Java
Developers
2.
Fundamental Programming
Structures in Java
-
The main() method
-
Primitive Data
Types
-
Variables
-
Constants
-
Assignments
-
Initializations
-
Operators
-
Strings
-
Control Flow
-
Code Examples &
Exercises
3.
Classes and Objects in Java
-
Classes & Objects
-
OOP Principles
o
Instantiation
o
Encapsulation
o
Specialization
-
Instance Variables
-
Class Variables
-
Constructors
-
Instance Methods
-
Class Methods
-
Method Overloading
-
The this
keyword
-
Passing and
returning objects
-
Garbage Collection
in Java
-
Code Examples &
Exercises
4.
Object Design and Programming
with Java
-
Abstraction
-
Inheritance
-
Polymorphism
-
Method Overriding
-
Associations
-
Delegation
5.
Java Interfaces
-
Purpose of
Interfaces
-
When to use them
-
Interface
Declaration
-
Implementing an
Interface
-
Interface
Inheritance
6.
Java Exception Handling
7.
Java Collections API
o
java.util.Collection
o
java.util.List
o
java.util.Map
o
java.util.Set
o
java.util.ArrayList
o
java.util.HashMap
o
java.util.HashSet
-
Iterating through
Collections
o
java.util.Iterator
8.
Java Input/Output API
-
Streams & Files
-
Input & Output
Streams
-
File Streams
-
Object Streams
-
Object
Serialization
-
Readers & Writers
-
The Java New I/O
API
9.
SQL/PLSQL
-
Databasse
Management Concepts
-
SQL:
Create, Alter,
Integrity Constraints( Primary Key, NOT NULL, Foreign Key,
Unique Key, Check Constraints), Insert
-
SQL:
Select,
Update Delete, Drop, Alter, Order by, Group by
-
SQL:
Single Row
Functiobn, Group Function, Having
-
SQL:
Index, Sequences,
Commit, Rollback, Savepoint
-
SQL:
Merge, Insert
clause & Enhanced Features
-
PL/SQL:
PL/SQL Block,
Variables
-
PL/SQL:
Writing the
DML Statement, Cursors
-
PL/SQL:
Triggers,
Functions, Packages
10.
JDBC
-
Introduction to
JDBC
-
The Java, SQL
Package
-
Connecting to the
Database
-
Working with
Connections
-
Working with
Results
-
Working with
Statements
11.
Java Servlets
12.
Java Beans
13.
JSP
Oracle
1. Overview Of Oracle
-
Oracle history
-
Grid architecture
-
Application architecture
Client/Server v Multi-tier;
-
Memory and Processes
-
Physical and logical structures
Files,
-
Tablespaces;, Segments, Extents
and Blocks
-
The Oracle Instance - Database
startup and shutdown
-
Management tools Oracle
Enterprise Manager,
-
SQL*Plus Exercise and quiz
2. Database Creation, Startup and Shutdown
-
DBA Privileges Levels DBA,
Security Officer, Network Administrator
-
Initialization files
-
Database creation
-
Database startup, quiescent,
shutdown
-
Alert log
3. SGA
and Background Processes
-
Introduction
-
Buffer cache
-
Redo log buffer
-
Shared pool
-
Program global area
-
Background processes
-
Transaction processing
4.
Tablespaces and Tables
Internal and External Files
-
Design considerations required
tablespaces
-
Tablespace creation and
management
-
Automated storage management
-
Table creation and management
constraints, triggers
5.
Internal and External Files
6.
Performance and Tuning Overview
-
Self monitoring architecture
-
Disk tuning - Temporary storage,
undo segments
-
Memory tuning Buffer cache,
shared pool, redo log buffer; locks
-
Statistics management
-
Oracle Advisors
7. Users,
Roles and Profiles
8. Backup
and Recovery
-
Cause of data loss
-
Structures used
-
Offline backups
-
Archiving redo logs
-
Online backups
-
Complete recovery principles
-
Incomplete recovery principles
-
Oracle Flashback overview
9. Oracle
Net Services
-
Client/Server architecture
Connection and Naming methods (Easy, Local, Directory,
External)
-
Local Networking and
Internet-Working
-
Files - TNSNAMES.ORA /
LISTENER.ORA / SQLNET.ORA / CMAN.ORA / OID (LDAP)
-
Advanced Features Load
Balancing and Failover
10. Oracle
Utilities
11. Advanced
Topics Overview
erformance - Table
compression, indexing choices
OLAP processing Materialized
views, ETL solutions
Programming options PL/SQL v
Java
Content Management XML, LOBs,
Ultra Search
Globalisation time zone,
language, date and number formats
Project
Work
Eligibility Criteria:
Two years Technical Course or Graduate
in Electronics/ Telecommunication/ Computer Science with 12
years of Schooling.
|
