Diploma In Software Engineering |
|
~ |
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 |
|
|
|
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: |
|
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. |
|
For Salient Features & Applications |
|
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. |
|
For Salient Features & Applications |
|
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. |
|
For Salient Features & Applications |
|
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. |
|
For Salient Features & Applications |
|
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. |
|
For Salient Features & Applications |
|
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 |
|
For Salient Features & ApplicationsClick Here |
|
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. |
|
For Salient Features & Applications |
|
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. |
|
For Salient Features & Applications |
|
|
|
Course Duration |
Fees (Indian RS.) |
Fees (US $) |
510 sessions of 1 hr. each |
65,000 |
1855 |
|