MySQL/PHP Classes @ LVS Online

The death toll  from the bush fires in Australia is 181 and counting, but you can help. Sitepoint, an Australian web designcompany,  is offering a huge sale on their excellent books. You can buy five books for the price of one and 100% of the proceeds will go to benefit the brush fire victims. The sale goes through 2/13 so you will want to take advantage of this offer quickly. The loss of home and livelihood has been staggering and the Australian brush victims are in desperate need of assistance now.

Here are some books that I think may be of particular interest for MySQL and PHP students:

The PHP Anthology: 101 Essential Tips, Tricks & Hacks, 2nd Edition

Build Your Own Database Driven Website Using PHP & MySQL

HTML Utopia: Designing Without Tables Using CSS, 2^nd Edition

The CSS Anthology: 101 Essential Tips, Tricks & Hacks, 2^nd Edition

Build Your Own Web Site The Right Way Using HTML & CSS

Simply JavaScript

The Principles of Beautiful Web Design

Once you have selected your books, be sure to use the form here to get the sale pricing and to make sure that all proceeds go to the brush fire victims.

Introduction to Database Development with MySQL – get organized for the new year. Databases are a great way to organize all kind of data from your books to your products to your contacts. In this course, you will use special database accounts on the LVS server to create an address database. We will be using MySQL 4 for this course. Anita will be the assistant this session.

LVS Online MySQL database class starts on 1/10/09. Register now!

Students will learn the basics of solid relational database design using MySQL, the most popular open source database software. Solid design results in an efficient and powerful means of not only storing, but also retrieving information. It prevents errors, reduces duplicate information and speeds up finding specific information. Databases may hold billions of records, serving as the backbone of corporations or organize your personal recipes. During this course, students will develop an address book MySQL database. Students will be given access to PHPAdmin accounts to administer their databases. PHP will not be covered in this course, PHP skills are not required to use this popular tool to administer MySQL. Note: This is designed to be an introductory course. Subsequent courses will enable students to harness more of the power of relational databases and utilizing PHP to administer your database.

Introduction to Database Development using MySQL:
This first course in the series focuses on solid database design. Students learn basic queries to create databases and tables, insert, update and delete records and to pull specific records from a database. Students use phpMyAdmin to administer their databases. The main student project is an address database.