Certificate ID:
805091
Authentication Code:
6e41b
Certified Person Name:
Tudor Gavril
Certified Person Email:
Trainer Name:
Copaceanu Constantin
Duration Days:
2
Duration Hours:
14
Course Name:
Oracle SQL LP - Fundamentals
Course Date:
10 April 2025 10:00 to 11 April 2025 17:00
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
Certificate Sent:
Certificate Sent