Book Image

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

By : Steve Ries
Book Image

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

By: Steve Ries

Overview of this book

<p>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.<br /><br />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.<br /><br />We begin with the essentials of why databases are important in today's information technology world and how they work.<br /><br />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.<br /><br />This book prepares you to master the fundamentals of the SQL programming language using an example-driven method that is easy to understand<br /><br />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.<br /><br />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.</p>

Related Content you might be interested in

Current Title:

Small book image
OCA Oracle Database 11g: SQL Fundamentals I: A Real World Certification Guide ( 1ZO-051 )
Steve Ries
Dec, 2011 | 460 pages
No titles found
Table of Contents (20 chapters)
OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
SQL and Relational Databases
SQL and Relational Databases
Relational Database Management Systems
Structured Query Language
Working with SQL
An introduction to Oracle SQL Developer
Summary
Test your knowledge
2
SQL SELECT Statements
SQL SELECT Statements
The purpose and syntax of SQL
Retrieving data with SELECT statements
Displaying the structure of a table using DESCRIBE
Using aliases to format output of SELECT statements
Using arithmetic operators with SELECT
Using DISTINCT to display unique values
Concatenating values in SELECT statements
Summary
Test your knowledge
3
Using Conditional Statements
Using Conditional Statements
Implementing selectivity using the WHERE clause
Using conditions in WHERE clauses
Examining conditions with multiple values
Sorting data
Summary
Certification objectives covered
Test Your Knowledge
4
Data Manipulation with DML
Data Manipulation with DML
Persistent storage and the CRUD model
Creating data with INSERT
Modifying data with UPDATE
Removing data with DELETE
Transaction control
Recognizing errors
Summary
Test your knowledge
5
Combining Data from Multiple Tables
Combining Data from Multiple Tables
Understanding the principles of joining tables
Using ANSI standard joins
Understanding Oracle join syntax
Summary
Test your knowledge
6
Row Level Data Transformation
Row Level Data Transformation
Understanding functions and their use
Understanding String functions
Handling DATE functions
Using arithmetic functions
Examining functions that execute conditional retrieval
Summary
Test your knowledge
7
Aggregate Data Transformation
Aggregate Data Transformation
Understanding multi-row functions
Grouping data
Putting it all together
Certification objectives covered
Summary
Test your knowledge
8
Combining Queries
Combining Queries
Understanding the principles of subqueries
Examining different types of subqueries
Investigating further rules for subqueries
Using set operators within SQL
Summary
Certification objectives covered
Test your knowledge
9
Creating Tables
Creating Tables
Introducing Data Definition Language
Using database constraints
Extending the Companylink Data Model
Summary
Test your knowledge
10
Creating Other Database Objects
Creating Other Database Objects
Using indexes to increase performance
Working with views
Using sequences
Object naming using synonyms
Summary
Test your knowledge
11
SQL in Application Development
SQL in Application Development
Using SQL with other languages
Understanding the Oracle optimizer
Advanced SQL statements
Exam preparation
Summary
Practice test paper
Companylink Table Reference
Companylink Table Reference
The Companylink data model
Getting Started with APEX
Getting Started with APEX
Oracle Application Express
Index
Index

Chapter 2. SQL SELECT Statements

In the previous chapter, we laid the groundwork for using SQL with Oracle databases. Now, we are almost ready to begin writing our own SQL statements. But, first, we'll need to examine the rules. Once that's complete, we will proceed to learn several different basic SQL queries, all derived from the single, most important SQL statement at our disposal—the SELECT statement. With this statement, we can retrieve data from an Oracle database and, by the end of the chapter, will begin to do transformations of the data as well. Beginning with this chapter, we also make note of the Certification objectives covered. This is a guide for us to match our subject matter with the objectives of the certification exam.

In this chapter, we shall:

  • Understand the purpose of SELECT statements

  • Explore the syntax and usage of SELECT statements

  • Use SELECT for single-column data retrieval

  • Use SELECT for multi-column data retrieval

  • Use SELECT to retrieve all the columns in a table

  • Display...

Previous Section
End of Section 1
Next Section