Dot NET Training Description

Course Description:- In Dot net training we are covered five modules VB.NET, ASP.NET, C#, XML, SQL2000

Course Content of VB.NET
" List the major elements of the .NET Framework and describe some of the major enhancements to the new version of Visual Basic
" Describe the basic structure of a Visual Basic .NET project and use the main features of the integrated development environment (IDE)
" Use the new language features and syntax in Visual Basic .NET
" Explain the basic concepts and terminology of object-oriented design specifically for Visual Basic .NET
" Explain and use the basic concepts and terminology of Object-Oriented programming in Visual Basic .NET
" Create applications by using Microsoft Windows Forms
" Create Internet applications that use Web Forms and Web Services
" Create applications that use ADO .NET
" Create components in Visual Basic .NET
" Set up and deploy various types of Visual Basic .NET-based applications
" Prepare existing Visual Basic-based applications for upgrade to Visual Basic .NET.

Course content of ASP.NET
" Describe the key differences between ASP and ASP.NET
" Create an ASP.NET Web application by using Microsoft Visual Studio® .NET.
" Create an ASP.NET Web application user interface.
" Use the Microsoft .NET-based programming languages for developing ASP.NET Web applications.
" Use the trace feature of ASP.NET to get information about executed requests. Use the Visual Studio .NET debugger to debug ASP.NET Web applications. Access databases in an ASP.NET Web application by using Microsoft ADO.NET.
" Access and display Extensible Markup Language (XML) data in an ASP.NET Web application.
" Create and call a COM object from an ASP.NET Web page.
" Explain how XML Web Services is beneficial to distributed Internet computing.
" Create an XML Web Service by using Visual Studio .NET.
" Create client code that can create and call a remote XML Web Service.
" List server- and client-side state management techniques and explain how ASP.NET improves state management.
" Use the ASP.NET Application object to track data that is associated with an ASP.NET Web application.
" Use the ASP.NET Session object to track data that is associated with an individual user session.
" Use the ASP.NET HttpCookie object to store client-side data.
" Explain what approach would be the best for migrating that ASP application to ASP.NET, given a specific ASP application scenario.
" Implement Forms-based authentication in an ASP.NET Web application.
" Prepare an ASP.NET Web application for deployment

Course contents of C#
" List the major elements of the .NET Framework and explain how C# fits into the .NET Platform.
" Analyse the basic structure of a C# application and be able to document, debug, compile, and run a simple application.
" Create, name, and assign values to variables.
" Use common statements to implement flow control, looping, and exception handling.
" Create methods (functions and subroutines) that can return values and take parameters.
" Create, initialise, and use arrays.
" Explain the basic concepts and terminology of object-oriented programming.
" Use common objects and references types.
" Create, initialise, and destroy objects in a C# application.
" Build new C# classes from existing classes.
" Create self-contained classes and frameworks in a C# application.
" Define operators, use delegates, and add event specifications.
" Implement properties and indexers.
" Use predefined and custom attributes.
Course Contents of XML
" Overview of XML Documents
" Overview of XML Technologies
" Generating XML Data from a Database
" Displaying an XML Document Using XSL
" Introduction to Transforming XML with XSLT
" Write XSLT style sheet templates
" Embedding XML Data in HTML
" Manipulating XML Data on the Client Using the DOM
" Transforming XML with XSL Programmatically
" Posting XML Data from Client to Server
" Validating XML Using Schemas
" Introduction to SOAP and XML Web Services

DIPLOMA IN MULTIMEDIA AND ANIMATION

Course Duration:- 1 Year
Course Fee:- Rs 10000 Per Semester
Course Contents:-
1st Semester
1. Basic Computers
2. Computer Graphics
3. Digital Imaging -1
4. Introduction to 2D Animation
5. Computer Graphics
6. Line art & Drawing
7. Digital Imaging - 2
8. 3D Modeling -I
9. 3D Animation -I
10. Camera Work Lighting
2nd Semester
1. 3D Modeling -II
2. 3D Animation -II
3. Sound Editing Technique
4. Character Animation
5. Audio Video Editing
6. Video garbing & Broadcast Tech.
7. Audio and video Special Effect
8. Morphing and Wrapping
9. Film Communication
10. Final Project.

