Prepare for the Oracle Certified Associate Oracle Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-061, including:
Electronic content includes:
A Fully Integrated Study System for OCA Exam 1Z0-051
Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:
On the CD-ROM:
Be more productive with the Oracle PL/SQL language. The fifth edition of this popular pocket reference puts the syntax of specific PL/SQL language elements right at your fingertips, including features added in Oracle Database 12c.
Whether youâre a developer or database administrator, when you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration with concise summaries of:
This handy pocket reference is a perfect companion to Steven Feuerstein and Bill Pribylâs bestselling Oracle PL/SQL Programming.
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
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.
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
Jonathan Lewis is one of the world's foremost authorities in this field (he is frequently quoted and reference by other leading experts, such as Tom Kyte â see for example http://asktom.oracle.com/pls/ask/download_file?p_file=3067171813508366601
Book will be strongly co-promoted with Tom Kyte's Expert Oracle Database Architecture (1-59059-530-0)
Highlights traps for those migrating from Oracle 8i to 9i to 10g, potentially averting often disastrous performance issues and downtime (=lost revenue)
The first comprehensive book written to investigate, describe, and demonstrate the methods used by the Cost Based Optimizer
Jonathan is one of very few Oracle authors to maintain online enhancements, errata and addenda pages, so the reader will be supported long after the book is published
Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
For Instructors: Teaching supplements are available forthis title.
Manage research, learning and skills at IT1me. Create an account using LinkedIn to manage and organize your IT knowledge. IT1me works like a shopping cart for information -- helping you to save, discuss and share.