Nexgen Advance Diploma course in Computer Application at providing individuals advanced training in the field of Web designing & Digital Marketing.This course can be taken up by students after 12th, HSC or any such equivalent. Nexgen Advance Diploma course in Computer Application is a professional course and has numerous career options in the It industry. Nexgen provides individual based training at our centers, No batches , students can schedule their training as per their time schedule and then mantain the same. This course could take approx one year for completition , however a fast-track option is also avaliable. We also assist with placement options after completion of this Advance Diploma Course in Computer Application. HTML5 & CSS
Introduction - What is internet ? , Overview of Web Browser, URLs (Uniform Resource Locator), World Wide Web (www), HTML Tools |
XHTML Document And Basic Tags - Writing Tools, Structure of an HTML document, Basic tags and Attributes, Body Attributes |
Text editing - Text attributes, Marquee tag & its attributes, Headings, Font,Paragraph, Line Break, Ordered and Unordered Lists, Blockquote |
Images - Image formats, Image attributes, Alignment of images |
Image mapping |
Tables - Create a table, Combine cells in a row or column |
Forms - Create a form, Accept input and Submit |
Special Things - Special Characters, Different graphic formats, Interlacing/Progresive Display, Putting your site Online |
XHTML 5 & CSS - Getting a Proper Code Editor and Formatting, Lists, Parent Child Relationships, Putting your site Online, Blockquotes, Anchors, Your First Stylesheet, Clean Project Structures, The Necessity of Divs, Ids and Classes, Assignment, Floats and a Simple Layout, NavigationLists, Introduction to Forms, Image Replacement, Typography Basics, The Difference Between Relative and Absolute Positioning, Images, Creating a Website Fragment, The Importance of Validation |
Creating Responsive Website |
Media Query |
What is Media Queries? |
Properties of Media Queries - width/height, device-width/height, orientation, aspect-ratio, device-aspect-ratio, color, color-index, monochrome, resolution, scan, grid |
Part I: Working with PHP |
Getting Started with PHP-Variables |
Assigning Simple Variables Within a Script - Delimiting strings, Assigning arrays within a script, Assigning two-dimensional arrays in a script |
Accessing Variables Passed from the Browser - HTML forms variables, Passing arrays, Cookies, Sessions |
Testing Variables - isset0, empty0, is_null0, is_int0, is_double0, is_string0, is_array0, is_bool0, is_object0, is_resource0, is_scalar0, gettype0 |
Changing Variable Types - Variable Variables. |
Control Structures |
The if Statement - Determining true or false in PHP, Comparison operators, Logical operators, Complex if statement, if…else statements, if…elseif statements |
switch…case - Loops, While…, do…while, for, foreach, continue and break |
PHP’s Built-in Functions - Function Basics, Arguments, Return values |
Function Documentation - Important PHP Functions, String handling functions |
Writing Organized and Readable Code - Indenting, Code blocks, Function calls, SQL statements |
Includes - Include0 and Require0, Include_once0 and Require_once0 |
User-Defined Functions - Function basics, Returning values, Using a variable number of arguments, Variable scope |
Object-Oriented Programming - Classes, Continued, Object cloning, Destructors, Exceptions |
Working on a E-Commerce ( Shopping Cart ) Live Project - Click to view the live project the students would be working with during this course |
Synopsis: - The data is stored in Products Table, Supplier Table, Category Table. Each product has a single supplier and single category, Each supplier supplies multiple products under multiple categories |
Login Page - The user will be authenticated before they enter the website for the correct username/password, There are 2 types of users Admin / User, the admin would have administrative rights, where as a user will only be able to view the products |
Search Page - After login, the user will be directed to a search page, where they can search for a product by selecting the supplier / category name, In advance search, string searches can be done. |
Product Result list - This page will return the result of the search criteria, A single page will display the records dynamically from the database, 5 records at a time. Using the Next / Previous button users can navigate through the list of products |
Details - Once the user clicks on the product name in the result list page, they are directed to the details page, where user can get the detail information with a image of the product, If the user is an admin, they would be given an option to add / update / delete If the user is not a admin, the following permissions will be disabled. |
Add / Update / Delete - Displaying data from multiple tables using forms & Adding / Updating / Deleting data |
Security - Extensive use of Sessions / Cookies for security purposes |
E-Commerce Module - Once the above project is completed, it’s taken to a next level where the e-commerce module is generated. Multiple Products can be added to the shopping cart, a dynamic bill is generated and user is forwarded to a payment gateway to complete the transaction. |
Introduction , Syntax , Data Types , Operators & Expression |
CREATE ,DROP, SELECT database ,CREATE table, SQL CONSTTRAINT , DROP table , Insert Query Truncate Command |
SELECT Query, WHERE Clause, AND & OR Clause , LIKE Clause ,ORDERED BY ,GROUP BY , DISTINCT Keyword , HAVING Clause , SORTING RESULTS |
UPDATE and DELETE QUERY and ALTER command |
JOINS : Left join, Right join , Inner join , Full join , Self join |
MY SQL DATABASE , MY SQL CONNECT , CREATE DATABASE |
CREATE Table , INSERT Data , Get Last ID , Multiple INSERT |
SELECT Data , UPDATE Data , Delete data |
Wild cards , DATE functions , Using Views , Indexes , NULL Values , Alias Syntax |
ASSINGMENT |
INTRODUCTION TO C PROGRAMMING(BASICS OF C) |
C TOKENS (DATATYPRE, VARIABLES, KEYWORDS) |
C OPERATORS (TYPES OF OPERATORS) |
C PROGRAMS INTRODUCTION TO EXPRESSIONS |
C PROGRAMS ( CONTINUE) |
CONTROL STATEMENTS ( DECESION MAKING ) |
CONTROL STATEMENTS ( LOOP STATEMENTS ) |
C ARRAY AND STRING |
PROGRAMS ON ARRAY HANDLING |
C POINTERS |
PROGRAMS TO POINTERS HANDLING |
C FUNCTIONS ( ALL 4 TYPES) AND PROGRAMS |
C FUNCTIONS ( ARGUMENTS IN C FUNCTIONS ) |
C STRUCTUES, UNIONS AND PROGRAMS |
C MEMORY PROGRAMS( MALLOC AND ALLOC FILES) |
C FILE HANDLING AND PROGRAMS |
INTRODUCTION TO C++ AND OBJECT ORIENTED PROGRAMMING |
CREATING FIRST C++ PROGRAM AND LEARNING HOW C++ PROCESSING DONE ( 3 PROGRAMS ) |
C++ TOKENS( VARIABLES AND DTATTYPES) |
C++ CONST KEYWORD AND C++ TOKENS EXAMPLES |
C++ CONTROL STATEMENTS AND EXAMPLES |
CLASSES AND OBJECT INTRODUCTIONS AND EXAMPLES OF HOW OBJECTS ARE CREATED IN C++ |
CLASSES AND OBJECTS CONTINUE |
CREATING FUNCTIONS IN C++ |
FUNCTIONS OVERLOADING WITH EXAMPLES |
TEST OF BASICS C++ FROM 19 TO 27 - INTRODUCTION TO INHERITANCE AND TYPES OF INHERITANCE WITH EXAMPLES |
C++ INHERITANCE CONTINUE |
C++ POLYMORPHISM PART 1 |
C++ POLYMORPHISM PART 1 CONTINUE.. |
C++ POLYMORPHISM PART 2 |
C++ POLYMORPHISM PART 2 CONTINUE.. |
C++ FILE HANDLING PART 1 |
C++ FILE HANDLING PART 2 |
C++ EXCEPTION HANDLING INTRODUCTION |
C++ EXCEPTION PROGRAMMING |
TEST OF C++ ADVANCE FROM 29 TO 38 - INTRODUCTION TO TEMPLATES |
Introduction to Object Oriented Programming. |
Java Basic: Data types, Object, Arrays, Strings, Operators, Statements, Exception Handling (try-catch-finally). |
Classes & Objects in Java: Constructors, destructors, class methods, extending a class, overriding methods, visibility modifiers, abstract classes and interfaces. |
Applets & Event Handling: Drawing graphics, reading apple parameters, animation. |
Graphical User Interface: Introduction to GUI components and event handling |
Multithreading. |
Introduction to Swing Package. |
Input & Output: File operations like creating, reading and modifying a file. |
Database Connectivity ( JDBC ). |
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 |
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. |
A Simple Servlet - Example Two-tiered Web Application, J2EE Software and Setup, Environment, Path and Classpath Settings, J2EE Application Components, Create the HTML Page, Create the Servlet, Compile the Servlet, Start the J2EE Application Server, Start the Deployment Tool, Assemble the J2EE Application, Verify and Deploy the J2EE Application, Run the J2EE Application, Updating Component Code, More Information |
A Simple Session Bean - Example Application Overview, Create the Session Bean, Local Interfaces, Modify the Servlet, Compile the Session Bean and the Servlet,Start the Platform and the Tools, Assemble the J2EE Application, Verify and Deploy the J2EE Application, Run the J2EE Application |
A Simple Session Bean - Example Application Overview, Create the Session Bean,Local Interfaces, Modify the Servlet, Compile the Session Bean and the Servlet, Start the Platform and the Tools, Assemble the J2EE Application, Verify and Deploy the J2EE Application, Run the J2EE Application |
A Simple Session Bean - Example Application Overview, Create the Session Bean, Local Interfaces, Modify the Servlet, Compile the Session Bean and the Servlet, Start the Platform and the Tools, Assemble the J2EE Application, Verify and Deploy the J2EE Application, Run the J2EE Application |
A Simple Session Bean - Example Application Overview, Create the Session Bean, Local Interfaces, Modify the Servlet, Compile the Session Bean and the Servlet, Start the Platform and the Tools, Assemble the J2EE Application, Verify and Deploy the J2EE Application, Run the J2EE Application |
JavaServer Pages Technology - Create the JSP, Change bonus.html, Start the Platform and Tools, Update the WAR File, Verify and Deploy the J2EE Application, Run the J2EE Application, More Information |
Adding JavaBeans to the Mix - About the Example, Create bonus.jsp, Create the JavaBeans Class, Bean Properties, Change the Servlet, Compile, Start the Platform and Tools, Update the WAR File, Verify and Deploy the J2EE Application, Run the J2EE Application, More Information |
Custom JSP Tag Libraries - About the Example, Custom JSP Tag, Declare the Tag Library, Create the Tag Library Descriptor, Create the Tag Handler Class, Change bonus.jsp, Compile, Start the Platform and Tools, Update the WAR File, Verify and Deploy the J2EE Application, Run the J2EE Application, More Information Gladiator-Predator Testing |
XML - Marking and Handling Text, Change the JavaBean Class, Creating the XML document using DOM, Parsing XML using SAX, SAX and DOM, XML and J2EE, Change the Servlet, Compile the Application, Update the Application, Verify and Deploy the J2EE Application, More Information |
JDBC Technology and Bean-Managed Persistence - Bean Lifecycle, Change the BonusBean, Other Components, Create the Database Table, Compile, Start the Platform and Tools, Update the JAR File, Verify and Deploy the Application, Run the Application, More Information Application, More Information |
DBC - Introduction, Jdbc Architecture, Types of Drivers, Statement, ResultSet, Read Only ResultSet, Updatable ResultSet, Forward Only ResultSet, Scrollable ResultSet, PreparedStatement, Connection Modes, SavePoint, Batch Updations, CallableStatement, BLOB & CLOB, |
SERVLETS - Introduction, Web application Architecture, Http Protocol & Http Methods, Web Server & Web Container, Servlet Interface, GenericServlet, HttpServlet, Servlet Life Cycle, ServletConfig, ServletContext, Servlet Communication, |
Introduction - Jsp LifeCycle, Jsp Implicit Objects & Scopes, Jsp Directives, Jsp Scripting Elements, Jsp Actions, JSTL & Tag Library |
IDE - MyEclipse |
SERVERS- Tomcat, Weblogic |
DATABASE - Oracle |
Basics of Servlet - Servlet: What and Why?, Basics of Web, Servlet API, Servlet Interface, GenericServlet, HttpServlet, Servlet Life Cycle, Working with Apache Tomcat Server, Steps to create a servlet in Tomcat, How servlet works?, servlet in Myeclipse, servlet in Eclipse, servlet in Netbeans |
ServletRequest - ServletRequest methods,Registration example with DB |
Servlet Collaboration - RequestDispatcher, sendRedirect |
ServletConfig - ServletConfig methods, ServletConfig example |
ServletContext - ServletContext methods, ServletContext example |
Attribute - How to set, get and remove example? |
Session Tracking - Cookies, Hidden Form Field, URL Rewriting, HttpSession |
Event and Listener |
Filter - Filter, Authentication Filter FilterConfig, Useful examples |
ServletInputStream and ServletOutputStream |
Annotation Servlet |
Project Development |
Basics of JSP - Life cycle of JSP, JSP API, JSP in Eclipse and other IDE's |
Scripting elements - scriptlet tag, expression tag, declaration tag |
9 Implicit Objects - out, request, response, config, application, session, pageContext, page, exception |
Directive Elements - page directive, include directive, taglib directive, |
Exception Handling |
Action Elements - jsp:forward, jsp:include, Bean class, jsp:useBean, jsp:setProperty & jsp:getProperty, Displaying applet in JSP |
Expression Language |
MVC in JSP |
JSTL |
Custom tags - Custom Tag : What and Why?, Custom Tag API?, Custom Tag Example, Attributes, Iteration, Custom URI |
Project Development in JSP |
Writing Basic SQL Select Statement. |
Restricting and Sorting Data. |
Displaying Data from Multiple Tables. |
Aggregating Data Using Group Functions. |
Sub queries. |
Producing Readable Output with iSQL*Plus. |
Manipulating Data. |
Creating and Managing Tables. |
Including Constraints. |
Creating Views. |
Other Database Objects. |
Controlling User Access. |
SQL Workshop. |
Using Set Operators. |
Date time Functions |
Enhancements to Group by Clause. |
Advanced Sub queries. |
Hierarchical Retrieval. |
Extensions to DML and DDL Statements. |
Understanding Query Flow, Syntactical Flow of the Query Statement, Logical Flow of the Query Statement, From Clause Data Sources, Possible Data Sources |
Named Ranges, [Table Name], Four-Part Table Names,Where Conditions |
Using the Between Search Condition, Using the In Search Condition, Using the Like Search Condition. Multiple Where Conditions |
Select….Where - Ordering the Result Set, Specifying the Order by Using Column Names, Specifying the Order by Using Expressions, Order by and Collation, Select Distinct |
Operators, Scalar Functions, User Information Functions, Data-Time Functions, String Functions |
Inner Joins, Creating Inner Joins within SQL Code, Number of Rows Returned, Multiple Table Joins, Outer Joins, Outer Joins and Optional Full Outer Joins, Placing the Conditions within Outer Joins, Self-Joins, Multiple-Condition Joins |
Using Unions, Intersection Union |
Simple Subqueries, Using Scalar Subqueries, Using Subqueries as Lists, Using Subqueries as Tables, Simple Aggregation, Basic Aggregations, Grouping within a Result Set, Simple Groupings, Aggravating Queries |
Why Use Views?, Working with Views, Creating Views with DDL Code, Order By and Views, View RestrictionsView Restrictions, Executing Views |
Inserting Data, Inserting One Row of Values, Inserting the Result Set from a Stored, Procedure, Updating Data, Updating a Single Table, Deleting Data, Creating Tables, Creating Primary Keys, Primary Keys, Creating Foreign Keys |
DDL Triggers, Creating and Altering DDL Triggers, EventData(), Enabling and Disabling DDL Triggers, Implementing Trigger |
XML Data Type, Querying XML Data, Merging XQuery with Select, Reading XML into SQL Server, Creating XML with SQL Server 2005 |
PHASE - I - How to open a new document in Word 2007, How to find a word, How to replace a word, How to save a file, How to close a file, How to open an existing file, How to use cut and paste, How to use copy and paste, How to select the whole text, Overview home tab, How to clear formats, How to go to different views, Overview Insert tab, How to exit from word, |
PHASE 2 - Work with insert option, Cover page, Blank page, Page break, Insert Table, Insert excel sheet, Insert Pictures from folders, Insert clip-art, Insert shapes, Insert smart art, Insert chart, Use of hyperlink, Bookmark, Header and Footer Text box Word art Drop cap Insert object and symbols |
PHASE 3 - Working in page layout, Set up themes, Color themes, Text themes, Page set up, Use of columns, Watermarks, Page Color, Page border |
PHASE 4 - Work in references tab, Insert foot note, Insert end note, Insert next note, Bibliography,Insert caption |
PHASE 5 - Work in review tab, Spelling and grammer, Translate, Thesaurus, Comments, Protect document |
PHASE 6 - Work in view window, Split, Arrange all, Macros, Zoom, Show\hide items, Document views |
Getting Started - Understanding the Excel screen, Navigating in a spreadsheet, Understanding worksheets, columns, rows and cells, Saving, opening, and closing workbooks |
Formatting a Spreadsheet - Changing column widths and row heights, Changing alignment of cells, Undoing and redoing actions, Formatting numbers, Clearing formats, Applying borders to cells, Merging cells |
Formulas and Functions - Entering formulas, Copying data and formulas, Using AutoSum, Understanding functions, ,Using simple aggregate functions (Sum, Count, Average, Min, Max), Copying formulas, Applying conditions in a formula (The IF function), Working with ranges |
Editing Features - Using cut , copy, and paste operations, Using paste special with values, Selection techniques, Navigation techniques |
Working with Large Worksheets - Freezing and unfreezing panes, Splitting windows, Inserting page breaks for printing |
Working with Charts - Creating charts using Chart Wizard, Creating different types of charts, Including titles and values in charts, Formatting of charts |
Previewing and Printing - Previewing worksheets, Page setup, Printing of worksheets in multiple pages, Repeating rows and columns for multiple pages, Printing multiple worksheets |
Simple Database Operations - Sorting tables, Filtering data with auto filter, Referring data from other worksheets |
Introduction - To Start the Program, What is powerpoint, Parts of powerpoint window, Overview of Menu bar |
File Menu - New autocontent wizard, New blank presentation, To Save the File, Save As, Open, Close Exit |
Edit Menu - Cut & Paste, Copy & Paste |
PHASE - II - Edit Menu, Find, Replace |
View Menu - Normal, Slide Sorter, Notes Page, Slide Show, Slide Master, Title Master, Black and White, Toolbars, Ruler, Header and Footer |
Insert Menu - New Slide, Slide Number, Date & Time, Comment, Slide Number, Date & Time, Comment, Picture, Text Box, Table, Object, Picture, Text Box, Table, Object |
PHASE - III - Format Menu, Font, Bullet and Numbering, Slide Layout, Slide Color Scheme, Background, Design Templates, Colors and lines |
Tool Menu - Auto Correct, Macro, Customize, Option |
SLIDE SHOW MENU - View Show, Set Up Show, Action Buttons, Preset Animation, Custom Animation, Slide Transition, Custom Shows |
Advanced Excel Course - Overview of the Basics of Excel - Customizing common options in Excel, Absolute and relative cells, Protecting and un-protecting worksheets and cells |
Advanced Excel Course - Working with Functions - Writing conditional expressions (using IF), Using logical functions (AND, OR, NOT), Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX), VlookUP with Exact Match, Approximate Match, Nested VlookUP with Exact Match, VlookUP with Tables, Dynamic Ranges, Nested VlookUP with Exact Match, Using VLookUP to consolidate Data from Multiple Sheets |
Advanced Excel Course - 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 |
Advanced Excel Course - Working with Templates - Designing the structure of a template, Using templates for standardization of worksheets |
Advanced Excel Course - Sorting and Filtering Data - Sorting tables, Using multiple-level sorting, Using custom sorting, Filtering data for selected view , (AutoFilter), Using advanced filter options |
Advanced Excel Course - 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, Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field), Viewing Subtotal under Pivot, Creating Slicers ( Version 2010 & Above) |
Advanced Excel Course - More Functions Date and time functions - Text functions, Database functions, Power Functions (CountIf, CountIFS, SumIF, SumIfS) |
Advanced Excel Course - Formatting - Using auto formatting option for worksheets, Using conditional formatting option for rows, columns and cells |
Advanced Excel Course - Macros - Relative & Absolute Macros, Editing Macro's |
Advanced Excel Course - WhatIf Analysis - Goal Seek, Data Tables, Scenario Manager |
Advanced Excel Course - Charts - Using Charts, Formatting Charts, Using 3D Graphs, Using Bar and Line Chart together, Using Secondary Axis in Graphs, Sharing Charts with PowerPoint / MS Word, Dynamically, (Data Modified in Excel, Chart would automatically get updated) |
Advanced Excel Course - New Features Of Excel - Sparklines, Inline Charts, data Charts, Overview of all the new features |
Advanced Excel Course - Final Assignment - The Final Assignment would test contains questions to be solved at the end of the Course |
Enterprise Bean overview |
Types of enterprise beans |
Advantages of enterprise beans |
The Life Cycles of Enterprise Beans |
Working with Session Beans |
Statefull vs. Stateless Session Beans |
Working with Entity Beans |
Message Driven Beans |
JNDI (Java Naming and Directory Interface) |
JNDI API |
Context operations |
Using JNDI in J2EE applications |