You’ve just built your first database application. You’re proud of your accomplishments — and you should be. You mastered the fundamentals of SQL: creating a table, putting data into it, and querying it. You took the basic approach: when it came time to sum a column of numbers, you wrote a FOR loop. Everything works, but shouldn’t your database be doing more for you?
Many people are in the position just described. When time came to use a database, the first web hit for “SQL Tutorial” became the bible. SELECT, INSERT, and DELETE — the bread and butter of data manipulation. The SQL database has satisfied the need for data storage. What else can it do?
It can do a lot more. From aggregate functions to stored procedures, this article will help your database sing and dance. (Note: the author is not responsible for damage, physical, mental or emotional, caused by database servers and software singing and dancing)
This introduction to more than basic SQL is written with multiple databases in mind. Feature availability is documented for PostgreSQL, and MySQL. If you have information on the use of features here with other databases, please leave a comment and I will be glad to update this article. This is part 1 of a multi-part article. Links to the next parts will be added at the end as they are published. I am eager to do similar writing on a freelance basis for any publications. If you are interested, please leave a comment.
Part 2: Queries
Part 3: Data Manipulation
Part 4: Stored Procedures
nice to have
Comment by johannes — 2006/11/23 @ 9:39 am
Part 1 is very nicely written. Will you ever get back to write parts 2-4?
Comment by david — 2007/03/14 @ 2:06 pm
Really this article is self explanatory. every thing is clearly
explained. All my doubt cleared.i m wating for second part…
Comment by Alok — 2007/05/25 @ 11:38 pm