Certificate in AutoCAD
Course Fee:-8000/-
Course Duration:- Two Months
Course Details:
This course is aimed at those wishing to learn how to use the latest version of the world's leading desktop draughting and design package. The course examines all 2D aspects of the package, from setting up, through creating and editing designs, to dimensioning and laying out designs ready for plotting. All topics are taught through hands-on exercises and the training material includes a giving you the opportunity to try them out in your own time.

Course structure
" Starting a new drawing
" Understanding the user interface
" Creating template drawings
" Creating and managing layers
" Controlling the display - zoom, pan, stored views
" Coordinate entry - absolute, relative and polar coordinates
" Creating basic objects - lines, arcs, circles, rectangles, polygons, construction lines, donuts, ellipses,
" Using object snapping
" Manipulating the user coordinate system
" Extracting drawing information - distance, point, entity location
" Creating selection sets for editing objects
" Editing commands - move, copy, offset, array, mirror, rotate, scale, stretch, lengthen, trim, fillet, break
" Using grips for editing
" Annotating drawings, creating text styles
" Hatching - creating and editing
" Dimensioning - creating dimensions and dimension styles
" Creating and managing blocks
" Managing the multiple design environment
" Using AutoCAD Design Centre
" Plotting a drawing

Advance AutoCAD
Course Fee:- 10000/-
Course Duration:-Two Months
Course description
This level II course goes beyond the basics of AutoCAD and explores topics such as surface modeling, solid modeling, attribute extraction and model space/paper space plotting. Candidates for this course will be expected to have a good working knowledge of the 2D draughting commands and will preferably have attended the Level I course.
Course breakdown
" Paper Space Layouts
" Advanced Plotting Features
" Design Publishing
" Drawing Security
" Text Tools
" Advanced Dimensioning
" Block Tools & Attributes
" External references
" Reference Manager
" CAD Standards
" Layer Tools
" Isometric Drawing
" Intro to 3D Modeling

Course Title: - DTP (Desktop Publishing)
Course Duration:- 3 Months
Course Fee:- 6000/-
Course Description:-
DTP Contain flowing three software packages:-
1. Adobe PhotoShop
2. Adobe PageMaker
3. Corel Draw

Adobe Photoshop:- In this course, students learn to use tools for selecting parts of images, and move, duplicate, and resize images. Students also learn to use layers, and to apply layer effects and filters to create special effects, including lighting and texture effects.

Identify the differences between raster and vector graphics
Identify Photoshop environment elements; and navigate in the Photoshop environment.
Select appropriate resolutions for different image and output types; and resize and crop image areas.
Select image areas using the Lasso, Marquee, and Magic Wand tools; and use alpha channels to save and load selections. Create and manipulate multiple layers to composite images easily.
Apply blending and shading effects to create realistic composites.
Identify the image mode characteristics, channels and bit depth;
Identify attributes that distinguish grayscale mode from bitmap mode;
and identify attributes that distinguish each color mode. - Select colors using the Color palette, Color Picker, and Eyedropper tool;
Use Photoshop painting tools to create artwork or to retouch photographs; and use the Clone Stamp tool to duplicate parts of an image.
Add and format text within an image; apply layer effects and filters to create special effects including lighting effects and textures; and merge layers.
Modify the brightness, contrast, color balance, hue, and saturation of images.
Save images in file formats for use with other applications and the Web.

