OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition

Book Description

A Complete Study System for OCA Exam 1Z0-061

Prepare for the Certified Associate Database 12c SQL Fundamentals I exam with this Oracle Press guide. Each chapter features challenging exercises, a 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
  • 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

content includes:

  • 150+ practice exam questions with detailed answers and explanations
  • Score report assessment tool
  • copy of the book

Table of Contents

Chapter 1 Relational Database Design Using Oracle
Chapter 2 Data Retrieval Using the SQL SELECT Statement
Chapter 3 Restricting and Sorting Data
Chapter 4 Single-Row Functions
Chapter 5 Using Conversion Functions and Conditional Expressions
Chapter 6 Reporting Aggregated Data Using the Group Functions
Chapter 7 Displaying Data from Multiple Tables
Chapter 8 Using Subqueries to Solve Problems
Chapter 9 Using the Set Operators
Chapter 10 Manipulating Data
Chapter 11 Using DDL Statements to Create and Manage Tables

Book Details

  • Title: OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition
  • Author:
  • Length: 592 pages
  • Edition: 2
  • Language: English
  • Publisher:
  • Publication Date: 2014-03-28
  • ISBN-10: 0071820280
  • ISBN-13: 9780071820288
Download LinkFormatSize (MB)Upload Date
Download from EU(multi)PDF18.812/03/2014
Download from FilePiTrue PDF, EPUB52.710/05/2015
Download from FilePiPDF18.812/03/2014
Download from ZippyShareTrue PDF, EPUB52.701/07/2016
Download from ZippyShareTrue PDF, EPUB52.705/14/2017
How to Download? Report Dead Links & Get a Copy