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
Table of contents
- Cover
- Title Page
- Copyright Page
- Acknowledgments
- About the Author
- Contents at a Glance
- Contents
- Preface
- Introduction
- 1. Relational Database Design Using Oracle
- 2. Data Retrieval Using the SQL SELECT Statement
- 3. Restricting and Sorting Data
- 4. Single-Row Functions
- 5. Using Conversion Functions and Conditional Expressions
- 6. Reporting Aggregated Data Using the Group Functions
- 7. Displaying Data from Multiple Tables
- 8. Using Subqueries to Solve Problems
- 9. Using the Set Operators
- 10. Manipulating Data
- 11. Using DDL Statements to Create and Manage Tables
- A: About the Download
- Glossary
- Index
Product information
- Title: OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061), 2nd Edition
- Author(s):
- Release date: April 2014
- Publisher(s): McGraw-Hill
- ISBN: 9780071820295
You might also like
book
OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle …
book
Oracle Database 12c SQL
Write Powerful SQL Statements and PL/SQL Programs Learn how to access Oracle databases through SQL statements …
book
Beginning Oracle SQL: for Oracle Database 12c, Third Edition
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL …
book
Beginning Oracle SQL for Oracle Database 18c: From Novice to Professional
Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to …