Adobe PageMaker :- In this course, you will learn basic techniques and skills as you create a four-page color newsletter that will give you a solid understanding of how to create professional publications using Adobe PageMaker software.
Document Creation
A tour of the work area; Creating a new publication; Setting up horizontal and vertical rulers; Working with guides; Specifying columns; Importing, formatting and positioning text and graphic elements; Working with colour and colour tints; Using the drawing tools; Printing as a PDF
Working with Type
Paragraph specifications; Column breaks; Attaching rules to text; Using the control palette; Using Tracking and Kerning; Creating and importing style sheets; Resizing, reflecting and rotating a text block
Images
Types of images; Positioning images in publications; Cropping and distorting images; Image control; Lines, rectangles, circles and polygons; Images and text; Text flow options
Templates
Setting a default measurement system; Setting template column and guides; Creating, saving and opening a template; Selecting and applying spot colours; Creating a tint of a spot colour; Creating a custom colour palette; Grouping and ungrouping objects; Looking at printing options
Layout and Master Pages
Creating a master page; Adding tints and colours to the Colour palette; Using the Control palette to manipulate objects; Specifying automatic page numbering; Autoflowing text; Kerning and tracking text; Creating and editing custom styles
Text and Graphics
Shape Fills; Reshaping shapes; Align and distribute shapes; Grouping objects; Image lightness and contrast controls; Handling text flow; Flowing text around graphics; Graphic libraries; Creating special effects
Layers and Frames
Working with and creating layers; Adding, moving and naming layers; Reversing text out of a frame; Creating a polygon frame; Placing text and graphics within frames; Converting shapes to frames; Threading frames; Placing an in-line graphic; Custom text wrap around frames
Advanced Layout
Working with different publication sizes; Creating columns of unequal width; Controlling column breaks; Creating custom justification and hyphenation; Setting a grid and creating custom rules; Using the Add Cont'd Line plug-in; Using the Bullets and Numbers plug-in; Using Adjust Layout options to change a master page; Using the Story Editor to find and replace; Using the library palette; Preparing files for a pre-press service provider
Book Compilation; Setting up a multi-chapter book; Working with headers and footers; Creating a book list; Inserting index markers; Indexing with Find and Change; Adding a cross-reference; Creating and formatting an index; Creating a table of contents
Web Publication
Add and edit hyperlinks; Export to a PDF ; Prepare text for HTML export; Associating PageMaker formats with HTML formats; Prepare graphics for HTML export; Export the publication to HTML; Preview the publication in a Web browser; Upload the publication to a web server
PDF Web Publication
Create and use hyperlinks for a PDF publication; Generate an automatic hyperlinked table of contents; Add hyperlinks to a master page; Create a hyperlink between two PDF files; Create invisible hyperlinks; Create an image map; Link to a movie; Link to a URL on the Web; Export as a web optimised PDF

Corel Draw: - When you complete this course you will be able to draw and manipulate graphics. New features include vector illustration, layout, bitmap creation, image-editing, and painting and animation software

Administering a Microsoft SQL Server 2000 Database Fee:- 8000/-
This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server™ 2000. The course content is being revised to reflect changes in the product.

Course Outline
Module 1: SQL Server Overview
Take a closer look: Download Sample Module 1 (Portable Document Format, 990 KB).
The following topics are covered in this module:
o What Is SQL Server
o SQL Server Integration
o SQL Server Databases
o SQL Server Security
o Working with SQL Server

The following lab is covered in this module:
o SQL Server Overview
Module 2: Planning to Install SQL Server
The following topics are covered in this module:
o Hardware Installation Considerations
o SQL Server 2000 Editions
o Software Installation Considerations
o Methods of Installing SQL Server
o Verifying the Installation
o Configuring SQL Server Enterprise Manager
o Troubleshooting
The following lab is covered in this module:
o Installing SQL Server
Module 3: Managing Database Files
The following topics are covered in this module:
o Introduction to Data Structures
o Creating Databases
o Managing Databases
o Placing Database Files and Logs
o Optimizing the Database Using Hardware-based RAID
o Optimizing the Database Using Filegroups
o Optimizing the Database Using Filegroups with Hardware-based RAID
o Capacity Planning
o Performance Considerations

The following lab is covered in this module:
o Managing Database Files
o Describe how SQL Server stores data and handles transactions.
o Create a database, including specifying options during and after database creation.
o Grow, shrink, or delete a database.
o Determine the placement of database files and transaction logs for performance and fault tolerance.
o Optimize a database by using hardware-based RAID.
o Determine when and how to use filegroups to optimize a database.
o Optimize a database by using filegroups with hardware-based RAID.
o Estimate the amount of space that a database requires.

Module 4: Managing Security
The following topics are covered in this module:
o Implementing an Authentication Mode
o Assigning Logins to Users and Roles
o Assigning Permissions to Users and Roles
o Managing Security Within SQL Server
o Managing Application Security
o Managing SQL Server Security in the Enterprise

The following labs are covered in this module:
o Managing Security
o Managing Permissions
o Managing Application Security

At the end of this module, you will be able to:
o Implement Windows Authentication Mode and Mixed Authentication Mode.
o Assign login accounts to database user accounts and roles.
o Assign permissions to user accounts and roles.
o Manage security within SQL Server.
o Manage security with views and stored procedures.
o Create and use application roles to manage application security.
o Manage SQL Server security in the enterprise environment.

