. NET (C#,ASP,SQL Server) on 29th Dec (Monday) 9:00AM at Kphb(Hyd) by Mr.Mohan Reddy

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