Oracle Database 12c R2: Introduction to SQL Ed 2

• Introduction to Oracle Database Exadata Express Cloud Service
• Accessing Cloud Database using SQL Workshop
• Connecting to Exadata Express Database using Database Clients

• Capabilities of the SELECT statement
• Arithmetic expressions and NULL values in the SELECT statement
• Column aliases
• Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
• Use of the DESCRIBE command

• Limiting the Rows
• Rules of precedence for operators in an expression
• Substitution Variables
• Using the DEFINE and VERIFY command

• Describe the differences between single row and multiple row functions
• Manipulate strings with character function in the SELECT and WHERE clauses
• Manipulate numbers with the ROUND, TRUNC and MOD functions
• Perform arithmetic with date data
• Manipulate dates with the date functions

• Describe implicit and explicit data type conversion
• Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
• Nest multiple functions
• Apply the NVL, NULLIF, and COALESCE functions to data
• Use conditional IF THEN ELSE logic in a SELECT statement

• Group Functions
• Creating Groups of Data
• Restricting Group Results

• Introduction to JOINS
• Types of Joins
• Natural join
• Self-join
• Non equijoins
• OUTER join

• Introduction to Subqueries
• Single Row Subqueries
• Multiple Row Subqueries

• Set Operators
• UNION and UNION ALL operator
• INTERSECT operator
• MINUS operator
• Matching the SELECT statements
• Using ORDER BY clause in set operations

• Data Manipulation Language
• Database Transactions

• Data Definition Language

• Introduction to Data Dictionary
• Describe the Data Dictionary Structure
• Using the Data Dictionary views
• Querying the Data Dictionary Views

• Overview of sequences
• Overview of synonyms
• Overview of indexes

• Overview of views

• Managing constraints
• Creating and using temporary tables
• Creating and using external tables

After completing this module, students will be able to:

• Retrieving Data by Using a Subquery as Source
• Working with Multiple-Column subqueries
• Using Scalar subqueries in SQL
• Correlated Subqueries
• Working with the WITH clause

• Using Subqueries to Manipulate Data
• Inserting by Using a Subquery as a Target
• Using the WITH CHECK OPTION Keyword on DML Statements
• Using Correlated Subqueries to Update and Delete rows

• Overview of the Explicit Default Feature
• Using multitable INSERTs
• Using the MERGE statement
• Performing flashback operations
• Tracking Changes in Data

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP
• Working with INTERVAL data types