|
 |
Education & Training
Individual & Students |
|
Software Development
|
 |
| |
 Diploma Program in Information Technology |
|
| |
|
|
| |
|
|
| |
|
|
| |
Exam Schedule |
| Submittions of Assignments & Case Studies |
|
13-Dec-2005 |
| Term End Study Leave |
14-Dec-2005 |
18-Dec-2005 |
| |
|
|
| Viva-Voice / Practical Exams |
|
19-Dec-2005 |
| Theory Exams |
|
20-Dec-2005 |
| |
|
|
| Term End break |
21-Dec-2005 |
1-Jan-2006 |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
 Basics of PC Microsoft Windows 2000 Network and Operating System Essentials |
|
| |
Prerequisties:
- Basic Knowledge of Computer & Network.
- Able to Read, Write & Conversein English |
Objective: Understand the
- Features of Windows 2000
- Basics of networking with Windows 2000
- the types of user accounts, security features
- Administrative tasks.
- Common protocols used in the a Windows 2000 network.
- Understand TCP/IP, Name resolution, routing, and IP addressing
- Network communication models
- Various types of network architectures
- Physical Components
- Protocols for remote access communication.
- Client and Server tech. used in accessing Web services. |
Topics |
Introduction to Windows 2000 and Networking
- Windows 2000 Operating Systems
- Introduction to Networks
- Windows 2000 Implementation of Networking
Administration of a Windows 2000 Network Topics
- Windows 2000 Help
- Administrative Tasks
- Administrative Tools
- Use Online Help.
- Describe the tools used to perform routine administrative tasks:
- Control Panel
- System Properties
- System Information
- Event Viewer
- Windows Task Manager
- Performance
- Printers
- Shared Folders
- Disk Management
- Backup
- Security Management
- Network
- Microsoft Management Console
Network Securing on User Accounts
- Groups
- User Rights
- Permissions
Examining the Network
- Scope of Networks
- Basic Connectivity Components
- Network Topologies
- Network Technologies
- Expanding the Network |
Examining the Network Protocols
- Introduction to Protocols
- Protocols and Data Transmissions
- Common Protocols
- Other Communication Protocols
- Remote Access Protocols
Examining TCP/IP
- Introduction to TCP/IP
- TCP/IP Protocol Suite
- Name Resolution
- Examining the Data Transfer Process
- Routing Data
Examining IP Addressing
- Classful IP Addressing
- Subnetting a Network
- Planning IP Addressing
- Assigning TCP/IP Addresses
Optimizing IP Address Allocation
- Classless Inter-Domain Routing (CIDR)
- Binary IP Addresses
- Binary Subnet Masks
- IP Address Allocation Using CIDR
Examining Web Services
- Identifying Internet Concepts
- Using Client Technologies
- Connecting to the Internet
- Identifying Web Server Concepts
|
|
|
| |
|
|
| |
|
|
| |
MS - OFFICE + Ms-Access |
|
| |
Prerequisties:
- Basic Knowledge of Computer & Network.
- Able to Read, Write & Conversein English |
Objective:Understand the
- Gain a good understanding of the Microsoft Office Suite of desktop applications.
- Operate Office applications more efficiently
|
Topics |
MS - WORD
- Templates, styles, themes, tables, columns, graphics, charts
- Customising menus, toolbars and macros
- Creating form letters, labels and mail merge documents, forms, footnotes, bookmarks, table of
contents and indexes
MS - EXCEL
- Performing calculations
- Analysing data using filters, sorts, scenarios, pivot tables and charts
- Using macros and database tools
MS - POWERPOINT
- Creating and working with presentations
- Using design templates
- Setting up slide shows and multimedia presentations
|
MS - OUTLOOK
- Working with, and managing, customising and organising e-mails
- Managing the calendar
- Creating and organising list of contacts, tasks and notes
- Using the journal
MS - ACCESS
- Creating and using a database and forms
- Locating specific information
- Keeping information secure and accurate
- Working with reports, pages and modules |
|
|
| |
|
|
| |
|
|
| |
Programming Tech (Flow Chart + Algorithm) Using VB |
|
| |
Prerequisties:
- Basic Knowledge of Computer & Network.
- Able to Read, Write & Conversein English |
Objective: Understand & Develop Confidence in
- Alogorithm, Program Logic and Pseudocode
- Gain knowledge of Programm Design & logic using VB
- Gain a good understanding of development of desktop applications. |
Topics |
Program design
- Top down; hierarchy charts
- Modular (functions, procedures)
- IPO (input-process-output)
- Pseudocode
- Flowcharts
Code generation; design and style
- Test case development
- Desk checking
- Debugging
- Documentation
Program development software
- Login, Logout
- Text Editor
- Compiling, linking, and executing
- Systems utility commands: PRINT, COPY, TYPE, etc.
Data Types
- Integer
- Real
- Character
- User Defined
|
Control Structures
- Sequence
- Selection
- Repetition
Arrays
- One-dimensional
- Using arrays
- Reading/Writing the elements of an array
- Building an array
- Manipulating an array
Number Systems
- Binary (Two’s complement)
- Octal
- Hexadecimal
- Conversions between bases |
|
|
| |
|
|
| |
|
|
| |
Developing ASP.NET Web Applications Using Visual Studio .NET |
|
| |
Prerequisties:
- Basic Knowledge of Computer Needed & Windows OS.
- Able to Read, Write & Conversein English
- Strong Programming Logic
- Good Implementation Knowledge of Visual Basic |
Objective:
- Fundamentals of Web application
- Site implementation using Microsoft ASP.NET and Microsoft VisualBasic .NET.
- Create an ASP.NET Web application that delivers dynamic content to Web site |
Topics |
Conceptual framework of the.NET Framework and ASP.NET.
- Introduction to the .NET Framework
- Overview of ASP.NET
- Overview of the Lab Application
- Resources
Using Microsoft Visual Studio .NET
- Overview of Visual Studio .NET
- Creating an ASP.NET Web Application Project
Using Microsoft .NET-Based Languages
- Overview of the .NET-Based Languages
- Comparison of the .NET-Based Languages
- Creating a Component Using Visual Studio .NET
Creating a Microsoft ASP.NET Web Form
- Creating Web Forms
- Using Server Controls
Adding Code to a Microsoft ASP.NET Web Form
- Using Code-Behind Pages
- Adding Event Procedures to Web Server Controls
- Using Page Events
Tracing in Microsoft ASP.NET Web Applications
- Understanding Tracing
- Remote Debugging
Validating User Input
- Overview of User Input Validation
- Using Validation Controls
- Page Validation
Creating User Controls
- Adding User Controls to an ASP.NET Web Form
- Creating User Controls
Accessing Relational Data Using Microsoft Visual Studio .NET
- Overview of ADO.NET
- Creating a Connection to the Database
- Displaying a DataSet in a List-Bound Control
Accessing Data with Microsoft ADO.NET
- Introduction to Using ADO.NET
- Connecting to a Database
- Accessing Data with DataSets
- Using Multiple Tables
- Accessing Data with DataReaders
|
Calling Stored Procedures with Microsoft ADO.NET
- Overview of Stored Procedures
- Calling Stored Procedures
|
Reading and Writing XML Data
- Overview of XML Architecture in ASP.NET
- XML and the DataSet Object
- Working with XML Data
- Using the XML Web Server Control
|
Consuming and Creating XML Web Services
- Overview of Using XML Web Services
- Calling an XML Web Service by HTTP
- Using a Proxy to Call an XML Web Service
- Creating an XML Web Service
|
Managing State
- State management
- Application and Session Variables
- Cookies and Cookieless Sessions
|
Configuring, Optimizing, and Deploying a Microsoft ASP.NET Web Application
- Using the Cache Object
- Using ASP.NET Output Caching
- Configuring an ASP.NET Web Application
- Deploying an ASP.NET Web Application
|
Helping to Protect a Microsoft ASP.NET Web Application
- Web Application Security Overview
- Working with Windows-Based Authentication
- Working with Forms-Based Authentication
- Overview of Microsoft Passport Authentication
|
Review
Review of Material Covered
Introduction to the Project |
|
|
|
| |
|
|
| |
|
|
| |
Web Development Skills from ASP to Microsoft ASP.NET |
|
| |
Prerequisties:
- Knowledge of HTML pages with tables, images, and forms.
- Experience using a scripting language, such as Microsoft Visual Basic® Scripting Edition or JavaScript.
- Familiarity with a Microsoft .NET-based programming language. |
Objective:
- Understand ASP and ASP.NET.
- Develop a ASP.NET Web application by using Microsoft Visual Studio® .NET
- Develop a ASP.NET Web Application UI.
- Understand Trace feature,debugger to debug, Access databases
- 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.
- Access and display Extensible Markup Language (XML) data in an ASP.NET Web application.
- Use caching to improve Web application performance |
Topics |
- Introduction to Microsoft ASP.NET Web Application Development
- Introduction to ASP.NET
- Developing an ASP.NET Web Application Using Visual Studio .NET
- .NET Programming Model Changes
- Developing a Microsoft ASP.NET Web Application User Interface
- Creating an ASP.NET Web Application User Interface
Validating User Input
- Creating and Using User Controls in an ASP.NET Web Form
- Processing ASP.NET Web Forms
- Debugging Microsoft ASP.NET Web Applications
- Tracing in ASP.NET Web Applications
- Debugging ASP.NET Web Applications
- Accessing Data Using Microsoft ADO.NET
- Overview of ADO.NET
- Reading Data Using DataReaders
- Programmatically Accessing Data Using DataSets
- Visually Generating DataSets
- Data-Bound Controls
- Best Practices for Secure and Reliable Data Access
- Managing State in a Microsoft ASP.NET Web Application
- Introduction to State Management
- Session State Management
- Client-Side State Management |
- Authenticating Users
- ASP.NET Authentication Model
- Implementing Windows-Based Authentication in ASP.NET Web Applications
- Implementing Forms-Based Authentication in ASP.NET Web Applications
- Creating and Consuming XML Web Services
- Introduction to XML Web Services
- Creating an XML Web Service
- Creating an XML Web Service Client
- Calling COM Component
- ASP.NET and COM Interoperability
- Calling Com Objects from ASP.NET Web Forms
- Migrating ASP Web Applications to Microsoft ASP.NET
- Migrating an ASP Web Page
- Migrating an ASP Application
- Deploying Microsoft ASP.NET Web Applications
- ASP.NET Application Deployment Methods
- Maintaining a Deployed ASP.NET Web Application
- Target : Accessing XML Data
- XML in Microsoft. NET
- Displaying XML Data on a Web Form
- XML and the DataSet Object
- Improving Microsoft ASP.NET Web Application Performance Using Caching
- Using the Cache Object
- Using ASP.NET Output Caching
- Migrating ASP Web Applications to Microsoft ASP.NET |
|
|
| |
|
|
| |
|
|
| |
Programming with Microsoft ADO.NET |
|
| |
Prerequisties:
- Good Implementation Knowledge of Visual Basic & HTML
- Good Understanding of ASP & ASP.Net |
Objective:
- Teach developers to build data-centric applications and Web services with Microsoft ADO.NET,
Microsoft SQL Server™ 2000, and the Microsoft .NET Framework. |
Topics |
Module 1:
Data-Centric Applications and ADO.NET
Design of Data-Centric Applications
ADO.NET Architecture
ADO.NET and XML
Module 2:
Connecting to Data Sources
Choosing a .NET Data Provider
Defining a Connection
Managing a Connection
Handling Connection Exceptions
Connection Pooling
Module 3:
Performing Connected Database Operations
Working in a Connected Environment
Building Command Objects
Executing Commands That Return a Single Value
Module 4:
Building DataSets
Working in a Disconnected Environment
Building DataSets and DataTables
Binding and Saving a DataSet
Defining Data Relationships
Modifying Data in a DataTable
Sorting and Filtering
|
Module 5:
Reading and Writing XML with ADO.NET
Creating XSD Schemas
Loading Schemas and Data into DataSets
Writing XML from a DataSet
Module 6:
Building DataSets from Existing Data Sources
Configuring a DataAdapter to Retrieve Information
Populating a DataSet Using a DataAdapter
Configuring a DataAdapter to Update the Underlying Data Source
Persisting Changes to a Data Source
How to Handle Conflicts
Module 7:
Building and Consuming a Web Service That Uses ADO.NET
Building and Consuming a Web Service That Returns Data
Build a Web service.
Consume a Web service in a client application.
Troubleshoot errors in an ADO.NET application.
|
|
|
| |
|
|
| |
|
|
| |
MS - SQL Server 2000 Database |
|
| |
Prerequisties:
A Thorough Knowledge of Microsoft Windows® 2000 operating system & its Network Abilities
which would include
- Connect clients running Windows 2000 to networks and the Internet.
- Configure the Windows 2000 environment.
- Create and manage user accounts.
- Manage access to resources by using groups.
- Configure and manage disks and partitions, including disk striping and mirroring.
- Manage data by using the NTFS file system.
- Implement Windows 2000 security.
- Optimize performance in Windows 2000. |
Objective:
Understand how to effectively use Microsoft SQL Server™ 2000 in .NET Framework. |
Topics |
Module 1:
SQL Server Overview
What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server
Module 2:
Overview of Programming SQL Server
Designing Enterprise Application Architecture
SQL Server Programming Tools
The Transact-SQL Programming Language
Elements of Transact-SQL
Additional Language Elements
Ways to Execute Transact-SQL Statement
Module 3:
Creating and Managing Databases
Creating Databases
Creating Filegroups
Managing Databases
Introduction to Data Structures
Module 4:
Creating Data Types and Tables
Creating Data Types
Creating Tables
Generating Column Values
Generating Scripts
Module 5:
Implementing Data Integrity
Types of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use
Module 6:
Planning Indexes
Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index
Module 7:
Creating and Maintaining Indexes
Creating Indexes
Creating Index Options
Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting Up Indexes Using the Index Tuning Wizard
Performance Considerations
Module 8:
Implementing Views
Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views
Optimizing Performance by Using Views
Performance Considerations
|
Module 9:
Implementing Stored Procedures
Introduction to Stored Procedures
Creating, Executing, Modifying, and Dropping Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
Performance Considerations
Module 10:
Implementing User-defined Functions
What Is a User-defined Function?
Defining User-defined Functions
Examples of User-defined Functions
Module 11:
Implementing Triggers
Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations
Module 12:
Programming Across Multiple Servers
Introduction to Distributed Queries
Executing an Ad Hoc Query on a Remote Data Source
Setting Up a Linked Server Environment
Executing a Query on a Linked Server
Managing Distributed Transactions
Modifying Data on a Linked Server
Using Partitioned Views
The following lab is covered in this module:
Using Distributed Data
Module 13:
Optimizing Query Performance
Introduction to the Query Optimizer
Obtaining Execution Plan Information
Using an Index to Cover a Query
Indexing Strategies
Overriding the Query Optimizer
Module 14:
Analyzing Queries
Queries That Use the AND Operator
Queries That Use the OR Operator
Queries That Use Join Operations
Module 15:
Managing Transactions and Locks
Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks
|
|
|
| |
|
|
| |
|
|
| |
|
|
 |
 |
 |
|
Japan to India |
|
IT Study Abroad Program |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
