Module 2 Microsoft Visual Basic .NET.

Module 3 ASP.NET Web Applications Using Visual Studio .NET

Module 4 Web Development Skills from ASP to Microsoft ASP.NET

Module 5 Microsoft ADO.NET

Module 6 MS - SQL Server 2000 Database

Patterns and Frameworks
Events and Signals
State Machines.
Processes and Threads.
Time and Space.
State chart Diagrams
Components.
Deployment.
Collaborations.
Patterns and Frameworks

Rational Unified Process
Component Diagrams
Deployment Diagrams.
Systems and Models
Applying UML.
Rational Unified Process.

Case Studies
Gather requirement through UML tech.
Provident fund calculation
Food order automation
Network based common mailing system
Digital library for research papers

Object Oriented Programming Concepts
Conventional vs. Object Oriented Programming
Inheritance, Encapsulation and Polymorphism
contents and indexes

Getting Started with Java™
Writing a Simple Class
Adding Methods to the Class
Language Statements
Using Strings
Specializing in a Subclass

Essential Java™ Programming
Fields and Variables
Using Arrays
Static Methods and Fields
Java Packages
Using the JDK

Advanced Java™ Programming
Inheritance and Polymorphism
Interfaces and Abstract Classes
Exception s
Multithreading
Programming JavaBeans™

Java Developer’s Toolbox
Utility Classes
Vector and Hashtable
Collections
Inner Classes
Java I/O

Writing Graphical User Interfaces
Containers and Layout Managers
Writing Simple Graphical Applications
Writing Complete Graphical Applications

Java™ Application Development
File System Access
Networking
Java Database Connectivity (JDBC)
Writing Java Applets

Enterprise Java Overview
Developing Java Servlets
Introduction to Java Server Pages (JSPs)
Java for the Enterprise

The java.sql package
Driver Manager, Driver, Connection, Statement, Result Set
Writing database applications
Connector interface, creating new classes, applications
contents and indexes

Java Beans : Component Technology in Java (BDK)
BeanBox concept
Creating Beans with simple properties and methods
Packaging Beans: Manifest files and jar files
Using JavaBeans in IDEs

Creating Beans with
Bound properties
Constrained properties
Indexed properties
Events
Property editors, Customizers

Servlets : Dynamic Content Generation
Advantages of Servlets over CGI
The Servlet interface
The HttpServlet, HttpServletRequest, HttpServletResponse classes

Session Tracking with Cookies & HttpSession
JSP : Separating UI from Content generation code
MVC architecture
Life cycle of a JSP page
Directives, Implicit and Explicit Objects, Scriptlets, Expressions

Scope
Session Tracking
Custom Tag Libraries in JSP

EJB : Server side distributed component architecture
EJB containers
EJB Types : Session and Entity Beans
EJBObject, EJBHome

Life Cycle of a stateless session Bean & stateful session bean
Creating Beans Stateless Session Beans & Stateful Session Beans
Deploying Beans : XML deployment descriptors
Writing bean client applications
Life Cycle of an Entity Bean

Enterprise Java Beans Query Language
Creating Entity Beans
Message driven beans
Calling EJBs from JSP pages
JSP, Servlets and EJB in J2EE
Java Security
Web-tier security
EJB-tier security
Application-tier-client security
Native Methods
Calling Win32 APIs from Java

J2EE Application Architecture
Technical Overview of J2EE
J2EE Application Architectures (web based)

Servlets API Essentials
Servlets
Writing a Basic HttpServlet
Form Processing
Controlling Client Behavior
Sessions and Cookies

Writing JavaServer™ Pages
Introduction to JavaServer™ Pages
Basic JSP Syntax
Implicit Objects
Actions and JavaBeans™
Brief Overview of JSTL

Web Applications
Understanding Web Applications
Configuring Web Applications
Application and Session Events

Security (Optional)
Overview of Security
Form Based Security
Basic Authentication
Programmatic Security

