Interested in taking a single class? Some courses (designated by a below) may be open on a space-available basis to professionals who are not seeking the certificate. See Single-Course Enrollment for details.

The program's three noncredit classes can be completed in eight months beginning in October 2009. Instruction is project-centered with lecture and lab formats. Specially equipped facilities allow hands-on experience with a variety of tools for developing web applications. Optional preliminary certificate and course includes, Certificate in .NET Development, and the course Introduction to SQL and Data Storage Technologies (see related course at the bottom of this page), are available for enrollment in advance of the start of the certificate program in October 2009.

Autumn Course

High Performance Data Integration with SQL Server

(10 sessions) Thursdays, 6:00-9:00 p.m., Oct. 1-Dec. 10, 2009; $726; 3 CEUs
Instructor: Randal Root

The needs of business to store and deliver information are without limit. Businesses need to be able to rapidly build high-performance systems that reliably deliver critical data when and where it is needed. Microsoft Visual Studio .NET and SQL Server provide a web database application development package that can deliver these needed systems rapidly and inexpensively. Learn how this can be done using:

• Object-oriented programming
• Abstract classes
• Code generation
• Built-tests and test frameworks
• DataSets: Exploiting the strongly typed dataset
• Stored procedures, views and transactions
• Performance tuning and optimization

The course begins with the fundamentals of accessing SQL Server utilizing ADO.NET. Following an overview of
.NET data access fundamentals, students learn how to utilize ADO.NET to build high performance database applications. Topics:

• Connecting to SQL Server and other data sources
• Working with ADO.NET's DataCommand, Data Reader, DataSet and DataTable objects
• Disconnected Recordsets
• Using ADO.NET to read/write XML

Prerequisites: (1) Working knowledge of C# and familiarity with the .NET framework or completion of the Certificate in .NET Development; (2) experience with a relational database or completion of Introduction to SQL and Data Storage Technologies (see Related Courses) at bottom of page; and (3) access to a computer running Windows (NT, 2000, Professional or 2003).

How to sign up for individual enrollment in this course

Winter Course

Designing and Developing Web-Based Solutions with ASP.NET

(10 sessions) Thursdays, 6:00-9:00 p.m., Jan. 7-March 11, 2010; $726; 3 CEUs.
Instructor: Chuck Walters

ASP.NET is Microsoft's advanced technology for developing dynamic web sites and web services with the .NET framework. This course prepares students to develop ASP.NET web applications and web services using C# in the Visual Studio.NET development framework. The course covers the most important aspects and features in ASP.NET, and shows how they can be used to build dynamic, interactive, database-driven web sites.

Topics include: introduction to ASP.NET, creating WebForms, code-behind pages, DataGrid and key web server controls, events, validation, data binding, pagelets and custom controls; state management, configuration files, and caching; deployment and configuration of web applications and web services. ADO.NET and SQL Server are used for data access and XML is integral to data manipulation. Upon successful completion of the course, students are able to design and implement a scalable data-driven web application.

Prerequisites: (1) Working knowledge of C# and familiarity with the .NET framework or completion of the Certificate in .NET Development ; (2) completion of the previous course, High Performance Data Integration with SQL Server or similar experience; and (3) access to a computer running Windows XP or Vista and Visual Studio
.NET.

How to sign up for individual enrollment in this course

Spring Course

Web Services and Security Implementation

(10 sessions) Thursdays, 6:00-9:00 p.m., March 31-June 3, 2010; $726; 3 CEUs.
Instructor: Randal Root

The course is dedicated to building web services on the .NET platform, and includes an overview of XML, web services, and related technologies, as well as hands-on experience in implementing web services using SOAP, WSDL, and UDDI. Alternatives to these technologies are discussed, as are emerging web service technologies. Consideration is then given to developing XML Web Services in .NET with ASP.NET and .NET Remoting. The final part of the course examines accessing SQL Server and web service security issues. Learning objectives include:

• Understand the problem that web services addresses
• Describe web services architecture
• Read and construct and SOAP message
• Understand a WSDL document and UDDI's purpose and specifications
• Develop a simple XML Web Service in .NET and a client to access the service
• Understand the security issues surrounding web services
• Identify and describe strategies to assure integrity, confidentiality and security in a web services environment.

Prerequisites: (1) Working knowledge of C# and familiarity with the .NET framework or completion of the Certificate in .NET Development; (2) completion of the previous course, Designing and Developing Web-Based Solutions with ASP.NET or similar experience; and (3) access to a computer running Windows XP or Vista and Visual Studio .NET.

How to sign up for individual enrollment in this course

Related Course

The following is an optional preliminary course, which may be useful in preparing to apply for the Advanced Web Application Development Certificate Program.

Introduction to SQL and Data Storage Technologies

Instructor-led, Web-based with online discussion; independent start; three-month completion; 3 credits. (View the course introduction)

This course is part of the Web Technology Solutions Certificate Program, which is offered in a classroom format and an online learning format. For more information on individual enrollment in this course, go to that program's classroom courses page or online learning courses page.

Databases have become an essential part of our highly data-driven world. Many interactive, information-rich web sites use underlying databases. This course focuses on the concepts and skills required to design and build databases useful for web applications. The course introduces you to the basic principles of how a database must function before an interface to a web site is made, including relational database design theory, data modeling, and normalization. Subsequent topics build upon this foundation by introducing Structured Query Language (SQL), the lingua franca of relational database processing. Client-server architecture and database access, both on the web and across networks, are covered. XML is examined as a data-storage technology alternative. After completing this course participants will be able to:

• Develop requirements to define the scope of a database design
• Use SQL to retrieve and modify data in a relational database structure
• Store, access and query a web database using MySQL and PHP, popular and accessible open source tools
• Describe the client-sever architecture, including the impact of HTTP on web application design.
• Define XML and how to leverage it as a data-storage technology for building and accessing unique data sets.
• Explain the architecture of web services, including servers, requesters and registries.