JavaScript Workshop » ASP E-Commerce Database Basics @ LVS Online.com

I am teaching a 2nd online class called ASP E-Commerce Database Basics at LVS Online. This 6-week class will teach you how to interact with a database by displaying, retrieving and updating data. It is a continuation from where I left off in my first class teaching ASP basics. For this class I am gearing the topics towards showing students how to create a simple online store so visitors can view and add products to a shopping cart.

The class learning level is "intermediate" which means taking the basics you already know and developing a usable web application. The class uses a simple Microsoft Access database (provided), but you can use almost any type of database with minimal code changes.

Topics Covered:

Week 1: E-Commerce types; Overview of ADO; Connecting to our database
Week 2: SQL basics: SELECT, WHERE, ORDER BY, LIKE
Week 3: SQL continued: INSERT INTO and UPDATE; Managing our Products
Week 4: Recordsets and Pagination; Creating a Search
Week 5: Shopping Cart pt 1
Week 6: Shopping Cart pt 2; Checkout Process

The Online Store gives students a good example to use and refer to when they need to create their own database-driven dynamic web sites. As an added bonus, here is the first lesson (.pdf) for you to see how the material is covered in class. I only cover the basics of ADO in this class, but if you need addtional reference material here is an ADO Reference Guide (.pdf) by DevGuru.