OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )

More Information
  • Get insights into the fundamentals of databases and how they work
  • Create and manipulate databases
  • Create complex reports by joining data from multiple tables
  • Use functions to manipulate data for solving real world problems
  • Create database objects from scratch to store the types of data used in businesses today
  • Use SQL in application development
  • Aggregate data transformation using group functions
  • Combine SQL queries



The Oracle Database 11g: SQL Fundamentals I exam is the first stepping stone in getting the Oracle Certified Associate Certification for Oracle Database 11g. The SQL programming language is used in every major relational database today and understanding the real world application of it is the key to becoming a successful DBA.

This book gives you: the essential real world skills to master relational data manipulation with Oracle SQL and prepares you to become an Oracle Certified Associate. Beginners are introduced to concepts in a logical manner while practitioners can use it as a reference to jump to relevant concepts directly.

We begin with the essentials of why databases are important in today's information technology world and how they work.

We continue by explaining the concepts of querying and modifying data in Oracle using a range of techniques, including data projection, selection, creation, joins, sub-queries and functions. Finally, we learn to create and manipulate database objects and to use them in the same way as today's expert SQL programmers.

This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand

This definitive certification guide provides a disciplined approach to be adopted for successfully clearing the 1Z0-051 SQL Fundamentals I exam, which is the first stepping stone towards attaining the OCA on Oracle Database 11g certification.

Each chapter contains ample practice questions at the end. A full-blown mock test is included for practice so you can test your knowledge and get a feel for the actual exam.

  • Successfully clear the first stepping stone towards attaining the Oracle Certified Associate Certification on Oracle Database 11g
  • This book uses a real world example-driven approach that is easy to understand and makes engaging
  • Complete coverage of the prescribed syllabus
  • Learn from a range of self-test questions to fully equip you with the knowledge to pass this exam
  • After reading this book, you can enter the exam room with confidence, knowing that you have done all you can to prepare for the big day
  • Get Mock test exam paper and Mock test answers

Test your Knowledge

Page Count 460
Course Length 13 hours 48 minutes
ISBN 9781849683647
Date Of Publication 5 Dec 2011


Steve Ries

Steve Ries has been an Oracle DBA for 16 years, specializing in all aspects of database administration, including security, performance tuning and backup and recovery. He is a specialist in Oracle Real Application Clusters (RAC) and has administered Oracle clustered environments in every version of Oracle since the creation of Oracle Parallel Server. Steve is the author of OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide, Packt Publishing. He holds five Oracle certifications as well as a Security+ certification. He currently consults for the Dept. of Defense, US Marine Corps, and holds a high-level security clearance. Additionally, Steve has been an adjunct instructor of Oracle technologies at Johnson County Community College for 9 years, where he teaches classes that prepare students for the Oracle certification exams. He was also a speaker at the 2011 and 2012 Oracle Open World conferences. Steve is a two-time, award-winning technical paper writer and the creator of the alt.oracle blog.