OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 1st Edition Steve O’Hearn

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) – Ebook Instant Download/Delivery ISBN(s): 9781259584619,1259584615

Product details:

A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test. Get complete coverage every topic on Exam 1Z0-071, including: • DDL and SQL SELECT statements • Manipulating, restricting, and sorting data • Single-row and group functions • Displaying data from multiple tables • Subqueries • Schema objects • Set operators • Grouping related data • Report creation • Data dictionary views • Large data sets • Hierarchical retrieval • Regular expression support • User access control The electronic includes: • Two full practice exams • Detailed answers and explanations

Table contents:

Chapter 1: Oracle and Structured Query Language (SQL)

Chapter 2: Using DDL Statements to Create and Manage Tables

Chapter 3: Manipulating Data

Chapter 4: Restricting and Sorting Data

Chapter 5: Using Single-Row Functions to Customize Output

Chapter 6: Using Conversion Functions and Conditional Expressions

Chapter 7: Reporting Aggregated Data Using the Group Functions

Chapter 8: Displaying Data from Multiple Tables

Chapter 9: Using Subqueries to Solve Queries

Chapter 10: Managing Schema Objects

Chapter 11: Using the Set Operators

Chapter 12: Managing Objects with Data Dictionary Views

Chapter 13: Manipulating Large Data Sets

Chapter 14: Controlling User Access

Appendix A: About the Download

Glossary

People also search:

oca oracle database sql exam guide (exam 1z0-071) pdf

oca oracle database sql exam guide (exam 1z0-071) (oracle press)

oca oracle database sql exam guide (exam 1z0-071) pdf download

oca oracle database 12c sql fundamentals i exam guide

how hard is the oracle sql certification

oracle oca certification cost in india