Course Fees: 60,000/-
Course Duration: 12 months
MS-Office
VB.Net
Advance Excel
ASP.net
HTML
JDK (CoreJava)
C & C++
JDBC & JavaBeans
PHP & MySQL
Java-Servlet
Microsoft SQL Server 2005
JSP
Oracle – SQL
J2EE
Syllabus:
MS-OFFICE:
Microsoft Word for Windows is a full-features Word processor designed to help you work more efficiently. Microsoft Word shows you how to create effective documents using its features. You will learn how to edit, format, print documents, insert and manage tables and graphics into documents.
Salient Features
Easy and Fast Tool to create a one page Letter, a hundred page Report, etc.
You could add Graphics to your Letters and Reports to make it more attractive.
Automatic Spelling check as well as Grammar check facility.
Freeform Table Draw.
Document Mapping.
You can also link to Excel numbers and Charts.
You can link your Word documents to World Wide Web or Intranet sites.
Application
With Word you can create and type Letters, Reports, Memos, Proposals, Newsletters, Brochures, Graphical Presentation, Web pages, etc.
MICROSOFT WORD
Microsoft Word for Windows is a full-features Word processor designed to help you work more efficiently. Microsoft Word shows you how to create effective documents using its features. You will learn how to edit, format, print documents, insert and manage tables and graphics into documents.
Salient Features
Easy and Fast Tool to create a one page Letter, a hundred page Report, etc.
You could add Graphics to your Letters and Reports to make it more attractive.
Automatic Spelling check as well as Grammar check facility.
Freeform Table Draw.
Document Mapping.
You can also link to Excel numbers and Charts.
You can link your Word documents to World Wide Web or Intranet sites.
Applications
With Word you can create and type Letters, Reports, Memos, Proposals, Newsletters, Brochures, Graphical Presentation, Web pages, etc.
MICROSOFT EXCEL
Microsoft Excel for Windows is a powerful electronics spreadsheet application that can be used for managing, analyzing and presenting data in graphical manner.
SALIENT FEATURES
Excel has three components that perform in three different manner:
1. The Spreadsheet.
2. The Data sheet.
3. The Chart.
Create formulas on worksheets. It’s easy and fast.
Enhanced formatting and layout features help you get the printed report or online form with the look you want.
You can quickly find the information you need and create automatic subtotals of your data.
Increased capacity, high-end formatting options, and a mapping feature give you powerful ways to analyze your data visually.
Explore the power of the Internet from your familiar Microsoft Excel spreadsheet.
When you want to analyze data from outside Microsoft Excel, there’s no need to retype. In a few keystrokes, you can bring the data right onto your worksheet.
Applications
Excel is used for preparing Company profiles in the form of Charts and Graphs.
Excel stores the accounting spreadsheets in Electronic form.
POWERPOINT
PowerPoint is the most famous and powerful presentation Program. Impressive colourful slide shows can be designed.
Salient Features
Quick and Easy, High impact visual to accompany a talk.
Fact-filled presentation with plenty of Graphs and Charts.
Sophisticated Electronic presentation
You can assemble existing text and graphics from other Microsoft Office Application.
You can time your Presentations.
You can save as Web Animation.
Applications
With Microsoft Powerpoint you can create Company Presentations and Profiles.
Advance Excel
Course Title: Microsoft Excel, Level 2 (2003, XP, 2003/2007)
This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports, and automating various tasks.
Program Objectives
This Advanced Excel training program will empower the participants to be able to do the following:
Performing complex calculations more efficiently, using various Excel functions.
Organizing and analyzing large volumes of data.
Creating MIS reports.
Designing and using templates.
Consolidating and managing data from multiple workbooks.
Audience
Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.
Prerequisites
Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.
Topics Coverd:
Customizing common options in Excel
Absolute and relative cells
Protecting and un-protecting worksheets and cells
Working with Functions
Writing conditional expressions (using IF) Using logical functions (AND, OR, NOT) Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
Data Validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell
Working with Templates
Designing the structure of a template
Using templates for standardization of worksheets
Sorting and Filtering Data
Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
Working with Reports
Creating subtotals
Multiple-level subtotals
Creating Pivot tables
Formatting and customizing Pivot tables
Using advanced options of Pivot tables
Pivot charts
Consolidating data from multiple sheets and files using Pivot tables
Using external data sources
Using data consolidation feature to consolidate data
More Functions
Date and time functions
Text functions
Database functions
Formatting
Using auto formatting option for worksheets
Using conditional formatting option for rows, columns and cells
HTML:
HTML(the hypertext markup language) is used to describe the layout of a web page. HTML is simply a vehicle to indicate elements of a hypertext page. The HTML page must tell the browser which applets to load and then where to put each applet on the web page
C:
C is a general purpose Programming Language. C has proven to be a pleasant, powerful, and versatile language for a wide variety of Programs. Many of the modern languages like C++, Visual C++, Java, JavaScript, etc. are based on C Language. Therefore, not Knowing this Language is considered as a handicap. 90% of UNIX Operating System is written in C Language.
C++:
C++ is an object oriented Programming language which includes concepts like polymorphism, data-hiding, operator overloading, encapsulation and inheritance, which are not observed in C. User defined objects (instances) can be reused with and without modifications to generate new applications. This reduces coding to a great extent. Even for file accessing, we use file objects.
PHP & MySQL:
PHP is a powerful cross platform server side scripting language. It is a full featured programming language capable of managing huge database driven online environments. Using PHP you can query databases, create dynamic images, create e-commerce websites, manage security for online transactions, read & write files on the server, talk to remote servers – the possibilities are endless. MySQL is a small, compact database server ideal for stand-alone and enterprise applications. The PHP-MySQL combination is also cross-platform.
Microsoft SQL Server 2005
SQL Server is the Database Management System (RDBMS) allows to store huge Database and manage the same easily. Its enterprise database management and analysis system.
ORACLE – SQL
Oracle is a Relational Database Management System (RDBMS).Oracle’s latest technology, today’s systems designers and Developers can build 21st century enabled application ranging from critical on-line transaction processing systems supporting thousand of users to multi-terabyte data warehouses for decision support and also World Wide Web-based applications.
Salient Features
Oracle has sophisticated security mechanisms control access to sensitive data by an assortment of privileges
Oracle provides sophisticated backup & recovery routines. Backup creates a second copy of Oracle Data, recovery restores a copy of data from back up.
Oracle provides flexible space management. It has special abilities that are capable of handling very large databases.
Oracle provides open connectivity to & from other vendors software
Oracle server supports a wide range of Development tools, end user query tools, off the shelf applications & office wide information tools.
Application
Education Industry
Software Development Industry
Data warehouse and maintenance
Domestic Air Services
Production Industry
Banking Industry
Topics Covered
Introduction to oracle products.
SQL*plus features and commands.
Data manipulation commands, data control commands.
Altering tables, data definition commands, joins, types of functions.
Process Transaction commands, SQL*plus set theory.
Sub-queries and Co-related queries.
Security in Oracle
Locking
Oracle Objects – Views, clusters, indexes, synonyms, snapshots.
Formatting output of queries, Report creation.
Implementing Object Oriented features in Oracle.
Introduction to PL/SQL.
Packages
Creating Cursors, exceptions, procedures, functions and triggers.
Understanding the Oracle Architecture.
Features of Latest Oracle Version.
Data Dictionary
DBA – An Overview
VB.net:
Salient Features
A brief history of .Net
Backbone of .Net framework
The ingredients of .NET
The .NET & web classes
Web Services and the next-generation Internet
Integration which more than 20 languages
Compatibility with commerce server & Biztak Server
Application
Web solution
Net security
ERP solution
PREREQUISITES (Should have knowledge of)
Basic programming
Experience in Visual Basic is a plus
TOPICS COVERED Level I
The .NET Revolution
The Design Environment
VB.NET Basics
Windows Forms
Object-Oriented Programming
Mastering Objects
Bug Proofing
Dealing With Data: Files, Printing, and XML
Databases and ADO.NET
Level II
Threading
Setup and Deployment
Web Forms and ASP.NET
Web Services
Migrating To Visual Basic.NET
ASP.net:
The Internet has revolutionized the way organizations think about application development and deployment. The leap from traditional client-server development to web base development takes more than accessing data through a browser.
Salient Features
ASP.NET helps to develop web-based applications with high performance and scalability.
Develop web-based applications using ASP.NET
Apply client-side and server-side programming, DHTML, scripting.
Analyze the performance issues involved in developing applications on the net.
Evaluate the use of client-side scripting vs. server-side scripting.
Develop applications using ASP.NET, XML and databases.
Obtain and process information about server, clients, and users.
Keeping track of client interactions.
Develop and deploy applications using Microsoft InterDev and Studio
Topics Covered
Web-based Programming. Web application development concepts, issues, and protocol. Server-browser interaction.
HTML. Overview of HTML capabilities, tags, formatting, writing forms and scripts.
HTTP Protocol. The protocol, methods, data transfer and queries.
DHTML. DOM, CSS2, attributes, events, netscape and IE extensions.
Scripting. Overview of VBScript, JavaScript, document objects.
ASP.NET. Why ASP.NET? Server and ASP.NET, Writing ASP.NET pages, IIS and ASP.NET
ASP.NET Object Model. Classes in the ASP.NET object model. Functionality and features.
Using InterDev. Creating projects, development and deployment using InterDev.
ASP.NET Facilities. Interaction with server, tracking sessions with cookies, and session objects.
ASP.NET Interactions. Interacting with other pages, forwarding and including.
Performance Techniques. Caching, refreshing, client pull, buffering, issues.
Managing Applications. The concept of an application in ASP.NET, Application objects.
Database Access. ASP.NET and ADO, database access.
Security. Security issues and concepts, authorization techniques, SSL.
Other Technologies. Comparison to other technologies like CGI, JSP.
XML and ASP.NET. Using XML with ASP.NET. XML for performance and ease of development.
JAVA DEVELOPMENT KIT:
Java is platform independent, reliable Programming language introduced by sun systems, used mainly to Develop Internet applications and applets. Java is used to create web-based applications and allows user interaction on the Internet. Java allows us to have animation, audio and video clippings in our web page. Java Programming helps in writing Programs using which one can connect to any computer on the Internet.
JDBC & JAVA BEANS:
JDBC technology is an API that lets you access virtually any tabular data source from the Java™ programming language. It provides cross-DBMS connectivity to a wide range of SQL databases, and now, with the new JDBC API, it also provides access to other tabular data sources, such as spreadsheets or flat files.
JavaBeans component architecture is the platform-neutral architecture for the Java application environment.
It is the ideal choice for developing or assembling network-aware solutions for heterogeneous hardware and operating system environments within the enterprise or across the Internet. In fact, it is the only component architecture you should consider if you’re developing for the Java platform. JavaBeans component architecture extends “Write Once, Run Anywhere ™” capability to reusable component development.
In fact, the JavaBeans architecture takes interoperability a major step forward, your code runs on every OS andalso within any application environment.
Java-Servlet:
Servlets are used for Server-Side Programming. Servlet are generic extensions to Java-enabled servers. Their most common use is to extend Webservers, providing a very secure, portable and easy-to-use replacement for CGI. A Servlet is a dynamically loaded module that services requests from a Web server. It runs entirely inside the Java Virtual Machine
JSP:
JavaServer Pages(JSP) is a web-scripting technology similar to Netscape server-side JavaScript(SSJS) or Microsoft Active Server Pages(ASP). Although the JSP specification has been managed by Sun Microsystems, any vendor can implement JSP in their own systems.
J2EE:
J2EE is a multitiered application architecture. The J2EE specification defines roles based on certain functionality in the normal course of development and deployment of a J2EE application.