Oca Oracle Database 12c Sql Fundamentals I Exam Guide 1z0 061 Pressa4

oca-oracle-database-12c-sql-fundamentals-i-exam-guide-exam-1z0-061-oracle-pressa4

User Manual: Pdf

Open the PDF directly: View PDF .
Page Count: 586 [warning: Documents this large are best viewed by clicking the View PDF Link!]

Scroll down to view the document on your mobile browser.

OCA Oracle Database 12c: SQL Fundamentals I Exam Guide (Exam 1Z0-061)
Contents at a Glance
Contents
Acknowledgments
Preface
Introduction
1 Relational Database Design Using Oracle
- 1.01 Position the Server Technologies
- 1.02 Understand Relational Structures
- 1.03 Summarize the SQL Language
- 1.04 Use the Client Tools
  - SQL*Plus
  - SQL Developer
- 1.05 Create the Demonstration Schemas
- ✓ Two-Minute Drill
- Q&A Self Test
2 Data Retrieval Using the SQL SELECT Statement
- 2.01 List the Capabilities of SQL SELECT Statements
- 2.02 Execute a Basic SELECT Statement
- ✓ Two-Minute Drill
- Q&A Self Test
3 Restricting and Sorting Data
- 3.01 Limit the Rows Retrieved by a Query
- 3.02 Sort the Rows Retrieved by a Query
  - The ORDER BY Clause
  - Exercise 3-2: Sorting Data Using the ORDER BY Clause
- 3.03 Ampersand Substitution
- ✓ Two-Minute Drill
- Q&A Self Test
4 Single-Row Functions
- 4.01 Describe Various Types of Functions Available in SQL
  - Defining a Function
  - Types of Functions
- 4.02 Use Character, Number, and Date Functions in SELECT Statements
- ✓ Two-Minute Drill
- Q&A Self Test
5 Using Conversion Functions and Conditional Expressions
- 5.01 Describe Various Types of Conversion Functions Available in SQL
  - Conversion Functions
- 5.02 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
- 5.03 Apply Conditional Expressions in a SELECT Statement
- ✓ Two-Minute Drill
- Q&A Self Test
6 Reporting Aggregated Data Using the Group Functions
- 6.01 Describe the Group Functions
  - Definition of Group Functions
  - Types and Syntax of Group Functions
- 6.02 Identify the Available Group Functions
- 6.03 Group Data Using the GROUP BY Clause
- 6.04 Include or Exclude Grouped Rows Using the HAVING Clause
- ✓ Two-Minute Drill
- Q&A Self Test
7 Displaying Data from Multiple Tables
- 7.01 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
- 7.02 Join a Table to Itself Using a Self-Join
  - Joining a Table to Itself Using the JOIN…ON Clause
  - Exercise 7-3: Performing a Self-Join
- 7.03 View Data that Does Not Meet a Join Condition Using Outer Joins
- 7.04 Generate a Cartesian Product of Two or More Tables
  - Creating Cartesian Products Using Cross Joins
  - Exercise 7-5: Performing a Cross-Join
- ✓ Two-Minute Drill
- Q&A Self Test
8 Using Subqueries to Solve Problems
- 8.01 Define Subqueries
  - Exercise 8-1: Types of Subqueries
- 8.02 Describe the Types of Problems That the Subqueries Can Solve
- 8.03 List the Types of Subqueries
- 8.04 Write Single-Row and Multiple-Row Subqueries
  - Exercise 8-4: Write a Query That Is Reliable and User Friendly
- ✓ Two-Minute Drill
- Q&A Self Test
9 Using the Set Operators
- 9.01 Describe the Set Operators
- 9.02 Use a Set Operator to Combine Multiple Queries into a Single Query
- 9.03 Control the Order of Rows Returned
  - Exercise 9-3: Control the Order of Rows Returned
- ✓ Two-Minute Drill
- Q&A Self Test
10 Manipulating Data
- 10.01 Describe Each Data Manipulation Language (DML) Statement
- 10.02 Insert Rows into a Table
  - Exercise 10-1: Use the INSERT Command
- 10.03 Update Rows in a Table
  - Exercise 10-2: Use the UPDATE Command
- 10.04 Delete Rows from a Table
- 10.05 Control Transactions
- ✓ Two-Minute Drill
- Q&A Self Test
11 Using DDL Statements to Create and Manage Tables
- 11.01 Categorize the Main Database Objects
- 11.02 Review the Table Structure
  - Exercise 11-2: Investigate Table Structures
- 11.03 List the Data Types That Are Available for Columns
  - Exercise 11-3: Investigate the Data Types in the HR schema
- 11.04 Create a Simple Table
- 11.05 Explain How Constraints Are Created at the Time of Table Creation
- ✓ Two-Minute Drill
- Q&A Self Test
A About the CD-ROM
Glossary
Index

Oca Oracle Database 12c Sql Fundamentals I Exam Guide 1z0 061 Pressa4

oca-oracle-database-12c-sql-fundamentals-i-exam-guide-exam-1z0-061-oracle-pressa4

Navigation menu

Versions of this User Manual:

Views

Navigation