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.

Listing Last Modified: Mon Jun 13 2005

 


Views: 60

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?

Listing Last Modified: Mon Jun 13 2005

 


Views: 58

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.

Listing Last Modified: Mon Jun 13 2005

 


Views: 59

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.

Listing Last Modified: Mon Jun 13 2005

 


Views: 67


|< <