Welcome,
New User!
New User!
OCA: Oracle Database 11g Administrator Certified Associate Study Guide
By: Biju ThomaseBook Publisher: John Wiley & Sons
Imprint: Sybex
Format: ePub Encrypted (DRM)
Earn $0.50 - Write a Review »
Our Price
$59.99
Reward Money:
$0.00
Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
For Instructors: Teaching supplements are available for this title.
See more like this in our Computers eBooks section
Share your thoughts on the OCA: Oracle Database 11g Administrator Certified Associate Study Guide Computers eBook with others!
| Title of Computers eBook: OCA: Oracle Database 11g Administrator Certified Associate Study Guide | |
| Release Date: 01-31-2011 | |
| Publisher: Sybex |
This eBook download is available in the following formats:
| Parent title | OCA: Oracle Database 11g... |
|---|---|
| Encrypted (DRM) | Yes |
| SKU | 9780470488348 |
| File size | 17376 |
| Security | n/a |
| Printing | Not allowed |
| Copying | Not allowed |
| Read aloud | No Sys requirements Download reader |
| Devices | Samsung Tablet, Apple Ipad & Iphone, Barnes & Noble Nook, Kobo eReader, Aluratek Libre, Iliad, Nokia, Blackberry, Hanlin |
| Note | Excellent navigation features are available via Adobe such as bookmarks and a quick access table of contents. Text search is easily accessible. An Adobe DRM-protected file is different than a pdf file in that it uses Adobe DRM (Digital Rights Management) technology, which authors and publishers use to protect their content from illegal online distribution and to set certain privileges such as restrictions on copying and printing. |
OCA: Oracle Database 11g Administrator Certified Associate Study Guide
Chapter One
Introducing SQL
ORACLE DATABASE 11g: SQL FUNDAMENTALS I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Retrieving Data Using the SQL SELECT Statement
* List the capabilities of SQL SELECT statements * Execute a basic SELECT statement
Restricting and Sorting Data
* Limit the rows that are retrieved by a query * Sort the rows that are retrieved by a query * Use ampersand substitution to restrict and sort output at runtime
Oracle 11g is a very powerful and feature-rich relational database management system (RDBMS). SQL has been adopted by most RDBMSs for the retrieval and management of data, schema creation, and access control. The American National Standards Institute (ANSI) has been refining standards for the SQL language for more than 20 years. Oracle, like many other companies, has taken the ANSI standard of SQL and extended it to include much additional functionality.
SQL is the basic language used to manipulate and retrieve data from the Oracle Database 11g. SQL is a nonprocedural language, meaning it does not have programmatic constructs such as loop structures. PL/SQL is Oracle's procedural extension of SQL, and SQLJ allows embedded SQL operations in Java code. The scope of the Oracle Database 11g SQL Fundamentals I test includes only SQL.
In this chapter, I will discuss Oracle SQL fundamentals such as the various types of SQL statements, introduce SQL*Plus and a few SQL*Plus commands, and discuss SELECT statements.
You will learn how to write basic SQL statements to retrieve data from tables. This will incl
...Read full excerpt from OCA: Oracle Database 11g Administrator Certified Associate Study Guide ebook
