1Z0-051 Practice Test

Oracle Database 11g (R2): SQL Fundamentals I

    • 132 questions simulating vendor test questions
    • 158 complimentary flash cards
    • Detailed explanations for correct/incorrect answers help you grasp underlying concepts
    • Comprehensive score report helps you focus your study efforts
    • 3 year license


Purchase Practice Test

CD

Only $99.00

Download + Bonus Online

Only $99.00

30 Day Online Access

Only $69.00

180 Day Online Access

Only $89.00

365 Day Online Access

Only $99.00

Subtotal

This test introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. The exam also now includes R2 topic coverage.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

Important Exam Information and Objectives
Learn to:
  • Retrieve row and column data from tables with the SELECT statement
  • Create reports of sorted and restricted data
  • Display data from multiple tables
  • Use DML statements to manage data
  • Use DDL statements to manage database objects