Database Basics
6-b: What's So Great About DISTINCT?We'll continue on with the discussion group scenario. Let's say that your discussion group has grown to over 20 categories. The administrator of your discussion group keeps adding categories right and left. Instead of manually adding category names to all the forms and drop-down list boxes in your web by hand you decide it would be better to simply retrieve the information from the database and populate your forms automatically. |
|
6-c: How Do I Delete Stuff?Now for the scary part, deleting data. Obviously, removing data from your database is necessary from time to time. It can be a very scary thing, though. What if you accidentally delete some very important data? What if you accidentally delete an entire table? |
|
7-a: Anything Else?Remember, the skills that you have learned here are only the tip of the iceberg. There are many more concepts and helpful tools just waiting for you out there. The next best step in learning how to work with databases is to actually create one yourself. Take some time and investigate the databases that are available to you. |
|
7-b: What Next?Once you have decided on a database, create a small project for yourself. Start with something simple like an address book that has your friends' names, addresses, telephone numbers and email addresses. This will provide you with a perfect opportunity to practice your skills. |
|