Module 5: Performing Administrative Tasks
The following topics are covered in this module:
o Configuration TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance TasksCreating AlertsTroubleshooting SQL Server AutomationAutomating Multiserver Jobs
o Configuring SQL Server
o Creating Jobs and Operators
o Creating Alerts

Module 6: Backing Up Databases
The following topics are covered in this module:
o Preventing Data Loss
o Setting and Changing a Database Recovery Model
o SQL Server Backup
o When to Back Up Databases
o Performing Backups
o Types of Backup Methods
o Planning a Backup Strategy
o Performance Considerations
The following lab is covered in this module:
o Backing Up Databases
o Create backup files and backup sets.
o Back up user and system databases by using Transact-SQL and SQL Server Enterprise Manager.
o Back up databases that are created on multiple files and filegroups.
o Apply the appropriate backup options to each of the different SQL Server 2000 backup methods.
o Use the BACKUP LOG statement to back up and clear transaction logs.
o Design an appropriate backup strategy.
Module 7: Restoring Databases
The following topics are covered in this module:
o SQL Server Recovery Process
o Preparing to Restore a Database
o Restoring Backups
o Restoring Databases from Different Backup Types
o Restoring Damaged System Databases
The following lab is covered in this module:
o Restoring Databases
Module 8: Monitoring SQL Server for Performance
The following topics are covered in this module:
o Why to Monitor SQL Server
o Performance Monitoring and Tuning
o Tools for Monitoring SQL Server
o Common Monitoring and Tuning Tasks
Module 9: Transferring Data
The following topics are covered in this module:
o Introduction to Transferring Data
o Tools for Importing and Exporting Data in SQL Server
o Introduction to DTS
o Transforming Data with DTS
Module 10: Maintaining High Availability
The following topics are covered in this module:
o Introduction to Availability
o Increasing Availability Using Failover Clustering
o Standby Servers and Log Shipping
The following lab is covered in this module:
o Automating the Maintenance of a Standby Server
Module 11: Introducing Replication
The following topics are covered in this module:
o Introduction to Distributed Data
o Introduction to SQL Server Replication
o SQL Server Replication Agents
o SQL Server Replication Types
o Physical Replication Models
The following lab is covered in this module:
o Implementing Replication

Course: - Flash MX
Course Fee: - 6000/-
Duration:-2Months
Flash MX Flash Overview
Recognize the basics of Flash animation
Recognize the Flash work environment
Use Tools, panels, and menus
Create keyboard shortcuts
Work with frames, keyframes, layers, and scenes
Use the Color options
Organize objects
Import graphics
Create, modify and use symbols
Create basic animation using individual keyframes
Flash MX Animation
Distinguish frame types
Create Shape and Motion tweens
Identify object properties that can be tweened
Describe the advantages of tweening
Orchestrate the dynamic object elements
Flash MX Text and Forms
Format text
Animate text blocks
Create micro-animations and graphic text
Morph text
Create an animated text banner
Flash MX Coordinated Animations
Plan and organize a Flash movie
Create and control a compound object
Create and organize scenes
Create and edit movie clips
Create and use masks
Flash MX Sound and Music
Select sounds for recording
Import sound files into a movie
Apply sounds to buttons
Modify sounds by looping and streaming
Create a music video

Course: -Dream weaver
Course Duration:- 2 Months
Fee: - 6000/-
Lesson 1
The Basics of Building a Site
· Combining Windows
· Creating a New Site or Connecting to an Existing Site
· Import Text from MSWord
· Using the Quick Tag Editor
Lesson 2
Working with Frames
· An Easy Way to Create Frames
· An Easier Way to Create Frames
· The Easiest Way to Create Frames
· No frames Content
Lesson 3
Adding "Behaviors"
· Swapping an Image
· Perform a Browser Check
· Adding New Behaviors
Lesson 4
Inserting Media
· Inserting Java Applets
· Inserting Shockwave and Flash Movies
· Using Other Editors
Lesson 5
Managing Your Site
· Linking to Your Remote Site
· Checking In and Checking Out Documents
· Synchronizing Your Files
Lesson 6
Other Dream weaver 3 Timesavers
· Creating HTML Stylesk
· Automating Repetitive Tasks
· Using Design Notes

