SQL Fundamentals (3rd Edition)
Super Savings Item! Save 36% on the SQL Fundamentals (3rd Edition) by Prentice Hall at Translate This Website. MPN: ill. Hurry! Limited time offer. Offer valid only while supplies last. SQL for the Real World Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the
SQL for the Real World
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 at the University of California, Berkeley Extension, 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. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.
SQL Fundamentals,Third Edition, teaches you how to
Build simple statements to retrieve, store, or modify data
Craft complex queries that draw information from multiple tables
Sort and summarize your data just the way you want it
Create and edit your own tables
Protect the integrity of your data
Create more efficient, high-performance queries
Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
Use the Oracle Data Dictionary
About the Web Site
The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.
|Item Weight:||2.55 pounds|
|Item Size:||1.2 x 9.2 x 9.2 inches|
|Package Weight:||2.55 pounds|
|Package Size:||6.9 x 1 x 1 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by Prentice Hall, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Brand: For Dummies
ean: 9780764574115, isbn: 0764574116,
This friendly, easy-to-use guide shows experienced Access usershow to useVBA (Visual Basic for Applications) to build Access databasesand applications, but also covers programming fundamentals fornonprogrammersIncludes practical, ready-to-use VBA cod...
mpn: 978-1-4302-2760-1, ean: 9781430227601, isbn: 1430227605,
Web sites, collaboration, document management, paperless offices―we want it all in business today, but how do we achieve all of these goals? More importantly, if you work for one of the millions of small-to-medium-sized businesses, how do you find ...
By Cengage Learning
ean: 9781337627948, isbn: 9781337627948,
MindTap MIS for Coronel's Database Systems: Design, Implementation, & Management, 13th edition helps you learn on your terms. You can connect with your instructor, organize coursework, and have access to a range of study tools including e-book, lectu...
By Brand: Pogue Press
ean: 9780596527600, isbn: 9780596527600,
Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn....
By Jones & Bartlett Learning
mpn: 9781598220605, ean: 9781598220605, isbn: 1598220608,
SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and ret...
By Mercury Learning & Information
ean: 9781942270843, isbn: 1942270844,
Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with th...
By Manning Publications
ean: 9781617292187, isbn: 1617292184,
SummaryPowerShell in Depth, Second Edition is the go-to reference for administrators working with Windows PowerShell. Every major technique, technology, and tactic is carefully explained and demonstrated, providing a hands-on guide to almost everythi...
ean: 9780735659872, isbn: 0735659877,
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarou...
By Brand: O'Reilly Media
mpn: 43171-552835, ean: 9781449357412, isbn: 1449357415,
Unlock the secrets of Access 2013 and discover how to use your data in creative ways. With this book’s easy step-by-step instructions, you’ll learn how to build and maintain a full-featured database and even turn it into a web app. You also get t...
sku: 9780470567012, mpn: 978-0-470-56701-2, ean: 9780470567012, isbn: 0470567015,
The ultimate handbook for Excel analysts who need reportingsolutions using Access Excel and Access are intended to work together. This book offersa comprehensive review of the extensive analytical and reportingfunctionality that Access provides and h...