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
Participants are required to possess a foundational understanding of relational database architectures and core database principles. Previous experience with Oracle SQL is not a prerequisite, as the curriculum is designed to accommodate novice learners. A general familiarity with computer operations and data management practices is recommended for successful participation.
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.
