SQL Fundamentals (3rd Edition) by John J. Patrick
Publisher: Prentice Hall PTR; 3rd book (September 12, 2008)
Language: English
ISBN-10: 0137126026
ISBN-13: 978-0137126026
SQL for a Real World
Don’t only sense “generic” SQL. Learn SQL to get formula with a world’s tip database platforms–Oracle for a craving as well as Microsoft Access for a desktop. Based upon John Patrick’s hands-on SQL march during a University of California, Berkeley Extension, this book shows only how to collect a interpretation we want, when we need it, in any application–from ad hoc reports to a interpretation warehouse. Thoroughly updated for a newest versions of Oracle, Access, as well as a SQL standard, this book contains some-more exercises, techniques, as well as solutions than ever before. You’ll sense only how to write SQL queries which have been easy to understand, verify, modify, as well as extend–even if you’ve never worked with databases before.
SQL Fundamentals,Third Edition, teaches we how to
Build elementary statements to retrieve, store, or cgange data
Craft formidable queries which pull report from mixed tables
Sort as well as promulgate your interpretation only a approach we wish it
Create as well as revise your own tables
Protect a firmness of your data
Create some-more efficient, high-performance queries
Work with unions, subqueries, self joins, cranky joins, middle joins, as well as outdoor joins
Use a Oracle Data Dictionary
No comments:
Post a Comment