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
- SQL overview
- Getting started with Oracle SQL Developer
- Foundations of SQL syntax
Data Retrieval
- Accessing table data via the SELECT statement
- Data filtering using the WHERE clause
- Combining logical conditions with AND & OR clauses
- Ordering results with the ORDER BY clause
- Filtering lists using the IN operator
- Defining ranges with the BETWEEN operator
- Text pattern matching using the LIKE operator
- Managing NULL values
- Incorporating comments into SQL code
Users and Schemas Explained
- Overview of user management and schemas in Oracle
- Utilizing the DUAL table
Table Joins
- Concepts of Primary and Foreign Keys
- Executing Inner Joins
- Investigating Outer Joins
- Managing Link Tables
- Applying Non-standard Join techniques
- Using Self-joins for related data structures
Utilising Functions
- String manipulation via Text Functions
- Date data processing with Date Functions
- Calculations using Aggregate Functions
- Conditional logic through DECODE & CASE functions
Sub-queries
- Concepts of Nested Sub-queries
- Application of Correlated Sub-queries
- Leveraging Inline Views (Common Table Expressions)
- Operating with ANY, ALL, and EXISTS operators
Requirements
Candidates should possess a foundational grasp of relational databases and core database concepts. While no previous exposure to Oracle SQL is necessary, making this course ideal for newcomers, a general familiarity with computer operations and data handling will serve as a useful background.
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.