Writing Custom Tags
Introduction to Custom Tags
Developing Custom Tags
Developing Advanced Custom Tags (Optional)

Getting Started with Struts
Jakarta Struts Project
MVC and Struts
Review Servlets, JSP and Web Applications
Struts Controller, Views and Resources

Your First Struts Application
Configuring Struts applications
Defining views & actions
Defining FormBeans
Action Mappings

Mapping the Model to the View
Review of Using Custom Tags
Introducing Struts Tags
Using HTML Tags
Using Bean Tags
Using Logic Tags

Project Work

Uploading Files and I18N
Uploading Files
Internationalization

Advanced Form Management
DynaActionForms
The Validator Framework

Working with Tiles
Using Tiles
Advanced Tiles

SQL
Writing Basic SQL Select Statements
Restricting and Sorting Data
Single-Row Functions
Displaying Data from Multiple Tables
Aggregating Data using Group Functions
Identify the available group functions
Use group functions
Group data using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Subqueries
Describe the types of problems that subqueries can solve
Define subqueries
List the types of subqueries
Write single-row and multiple-row subqueries

Producing Readable Output with iSQL*Plus
Produce queries that require a substitution variable
Produce more readable output
Create and execute script files

Manipulating Data
Describe each DML statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Merge rows in a table
Control transactions

Creating and Managing Tables
Describe the main database objects
Create tables
Describe the datatypes that can be used when specifying column definition
Alter table definitions
Drop, rename and truncate tables
Including Constraints
Describe constraints
Create and maintain constraints

Creating Views
Describe a view
Create, alter the definition, and drop a view
Retrieve data through a view
Insert, update and delete data through a view

Creating Other Database Objects
Create, maintain and use sequences
Create and maintain indexes
Create private and public synonyms

Oracle Data Dictionary
Describe the data dictionary views a user may access
Query data from the data dictionary

Writing Control Structures
Identify the uses and types of control structures
Construct an IF statement
Construct and identify different loop statements
Use logic tables
Control block flow using nested loops and labels

Working with Composite Datatypes
Create user-defined PL/SQL records
Create a record with the % ROWTYPE attribute
Create a PL/SQL table
Create a PL/SQL table of records
Describe the difference between records, tables, and tables of records

Overview of Relational Databases, SQL, and PL/SQL
Discuss the theoretical and physical aspects of a relational database
Describe the Oracle implementation of the RDBMS and ORDBMS
Describe the use and benefits of PL/SQL

Aggregating Data using Group Functions
Identify the available group functions
Use group functions
Group data using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Views
Create and use an inline view
Perform Top 'N' Analysis

Other Database Objects
Describe database objects and their uses
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Controlling User Access
Create users
Create roles to ease setup and maintenance of the security model
Use the GRANT and REVOKE statements to grant and revoke object privileges

Declaring Variables
List the benefits of PL/SQL
Describe the basic PL/SQL block and its sections
Describe the significance of variables in PL/SQL
Declare PL/SQL variables
Execute a PL/SQL block

Writing Explicit Cursors
Distinguish between an implicit and an explicit cursor
Use a PL/SQL record variable
Write a cursor FOR loop

Advanced Explicit Cursor Concepts
Write a cursor that uses parameters
Determine when a FOR UPDATE clause in a cursor in required
Determine when to use the WHERE CURRENT OF clause
Write a cursor that uses a subquery

Writing Basic SQL Statements
List the capabilities of SQL SELECT statements
Execute a basic SELECT statement
Differentiate between SQL statements and SQL*Plus commands

Restricting and Sorting Data
Limit the rows retrieved by a query
Sort the rows retrieved by a query

Displaying Data from Multiple Tables
Write SELECT statements to access data from more than one table by using equality and nonequality joins
View data that generally does not meet a join condition by using outer joins
Join a table to itself

Single Row Functions
Describe the various types of functions available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of conversion functions

Writing Executable Statements
Describe the significance of the executable section
Write statements in the executable section
Describe the rules of nested blocks
Execute and test a PL/SQL block
Use coding conventions

