Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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 expected to have a basic understanding of relational databases and familiarity with fundamental database concepts. No prior experience with Oracle SQL is required, making this course suitable for beginners. A basic understanding of computer operations and data management will be beneficial.
14 Hours
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.
