My Village
My Village
Home
My village
Profile
History
Geography
Demography
Emergency Services
Ambulance Services
Fire Station
Hospitals
Police
GAS Services
Electricity Supply
Chemists (Day & Night)
Water Supply
Infrastructure
Banks
Colleges/Schools
Govt offices
Transport Services
City Bus Guide
Railway Times
Airways
My Pride
My Institute
About Us
Profile
Vision
Mission
Contact Us
My Institute
Home Page
My Institute
Previous
Next
74,531
Total Orders
53
Today orders
55
Total Items
75,00
No.of visitors
Available Courses
Computer Basics
Basics of computer
About Computer H/W & S/W
Creating of Folder,Files
Different fileformats
About Browsers
About Notepad,MS-Dos,Paint
About Calculator,Word pad
Microsoft Word
Introduction to Ms - Word
File Opening ,Saving, Closing
Print, Page Setups, page Layouts
Page Numbers, Date & Time
Drawing the Pictures ,Shapes
Bullets & Numbering, Hyperlinks
Borders & Shading, Themes
Borders & Shadings, BG colors
Mail Merge, Envelops & Labels
Creating Tables
Creating of ressumes
Microsoft Excel
Introduction to Excel Sheets
Functional Formula
Create Macros, Validation
Create Payrolls, Tables
Create Accounts Using Formula
Graphs , Charts
Advance Excel
Look up, H Look Up
Sum If, Count If functions
Index & Match Functions
Pivot Tables Charts
Filters. Adv Filters
Paste Links
Paste Special
Import Tables Excel To Word
Custom List, Data Functions
Logical Functions Name Define
Data Functions
text Functions
Conditional Formatting
Sub Total Functions
Goal seek, pmt Functions
Protect Book & Sheet
Scenarios, number series
Sheet Breaks
formula Auditing
Hide And Unhide Sheets, Object
Columns And Rows, Print Titles
Smart Art, watch windows
Microsoft Power Point
Introduction to Ms-power point
Create Designing Slides
Create Custom Animations
Sound effects & BG Design
Create Timing Presentation
Slide Shows Presentation
Creating of business power point with brief explanation
Microsoft Access
Introduction to MS Access
Table in Design view
Table by Using Wizard
Data base, Tables Creations
Forms, reports, queries
INTERNET CONCEPT
Creating e-mails
sending e-mail
Online job searching, interviews
Online tickets booking, shopping
Downloading files, websites
Sql
Introduction To SQL Server
Advantages and Drawbacks Of SQL Server Compared To Oracle And DB2
Connecting To Server
Server Type
Server Name
Authentication Modes
Windows Authentication Mode
Login and Password
Sql Server Management Studio and Tools In Management Studio
Object Explorer
Object Explorer Details
Query Editor
TSQL (Transact-Structured Query Language)
Introduction To TSQL
History and Features of TSQL
Types Of TSQL Commands
Language Commandes
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Data Control Language (DCL)
Transaction Control Language (TCL)
Database
Creating Database
Altering Database
Deleting Database
Constrains
Procedural Integrity Constraints
Declarative Integrity Constraints
Not Null, Unique, Default and Check constraints
Primary Key and Referential Integrity or foreign key constraints
Table
Creating Table
Altering Table
Deleting Table
Data Manipulation Language
Insert
Identity
Creating A Table From Another Table
Inserting Rows From One Table To Another
Update
Computed Columns
Delete
Truncate
Differences Between Delete and Truncate
Data Query Language (DQL)
Select
Where clause
Order By Clause
Distinct Keyword
Isnull() function
Column aliases
Predicates
Between … And
In
Like
Is Null
Built In Functions
Scalar Functions
Numeric Functions
Character Functions
Conversion Functions
Date Functions
Aggregate Functions
Convenient Aggregate Functions
Statistical Aggregate Functions
Group By and Having Clauses
Super Aggregates
Over(partition by …) Clause
Ranking Functions
Joins
Inner Join
Equi Join
Natural Join
Non-Equi Join
Self Join
Outer Join
Left Outer Join
Right Outer Join
Full Outer Join
Cross Join
Sub Querie
Single Row Sub Queries
Multi Row Sub Queries
Any or Some
ALL
Nested Sub Queries
Co-Related Sub Queries
Exists and Not Exists
Indexes
Clustered Index
NonClustered Index
Create , Alter and Drop Indexes
Using Indexes
Security
Login Creation
SQL Server Authenticated Login
Windows Authenticated Login
User Creation
Granting Permissions
Revoking Permissions
Roles
Views
Purpose Of Views
Creating , Altering and Dropping Indexes
Simple and Complex Views
Encryption and Schema Binding Options in creating views
Transaction Management
Introduction
Begin Transaction
Commit Transaction
Rollback Transaction
Save Transaction
Role Of Log File In Transaction Management
Implicit Transactions
TSQL Programming
Drawbacks Of TSQL that leads to TSQL Programming
Introduction To TSQL Programming
Control statements In TSQL Programming
Conditional Control Statements
If
Case
Looping Control Statements
Cursors
Working With Cursors
Types Of Cursors
Forward_Only and Scroll Cursors
Static, Dynamic and Keyset Cursors
Local and Global Cursors
Stored Sub Programs
Advantages Of Stored Sub Programs compared to Independent SQL Statements
Stored Procedures
Creating , Altering and Dropping
Optional Parameters
Input and Output Parameters
Permissions on Stored Procedures
User Defined Functions
Creating, Altering and Dropping
Types Of User Defined Functions
Scalar Functions
Table Valued Functions
Inline Table Valued Functions
Multi Statement Table Valued Functions
Permissions On User Defined Functions
Triggers
Purpose of Triggers
Differences Between Stored Procedures and User Defined Functions and Triggers
Creating, Altering and Dropping Triggers
Magic Tables
Instead Of Triggers
Exception Handling
Implementing Exception Handling
Adding and removing User Defined Error Messages To And From SQL Server Error Messages List
Raising Exceptions Manual
HTML5 and CSS3 Course
Introduction to WEB
W3C and W3C Members
Why WHATWG?
What is Web?
HTML Basics
Introduction
Parts in HTML Document
Editors
Basic
Elements
Attributes
Headings
Basics
Paragraphs
Formatting
Links
Head
CSS
Images
Tables
JavaScript
HTML XHTML
HTML4 Drawbacks
HTML5 Introduction
HTML5 HISTORY
New Features and groups
Backward Compatibility
Why HTML5?
Power of HTML5:
m or mobi or touch domains
Common Terms in HTML5
Obsolete Elements/Deprecated Elements
<acronym>
<applet>
<basefont>
<big>
<center>
<dir>
<font>
<frame>
<frameset>
<isindex>
<noframes>
<s>
<strike>
<tt>
<u>
<xmp>
HTML5 New Elements
New Semantic/Structural Elements
<article>
<aside>
<bdi>
<command>
<details>
<dialog>
<summary>
<figure>
<figcaption>
<footer>
<header>
<mark>
<meter>
<nav>
<progress>
<ruby>
<rt>
<rp>
<section>
<time>
<wbr>
HTML5 Canvas
What is Canvas?
Create a Canvas
Canvas Coordinates
Canvas – Paths
Canvas – Text
Canvas – Gradients
Canvas – Images
HTML5 SVG<
What is SVG?
SVG Advantages
Differences Between SVG and Canvas
Comparison of Canvas and SVG
HTML5 Drag/Drop
Introduction
Make an Element Draggable
What to Drag?Where to Drop?
HTML5 Geo location
Introduction
Locate the User’s Position+
Handling Errors and Rejections
The getCurrentPosition()
Geolocation object
HTML5 Video
Introduction
Video on the Web
How It Works?
Video Formats and Browser Support
HTML5 Video Tags
HTML5 Audio
Introduction
Audio on the Web
How It Works?
Audio Formats and Browser Support
HTML5 Audio Tags
HTML5 Input Types
Introduction
color
date
datetime
datetime-local
email
month
number
range
search
tel
time
url
week
HTML5 Form Elements
<datalist>
<keygen>
<output>
HTML5 Form Attributes
New attributes for <form> and <input>New attributes for <form>:
autocomplete
novalidate
New attributes for <input>
autocomplete
autofocus
form, formaction
formenctype,formmethod
formnovalidate
formtarget
height and width
list, min and max
multiple
pattern (regexp)
placeholder
required, step
HTML5 Semantic
Introduction
What are Semantic Elements?
non-semantic elements: <div> and <span>
semantic elements: <form>, <table>, and <img>
New Semantic Elements in HTML5
<header>
<nav>
<section>
<article>
<aside>
<figcaption>
<figure>
<footer>
HTML5 Web Storage
What is HTML5 Web Storage?
Browser Support
The localStorage Object
The sessionStorage Object
HTML5 App Cache
What is Application Cache?
Cache Manifest Basics
HTML5 Cache Manifest
HTML5 Web Workers
What is a Web Worker?
Check Web Worker Support
Create a Web Worker File
Terminate a Web Worker
HTML5 SSE
One Way Messaging
Browser Support
The EventSource Object
HTML Media
New Media Elements
<audio>
<video>
<source>
<embed>
<track>
HTML Multimedia
What is Multimedia?
Browser Support
Multimedia Formats
Video Formats
Sound Formats
HTML5 – MathML
Introduction
Using MathML Characters
Matrix Presentation
Math Formulas
CSS 1.0 and 2.0
CSS Basics
CSS Introduction
CSS Syntax,CSS Id, Class and CSS Styling,Styling Backgrounds
Styling Text,Styling Fonts, Links, Styling Lists and Styling Tables
CSS Border
CSS3
Introduction
CSS3 Modules
Selectors
Box Model
Backgrounds and Borders
Text Effects
2D/3D Transformations
Animations
Multiple Column Layout
User Interface
Borders
border-radius
box-shadow
border-image
CSS3_Backgrounds
background-size
background-origin
CSS3 Text Effects
text-shadow
word-wrap
CSS3 2D Transforms
How Does it Work?
Browser Support
2D Transforms
translate()
rotate()
scale()
skew()
matrix()
CSS3 3D Transforms
rotateX()
rotateY()
CSS3 Animations
CSS3 @keyframes Rule
Browser Support
Animation, animation-duration
CSS3 Transitions
How does it work?
transition-property, duration and delay
CSS3 Multiple Columns
column-count
column-gap
column-rule
CSS3 User Interface
resize
box-sizing
outline-offset
C Language
Introduction to ‘C’ language
Features of C
History
Structure of C Program
Keyword, Identifiers & Constants
Data Types
Primitive Data Types
Aggregated Data Types
Operators
Binary Operators
Unary Operators
Ternary Operators
Special Operators
Order of Evaluation
Selections
Simple if
if..else
Nested if
if..else ladder
Goto Statement
Break and Continue Statement
Switch..Case statement
Iteration
While
For
Do..While
Nested loop Statements
Arrays
Introduction to arrays
Need for Arrays
Types of arrays
String Manipulation
DeclaringString
String Functions
Multiple Strings
Functions
Interdiction to Functions
Function Prototype
Calling Function
Function with Arrays
Function with Strings
Recursive Functions
Storage class Specifiers
Automatic
Register
Structures, unions, enum
Introduction to structures
Structures with Arrays
Structures with Function
Nested Structures
Declaring Union
Difference between Structures and Unions
Enumerations
Pointers
Introduction to Memory,Pointers
Operations on Pointers
Pointer to Pointer,Arrys
Void pointers
Call by Value and Call by Reference
Pointer to Functions
Pointers with Structures
Dynamic Memory Allocation
Allocation (Malloc, Calloc & Realloc)
De – Allocation (Free)
Files
File Input, Output Operations
Sequential,Random Access Files
Handling ErrorsDatabase vs File Sy
Command Line Arguments,stem
Graphics
Introduction to Graphics
Initializing Graphics
Graphic Drivers & Modes
Graphic Functions
C++ Language
Basic In C++
Programming Methods
Object-Oriented Programming
Introduction to C++
Variables, Datatypes, Operators
Reference Operator
Scope,Resolution Operators
New Structure of a C++ Program
Control Structures
Conditional – if, if…else, Nested if…else, Switch…Case
Loops – While, do…While, For, Nested Loops
Jump – Goto, Continue & Break
Functions
Introduction a Function
Deafening a Function
Prototypes
Actual and Formal Arguments
Parameter Passing Techniques
Call by Value, Reference, Pointer
Default Arguments
Function Overloading
Inline Functions
Oops_Concepts
Encapsulation
Abstraction
Polymorphism
Static Binding
Dynamic Binding
Inheritance
Message Passing
Class
Object
Classes and Objects
Class Declaration
Access Member and Member Functions
Creating Objects
Differences between Class and Structure
Objects as arguments
Returning Objects
Static Members
Friend Functions and Classes
Constructors and Destructors
Introduction
Defining Constructor
Comparing Constructor Member Function
Default Constructor
Argument Constructor
Copy Constructor
Constructor Overloading
Default Argument in Constructor
Destructor
Defining Destructor
Operator Overloading
Need of Overloading
Defining Operator Overloaded Function
Operator Overloading Rules
Overloading Unary Operators and Unary Operators
using Friend
Overloading Binary Operators and Binary Operators
using Friend
Overloading Other Operators
Inheritance
Introduction
Types of Inheritance
Single Level Inheritance
Multilevel Inheritance
Multiple Inheritance
Hybrid Inheritance
Hierarchical Inheritance
Base Class
Derived Class
Inheritance Scope
Protected Members
Virtual Base Class and Destructors
Advanced Class Concepts
Container Class & Contained Class
Local Classes
Inheritance v/s Containership
Polymorphism and Virtual Functions
Type Polymorphism
Dynamic Binding
Function Overriding
Difference between Function Overloading and Overriding
Need of Virtual Functions
Pure Virtual Functions
Templates
Need of Template
Defining Template
Function Templates
Class Templates
Exception Handling
What is Exception?
Need of Handling Exceptions
Types Of Exceptions
Exception Handling Mechanism
Streams
Hierarchy of I/O Streams
Istream Class Functions
Ostream Class Functions
IOS Class Functions
Manipulators
Files
Hierarchy of File Streams
Opening a File
File Opening Modes
Sequential Access Files
Random Access Files
Command Line Arguments
Graphics
Introduction to Graphic
Initializing Graphic
Graphic Drivers, Modes and Graphic Functions
Asp.NetMvc
Introduction
Understanding ASP.NET MVC
ASP.NET vs. MVC vs. ASP.NET Web Form vs. ASP.NET MVC
Advantages of ASP.NET MVC
Visual Studio Project Templates
Understanding Visual Studio ASP.NET MVC Templates
Creating an ASP.NET MVC project
Understanding ASP.NET MVC project folder structure
Understanding configuration files
Controller & Actions
Understanding Controller
Creating Controller
Understanding Actions
Actions and Non Actions Methods
Understanding Action Results
Views
Types of Views
Creating Standard View
Creating Layout Page
Communication between Controller and View
MVC Pattern and 3-Tier
Understanding Model, View and Controller
Design Pattern vs. Architectural Pattern
Layer vs. Tier
MVC pattern vs. 3-Tier Architecture
Razor View Engine
Understanding Razor View Engine
Razor View Engine vs. Web Form Engine
Razor Syntax
Razor Statements, Loops etc.
Routes & URLs
Introduction to Routing
Routing vs. Url Rewriting
Defining Routes
Attribute Routing
Need of attributes routing
Helpers
Understanding Html Helpers
Types of Html Helpers
Built-In Html Helpers
Standard Helpers
Strongly Typed Helpers
Templated Helpers
Inline Helpers
Custom Helpers
Url helpers
Server-side Data Receiving Ways
Action Parameters
View Models/Objects
FormCollection
Partial Views
Static Partial View
Dynamic Partial View
Data Passing Techniques
ViewData
ViewBag
TempData
Session
Query String
Hidden Fields
Cookies
ViewModel & Validation
Creating ViewModel
Understanding ASP.NET MVC Validation
Need of Server Side and Client Side Validation
Validation with Data Annotation
Custom Validation
Custom client side Validation
Custom Server side validation
Data Passing Techniques
ViewData
ViewBag
TempData
Session
Query String
Cookies
WebGrid: Listing, Paging and Sorting
Creating Custom Paging Method
Using WebGrid for Listing, Paging and Sorting
Ajax WebGrid
ASP.NET Web API
Introduction to SOA
Introduction to REST
REST Principles
Understanding ASP.NET Web API
Choosing between WCF and WebAPI
ASP.NET Web API Controller & Actions
Understanding Controller & Actions
Creating Controller
Creating Actions
Database Operations and Postman
CRUD Operations using Web API
Using Postman for testing Web API
Consuming Web API using ASP.NET MVC
Forms Authentication
Understanding Forms Authentication
Customizing principal
Implementing custom Forms Authentication
ASP.NET MVC Pipeline and Filters
ASP.NET MVC Pipeline
ASP.NET MVC Filters
Extending ASP.NET MVC Filters
Configuring ASP.NET MVC Filters
C# Language
.Net Framework [Advanced]
Advantages/Disadvantages
Features of .Net
Assemblies in Detail
GAC, Strong Names
Language Interop
Reflection
Visual C#.Net Language
Advantages/Disadvantages
Why C#/ Why Not C#
Where does C# Fit in
C, C++ to Visual C#
Features of C#
.NET Namespaces
.Net Installations/C#.Net
Visual Studio.NET 2003/2005/Orcas/2008
Windows Vista – New Look
Gadgets/SideBars/UAC – relation with .NET
Hardware/Software Requirements
FAQ’s with detailed answers
Programming Using Visual C#.Net
The start of the application
C#.Net Program Design
Variables and types
Value types and reference types (CTS)
Strings and arrays
The Console class
String formatting
Statements and flows
Programming Structures
Command-line arguments
VS.NET to Create C#.NET Apps
C# 3.0/3.5 features – Implicit types , Extention Methods and more
Object Oriented Concepts (Basic)
Classes & objects
Abstract & override methods
Creating and using your own classes l Data members and member methods l Instantiate an object
This keyword
Properties – Read Only Write Only…
Build process using windows class library l Generate classes for other clients
How to use classes as part of project
Object Oriented Concepts (Advanced)
Accessibility levels, specifiers
Constructors
Method overloading
Class (static) variables & methods
Object destruction
‘ref’ and ‘out’ parameters
Constant values
Enumerations
Inheritance and Polymorphism
The root of all classes
Creating derived classes
Method overriding and hiding
Polymorphism and virtual functions
Casting objects
Abstract classes
Sealed classes
Static classes
Object Oriented Concepts (Implementation Oriented)
Case Studies
Class Diagram in VS.Net
Refactoring & others
FAQ’s
Error Handling
Unstructured error handling support
Structured error handling
Error categories
Debugging the application
Debug and Trace classes
Code Optimization
Testing and strategies
Asp.Net
ASP.NET Training Course Objective
Introduction to web technologies
Web Forms Architecture
ASP.Net and HTTP
Web application developing using Visual Studio
State Management and Web Applications
ASP.Net Server-side controls
Caching in ASP.Net
ASP.Net application configuration
Debugging, Diagnostics of application
Connectivity with Database using ADO.Net/Entity Framework
Data Access Controls
Personalization and Security
Introduction to Web Services
Introduction to WCF
OVERVIEW OF .NET (ASP.NET)
Intro to .NET
Drawbacks of Current Trend
.NET Framework
Key Design Goals
CLR, CTS, MSIL, & Other Tools
Multiple Language Interaction & Support
Moving from Project to Assemblies…
Security Services and environment
Vista & IIS 6.0/7.0 & their requirements
Installing & Configuring VS.NET/.NET 2.0/3.0/3.5
AJAX(ATLAS) importance in Web applications
The need for AJAX & the Solution
ACTIVE SERVER PAGES .NET ROLE
Shifting from ASP to ASP.Net, Asp.net to web 2.0 (new)
ASP.Net as Framework, Namespaces
ASP.Net – New Scenario in development process with IDE – VS.NET
Web Pages to Web Forms, HTML – ASP.NET, State management- an Important Objective
Understanding the ASP.NET Execution Scenario
C#.Net role in ASP.NET Development
ASP.NET/C#.Net – the Industry approach
HTML, HTML Controls, ASP.NET Controls
Client-side & Server-side Controls
Consuming HTML Client/Server Controls in WebForms
Consuming ASP.Net Controls in WebForms
Understanding the Rendering Nature of Controls Developing a Simple Startup Application
ASP.NET WEB FORMS – THE NEW TECHNOLOGY(BEGINNING)
Introducing Web Forms, Worker process
Working with Server Controls
Applying Styles to Controls, Themes, Skins etc
FORM
Page Directives and its use
Separating Code & Design
New Code behind Techniques
Implementing ASP.NET Server Controls
Types of ASP.NET & their need/render
Intrinsic – Validation – Bound – DataSource
Navigation – Login – Web Parts & AJAX.-as building blocks Asp.net.
WEB FORMS – INTRODUCTION TO AJAX INPUT VALIDATION
Validating Form with Validation Controls of Asp.net
Using RequiredFieldvalidator control
Using CompareValidator Control Using RangeValidator Control
Using CustomValidator control
Create Server-side / Client-side functions for – CustomValidator Control
Group Validations & avoiding Validations.
Finally – Client Targets & ValidationSummary control
ADO.NET I – DATABASE SERVICES (V1.1/2.0/3.5)
XML, XML to HTML, XML & Databases
XML Schema Definition Tool
Overview of ADO.NET/ XML Support in .NET
Connect/Insert/Update/Delete,Query data -using ADO.NET
Retrieve data with datasets
Data Adapters, Understanding Data tables
Build Data table programmatically
Filter and sort Data table, Data Relations
ADO.NET LINQ
ADO.NET – II
Parameters with Command Object
Stored Procedures with ADO.NET using –output parameters
Develop a Registration form using ADO
PRESENTING DATA USING ASP.NET BOUND CONTROLS (USING VB.NET/C#)
ASP.Net bound controls
DataSource Controls
Repeater & its uses.
DataBound and DataAware Controls
Bind data to Dropdownlist Control
Datalist control
DataGrid(1.1/2.0) Control
GridView & its importance in Development
GridView(Basic) – simple uses
GridView (Advanced) –Runtime Fields, Empty DataRows, NTier …
FormView & DetailsView
ListView
AJAX (ATLAS )
Introduction to Microsoft AJAX.(Code name ATLAS)
XML Http object
Programming with XML HTTP Object
Advantages and Disadvantages of AJAX.
Features of AJAX.
MS Implementation of AJAX
ASP.NET ERROR HANDLING & DEBUG.
Error Handling & .NET Runtime
Avoid Errors before they occur
Structured Error Handling
Catching General Exceptions
Catching Specific Exceptions
Throwing Exceptions
Custom Exceptions
Page Level Error Handling
Application Level Error Handling
USER CONTROLS
Creating User Controls
Adding member to user controls.
Registering User Controls
Properties & Methods
Dynamically loading user controls
Master Pages
CONFIGURING ASP.NET APPLICATION
Web Application configuration-Advantages.
New Configuration Model, ASP.NET Confn Tool
Web Application Machine Configuration
Global Assembly Cache, Strong Names VS2005.
Working with Assembly Info
Web.Config, Machine.Config
Process Model –System Configuration.
ASP.NET WEB APPLICATIONS
About Session & Application object
Comparison between Session & Application
Using the Global.asax file
Managing Application State
Http Handlers
Application & Session Variables
Application & Session Events
CACHE SERVICES
Caching Overview
Advantages of Caching
Comparing with Application & Session var’s
Page Output Caching
Page Data Caching
Fragment Caching
SECURITY
Security Overview
Authentication & Authorization
Windows-based Authentication
Passport Authentication.(WebServices)
Forms-based Authentication
Memberships
Authorizing Users and Roles
User Account Impersonation
ASP.NET XML WEB SERVICES
Introducing XML Web Services
Differences Between DCOM / Remoting / Web Services
Asp.net Webservices.
Writing a Simple Web Service
Xml web services stack, SOAP,WSDL,UDDI,Sync an
Async calls
Web Service Type Marshalling
Using Data in Web Services
Using Objects and Intrinsic
HTML Pattern Matching
WCF
WEBPARTS
New concept in Web Apps.
Advantages and Disadvantages.
Predefined/ user defined controls with webparts.