Interacting with the Oracle Server
Write a successful SELECT statement in PL/SQL
Declare the datatype and size of a PL/SQL variable dynamically
Write DML statements in PL/SQL
Control transactions in PL/SQL
Determine the outcome of SQL DML statements

Handing Exceptions
Define PL/SQL exceptions
Recognize unhandled exceptions
List and use different types of PL/SQL exception handlers
Trap unanticipated errors
Describe the effect of exception progagation in nested blocks
Customize PL/SQL exception messages

Subqueries
Describe the types of problems that subqueries can solve
Define subqueries
List the types of subqueries
Write single-row and multiple-row subqueries

Multiple-Column Subqueries
Write multiple-column subqueries
Describe and explain the behavior of subqueries when null values are retrieved
Write subqueries in a FROM clause

Producing Readable Output with iSQL*Plus
Produce queries that require a substitution variable
Produce more readable output
Create and execute script files

Manipulating Data
Describe each DML statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Merge rows in a table
Control transactions

Including Constraints
Describe constraints
Create and maintain constraints

Oracle Architectural Components
Describe the Oracle architecture and its main components
Describe the structures involved in connecting a user to an Oracle instance

Getting Started With the Oracle Server
Identify common database administrative tools available to a DBA
Identify the features of the Oracle Universal Installer
Explain the benefits of Optimal Flexible Architecture
Set up password file authentication
List the main components of the Oracle Enterprise Manager and their uses

Maintaining the Control File
Explain the uses of the control file
Describe the contents of the control file
Multiplex and manage the control file
Manage the control file with Oracle Managed Files
Obtain control file information

Managing Tablespaces and Data files
Describe the logical structure of tablespaces within the database
Create tablespaces
Change the size of the tablespace
Allocate space for temporary segments
Change the status of tablespaces
Change the storage settings of tablespaces
Implement Oracle Managed Files

Managing Tables
Identify the various methods of storing data
Describe Oracle data types
Distinguish between an extended versus a restricted ROWID
Describe the structure of a row
Create regular and temporary tables
Manage storage structures within a table
Reorganize, truncate, drop a table
Drop a column within a table

Managing an Oracle Instance
Create and manage initialization parameter files
Configure OMF
Start up and shut down an instance
Monitor the use of diagnostic files

Creating a Database
Describe the prerequisites necessary for database creation
Create a database using Oracle Database Configuration Assistant
Create a database manually

Maintaining Redo Log Files
Explain the purpose of online redo log files
Describe the structure of online redo log files
Control log switches and checkpoints
Multiplex and maintain online redo log files
Manage online redo log files with OMF

Storage Structure and Relationships
Describe the logical structure of segments within the database
Describe the segment types and their uses
List the keywords that control block space usage
Obtain information about storage structures from the data dictionary

Managing Undo Data
Describe the purpose of undo data
Implement Automatic Undo Management

Managing Indexes
Describe the different types of indexes and their uses
Create various types of indexes
Reorganize indexes
Drop indexes
Get index information from the data dictionary
Monitor the usage of an index

Data Dictionary Content and Usage
Identify key data dictionary components
Identify the contents and uses of the data dictionary
Query the data dictionary

Managing Password Security and Resources
Manage passwords using profiles
Administer profiles
Control use of resources using profiles
Obtain information about profiles, password management and resources
Managing Users
Create new database users
Alter and drop existing database users
Monitor information about existing users
Managing Privileges
Identify system and object privileges
Grant and revoke privileges
Identify auditing capabilities
Managing Roles
Create and modify roles
Control availability of roles
Remove roles
Use predefined roles
Display role information from the data dictionary
Maintaining Data Integrity
Implement data integrity constraints
Maintain integrity constraints
Obtain constraint information from the data dictionary
Using Globalization Support
Choose database character set and national character set for a database
Specify the language- dependent behavior using initialization parameters, environment variables and the ALTER SESSION command
Use the different types of National Language Support (NLS) parameters
Explain the influence on language-dependent application behavior
Obtain information about Globalization Support usage

