A Guide to SQL
This textbook teaches concepts and techniques with the help of numerous examples. A running case presents lessons in a real-world context. Although based on Oracle9i, the text calls out information specific to Microsoft Access 2002 and can be used for instruction in any version of SQL. Additional hands-on projects at the end of each chapter offer the opportunity to solve problems based on skills learned.
Introduction to Premiere Products and Henry Books
An Introduction to SQL
8 other sections not shown
148 Al's Appliance 282 Brookings Direct 356 Ferguson's 462 Bargains Galore 608 Johnson's Department 725 Deerfield's Four 842 All Season ALTER TABLE command appear in Figure Appliance and Sport BALANCE book code chapter column name command shown COMPUTE contains CREATE TABLE command CREATE VIEW credit limit cursor customer number CUSTOMER table CUSTOMER_NAME data type database administrator DBMS decimal Deerfield's Four Seasons display example execute foreign key Henry Books I_REP_NUM inner join INSERT command item class Johnson's Department Store Kaiser Kline's LAST_NAME Microsoft Access null values number and name operator Oracle SQL*Plus order line order number ORDER_LINE table ORDER_NUM ORDERS table outer join PART_NUM Perez PL/SQL programs primary key REP table REP_NUM rows selected sales rep number script file Season Sport SELECT clause SELECT command SELECT CUSTOMER_NUM shown in Figure SLSR Sport and Appliance SQL commands SQL implementations strSQL subquery table name units on hand