Course :-ASP(Active server Page) Fee:-4000
Behind the Scenes-How Active Server Pages Work
Introduction to IIS
ASP Requirements
HTML Basics
Intrinsic ASP Objects
The Response Object
The Request Object
The Application and Server Objects
The Session Object
Writing Server-side Code
Introduction to VBScript
Introduction to JScript
The Scripting Dictionary Object
File Access with ASP
Debugging ASP and Error-Handling
Using Components
The Browser Capabilities Component
Other ASP Components
Sending and Receiving Email with ASP
Accessing Databases with ASP and ADO
Introduction to Relational Databases and SQL
Introduction to ADO
Accessing Data with ADO
Controlling Transactions in ASP
ASP Applications
Introduction to ASP Applications
State Maintenance in ASP Applications
Controlling Access and Monitoring
Planning Applications

JavaScript Programming Fee:- 4000/-
Getting Started
JavaScript Overview
JavaScript Programming Basics
Variables and Operators
Variables and Data Types
Using Variables and Literals
Operators
Control Statements
Controlling the flow: JavaScript Control Statements
Functions and Objects
Functions
Objects
The Window Object
The Window Object
Dialog Boxes
Status Bar Messages
Window Manipulations
The Document Object
The Document Object
Writing to Documents
Dynamic Documents
Working with Frames
HTML Frames Review
Scripting for Frames
Working with Forms and Forms-based Data
The Form Object
Working With Form Elements and Their Properties
The String and RegExp Objects
The String Object
Using String Object Methods to Correct DataEntry Errors
Creating Dynamic Effects With Substring Methods
The RegExp Object
Validating Form Data
Form Validation: A Process
Testing Data
Preparing Data for Validation and Reporting Results
Validating Non-text Form Objects
Dates and Math
The Date Object
Using and manipulating Dates
The Math Object
Doing Math with JavaScript
Introduction to Cross-browser Compatibility
Examining the Compatibility Landscape
Detecting Browser and Platforms

FrontPage XP Web site designing courses Fee:-3000/-
Duration: - 1 Month
Introduction
Working with Navigation View
FrontPage Editor
Creating & Formatting Web Pages
Importing & Formatting Images
Hyperlinks, Tables
Using Plug-ins & Applets
Image & applying image effects
Input Forms
Orchestrating your Web page
Templates & Wizard
DHTML Effects

Advance Java Fee:-8000/-
Core Java
I/O Packages
Networking with Java (Socket Programming)
Interfacing
Threading & Multi-Threading
Class & Method
GUI
JDBC
Java IDL
Exception Handling
String & String Buffer
Using Images & Audio Clips
Java Applications Java courses (Part 1)
Defining Classes
Creating Instances & Class Variables
Defining Instance Variables
Creating Methods
Creating Java Applications
Passing Arguments to Java Programming
Creating Methods with the Same Name, Different Arguments
Constructor Methods
Finalizer Methods

Java Language, Utility & I/O Packages Java courses
Java Fundamental Classes
The Object Class
Data Type Wrapper Classes
Math Class
String Class
System related Classes
Thread Classes
Class Classes
Exception Handling Classes
Java Utility Classes
Date Class
Data Structure Classes
File & Input/Output manipulation in Java
The Input Stream Class
Byte ArrayInputStream Class
FileInputStream Class
Buffered IO
DataInputStream Class
Random AccessFile Class
Serialization
Networking in Java Java courses
Introduction
Connection Oriented v/s.
Connectionless Communications
Java .NET Package
Constructors
Methods
Class InetAddress
Class ServerSockets
Class Socket
Class Socketlmpl
URL Class
Class URL Connection
Interface Content Handler Factory
Class URL Stream Handler
Class Malformed URL Exception
Class ProtocolException
Creating Links Inside Applets
Opening Web connections
Socket Programming
Java Applets Java courses
Introduction
Creating Applets
Applet Life cycle
Security Issues
Applet Capabilities
Applet Attributes for Positioning
Applet Attributes for Code
Sending messages to other Applets
Finding an Applet by Name -The getApplet() Method
Playing Sound in an Applet
Pre-made UI Components
Threads Java courses (Part 1)
What are Threads & why use them?
Writing Applet with Threads
Java Exceptions
The Finally Clause
Multi-Threading
Creating & using Threads
The Runtime Interface
Thread Tester
Thread Scheduling