Oracle9i Performance Tuning
Describe the roles associated with the database tuning process
Describe the dependency between tuning in different development phases
Describe service level agreements
Describe appropriate tuning goals
Describe the most common tuning problems
Describe the tuning considerations during development and production
Describe performance and safety tradeoffs
Sizing the Buffer Cache
Describe how the buffer cache is used by different Oracle processes
Describe the tuning issues related to the buffer cache
Monitor the use of the buffer cache, also the different pools within the buffer cache
Implement dynamic SGA allocation
Set the DB_CACHE_ADVICE parameter
Create and size multiple buffer pools
Detect and resolve free list contention
Sizing other SGA Structures
Monitor and size the redo log buffer
Monitor and size the java pool
Control the amount of Java session memory used by a session
Configure the instance to use I/O Slaves
Configure and use multiple DBW processors
Monitoring and Detecting Lock Contention
Define levels of locking
Describe possible causes of contention
Use Oracle utilities to detect lock contention
Resolve contention in an emergency
Prevent locking problems
Recognize Oracle errors arising from deadlocks
Using Oracle Blocks Efficiently
Describe the correct usage of extents and Oracle blocks
Explain space usage and the high water mark
Determine the high water mark
Recover space from sparsely populated segments
Describe and detect chaining and migration of Oracle blocks
Perform index reorganization
Monitor indexes to determine usage
Diagnostic and Tuning Tools

Explain how the alert.log file is used
Explain how background trace files are used
Explain how user trace files are used
Describe the statistics kept in the dynamic performance views
Explain how StatsPack collects statisticsd
Collect statistics using StatsPack
Collect statistics using Enterprise Manager
Use other tuning tools
Database Configuration and I/O Issues
Explain the advantages of distributing different Oracle file types
Describe reasons for partitioning data in tablespaces
Diagnose tablespace usage problems
Describe how checkpoints work
Monitor and tune checkpoints
Monitor and tune redo logs
Optimize Sort Operations
Describe how sorts are performed
Identify the SQL operations which require sorts
Differentiate between disk and memory sorts
Create and monitor temporary tablespaces

Reduce total sorts and disk sorts
Determine the number of sorts performed in memory
Set old and new sort parameters

Tuning Oracle Shared Server
Identify issues associated with managing users in a Shared Server environment
Diagnose and resolve performance issues with Oracle Shared Server processes
Configure the Oracle Shared Server environment to optimize performance
Application Tuning
Describe the role of the DBA in tuning Applications
Explain different storage structures, and why one storage structure may be preferred over another
Explain the different types of indexes
Explain Index Organized Tables
Describe partitioning methods
Explain the use of the DBMS_STATS procedure
Describe Materialized Views and use of Query Rewrites
List requirements for OLTP, DSS and Hybrid Systems
SQL Statement Tuning
Describe how the Optimizer is used
Explain the concept of plan stability
Use stored outlines
Describe how hints are used
Use SQL Trace and TKPROF
Collect statistics on indexes and tables
Describe the use of histograms
Copy statistics between databases
Sizing the Shared Pool
Measure and tune the library cache hit ratio
Measure and tune the dictionary cache hit ratio
Size and pin objects in the shared pool
Tune the shared pool reserve space
Describe the UGA and session memory considerations
Explain other tuning issues related to the shared pool
Set the large pool
Diagnosing Contention For Latches
Describe the purpose of latches
Describe the different types of latch request
Diagnose contention for latches
Tune the appropriate resources to minimize latch contention
Tuning the Operating System and Using Resource Manager
Describe different system architectures
Describe the primary steps of OS tuning
Identify similarities between OS and DB tuning
Understand virtual memory and paging
Explain the difference between a process and a thread
Set up Database Resource Manager
Assign users to Resources Manager groups
Create resource plans within groups

