ASP.Net & Ms-Sql

INTRODUCTION TO ASP.NET

• OOPs Concepts
• From ASP to ASP.NET
• Web Forms
• Web Services
• ASP.NET Features

WEB FORMS ARCHITECTURE

• Page Class
• Web Forms Life Cycle
• Web Forms Event Model
• Code-Behind

ASP.NET AND HTTP

• Request/Response Programming
• HttpRequest Class
• HTTP Collections
• HttpResponse Class
• Redirection
• HttpUtility Class

WEB APPLICATIONS USING VISUAL STUDIO

• AndroidManifest.xml
• Using Visual Web Developer
• Visual Studio Forms Designer
• Using Components
• Shadow Copying
• Using the Global.asax File
• Data Binding

STATE MANAGEMENT AND WEB APPLICATIONS

• Session State
• Application State
• Multithreading Issues
• Cookies

SERVER CONTROLS

• HTML Server Controls
• Web Forms Server Controls
• Rich Controls
• Validation Controls
• User Controls

CACHING IN ASP.NET

• What Is Caching
• Page-Level Caching
• Optimizing Your ASP.NET Application
• Application Caching

ASP.NET CONFIGURATION AND SECURITY FUNDAMENTALS

• Configuration Overview
• Authentication and Authorization
• Forms Authentication
• Windows Authentication
• Security and ASP.NET

DEBUGGING, DIAGNOSTICS AND ERROR HANDLING

• Debugging
• Application Tracing
• Page Tracing
• Error Handling

MORE SERVER CONTROLS

• Most recent ASP.NET Controls
• ASP .NET
• Menus
• Master Pages

ADO.NET AND LINQ

• ADO.NET Overview
• NET Data Providers
• Connections
• Commands
• DataReaders and Connected Access
• Data Sets and Disconnected Access
• Language Integrated Query

DATA ACCESS IN ASP.NET

• Most recent ASP.NET Controls
• Data Source Controls
• Connection String Storage
• GridView
• DetailsView
• FormView
• Object Data Sources
• ListView
• DataPager
• LinqDataSource

PERSONALIZATION AND SECURITY

• Configuration Overview
• Themes
• Skins
• Security in ASP.NET
• Membership and Roles
• Login Controls
• User Profiles

INTRODUCTION TO ASP.NET AJAX

• Rich Client ApplicationsAJAX
• ScriptManager
• UpdatePanel
• AJAX Client Library
• Remote Method Calls
• AJAX Control Toolkit

HTTP PIPELINE

• Pipeline Architecture
• Contex
• Applications
• Handlers
• Modules

Microsoft SQL Server is the high-performance relational database engine from Microsoft for its Windows Servers and development tools. Microsoft SQL Server is widely used in many businesses, from small to large, for a wide variety of applications. It is an excellent backend database for web server applications and software, and is highly recommended for active web sites.SQL Server is a relational database management system (RDBMS) from Microsoft that’s designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables

SQL SERVER BASICS

• Client-Server database architecture and SQL Server architecture
• Installing MS SQL Server (2008, 2012 or earlier)Tables, relational
• databases, SQL and database objects
• Design and develop MS SQL Server databases and tables
• Referencing objects in SQL Server databases
• Obtaining information from database tables
• SQL Server security

UNDERSTANDING TABLES AND DATABASES

• Creating databases manually
• Creating databases with database wizard database
• Defining a maintenance plan wizard
• Databases using Transact-SQL
• Database manipulation: characteristics and deletions
• Working with tables

INDEXES AND VIEWS

• The basics of index structures
• Creating and working with indexes
• Indexes and table architecture
• Creating views (including using view manager)
• Working with views
• Indexed views

DATABASE DIAGRAMS, THE QUERY ANALYZER AND SQL BASICS

• Working with diagrams
• Diagramming for pubs database
• Server connectivity and Screen management
• Working with queries
• SQL essentials (select, create table, insert, delete, update)

STORED PROCEDURES, TRIGGERS AND REPLICATION

• Components of stored procedures
• Creating and working with stored procedures/system stored procedures
• Components of triggers
• Creating and working with triggers
• Replication model and types of replication
• Merge replication

DATA TRANSFORMATION SERVICES (DTS), BACK UPS/RESTORES, USERS, ROLES, LOGINS AND

• Analysis Manager
• Creating, importing and exporting DTS
• Creating, scheduling backups and restores
• Authentication types, users, roles, security plans
• Configuring DSN, loading analysis manager and working with cubes
• Work on a final project