What do you think?
Rate this 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 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,
• 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 • Two full practice exams • Detailed answers and explanations
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,
• 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 • Two full practice exams • Detailed answers and explanations
655 pages, Kindle Edition
Published August 25, 2017
29 people are currently reading
56 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 4 of 4 reviews
August 16, 2020
Buena referencia teórica para el examen. Sin embargo, le hacen falta temas como "Temporary tables" que sí venían en el examen.
Tuve que hacer un listado de temas que incluían en el libro y compararlo con los temas del examen para estudiar los temas faltantes por separado.
Tuve que hacer un listado de temas que incluían en el libro y compararlo con los temas del examen para estudiar los temas faltantes por separado.
April 5, 2021
This is the ultimate guide for the 1Z0-071 exam, but unfortunately it misses out on some topics/concepts like Temporary Tables, Flashback operation syntax etc.
Overall, this is the go-to studying source for the exam.
Overall, this is the go-to studying source for the exam.
March 2, 2022
Straight 5 stars after reading only one hundred pages.
No matter which version/type of SQL you want to master, this is a great place to start with. The book covers everything you need to know about SQL for beginners or even for professionals to go dip down into the details.
The book was easy to read, and the questions at the end of each chapter were fantastic. Plus, it comes with stimuli mock exams, so yes!
Thank you so much!
No matter which version/type of SQL you want to master, this is a great place to start with. The book covers everything you need to know about SQL for beginners or even for professionals to go dip down into the details.
The book was easy to read, and the questions at the end of each chapter were fantastic. Plus, it comes with stimuli mock exams, so yes!
Thank you so much!
Displaying 1 - 4 of 4 reviews