GUI Java courses
Graphic User Interface Java courses (Part 1)
The Graphic Class
Text & Fonts
Font Objects
Color
3D Graphic
Swing Features
Layout Management
Event Handling
Panels
Frames
Layout
Swing Menus
JDBC Java courses
(Java Database Connectivity)
Introduction
Relational Databases
Using JDBC
JDBC Architecture
SQL- Structured Query Language
Establishing a Connection
Creating JDBC Statements
Database Concepts
Applications
Inserting & Deleting Rows
Making Batch Updates

VB Script Java VB ASP scripting courses
Fundamentals of VB Script
(Use in corporate Intranet)
Working with Operators, DLL
Controlling the flow of VB Script Code
Functions & Procedures
Error Handling
Scripting Model
ActiveX Controls
Access file system on client's machine
Java Script
Where does JavaScript fit in?
Difference between Java & JavaScript
Using JavaScript in HTML
JavaScript Event Handlers
Programming Constructs
(If-Else, Loops, Arrays, etc.)
JavaScript Object Hierarchies
Creating on-the-fly Documents
Creating & Submitting Forms
Image Objects
Methods, Properties
Working with Scrollbars, Frames, etc.
Cookies, Links

ASP
(Active Server Pages)
Creating Web pages dynamically with ASP
Features: ADO (ActiveX Data Objects)
Server Side Scripts, Working with Files
Object & Components

Oracle 9i RDBMS databases courses
Overview, Introduction to RDBMS
JAVA in Oracle 9i
SQL Embedded in Java
Java Stored Procedures
Definer & Invoker's RightMode
DDL/ DML/ DOL
Features of ORDBMS
Materialized Views
Front-end Applications RDBMS databases courses
(like DAO, ADO, RDO, OLE, DLL, ActiveX) RDBMS databases courses
(topics as applicable by the name)
PL/SQL RDBMS databases courses
Features
Block Structures & Constructs
Procedures & Functions
Packages
Event Driven Database Level Triggers
OAS & Web PL/SQL RDBMS databases courses
Oracle Application Server (Administration)
Introduction to PL/SQL Web Applications
Creating a Web page with HTML
Using PL/SQL Web Toolkit
Building Dynamic Forms
Creating Dynamic Forms
Creating Display Areas with Frames
Advance Java/J2EE (frame work)
General
A Detailed Comparison of CORBA, DCOM and Java/RMI
MTS vs. EJB (with specific code examples)
JDO vs. EJB
Enterprise Java Beans (EJB)
What is Enterprise Java Beans
Modeling using Session and Entity Beans
Developing Entity Beans
Developing Session Beans
Developing an EJB Client
Developing an EJB Servlet Client
Coding Bean Managed Persistence (BMP) into Entity EJBs

Java Message Service (JMS)
Overview of java message service
Jini Technology
What is Jini
Coding a Simple Jini Service
Coding a Simple Jini Client
Remote Method Invocation (RMI)
What is Java-RMI
Java RMI - Under the Hood
Coding a Java RMI Server
Coding a Java RMI Client
Getting RMI to work on MS-IE & Netscape
Java Server Pages (JSP), JavaMail
Developing using JSP, the Servlets API and the Java Mail API
Developing the EmailSend.jsp page
Developing the EmailSendServlet class
Developing the SendMultipartMessage JavaBean
Developing the EmailContents JavaBean
Developing the EmailContents.jsp response page
Developing the EmailSendError.html - Generic Error Page
JavaBeans
The Java 1.1 Event Model
Serialization
Introspection and Reflection
Property Editors
Customizers
Steps to write your own Bean
Threading in Java
Threading and Concurrency
Pipes
Network Programming in Java
Sockets
Network Clients & Servers
Multicasting

