Oracle

CIS376: Oracle SQL 1

(STY-CIS376.AO2)
Lessons
Lab
TestPrep
AI Tutor (Add-on)
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Oracle and Structured Query Language (SQL)

  • The Exam: An Overview
  • Identify the Connection Between an ERD and a Relational Database
  • Explain the Relationship Between a Database and SQL
  • Describe the Purpose of DDL
  • Describe the Purpose of DML
  • Build a SELECT Statement to Retrieve Data from an Oracle Database Table
  • Two-Minute Drill
2

Using DDL Statements to Create and Manage Tables (Part 1)

  • Categorize the Main Database Objects
  • Create a Simple Table
  • Review the Table Structure
  • List the Data Types That Are Available for Columns
3

Using DDL Statements to Create and Manage Tables (Part 2)

  • Explain How Constraints Are Created at the Time of Table Creation
  • Drop Columns and Set Column UNUSED
  • Create and Use External Tables
  • Two-Minute Drill
4

Manipulating Data

  • Truncate Data
  • Insert Rows into a Table
  • Update Rows in a Table
  • Delete Rows from a Table
  • Control Transactions
  • Two-Minute Drill
5

Restricting and Sorting Data (Part 1)

  • Sort the Rows That Are Retrieved by a Query
  • Limit the Rows That Are Retrieved by a Query
6

Restricting and Sorting Data (Part 2)

  • Use Ampersand Substitution to Restrict and Sort Output at Run Time
  • Use the SQL Row Limiting Clause
  • Two-Minute Drill
7

Using Single-Row Functions to Customize Output

  • Use Various Types of Functions That Are Available in SQL
  • Use Character, Number, Date, and Analytical (PER...TDDEV, LAG, LEAD) Functions in SELECT Statements
  • Two-Minute Drill
8

Using Conversion Functions and Conditional Expressions

  • Describe Various Types of Conversion Functions
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE Conversion Functions
  • Apply General Functions and Conditional Expressions in a SELECT Statement
  • Two-Minute Drill
9

Reporting Aggregated Data Using the Group Functions

  • Describe the Use of Group Functions
  • Group Data by Using the GROUP BY Clause
  • Include or Exclude Grouped Rows by Using the HAVING Clause
  • Two-Minute Drill
10

Displaying Data from Multiple Tables

  • Describe the Different Types of Joins and Their Features
  • Use SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-Equijoins
  • Join a Table to Itself by Using a Self-Join
  • View Data That Generally Does Not Meet a Join Condition by Using Outer Joins
  • Two-Minute Drill

1

Oracle and Structured Query Language (SQL)

  • SandBox Lab
  • Normalizing a Table
  • Creating a Table and Inserting Records in it
2

Using DDL Statements to Create and Manage Tables (Part 1)

  • Altering the Table
  • Adding a Foreign Key
  • Dropping a Primary Key and Adding a Unique Key
  • Viewing the Table Structure
  • Creating a Table Using the CLOB Data Type
3

Using DDL Statements to Create and Manage Tables (Part 2)

  • Creating a Table Using Constraints
  • Dropping a Column
4

Manipulating Data

  • Truncating a Table
  • Inserting Records in the Existing Table
  • Updating a Record in the Table
  • Deleting a Record from the Table
  • Using the Commit and Rollback Statements
5

Restricting and Sorting Data (Part 1)

  • Sorting the Result
  • Using the Boolean Operator
  • Using the LIKE Operator
6

Restricting and Sorting Data (Part 2)

  • Using the ACCEPT and PROMPT Statements
  • Using the Fetch Statement
  • Using the WITH TIES Clause
  • Using the OFFSET-FETCH Clause
7

Using Single-Row Functions to Customize Output

  • Using the INITCAP Function
  • Using the STDDEV Function
  • Using the LEAD and LAG Functions
  • Using the REMAINDER Function
  • Using the SUBSTR Function
  • Using the RTRIM Function
  • Using the CONCAT Function
8

Using Conversion Functions and Conditional Expressions

  • Using the Implicit and Explicit Conversions
  • Using the TO_DATE Function
  • Using the TO_CHAR Function
  • Using the TO_NUMBER Function
  • Using the NVL Function
  • Using the Case Statement
9

Reporting Aggregated Data Using the Group Functions

  • Using the GROUP BY Clause
  • Using the HAVING Clause
10

Displaying Data from Multiple Tables

  • Using the INNER JOIN Operation
  • Creating a Table Using Records of Another Table
  • Using the NATURAL JOIN Operation
  • Using the LEFT OUTER JOIN and RIGHT OUTER JOIN Operation

Related Courses

All Courses