Oracle SQL LP - Fundamentals Certificate for ROMAN STURZA
Certificate ID:
761215
Authentication Code:
e502b
Certified Person Name:
ROMAN STURZA
Trainer Name:
Gabriel Petrescu
Duration Days:
2
Duration Hours:
14
Course Name:
Oracle SQL LP - Fundamentals
Course Date:
2024-04-22 10:00 to 2024-04-23 10: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