My Account Details
ISBN10: 0071820280 | ISBN13: 9780071820288
* The estimated amount of time this product will be on the market is based on a number of factors, including faculty input to instructional design and the prior revision cycle and updates to academic research-which typically results in a revision cycle ranging from every two to four years for this product. Pricing subject to change at any time.
Instructor Information
Quick Actions (Only for Validated Instructor Accounts):
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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
Need support? We're here to help - Get real-world support and resources every step of the way.