School Map:
Home / Enroll
$ Student Records; Class
$ News @ LIVE
Tech Radio * Support/FAQ
| Store | FORUMS
Script School MySQL 101 Database class
Basic To-Do Assignment for Week #1: Use the tools available on your host or PHP to create a test Database and connect to it.
Advanced To-Do Assignment for Week #1:
Install an SDK on Your local workstation and use phpMyAdmin to create Your test Database and test Your connection to it.Week #2 |
Course Info, Interaction & Feedback |
| I. What is a relational database, what is it good for? II. Basic Setup & tools necessary A. firepages -> local setup B. how to determine if you have mySQL on your server C. connection to database information: host, username, password, database name D. Root access and granting user access to database |
- Course Week 1 Text - active
following Aug 15, 2003 radio show 2pm PST / 5pm ET / 10pm GMT - Forums (Q & A) - MySQL101 - IRC Workshop: Tuesday Aug 12, 2003 7pm PST / 10pm EST LIVE Chat / irc.scriptschool.com #scriptschool - Radio: Audio Recap Fri Aug 15, 2003 |
| Turn in your Basic & Advanced To-Do Assignment in the forum: http://class.scriptschool.com/forums/mysql101/ | |
Basic TO-DO Assignment #2: Create table for sponsors that you are signed up with (fields would be: sponsor name, stats url, username, password (md5), signup date advanced: sites linked to sponsor)
Week #2 |
Course Info, Interaction & Feedback |
| I. Creating Database, Creating basic table A. Indices and primary and secondary keys, auto increment II . A basic starting query: "Show tables" and display to PHP III. What is a table A. What is a row B. What is a column C. What are column types D. Differences between set and enumerations |
- Course Week 2 Text - active
following Aug 15, 2003 radio show 2pm PST / 5pm ET / 10pm GMT - Forums (Q & A) - MySQL101 - IRC Workshop: Tuesday Aug 19, 2003 7pm PST / 10pm EST LIVE Chat / irc.scriptschool.com #scriptschool - Radio: Audio Recap Fri Aug 22, 2003 |
| Turn in your Basic & Advanced To-Do Assignment in the forum: http://class.scriptschool.com/forums/mysql101/ | |
Basic TO-DO ASSIGNMENT #3: Create basic admin area shell and insert form for inserting data into sponsors table(s)
Week #3 |
Course Info, Interaction & Feedback |
| I. How to INSERT data into the sponsor tables A. Checking and sanitizing the data B. addslashes and stripslashes, mysql_escape_string, html_entities, strip_tags C. Build HTML form in the ADMIN AREA (reference to clicks out course) to allow inserting D. Success and failure messages for inserting |
- Course Week 3 Text - active
following Aug 22, 2003 radio show 2pm PST / 5pm ET / 10pm GMT - Forums (Q & A) - MySQL101 - IRC Workshop: Tuesday Aug 26, 2003 7pm PST / 10pm EST LIVE Chat / irc.scriptschool.com #scriptschool - Radio: Audio Recap Fri Aug 27, 2003 |
| Turn in your Basic & Advanced To-Do Assignment in the forum: http://class.scriptschool.com/forums/mysql101/ | |
Basic TO-DO ASSIGNMENT #4: Setting up queries to display inserted data and to be able to edit or delete the data
Week #4 |
Course Info, Interaction & Feedback |
| I. How to QUERY (search) through data) and UPDATE data
and output the data A. SELECT, Order by, WHERE, LIMIT, GROUP BY, HAVING B. STATUS marking records versus DELETING (undelete function) C. Spanning pages |
- Course Week 4 Text - active
following Aug 29, 2003 radio show 2pm PST / 5pm ET / 10pm GMT - Forums (Q & A) - MySQL101 - IRC Workshop: Tuesday Sep 2, 2003 7pm PST / 10pm EST LIVE Chat / irc.scriptschool.com #scriptschool - Radio: Audio Recap Fri Sep 5, 2003 |
| Turn in your Basic & Advanced To-Do Assignment in the forum: http://class.scriptschool.com/forums/mysql101/ | |
Basic TO-DO ASSIGNMENT #5: Backup your data and drop table and then recreate the table and and re-insert backed up data
Week #5 |
Course Info, Interaction & Feedback |
| I. Managing and optimizing the database A. Backup function - backing the database up into a text file B. Pulling data in through LOAD function into the database. |
- Course Week 5 Text - active
following Sep 5, 2003 radio show 2pm PST / 5pm ET / 10pm GMT - Forums (Q & A) - MySQL101 - IRC Workshop: Tuesday Sep 9, 2003 7pm PST / 10pm EST LIVE Chat / irc.scriptschool.com #scriptschool - Radio: Audio Recap Fri Sep 12, 2003 |
| Turn in your Basic & Advanced To-Do Assignment in the forum: http://class.scriptschool.com/forums/mysql101/ | |
Basic TO-DO ASSIGNMENT #5: Backup your data and drop table and then recreate the table and and re-insert backed up data
School Map:
Home / Enroll
$ Student Records; Class
$ News @ LIVE
Tech Radio * Support/FAQ
| Store
Advertising
| Link To Us | Privacy
Copyright 2000-2002 Script School Productions / KMR
Enterprises
No part of this website may be reproduced, copied and/or distributed
in any medium
without express written permission