Back To Exam Listing

Exam:

1Z0-071

Title:

Oracle Database 12c SQL

Time (Mins):

Questions:

Passing Score:

%

---

Oracle Education Links:	Oracle Education Links
Exam Page:	Exam Details	Topics:	Exam Topics
Recommended Training:	Recommended Training & Preparation

• Main
• Exam Info
• Study Guides
• Practice Tests
• FAQ/Tips
• Contact Us
• OCPrep Blog

SQL Developer User's Guide
SQL Language Quick Reference
SQL Language Reference
SQL*Plus User's Guide and Reference
Sample Schemas

Study Guide for 1Z0-071: Oracle Database 12c SQL
OCPrep SQL Study Guide -- DDL/Objects

A Function of Character by Melanie Caffrey
An Order of Sorts by Melanie Caffrey
Beginner SQL Tutorial
DEFAULT Values for Table Columns
Exact Formatting with the FX Modifier
Fill Mode Formatting with the FM Modifier
Format Punctuation
Format Suffixes
Formatting Dates
Formatting Times
From Floor to Ceiling and Other Functional Cases by Melanie Caffrey
Get Your Information in Order by Melanie Caffrey
Getting Answers with SELECT by Melanie Caffrey
Identity Columns in Oracle Database 12c
Modeling and Accessing Relational Data by Melanie Caffrey
Oracle SQL -- René Nyffenegger on Oracle
Oracle SQL Tutorials
Row Limiting Clause for Top-N Queries in Oracle Database 12c
Why WHERE Matters by Melanie Caffrey

Data Retrieval with SQL SELECT
Oracle Database - Basic SQL Syntax
Oracle Database - Constraints
Oracle Database - DML and DDL Queries
Oracle Database - Database Dependencies
Oracle Database - Database Design
Oracle Database - Database Objects
Oracle Database - ERDs continued
Oracle Database - Entity Relationship Diagrams
Oracle Database - Introduction to SQL
Oracle Database - Normalization
Oracle Database - Overview of SQL
Oracle Database - Overview of a Database
Oracle Database - SQL Boot Camp 1
Oracle Database - SQL Boot Camp 2
Oracle Database - SQL Boot Camp 3
Oracle Database - SQL Operations
Oracle Database Concepts - Part 1
Oracle Database Concepts - Part 2
Oracle SQL Tutorial - Adding a column to a table
Oracle SQL Tutorial - Altering a Table using SQL commands (Theory)
Oracle SQL Tutorial - Altering a table using SQL commands (Hands-On)
Oracle SQL Tutorial - Creating a Table - Hands-On (CREATE TABLE command)
Oracle SQL Tutorial - Creating a User (Hands-On)
Oracle SQL Tutorial - Creating a User (Theory)
Oracle SQL Tutorial - Creating a sequence
Oracle SQL Tutorial - Creating a synonym
Oracle SQL Tutorial - Creating a table (Theory)
Oracle SQL Tutorial - Creating a table and its constraints
Oracle SQL Tutorial - Creating a view
Oracle SQL Tutorial - Creating an Index
Oracle SQL Tutorial - Creating constraints after Table Creation
Oracle SQL Tutorial - Data Control Language - System Privileges (Theory)
Oracle SQL Tutorial - Data Control Language- System Privileges (Hands-On)
Oracle SQL Tutorial - Deleting data in a table
Oracle SQL Tutorial - Insert data in a table
Oracle SQL Tutorial - Joining Tables (Hands-on) - Part 1
Oracle SQL Tutorial - Joining Tables (Hands-on) - Part 2
Oracle SQL Tutorial - Object Privileges (Hands-On)
Oracle SQL Tutorial - Object Privileges (Theory)
Oracle SQL Tutorial - Query the Data Dictionary (Hands-On) - Part 1
Oracle SQL Tutorial - Query the Data Dictionary (Hands-On) - Part 2
Oracle SQL Tutorial - Querying Data - Part 10(a) - Single-Row Character Functions
Oracle SQL Tutorial - Querying Data - Part 9 - Intro to Single-Row Functions
Oracle SQL Tutorial - Querying a Table - Part 11(b) - Group Functions (Hands-on)
Oracle SQL Tutorial - Querying a table - Part 1
Oracle SQL Tutorial - Querying a table - Part 10(c) Single-Row Numeric Functions
Oracle SQL Tutorial - Querying a table - Part 10(d) - Single-Row Date Functions
Oracle SQL Tutorial - Querying a table - Part 10(e) - Single-Row Conversion Functions
Oracle SQL Tutorial - Querying a table - Part 10(f) - Single Row Null Functions
Oracle SQL Tutorial - Querying a table - Part 11a) - Group Functions (Theory)
Oracle SQL Tutorial - Querying data - Part 10(b) - Single-Row Character Functions
Oracle SQL Tutorial - Querying data - Part 2
Oracle SQL Tutorial - Querying data - Part 3 - Column Aliases
Oracle SQL Tutorial - Querying data - Part 4 - (ORDER BY clause)
Oracle SQL Tutorial - Querying data - Part 5 - SQL DISTINCT clause
Oracle SQL Tutorial - Querying data - Part 6 - WHERE clause
Oracle SQL Tutorial - Querying data - Part 7 - WHERE clause continued
Oracle SQL Tutorial - Querying data - Part 8 - WHERE clause continued
Oracle SQL Tutorial - Roles in Oracle (Hands-On)
Oracle SQL Tutorial - Roles in Oracle (Theory)
Oracle SQL Tutorial - Update data in a table
Oracle SQL Tutorials - Joining Tables Theory - Part 1
Oracle SQL Tutorials - Joining Tables Theory - Part 2