Free Downloads

OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press)

A Complete Study System for OCA Exam 1Z0-061 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: Data retrieval using the SQL SELECT statement Restricting and sorting data Single-row functions Using conversion functions and conditional expressions Reporting aggregated data with the group functions Displaying data from multiple tables with joins Using subqueries to solve problems Using the set operators Manipulating data with DML statements Using DDL statements to create and manage tables Electronic content includes: 150+ practice exam questions with detailed answers and explanations Score report performance assessment tool PDF copy of the book

Series: Oracle Press

Paperback: 592 pages

Publisher: McGraw-Hill Education; 2 edition (April 18, 2014)

Language: English

ISBN-10: 0071820280

ISBN-13: 978-0071820288

Product Dimensions: 1.2 x 7.2 x 9 inches

Shipping Weight: 2.1 pounds (View shipping rates and policies)

Average Customer Review: 3.7 out of 5 stars  See all reviews (18 customer reviews)

Best Sellers Rank: #92,583 in Books (See Top 100 in Books) #2 in Books > Computers & Technology > Databases & Big Data > Relational Databases #2 in Books > Computers & Technology > Certification > Oracle #2 in Books > Computers & Technology > Databases & Big Data > Oracle

Suppose you were 16 years old and getting your driver's license for the first time. You apply to the DMV, and they send you a transportation rulebook. You buzz through the book, you ace the end-of-chapter questions and easily pass the officially sanctioned practice exam included with the officially approved study materials.Then you take the test and find that a substantial chunk of the questions are about things that were not covered in the book, and that most of the questions are not simple "pick one" questions of the practice test but "pick two/three/all correct answers of five" which eat up time like nothing, and that for some of these, there are more correct answers (proven by actually trying the hypotheticals in question) than are provided.I suspect I'm going to get a bunch of Oracle apologists on my case right about now, yammering about how of course it's hard, they can't just hand out certificates willy-nilly. Or that I'm bitter because I failed the test and am just venting.It is true that I failed the test and am venting, which means that this review should be considered more accurate, not less, for the simple reason that I actually took the test and thus am in the best position to judge whether this book was adequate preparation. The test asks several questions about the FETCH FIRST functionality which was nowhere in the book. It asks several questions about LISTAGG which was nowhere in the book. When working through this book, I tended to either get 100% of the end-of-chapter questions correctly, or miss literally one or two at most. When doing a blind run through the included practice test (that is, I finished working through the chapters and decided to take it without reviewing previous notes), I scored an 85%.

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM: Exams 1Z0-051, 1Z0-052, 1Z0-053 (Oracle Press) SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) OCA/OCP Java SE 7 Programmer I & II Study Guide (Exams 1Z0-803 & 1Z0-804) (Certification Press) SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Oracle Database 12c The Complete Reference (Oracle Press) Oracle Database 12c DBA Handbook (Oracle Press) Oracle Database 12c Install, Configure & Maintain Like a Professional (Oracle Press) OCP Oracle Solaris 11 Advanced System Administration Exam Guide (Exam 1Z0-822) (Certification Press) Oracle Database 12c PL/SQL Programming SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Oracle Database 12c Oracle RMAN Backup and Recovery Oracle Database 11g SQL (Oracle Press) Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution (Oracle Press) Oracle ASM 12c Pocket Reference Guide: Database Cloud Storage Oracle Database 12c For Beginners ORACLE PL/SQL 101 (Oracle Press) Oracle Database 11g & MySQL 5.6 Developer Handbook (Oracle Press) Oracle Database 11g New Features (Oracle Press)