SQLAs dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too--no programming experience required! After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage. Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database.. |
Contents
DBMS Specifics | 1 |
The Relational Model | 21 |
Tables Columns and Rows | 22 |
Copyright | |
27 other sections not shown
Common terms and phrases
a.au_id allowed au_id au_lname authors biography Buchman calculate Chapter character clause column names combination command compared comparison condition constraint contains convert COUNT CREATE CREATE TABLE data type database datetime DBMS DBMSes default defined DELETE depending DESC determine display DISTINCT duplicate earlier equivalent evaluated example EXISTS expression Figure foreign key functions GROUP Hull identifier INNER JOIN INSERT integer interval Kells keyword Klee later length Listing SELECT literal match means Microsoft Access Microsoft SQL Server MySQL NULL omit operators optional Oracle ORDER outer join PostgreSQL Press primary key programs pub_id publishers query refer Result of Listing retrieve returns rows royalties run Listing San Francisco Sarah sequence shows simple single sort specify SQL statement standard statement string subquery syntax tion Tips title_authors title_id title_name titles TRIM unique UPDATE values