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


Rs.860
Rs.662
23%
Rs.197 (23%)

In Stock
Fulfilled By Infibeam
Sold by Infibeam Seller
Ships in 2 - 4 Days
OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0- 051)
INR
P-M-B-9780070264991
In Stock
662.2
Rs.662


Description

Description:

A Fully Integrated Study System for OCA Exam 1Z0-051

Prepare for the Oracle Certified Associate Oracle Database 11
g

: 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

On the CD-ROM:

One full practice exam that simulates the actual OCA exam

Detailed answers and explanations

Score report performance assessment tool

Complete electronic book

Bonus exam available free with online registration

Table of Contents:

Chapter 1. Oracle Server Technologies and the Relational Paradigm

Chapter 2. Data Retrieval Using the SQL SELECT Statement

Chapter 3. Restricting and Sorting Data

Chapter 4. Single-Row Function

Chapter 5. Using Conversion Functions and Conditional Expressions

Chapter 6. Reporting Aggregated Data Using the Group Functions

Chapter 7. Displaying Data from Multiple Tables

Chapter 8. Using Subqueries to Solve Problems

Chapter 9. Using the Set Operators

Chapter 10. Manipulating Data

Chapter 11. Using DDL Statements to Create and Manage Tables

Chapter 12. Creating Other Schema Objects

Appendix

Glossary

Index

Description:A Fully Integrated Study System for OCA Exam 1Z0-051Prepare 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 statementsRestricting and sorting dataSingle-row functionsConversion functions and conditional expressionsGroup functionsDisplaying data from multiple tablesSubqueriesSet operatorsDML and DDL statementsSchema objectsOn the CD-ROM:One full practice exam that simulates the actual OCA examDetailed answers and explanationsScore report performance assessment toolComplete electronic bookBonus exam available free with online registrationTable of Contents:Chapter 1. Oracle Server Technologies and the Relational ParadigmChapter 2. Data Retrieval Using the SQL SELECT StatementChapter 3. Restricting and Sorting DataChapter 4. Single-Row FunctionChapter 5. Using Conversion Functions and Conditional ExpressionsChapter 6. Reporting Aggregated Data Using the Group FunctionsChapter 7. Displaying Data from Multiple TablesChapter 8. Using Subqueries to Solve ProblemsChapter 9. Using the Set OperatorsChapter 10. Manipulating DataChapter 11. Using DDL Statements to Create and Manage TablesChapter 12. Creating Other Schema ObjectsAppendixGlossaryIndex

Features

  • : OCA Oracle Database 11g: SQL Fundamentals I Exam Guide (Exam 1Z0- 051)
  • : Tata McGraw-Hill
  • : 0070264996
  • : 9780070264991
  • : Paperback

Look for Similar Items by Category

Disclaimer

Shipped by Infibeam.com

The following policies apply for the above product which would be shipped by Infibeam.com
1. Infibeam accept returns if the item shipped is defective or damaged
2. In case of damaged or defective product, the customer is required to raise a concern and ship the product back to us within 15 days from delivery
3. Return shipping costs will be borne by Infibeam.com
4. Infibeam will send a replacement unit as soon as the return package is received
5. Infibeam does not offer any cash refunds
Powered by infibeam