Web application devep.ASP.Net

Course details


Overview of
 Introduction of different Web
Technology
 What is
 How Works
 Use of visual studio
 Different Languages used in

 Summary
FRAMEWORK
 Common Language Runtime
(CLR)
 .NET Framework Class Library.
 Summary
SETTING AND INSTALLINA

 Installing Internet Information
Server
 Installation of
 Virtual directory
 Application Setting in IIS.
 Summary
Microsoft SQL Server 2008
 Overview of SQL Server 2008
 Installation of SQL Server 2008
 Features of SQL Server Express
 SQL Server 2008 Express
management tools
SQL Server Basic
 Database Architecture
 Data Manipulation Language
(DML)
 Data Definition Language (DDL)
 Manipulation of Data (SQL
Command)
 Stored Procedure
 Function
 Trigger
 Views
 Cursor
OVERVIEW OF DATA ACCESS
 Creating database connections
 Connecting to MSSQL Server
and MS Access
 Dataset & Data Table
Features
 Using inline SQL Statements
 Using Stored Procedures
 Executing select commands
 Sql Transaction
 Summary

 What is AJAX?
 What is
 Script Manager
 Update Panel
 Update Progress
 Timer
 AJAX Control Toolkit
 Coding Standards
 Overview of coding standards
follows during programming
 Summary

 Mysql Database
• INTRODUCTION
• CREATE DATABASE
• DROP DATABASE
• SELECT DATABASE
• DATA TYPES
• CREATE TABLES
• DROP TABLES
• INSERT QUERY
• SELECT QUERY
• WHERE CLAUSE
• UPDATE QUERY
• DELETE QUERY
• LIKE CLAUSE
• SORTING RESULTS
• USING JOIN
• NULL VALUES
• ALTER COMMAND
• FUNCTIONS
• DATABASE INFO
• USING SEQUENCES
• HANDLING DUPLICATES
• DATABASE EXPORT
• DATABASE IMPORT
 Live Project Updated on 28 July, 2020