Oracle 9i Fee:-10000/-
Course Contents:
Brief overview of Oracle architecture
Components of an Oracle database
Introduction to performance tuning goals and activities
Understanding Oracle alerts and trace files
Interpreting the diagnostic information
Utilities and dynamic performance views
Interpreting the system level and session level tuning statistics
SQL Tuning
Analysing SQL performance
Using Explain Plan and SQL*Trace
Indexing considerations
Various types of indexes in Oracle
Using hints
Tuning the queries for optimal performance
Tuning the schema
Using clusters and hash clusters
Tuning the SGA
Tuning the data dictionary cache
Tuning the shared pool area
Tuning the redo log buffer
Tuning the I/O contention
Understanding tablespaces and data files
Recommended division of data files across volumes
Identifying migrated and chained rows
Eliminating migration and chaining
Removing fragmentation
Tablespace fragmentation
Freespace fragmentation
Optimising storage
Using Oracle blocks efficiently
Optimising sort operations
Identifying operations which invoke sort operations
Tuning the sort parameters
Tuning rollback segments
Deciding the number and size of rollback segments
Handling the "segment too old" problem
Monitoring and detecting lock contention
Understanding DML and DDL lock attributes
Identifying situations that lead to lock contention
Latch tuning
Latch contention issues
Oracle 9i Database Administration Course Fee:-16000/-
Course Contents:
Introduction to Oracle DBA concepts
Role of the DBA
Components of an Oracle database
Data files, control files and redo log files
Initialization parameter file
Creating a database
Creating data dictionary views
Starting and shutting down a database
Oracle architecture
Components of the SGA
Database processes
Data dictionary tables and views
Static and dynamic data dictionary views
Managing database users
Managing user passwords
Profiles
Managing database security
User roles
Enabling and disabling roles
Object privileges
System privileges
Multiplexing control files
Backing up control files
Managing redo log files
Archiving redo log files
Multiplexing redo log files
Managing disk space
Managing tablespaces
Managing temporary segments
Segments and extents
Storage parameters
Managing undo space
Understanding transactions
Working with tables and indexes
Analyzing tables for statistics and integrity
Compressed indexes
Bitmap indexes
Backup and recovery
Logical backups
Physical backups
Recovery strategies
Recovery case studies
Performance tuning and optimization
Turning the SGA
Tuning disk resources
Tuning for resource contention
Query optimization
Auditing database use
Login audits
Auditing actions on database objects
Auditing system privileges
Data Warehousing
Course Contents:
Overview of Business Intelligence applications
Data Warehouse Design - Presenting Concepts
Data Warehouse Design - Discussing Business Cases
Data Warehouse Design - Exercise
Data Warehouse Building - Data Extraction, Loading and
Transformation - Presenting Concepts
Analyzing Data - OLAP - Presenting Concepts
Identifying Data Needs - Exercise
Fine Tuning Design - Aggregates Building, Partitioning - Presenting
Concepts
Fine Tuning Design - Aggregates Building - Exercise
Miscellaneous Topics - System Development Life Cycle and issues,
Meta Data, Tools
Panel discussion
Demonstrating a Data Warehouse System using SQL Server
Hands-on designing and building Data Warehouse System
using SQL Server
Hands-on designing and building Data Warehouse System
using SQL Server (Cont)
Hands-on Analyzing Data Warehouse System using
OLAP - SQL Server

SQL Server 2000 Fee:- 6000/-
Course Contents:
Introduction to SQL Server
Working with tables
Creating Tables
Data types and user defined data types
Indexes
Constraints
Identity properties
Temporary tables
Querying data
The Select statement
Joins
Dealing with nulls
Subqueries
Views and derived tables
Other search expressions (like, between, etc.)
Modifying Data
Basic modification operations
Internal and performance considerations
Programming with Transact -SQL
Transact-SQL programming constructs
Batches,
Transactions
Stored procedures
Triggers
Cursors
Cursors and ISAM
Appropriate use of cursors
Cursor syntax and behavior

Red Hat Linux
1.Red Hat Essential
Course Duration:-24 Hrs
Course Fee:- 5000/-
Course Contents:-
Learn to install software, configure the network, configure authentication, and install and configure various services using graphical tools
Understand the Linux file system
Perform common file maintenance tasks
Use and customize the GNOME interface
Issue essential Linux commands from the command line
Perform common tasks using the GNOME GUI
Open, edit, and save text documents using the vi editor
File access permissions
Customize X Window System
Regular expression pattern matching and I/O redirection
Install, upgrade, delete, and query packages
Network utilities for the user
Power user utilities

