ASP E-Commerce Database Basics Class

Post on August 23rd, 2007
Updated November 2009
This class has been delegated to self-study so it can be taken anytime and the price is reduced to $15.



I am teaching database-based ASP online class called ASP E-Commerce Database Basics at LVS Online.com.

This 6-week class will teach you how to interact with a database by displaying, retrieving and updating data. The class is a continuation from where I left off from my Basic Web Applications with ASP class.

The class is only $30 $15 and there are no other materials or software needed.

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.

Here is the first lesson (.pdf) for you to see how it looks.

When Does Class Start?

The class runs five times a year for six weeks in January, March, May, August and October. To learn more view the course description page and contact me to find out the exact date on when you can register.

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.


9 Comments
  1. Patricia Byrne permalink

    You have been a great teacher and had excellent course material. Thank you for all the help and additional links to pursue further information.

  2. Cheryl Heidorn permalink

    Great information as well as an instructor. Thank you!

  3. Lien Le Quang permalink

    Another great class! :)

  4. Murrel permalink

    You covered so much, that I need another 6 weeks for take it all in. :)

    I really appreciate all the work you put into this class and I hope I can use all the great information.

    Thanks

  5. Marsha Lauderman permalink

    Wonderful class and you seem to really enjoy teaching people.

  6. Darrell Ray permalink

    You explained things that I would never have found out reading in a book.

    Very well done.

    I look forward to more classes taught by you.

Leave a Reply

Note: XHTML is allowed. Your email address will never be published.