ASP.NET Essential

SkillsFuture Course - ASP.NET Essential

Thousands of businesses have used Microsoft ASP.NET to build professional, dynamic websites. In this course, the trainer will demonstrate the tools needed to build and deploy a dynamic site using ASP.NET. Covering everything from installing and configuring Visual Studio for Web and SQL Server Express to creating web form pages, this course is designed to give beginning and intermediate developers hands-on experience.

Topics include:

• Storing data with SQL Server
• Using the GridView control to present and edit dynamic data
• Creating a data entry system
• Attaching external CSS files
• Creating pages to log in and authenticate visitors

Module 1. Getting Started

• Understanding how ASP.NET works
• Installing Visual Studio 
• Hello World: Creating your first ASP.NET web site
• Creating pages with dynamic output
• Understanding the development web server
• Exploring the development environment

Module 2. Using Microsoft SQL Server

• Understanding Microsoft SQL Server
• Installing SQL Server Express
• Exploring SQL Server Management Studio Basic
• Creating a new database
• Connecting to the database in ASP.NET
• Testing SQL queries
• Presenting a dataset in an ASP.NET page

Module 3. Creating ASP.NET Pages

• Understanding ASP.NET web form pages
• Separating presentation and logic with code files
• Adding web form controls to a page
• Handling postback data in a web form page
• Using data binding expressions

Module 4. Programming in ASP.NET

• Creating a testing environment
• Declaring and using a simple variable
• Declaring and using a complex object
• Using loops
• Using functions
• Using trace statements
• Debugging with breakpoints
• Commenting code

Module 5. Creating Reusable Code

• Creating web controls
• Registering a user control on a web form page
• Registering controls globally in the web.config file
• Adding public properties to a web control

Module 6. Using Cascading Style Sheets in Web Forms

• Understanding Cascading Style Sheets (CSS)
• Attaching external CSS files
• Defining a CSS selector
• Using CSS class selectors in server controls

Module 7. Presenting Dynamic Data

• Presenting data with the GridView control
• Controlling GridView paging and appearance
• Editing data with the GridView control
• Presenting data with the DataList control
• Formatting data with binding expressions

Nodule 8. Creating a Data Entry System

• Using the DetailsView control
• Inserting data with the DetailsView control
• Redirecting page requests
• Creating an update page
• Linking to update pages from the list page
• Deleting database records

Module 9. Validating User Input

• Customizing forms with item editing templates
• Adding validator controls to a form
• Controlling the validation error message display
• Using the ValidationSummary control

Module 10. Creating Reports

• Creating a query with joined tables
• Replacing control style properties with CSS
• Creating a CSS file for printing
• Suppressing elements in printed web pages
• Selecting data for a report

Module 11. Managing Session State

• Understanding ViewState and managing postbacks
• Using session variables

Module 12. Securing a Site with Forms Authentication

• Turning on forms authentication
• Creating a page to log in users
• Creating a page to set up new users
• Understanding the security database
• Configuring security in the web.config file
• Creating a page to log out users

Sia King Shyan has over 19 years of industrial experience in IT project management, system development, support and administration. His last job as a project manager with Maybank required him to often interact with branch staff across the country by providing support and training to them. When he was an assistant vice president with DBS, he managed and implemented virtual infrastructure related projects, covering platforms like VMWare and AIX PowerVM. When he was a senior manager with the Republic Polytechnic, he oversaw the project management for the Corporate and Governance services, and started up and managed a support team taking care of general application support, MSSQL databases, SharePoint and system deployment.

King Shyan specializes in designing and developing Web and Client/Sever applications and has vast experience in system development and migration. His main technical skill set includes development language/tools like .Net, Java, PowerBuilder to C++/ C and the platforms diverged from UNIX, VAX/VMS to Windows servers. In addition, he has very strong knowledge on almost all database engines, for instance, MSSQL, DB2, Sybase and Oracle.