Networking Overview
Explain solutions included with Oracle9i for managing complex networks
Describe Oracle networking add-on solutions

Basic Oracle Net Architecture
Explain the key components of the Oracle Net layered architecture
Explain Oracle Net Services role in client server connections
Describe how web client connections are established through Oracle networking products

Backup and Recovery Overview
Describe the basics of database backup, restore and recovery
List the types of failure that may occur in an Oracle environment
Define a backup and recovery strategy

Instance and Media Recovery Structures
Describe the Oracle processes, memory structures, and files relating to recovery
Identify the importance of checkpoints, redo log files, and archived log files
Describe ways to tune instance recovery

Oracle Recovery Manager Overview and Configuration
Identify the features and components of RMAN
Describe the RMAN repository and control file usage
Describe channel allocation
Describe the Media Management Library interface
Connect to RMAN without the recovery catalog
Configure the RMAN environment

User-Managed Complete Recovery
Describe media recovery
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived redo log files
Describe read-only tablespace recovery

Recovery Catalog Creation and Maintenance
Describe the contents of the recovery catalog
Create the recovery catalog
Maintain the recovery catalog by using RMAN commands
Use RMAN to register, resynchronize, and reset a database
Query the recovery catalog to generate reports and lists
Create, store, and run scripts
Describe methods for backing up and recovering the recovery catalog

Basic Net Server-Side Configuration
Identify how the listener responds to incoming connections
Configure the listener using Oracle Net Manager
Control the listener using the Listener Control Utility (lsnrctl)
Describe Dynamic Service Registration
Configure the listener for IIOP and HTTP connections

Basic Oracle Net Services Client-Side Configuration
Describe the difference between host naming and local service name resolution

Configuring the Database Archiving Mode
Describe the differences between Archivelog and Noarchivelog modes
Configure a database for Archivelog mode
Enable automatic archiving
Perform manual archiving of logs
Configure multiple archive processes

Configure multiple destinations, including remote destinations

Oracle Recovery Manager Overview and Configuration
Identify the features and components of RMAN
Describe the RMAN repository and control file usage
Describe channel allocation
Describe the Media Management Library interface
Connect to RMAN without the recovery catalog
Configure the RMAN environment
Perform recovery in Noarchivelog mode
Perform complete recovery in Archivelog mode
Restore datafiles to different locations
Relocate and recover a tablespace by using archived redo log files

Transporting Data Between Databases
Describe the uses of the Export and Import utilities
Describe Export and Import concepts and structures
Perform simple Export and Import operations
List guidelines for using Export and Import

User-Managed Incomplete Recovery
Describe the steps of incomplete recovery
Perform an incomplete database recovery
Identify the loss of current online redo log files
Basic Oracle Net Services Client-Side Configuration
Describe the difference between host naming and local service name resolution
Use Oracle Net Configuration Assistant to configure: Host Naming, Local naming method, Net service names
Perform simple connection troubleshooting
Usage and Configuration of the Oracle Shared Server
Identify the components of the Oracle Shared Server
Describe the Oracle Shared Server architecture
Configure the Oracle Shared Server
Identify and explain usefulness of related dictionary views

RMAN Backups
Identify types of RMAN specific backups
Use the RMAN BACKUP command to create sets
Back up the control file
Back up the archived redo log files
Use the RMAN COPY command to create image copies

RMAN Incomplete Recovery
Perform an incomplete database recovery using UNTIL TIME
Perform an incomplete database recovery using UNTIL SEQUENCE

RMAN Maintenance
Perform cross checking of backups and copies
Update the repository when backups have been deleted
Change the availability status of backups and copies
Make a backup or copy exempt from the retention policy
Catalog b ackups made with operating system commands

RMAN Complete Recovery
Describe the use of RMAN for restoration and recovery

Loading Data into a Database
Demonstrate usage of direct- load insert operations
Describe the usage of SQL*Loader
Perform basic SQL*Loader operations
List guidelines for using SQL*Loader and direct-load insert