Oracle SQL LP - Fundamentals

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.

The Oracle SQL Fundamentals training course is a comprehensive program designed to equip participants with essential skills and knowledge in Structured Query Language (SQL) using Oracle Database.

By the end of this training, participants will be able to:

• Gain proficiency in writing SQL queries to retrieve and manipulate data in Oracle databases.
• Acquire essential skills in joining tables and handling complex data relationships.
• Understand how to use functions effectively for data manipulation and calculation.
• Master the art of writing efficient sub-queries to perform advanced data filtering and processing
• Gain confidence to work with Oracle SQL in real-world scenarios, enhancing their career prospects in database management and development.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

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