Re: [PHP-DB] comprehensive sql tutorial
On Monday 28 March 2005 13:00, Yemi Obembe wrote: Does anyone please know where i can get a comprehensive SQL tutorial as in one that contains stuffs on engines, data structures, table types, etc NOT JUST the basic query commands CREATE, SELECT, UPDATE, DELETE, INSERT... their syntax(es). Hi Yemi It sounds like the information you're after tends to be fairly specific for the database you're using. Of the databases I've used both Oracle and MySql's documentation was very helpful about setting up databases although they do assume some knowledge of general database concepts. See (for MySQL) http://dev.mysql.com/doc/ or (for Oracle - requires OTN membership which is free) http://oraclesvca2.oracle.com/docs/cd/B14117_01/index.htm cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] comprehensive sql tutorial
Yemi, Well, Joe Celko is a recognized expert; Googling for Joe Celko tutorial turned up 8,900 hits, but this link was found on the first page: http://www.codebox.8m.com/sql.htm Lots of stuff there. If you want books, The Practical SQL Handbook Bowman, Emerson and Darnovsky ISBN 0-201-44787-8 SQL for Smarties: Advanced SQL Programming Joe Celko ISBN 1-55860-323-9 Keep in mind that one of the WONDERFUL things about SQL is that a lot of the plumbing is hidden. Determine what information you need returned, what inputs you have, normalize your data (with sufficient keys to ensure uniqueness for each and every row) and go for it. Don't tie yourself in knots wondering if any product meets all of Codd Date's criteria - to the best of my knowledge none do, nor do many meet the SQL-2 standard. (SQL-92? I'm relying on memory here.) The most widely used almost-but-not-quite-yet-evidently-good-enough relational database on the Internet is MySQL. Some of the exercises in the aforementioned books could not be done with MySQL - doesn't mean it's not useful. Tens and tens of thousands have found it is. Give PostgresSQL a serious look - v. impressive. Ditto Firebird. Have fun - Miles At 08:00 AM 3/28/2005, Yemi Obembe wrote: Does anyone please know where i can get a comprehensive SQL tutorial as in one that contains stuffs on engines, data structures, table types, etc NOT JUST the basic query commands CREATE, SELECT, UPDATE, DELETE, INSERT... their syntax(es). - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] comprehensive sql tutorial
Check the docs for the DB of your choice. Or google for it. Bastien From: Yemi Obembe [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] comprehensive sql tutorial Date: Mon, 28 Mar 2005 04:00:25 -0800 (PST) Does anyone please know where i can get a comprehensive SQL tutorial as in one that contains stuffs on engines, data structures, table types, etc NOT JUST the basic query commands CREATE, SELECT, UPDATE, DELETE, INSERT... their syntax(es). - A passion till tomorrow, Opeyemi Obembe | ng.clawz.com - Do you Yahoo!? Yahoo! Small Business - Try our new resources site! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php