SQL course
Friday August 18, 2006
SQL for database-driven Web sites
This is a 6-week course developed by me and delivered over the Web by Eclectic Academy. The course fee is US$20.
Why take an online course, instead of, say, buying a book? Because the Eclectic Academy instructors and students communicate with each other on a message board during the 6 week course. You are free to ask questions any time. By sharing the questions and answers on a message board, all students benefit from other opinions and explanations. And of course the instructor contributes to the message board discussion too.
As well, you get access to the course materials, which are presented on secure web pages in 6 weekly classes.
To take this course, please enroll at EclecticAcademy.com.
SQL for database-driven Web sites
Instructor: Rudy Limeback
A database-driven Web site lets you manage the contents of your site using a database instead of HTML files. Your site still delivers HTML to the browser, but the HTML is assembled dynamically, using page templates combined with database content. Immediate benefits are simplified site maintenance and automatic generation of site components like the site map, navigation, and search.
This course is geared to all databases, all languages. You can be using ASP and Access, ColdFusion and MySQL, PHP and Sybase, or whatever combination you like. This course covers concepts useful to all database-driven Web sites.
Prerequisites
- Knowledge of HTML and Web design
- An installed and working database server, to take advantage of the exercises.
- Familiarity with concepts such as tables, queries, joins, and keys; some SQL experience is advised.
This course does not cover database installation. This course assumes that you have a database server up and running and responding to queries executed from whatever web scripting language you are using, by Week 2 at the latest. This course covers what kinds of queries you need for a dynamic Web site, but not the technical details of how to run them.
Course Outline
- Week 1
- How a dynamic Web site works
- Week 2
- Displaying and maintaining entries
- Week 3
- Many-to-many relationships: Entries and Authors
- Week 4
- Navigation, Site Maps, Breadcrumbs
- Week 5
- More Many-to-Many: Categories, Keywords
- Week 6
- Search
