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.