Shows how to use the SQL language to get information from a relational database. The book begins with simple queries that retrieve selected data from a single table, then progresses to advanced queries that summarize the data, combine it with data from other tables, or display the data in specialized ways. The CD-ROM furnishes a library of Access databases and the code for building Oracle databases. Annotation c. Book News, Inc., Portland, OR (booknews.com)
"synopsis" may belong to another edition of this title.
JOHN PATRICK is a computer consultant and software developer specializing in relational database technology. He teaches SQL Fundamentals and other database courses at the University of California, Berkeley Extension and has over 20 years' experience in software development at Bank of America, Chevron, Kaiser Permanente and other leading firms.
Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle for the enterprise and Microsoft Access for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application - from ad hoc reports to the data warehouse. SQL Fundamentals covers all this and more:
* Simple queries that retrieve information from a single table
* Creating tables and views to divide a complex process into a series of single steps
* Summarizing your data
* Inner joins, outer joins, unions, self joins, cross joins, and subqueries
* Writing SQL queries that are easily understood, verified, modified, and extended
Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use! If you want to fully use the information in your database, then read this book!
CD-ROM INCLUDED
The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the code is completely correct and works with the latest versions of both Oracle and Access.
"About this title" may belong to another edition of this title.
FREE shipping within U.S.A.
Destination, rates & speedsSeller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less 2.38. Seller Inventory # G0130960160I3N00
Quantity: 1 available
Seller: Goodwill of Silicon Valley, SAN JOSE, CA, U.S.A.
Condition: acceptable. Supports Goodwill of Silicon Valley job training programs. The cover and pages are in Acceptable condition! Any other included accessories are also in Acceptable condition showing use. Use can include some highlighting and writing, page and cover creases as well as other types visible wear such as cover tears discoloration, staining, marks, scuffs, etc. All pages intact. Seller Inventory # GWSVV.0130960160.A
Quantity: 1 available
Seller: Wonder Book, Frederick, MD, U.S.A.
Condition: Good. Good condition. With CD! A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Seller Inventory # Y12B-03224
Quantity: 1 available
Seller: dsmbooks, Liverpool, United Kingdom
Paperback. Condition: Good. Good. book. Seller Inventory # D8S0-3-M-0130960160-3
Quantity: 1 available