Certificate Authentication

Introduction to SQL

• Overview of SQL
• Introduction to Oracle SQL Developer
• Basic SQL Syntax

Retrieving Data

• Viewing table data using SELECT statement
• Filtering data with WHERE clause
• Combining conditions with AND & OR clauses
• Sorting data with ORDER BY clause
• Filtering with the IN operator
• Ranges with the BETWEEN operator
• Pattern matching with the LIKE operator
• Handling NULL values
• Adding Comments to SQL code

Understanding Users and Schemas

• Overview of users and schemas in Oracle
• Working with the DUAL table

Joining Tables

• Understanding Primary and Foreign Keys
• Performing Inner Joins
• Exploring Outer Joins
• Handling Link Tables
• Implementing Non-standard Joins
• Self-joins for related table data

Working with Functions

• Using Text Functions for string manipulation
• Manipulating Date data with Date Functions
• Performing calculations with Aggregate Functions
• Conditional processing using DECODE & CASE functions

Sub Queries

• Understanding Nested Sub-queries
• Implementing Correlated Sub-queries
• Utilizing Inline Views (Common Table Expressions)
• Working with ANY, ALL, and EXISTS operators