Intermediate ASP.NET Web Development with C# (P189)

ASP.NET is a web application framework developed by Microsoft that allows developers to build dynamic web sites, web applications and XML web services. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications.

Learning how to connect and interact with a database is the next step in learning ASP.NET as this class continues from the Introduction to ASP.NET Web Development class.

Students will learn the database class framework, ADO.NET that is used with ASP.NET to connect and interact with different types of databases such as SQL Server, ORACLE, XML and even MySQL. Understanding the syntax of structured query language (SQL) that communicates with the database is covered. Students will be taught different techniques in working with a database to retrieve, filter, display and format data on a web page.

Learning what and how AJAX can be added to an existing ASP.NET to improve visitor interactivity and responsiveness.

AJAX is a set of technologies (JavaScript, the DOM, XML, and the XMLHttpRequest object) that have formed the foundation for many of new interactive (web 2.0) websites you see now on the web. AJAX allows you to update parts of your website without refreshing the entire page.

Students will be using Visual Studio 2010 Express and SQL Server 2005/2008.

Applicable Job Roles: ASP.NET developer, web developer, software engineer, and database engineer

Objectives for this class are:

Overview of databases on the web and Microsoft’s ADO.NET framework
Understand basic syntax of SQL with respect to SELECT, INSERT, and UPDATE statements.
Understand how to use (C#) to interact with classes of the ADO.NET framework to interact with SQL Server databases.
How to programmatically (C#) interact with data server controls in connecting, interacting and filtering data for more RAD of data interaction.
Learn the components of AJAX and how it can be used with ASP.NET
Learn how to code (C#) AJAX-based server controls to update independent sections of an ASP.NET web page.
Overview of some Microsoft ASP.NET Certifications that students can study after taking the class.

Outline

Week 1: Data Sources on the Web

Overview of ADO.NET
SQL Server 2005/2008 (and Management Studio) review and installation
Review our sample database
DataSource controls overview
Connecting to the database (connection string)
Rendering the data

Week 2: SQL Statements, Data Controls and Code

SQL Overview (SELECT with WHERE, IN and BETWEEN)
Comparison operators
Retrieving and filtering your data
Querying multiple tables (JOIN)
Using web.config for global data connections
Exception Handling
Interacting with data and server controls
Review of ADO.NET Connection Objects (instead of SQLDataSource)
SQL Injection Attacks precautions
ADONET: DataReader object

Week 3: Interacting with Data

ADO.NET: DataSet object
INSERT query
Using SCOPE_IDENTITY() for return values
DELETE query
UPDATE query
Using code to maintain referential integrity with your database

Week 4: SQL Server Programming

Benefits of using Stored Procedures
Review of creating a Stored Procedures in SQL Server
How to use Stored Procedures on your web host
Setting up input parameters
Transactions Overview

Week 5: ASP.NET AJAX

Understanding AJAX
Script Manager and Partial Refreshing
Conditional Updating
Update Progress Notification
Timed Refreshing

Week 6: AJAX Toolkit

Component Overview and implementation
Testing our HTTP calls with Fiddler
JavaScript libraries overview
Performance tweaking

Prerequisites

Students have to have taken the Introduction to ASP.NET Web Development or have prior experience with ASP.NET and C#.
Students should have a basic knowledge of HTML and CSS.

Requirements

Software: For web development students can use either:

Commercial or Free Tool: Visual Studio Express 2012 or 2010

Web Hosting: Students are required to have a Windows web host that supports ASP.NET 4.0, including AJAX and SQL Server 2005/2008. Contact the instructor before purchasing web host if do not have one already.

Books:	No book is required.
Suggeted Book:	Beginning ASP.NET 4: in C# and VB
Additional information:
Your place in the course is confirmed by your payment. Introductory courses are intended for students with no experience in the subject matter and are seeking beginner level training. Refund Policy: Please read our Terms and Refund Policy before registering for this course. Additional Cost: Book and software might be required for the course. Read the Requirements and Book section for more information. Course fee does not include the book and software cost . How eClasses Work:Instructors post lectures (text-based, no video or audio), reading selections, and hands-on assignments once a week in the online classroom. Students can discuss the assignments with the instructor and amongst themselves in the classroom area. This format has no set meeting time, which allows students to attend class at a time most convenient to them, yet still provides logically organized communication between class participants. Students can apply for the completion certificate after finishing the class.

Intermediate ASP.NET Web Development with C#

Price:

$240.00

Item No.:

P189

Instructor:

Frank Stepanski

Open Courses: No other sessions are scheduled for this course. You can add to your wish list and you will be notified when other sessions are scheduled.

Instructor's Profile

Frank Stepanski has over 10 years experience in web development with a Masters in Software Engineering. Frank has worked with technologies such as ASP.NET, SQL Server, PHP, MySQL, as well as HTML, CSS and JavaScript. He also teaches web programming classes at a local community college.

Before you register for this class, please read the Outline, Prerequisites, Requirements, Books, and Refund Policy sections carefully.

Testimonials

No testimonial available!