OCA Oracle Database 11g: SQL Fundamentals I: A Real-World Certification Guide
Relational Database Management Systems
An introduction to Oracle SQL Developer
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
Implementing selectivity using the WHERE clause
Using conditions in WHERE clauses
Examining conditions with multiple values
Certification objectives covered
Persistent storage and the CRUD model
Combining Data from Multiple Tables
Understanding the principles of joining tables
Understanding Oracle join syntax
Understanding functions and their use
Understanding String functions
Examining functions that execute conditional retrieval
Understanding multi-row functions
Certification objectives covered
Understanding the principles of subqueries
Examining different types of subqueries
Investigating further rules for subqueries
Using set operators within SQL
Certification objectives covered
Introducing Data Definition Language
Extending the Companylink Data Model
Creating Other Database Objects
Using indexes to increase performance
SQL in Application Development
Using SQL with other languages