2. Red Hat Linux for Administrator
Course Duration:-32 Hrs
Course Fee:-8000/-
Contents:-
What you will learn:
Install Red Hat Linux interactively and with Kickstart
Control common system hardware
Create and maintain the Linux filesystem
Configure an NFS client and autofs
Understand system and service initialization
Perform user and group administration
Integrate a workstation with an existing network running common network services
Configure a workstation as a client to NIS, LDAP, DNS, and DHCP services
Administer the Linux printing subsystem
Automate tasks with at, cron, and anacron
Maintain and interpret system logs
Back up filesystems to tape and tar archive
Install, update, query and remove software packages with RPM
Upgrade the Linux kernel via RPM
Configure the X Window System and the GNOME desktop environment
Perform basic performance, memory, and process management
Configure basic host security
Perform basic troubleshooting

3.Red Hat Linux Network service and security Admin
Course Duration:-32 hrs
Course Fee:- 8000/-
Course Details:-
Introduction to Network Services
Organizing Networked Systems
DNS Basics
Name Server Hierarchy
Server-side DNS
Berkeley Internet Name Domain (BIND)
Configuring BIND
Configuration File Basics
Address Match Lists and acl
Network File Sharing Services
Hands-on lab: Electronic Mail Services
The HTTP Service
Apache Features
Remote Service Detection
Definitions of Security
Security Policy
Service Profile: PAM
PA ication Modules
Password Security
NIS Server Topology
Configuring an NIS Server
Set User and Group ID Permissions
Typical Problematic Permissions
EXT2 Filesystem Attributes
Monitoring Data Integrity with tripwire
Configuring tripwire
System Log Files
syslogd and klogd configuration
Advanced syslogd configuration
Log File Analysis
Securing the Service
tcp_wrappers Configuration
Daemon Specification
Client Specification
OpenSSH Authentication
Protecting M Operation
Core PAM Modules
Authent Your Keys
Applications: RPM

SOFTWARE QUALITY TESTING
Course:-LOAD RUNNER
Fee:-10000/-
Duration: - 2Months
Contents:-
How do you determine if an application or system will meet the needs of the business before going live?
Are undetected application bottlenecks resulting in slowtime or downtime in production?
Are you struggling to deploy business systems smoothly, with no performance surprises?
How do you know if an application or system can scale to the desired level of usage in production?
Mercury LoadRunner® prevents costly performance problems in production by detecting bottlenecks before a new system or upgrade is deployed. You can verify that new or upgraded applications will deliver intended business outcomes before go-live, preventing over-spending on hardware and infrastructure. It is the industry-standard load testing solution for predicting system behavior and performance, and the only integrated load testing, tuning, and diagnostics solution in the market today. With LoadRunner web testing software, you can measure end-to-end performance, diagnose application and system bottlenecks, and tune for better performance-all from a single point of control. It supports a wide range of enterprise environments, including Web Services, J2EE, and .NET.
With LoadRunner, you can:
Obtain an accurate picture of end-to-end system performance.
Verify that new or upgraded applications meet specified performance requirements.
Identify and eliminate performance bottlenecks during the development lifecycle.

Course:-WINRUNNER
Duration:- 2Month
Fee:-10000/-
How do you efficiently test multiple applications that are constantly evolving and required to work in diverse environments?
Do you struggle with limited resources and increased pressure to deliver high-quality products on schedule?
How can you ensure that mission-critical applications work as expected and meet business requirements?
The answer is functional and regression testing prior to deployment. Mercury WinRunner® offers your organization a powerful tool for enterprise wide functional and regression testing. Mercury WinRunner captures, verifies, and replays user interactions automatically, so you can identify defects and ensure that business processes work flawlessly upon deployment and remain reliable.
With Mercury WinRunner, your organization gains several advantages, including:
Reduced testing time by automating repetitive tasks.
Optimized testing efforts by covering diverse environments with a single testing tool.
Maximized return on investment through modifying and reusing test scripts as the application evolves.

Course : Tally 7.2
Duration: 2Months
Fee: 4000/-

Accounting Introduction
What Is VAT
What's New in Tally 7.2
Tally 7.2: VAT AND TDS
Input VAT And OutPut VAT
Activating Tally 7.2
Company Setup in Tally
Data Security in Tally
Ledgers and Vouchers
Inventory Control System
Data Entry in Tally
Viewing Reports
Export and Report
Keyboard ShortCut