Oracle SQL

Writing Basic SQL Select Statements

• Basic SELECT Statement 

• Selecting all Columns

• Selecting Specific Columns

• Column Heading aliases

• Arithmetic Expressions 

• Using Arithmetic Operators 

• Operator Precedence 

• Using the Concatenation Operator 

• Eliminating Duplicate Rows (Distinct clause)

Restricting and Sorting Data

• Limiting Rows Using a Selection 

• Using the WHERE Clause 

• Character Strings and Dates 

• Comparison Conditions 

• Using between, in, like operators

• Using Logical Conditions (and, or, not)

• Rules of Precedence 

• Sorting using order by clause

• Sorting by multiple columns

Single-Row Functions

• Character Functions 

• Case Manipulation Functions 

• Number Functions 

• Date and time functions

• Conversion Functions 

• Implicit and Explicit Data Type Conversion 

• Using the TO_CHAR Function with Dates 

• Using the TO_CHAR Function with Numbers 

• Using the TO_NUMBER and TO_DATE Functions 

• Nesting Functions 

• General Functions 

• NVL Function 

• Using the NVL Function 

• Using the NVL2 Function 

• Using the NULLIF Function 

• Using the Coalesce Function 

• Conditional Expressions 

• The Case Expression 

• The Decode Function 

Displaying Data from Multiple Tables (Joins)

• Obtaining Data from Multiple Tables 

• Types of Joins 

• Retrieving Records with Equijoins 

• Additional Search Conditions Using the AND Operator 

• Qualifying Ambiguous Column Names 

• Using Table Aliases 

• Joining More than Two Tables 

• Retrieving Records with Natural Joins 

• Retrieving Records with Equijoins 

• Retrieving Records with the USING Clause 

• Retrieving Records with the ON Clause 

• Cartesian Products

 Aggregating Data Using Group Functions

• Types of Group Functions 

• Using the AVG, SUM, MIN, MAX and COUNT Functions 

• Using the GROUP BY Clause 

• Using the GROUP BY Clause on Multiple Columns 

• Using the HAVING Clause 

Subqueries

• Using a Subquery to Solve a Problem 

• Single-Row Subqueries 

• Using Group Functions in a Subquery 

• The HAVING Clause with Subqueries 

• Multiple-Row Subqueries 

• Using the ANY Operator in Multiple-Row Subqueries

• Using the ALL Operator in Multiple-Row Subqueries 

Manipulating Data

• Adding a New Row to a Table 

• The INSERT Statement Syntax

• The UPDATE Statement Syntax 

• The DELETE Statement 

• Using a Subquery in an INSERT Statement 

• Using the WITH CHECK OPTION Keyword on DML Statements 

• Using Explicit Default Values 

• The MERGE Statement

• Database Transactions 

• Advantages of COMMIT and ROLLBACK Statements 

Creating and Managing Tables

• Database Objects 

• Naming Rules 

• The CREATE TABLE Statement 

• Referencing Another User’s Tables 

• The DEFAULT Option 

• The ALTER TABLE Statement 

• Adding, modifying and deleting a Column 

• Dropping column

• Truncating tables