Cargando…
OCA Oracle database 11g : SQL fundamentals I exam guide (exam 1Z0-051) /
"Prepare 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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York :
McGraw-Hill,
©2008.
|
| Colección: | McGraw Hill professional.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Cover
- Contents
- Introduction
- 1 Oracle Server Technologies and the Relational Paradigm
- Position the Server Technologies
- The Oracle Server Architecture
- The Oracle Application Server
- Oracle Enterprise Manager
- Grid Computing
- Exercise 1-1: Investigate Your Database and Application Environment
- Development Tools and Languages
- Understand Relational Structures
- Rows and Tables
- Data Normalization
- Exercise 1-2: Perform an Extended Relational Analysis
- Summarize the SQL Language
- SQL Standards
- SQL Commands
- A Set-oriented Language
- Use the Client Tools
- SQL*Plus
- SQL Developer
- Create the Demonstration Schemas
- Users and Schemas
- The HR and OE Schemas
- Demonstration Schema Creation
- Two-Minute Drill
- Q & A: Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 2 Data Retrieval Using the SQL SELECT Statement
- List the Capabilities of SQL SELECT Statements
- Introducing the SQL SELECT Statement
- The DESCRIBE Table Command
- Exercise 2-1: Describing the Human Resources Schema
- Capabilities of the SELECT Statement
- Execute a Basic SELECT Statement
- Syntax of the Primitive SELECT Statement
- Rules Are Meant to be Followed
- Exercise 2-2: Answering Our First Questions with SQL
- SQL Expressions and Operators
- NULL Is Nothing
- Exercise 2-3: Experimenting with Expressions and the DUAL Table
- Two-Minute Drill
- Q & A: Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 3 Restricting and Sorting Data
- Limit the Rows Retrieved by a Query
- The WHERE clause
- Comparison Operators
- Exercise 3-1: Using the LIKE Operator
- Boolean Operators
- Precedence Rules
- Sort the Rows Retrieved by a Query
- The ORDER BY Clause
- Exercise 3-2: Sorting Data Using the ORDER BY Clause
- Ampersand Substitution
- Substitution Variables
- Define and Verify
- Exercise 3-3: Using Ampersand Substitution
- Two-Minute Drill
- Q & A: Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 4 Single-Row Functions
- Describe Various Types of Functions Available in SQL
- Defining a Function
- Types of Functions
- Use Character, Number, and Date Functions in SELECT Statements
- Using Character Case Conversion Functions
- Exercise 4-1: Using the Case Conversion Functions
- Using Character Manipulations Functions
- Exercise 4-2: Using the Case Manipulation Functions
- Using Numeric Functions
- Working with Dates
- Using Date Functions
- Exercise 4-3: Using the Date Functions
- Two-Minute Drill
- Q & A: Self Test
- Lab Question
- Self Test Answers
- Lab Answer
- 5 Using Conversion Functions and Conditional Expressions
- Describe Various Types of Conversion Functions Available in SQL
- Conversion Functions
- Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
- Using the Conversion Functions
- Exercise 5-1: Converting Dates into Characters Using the TO_CHAR Function
- Apply Conditional Expressions in a SELECT Statement
- Nesting Functions
- Exercise 5-2: Using NULLIF and NVL2 for Simple Conditional Logic
- Conditional Functions
- Exercise 5-3: Using the DECODE Function
- Two-Minute Drill
- Q & A: Self Test
- Lab Q.