OCA Oracle Database 11g: SQL Fundamentals I: Exam Guide (Exam 1Z0-051)

  • 7h 56m
  • John Watson, Roopesh Ramklass
  • Oracle Press
  • 2008

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including:

  • SQL SELECT statements
  • Restricting and sorting data
  • Single-row functions
  • Conversion functions and conditional expressions
  • Group functions
  • Displaying data from multiple tables
  • Subqueries
  • Set operators
  • DML and DDL statements
  • Schema objects

About the Authors

John Watson (Oxford, UK) works for BPLC Management Consultants, teaching and consulting throughout Europe and Africa. He was with Oracle University for several years in South Africa, and before that worked for a number of companies, government departments, and NGOs in England and Europe. He is OCP qualified in both database and Application Server administration. John is the author of several books and numerous articles on technology and has 25 years of experience in IT.

Roopesh Ramklass (South Africa), OCP, is an independent Oracle specialist with over 10 years of experience in a wide variety of IT environments. These include software design and development, systems analysis, courseware development, and lecturing. He has worked for Oracle Support and taught at Oracle University in South Africa for several years. Roopesh is experienced in managing and executing IT development projects, including infrastructure systems provisioning, software development, and systems integration.

In this Book

  • Oracle Server Technologies and the Relational Paradigm
  • Data Retrieval Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Single-Row Functions
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using Subqueries to Solve Problems
  • Using the Set Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
SHOW MORE
FREE ACCESS

YOU MIGHT ALSO LIKE

Book Oracle on Docker: Running Oracle Databases in Linux Containers
Course Database Fundamentals: Understanding Relational Database Management Systems
Rating 4.5 of 175 users Rating 4.5 of 175 users (175)
Book Extending Oracle Application Express with Oracle Cloud Features: A Guide to Enhancing APEX Web Applications with Cloud-Native and Machine Learning Technologies