OCA Oracle Database 12c

SQL Fundamentals I Exam Guide Exam 1Z0-061

Book Details:

Publisher:	McGraw-Hill Osborne Media
Series:	McGraw Hill , Certification
Author:	Roopesh Ramklass
Edition:	1
ISBN-10:	0071820280
ISBN-13:	9780071820288

Pages:	592
Published:	Mar 28 2014
Posted:	Feb 12 2015
Language:	English
Book format:	PDF
Book size:	27.18 MB

Book Description:

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

Download Link:

Related Books:

OCA

Oracle Database 12c Administrator Certified Associate Study Guide Exams 1Z0-061 and 1Z0-062

An all-in-one study guide prepares you for the updated Oracle Certified Associate certificationIt's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting dataWalks you through using conversion functions and conditional expressionsAddresses displaying data from multiple tables, manipulating data, database mai...

Oracle Essentials

Oracle Database 12c

5th Edition

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle's product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracl...

Beginning Oracle SQL

For Oracle Database 12c

3rd Edition

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQLfrom a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements man...