Course Outline
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
Requirements
Prior knowledge of relational database architecture and core data principles is recommended. Although no background in Oracle SQL is necessary, rendering the material appropriate for novice learners, a foundational grasp of computing systems and data governance processes is advantageous for government personnel participating in this training program.
Testimonials (2)
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
