SQL fundamentals /
Patrick, John J.
SQL fundamentals / John J. Patrick. - 2nd ed. - Upper Saddle River, N.J. : Prentice Hall PTR, c2002. - xxvi, 834 p. : ill. ; 24 cm.
Previous ed.: 1999. Includes index. CD-ROM in back pocket.
1.Storing information in tables -- 2.Getting information from a table -- 3.Compound conditions in the where clause -- 4.Saving your results -- 5.Modifying data through a view -- 6.Creating your own tables -- 7.Formats, sequences, and indexes -- 8.Data integrity -- 9.Row functions -- 10.Using row functions -- 11.Summarizing data -- 12.Controlling the level of summarization -- 13.Inner joins -- 14.Outer joins -- 15.Union and union all -- 16.Cross joins and self joins -- 17.Combining talbes in a production database -- 18.If-then-else and subqueries -- 19.The multiuser environment -- 20.The design of SQL -- Appendix A.Obtaining and installing ORACLE -- Appendix B.Tips on using ORACLE -- Appendix C.Tips on using ACCESS -- Appendix D.Diagram of the lunches database.
SQL is a standardised query language for requesting information from a database. Covering topics such as inner joins, self joins and subqueries using clear, easy to follow examples, this book compares and contrasts Oracle 9I and Access 2000 databases.
9780130669476 (pbk.) : £35.99 0130669474
SQL (Comptuer program language).
SQL (Computer program language)
Relational databases.
Database management.
Computers and IT.
Database programming
QA76.73.S67 / P38 2002
005.7565 PAT
SQL fundamentals / John J. Patrick. - 2nd ed. - Upper Saddle River, N.J. : Prentice Hall PTR, c2002. - xxvi, 834 p. : ill. ; 24 cm.
Previous ed.: 1999. Includes index. CD-ROM in back pocket.
1.Storing information in tables -- 2.Getting information from a table -- 3.Compound conditions in the where clause -- 4.Saving your results -- 5.Modifying data through a view -- 6.Creating your own tables -- 7.Formats, sequences, and indexes -- 8.Data integrity -- 9.Row functions -- 10.Using row functions -- 11.Summarizing data -- 12.Controlling the level of summarization -- 13.Inner joins -- 14.Outer joins -- 15.Union and union all -- 16.Cross joins and self joins -- 17.Combining talbes in a production database -- 18.If-then-else and subqueries -- 19.The multiuser environment -- 20.The design of SQL -- Appendix A.Obtaining and installing ORACLE -- Appendix B.Tips on using ORACLE -- Appendix C.Tips on using ACCESS -- Appendix D.Diagram of the lunches database.
SQL is a standardised query language for requesting information from a database. Covering topics such as inner joins, self joins and subqueries using clear, easy to follow examples, this book compares and contrasts Oracle 9I and Access 2000 databases.
9780130669476 (pbk.) : £35.99 0130669474
SQL (Comptuer program language).
SQL (Computer program language)
Relational databases.
Database management.
Computers and IT.
Database programming
QA76.73.S67 / P38 2002
005.7565 PAT