Intermediate ASP.NET Web Development with C#

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
Topic 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
Topic 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
Topic 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
Topic 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
Topic 5: ASP.NET AJAX
  • Understanding AJAX
  • Script Manager and Partial Refreshing
  • Conditional Updating
  • Update Progress Notification
  • Timed Refreshing
Topic 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.

3113

Price: $240.00
IWA Member Price: $140.00
Course No.: P189
Instructor Frank Stepanski
Co-instructor/TA
CEUs 3
Duration 6 weeks
Cost 56
Open Courses:

Sorry, no other session is scheduled for this course. You can add this course to your wish list and we will notify you when other sessions are scheduled.

Instructor's Profile:
InstructorFrank 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

Sorry, no testimonial has been posted for this course!

Ratings