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.
Duration 14 hours
Course Outline
Introduction to SQL
- General overview of SQL concepts
- Getting started with Oracle SQL Developer
- Foundations of SQL syntax
Retrieving Data
- Displaying table contents using the SELECT statement
- Data filtering utilizing the WHERE clause
- Combining logical conditions with AND and OR operators
- Data ordering using the ORDER BY clause
- Filtering specific values with the IN operator
- Defining ranges using the BETWEEN operator
- Pattern-based search using the LIKE operator
- Managing NULL values
- Incorporating comments into SQL code
Understanding Users and Schemas
- Concepts of users and schemas within Oracle
- Utilizing the DUAL table for testing
Joining Tables
- Concepts of Primary and Foreign Keys
- Executing Inner Joins
- Examining Outer Joins
- Managing Link Tables
- Applying Non-standard Joins
- Executing Self-joins for related data structures
Working with Functions
- String manipulation using Text Functions
- Date and time processing with Date Functions
- Performing statistical calculations with Aggregate Functions
- Conditional logic implementation using DECODE and CASE functions
Sub Queries
- Concepts of Nested Sub-queries
- Creating Correlated Sub-queries
- Applying Inline Views (Common Table Expressions)
- Utilizing ANY, ALL, and EXISTS operators
Requirements
Attendees should possess a foundational understanding of relational databases and general database principles. While prior hands-on experience with Oracle SQL is not necessary, making this course ideal for beginners, a basic grasp of computer operations and data management practices is advantageous.
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.
