Batch
Date: 3rd Mar @ 9:00AM
Faculty: Mr. Mohan Reddy
Duration:
45 Day's (Fast Track)
Fee: 2500/- + Reg Fee 100/-INR
Location
:Kphb, Hyderabad.
Venue
:
3rd floor, above HDFC bank
Near JNTU signal, Kukatplly
Hyderabad-500085
Syllabus:
C#.Net
Introduction To
.Net
What is .net?
.Net Platform Independent or not
.Net framework
CLR (Common Language Runtime)
CTS (Common Type System)
BCL or FCL (Framework Class Libraries)
CLR (Common Language Runtime)
JIT (Just Ion Time) Compilation and its types
Introduction To C#.Net
Features of C#.Net
Data Types in C#.net
Value types and Reference types
Boxing and Unboxing
Console Applications and Console Class
Conditional and Looping Control Statements
Arrays
One Dimensional Arrays
Two Dimensional Arrays
Jagged Arrays
Members Of Array Class
Functions
Optional Parameters
Param Array Parameters
Ref and Out Parameters
Pointers
Structures
Enumerations
ASP.Net
Introduction To Web Applications
Types of Applications – Desktop, Web , Mobile and Service
Oriented Applications
HTML
Java Script
CSS
What is Webserver and its Purpose
IIS Web Server and Configuring IIS Web Server
What is Virtual Directory and How To Create It
Introduction To ASP.Net
What is ASP.Net and How To Create ASP.Net Web Pages
How The Request For An ASP.Net Page Is Processed
Request and Response Objects
Page Submission Methods Post and Get
ASP.Net Page Postback
Creating ASP.Net Web Pages In Visual Studio.Net
How to create ASP.Net Website in Visual Studio.Net
In page and Code Behind Techniques
Client Side and Server Side Controls
HTML Server Controls and Web Server Controls
Standard Web Server Controls – TextBox, Button, Label,
Listbox, DropDownList, CheckBox, RadioButton, CheckBoxList,
RadioButtonList, Image, LinkButton, ImageButton, HyperLink,
View , MultiView, AdRotator, Calendar and FileUpload
Validations
Types of Validations – Client Side Validations and Server
Side Validations
Validation Controls – RequiredFieldValidator, CompareValidator,
RangeValidator, CustomValidator, RegularExpressionValidator
and ValidationSummary
Validation Groups
ADO.Net
History of Database Technologies By Microsoft
ADO.Net Data Providers
SqlClient
OracleCLient
OLEDB
ODBC
ADO.Net Architecture
Disconnected Architecture
Connected Architecture
Creating Connection To Various Data Sources
Examples with Disconnected and Connected Architecture
Calling Stored Sub Programs using ADO.Net
Connection Pooling
Web.Config File and its use related to ADO.Net
Data Bound Controls Of ASP.Net
GridView
DataList
Repeater
ListView
FormView
DetailsView
ASP.Net Worker Process
and Page Life Cycle
State Management
What is State Management?
Client Side State Management Techniques
Cookies
Query String Parameters
ViewState
Server Side State Management Techniques
Session State Management
Configuring Session State in Web.Config File
Session Object and its Members
In Process and Out Of Process Sessions
State Server
SQL Server
Application State Management
Handling Session and Application Events
Caching
Page Output Caching
VaryByParam
VaryByControl
VaryByHeader
VaryByCustom
Cache Location
File Dependency
DataSource Caching
Data Caching
Cache Object and Its Members
File Dependency
Sql Cache Dependency
Polling Sql Cache Dependency
Push Sql Cache Dependency
Partial Page Caching
Post Cache Substitution
ASP.Net User Controls
Security In ASP.Net
What is Authenticatin and Authorization
Types of Authentication
Windows
Passport
Forms
Implementing Forms Authentication
Configuring Forms Authentication In Web.Config File
FormsAuthentication Class and its Members
Impersonation
Implementing Security With Login Controls
Web Parts In ASP.Net
Localization and Globalization
Master Pages
Introduction
Creating Master Pages and Content Pages
Accessing Master Page Content From Content Page
Dynamic Master Pages
Themes
Introduction
How To Create themes and apply them to pages
Dynamic themes
Global themes
Mobile Application Development
In ASP.Net
Introduction to mobile web app
Different ways to create asp.net mobile web apps
ASP.Net Web Application Deployment
Introduction to SQL Server :-
Understanding Client/Server Architecture
SQL Server Versions
SQL Server Instance
SQL Server Editions
Tools in SQL Server
SQL Server Management Studio
Creating Sample DB manually & using wizard
Introduction to TSQL
Sublanguages of TSQL
DDL,DML,DRL,TCL,DCL
Creating Tables
Inserting Data into Tables
Working With Single Table Queries
:-
Writing Queries using SELECT statement
Understanding Query Flow
Operators in SQL Server
Clauses in SQL Server
Filtering Data Using WHERE clause
Sorting Data Using ORDER BY clause
Eliminating Duplicates using DISTINCT clause
Using TOP clause
DML commands :-
Copying data from one table to another
Update Command
Delete Command
Using OUTPUT clause
DDL commands :-
Creating Tables from another table
ALTER command
DROP command
TRUNCATE command
DELETE vs TRUNCATE
Built-in Functions :-
Scalar Functions
String
Date
Mathematical
Conversion
Environment
Working with NULL & coalesce
Group Functions
Aggregating Data :-
Writing Queries using Aggregate functions
Grouping Data Sets
Filtering Groups using HAVING clause
Adding Grand Total
Grouping_id function
Generating Matrix Report
Using New Window Functions
Merging Data With JOINS &
UNION :-
Importance of Join operation
Types of Joins
Inner join or equi join
Outer join
Left Outer Join
Right Outer Join
Full Outer Join
Non-equi Join
Self Join
Cross Join
Complex joins
Stacking Data with UNION
Finding Set Difference
JOIN VS UNION
SubQueries :-
Importance of Subquery
Types of Subqueries
Single Row Subqueries
Multi Row Subqueries
Nested Queries
Co-related Subqueries
Derived Tables
Subqueries as Expressions
WITH clause
TOP N Queries
Database Transactions :-
Controlling Transactions using COMMIT
& ROLLBACK
Introducing ACID properties
Working With LOCKS
Viewing DeadLocks
Various Isolation Properties
Database Security :-
Understanding privileges
Types of privileges
Granting & Revoking Privileges
Schema Objects :-
Views
Synonyms
Creating indexes
Examining Query Execution Plan
Materialized Views
TSQL programming :-
Introduction to TSQL
Writing programs
Working with variables
Controlling Procedural Flow
Working With CURSOR
Handling Errors
Controlling Transactions
Stored Procedures :-
Introduction to Stored Procedures
Working with Parameters
Working with OUT parameters
Optional parameters
Calling stored procedures from front-end applications
User Defined Functions :-
Creating Scalar Functions
Working with Inline Table-Valued Functions
Triggers & AUDIT TRAILS :-
Purpose of creating Triggers
Using AFTER triggers
Using INSTEAD OF triggers
Disabling triggers
Auditing Data changes
Advanced Topics in SQL SERVER
Creating Reports using SSRS
