Welcome to the Oracle Introduction to SQL Training Course! This comprehensive 5-day program is designed to provide you with a solid foundation in SQL (Structured Query Language) using Oracle’s database platform. Whether you’re new to databases or seeking to enhance your SQL skills, this course will guide you through the essentials of data querying and manipulation.
Through hands-on exercises, practical examples, and interactive discussions, you’ll learn how to retrieve, modify, and manage data efficiently using SQL within the Oracle database environment. This training teaches you how to write sub queries, combine multiple queries into a single query using SET operators and report aggregated data using group functions.
Duration: 5 days – 35 hrs.
Objectives
- Understand the fundamentals of relational databases and SQL.
- Write basic to intermediate SQL queries to retrieve and manipulate data.
- Gain proficiency in querying data from Oracle databases.
- Perform data manipulation tasks such as updating, inserting, and deleting records.
- Develop a strong foundation for more advanced SQL concepts and Oracle database usage.
Audience
- IT professionals seeking to gain proficiency in SQL and Oracle databases.
- Database administrators, developers, and analysts interested in data manipulation.
- Individuals aiming to master SQL for querying and managing data within Oracle environments.
Prerequisites
- Basic familiarity with databases and data concepts is recommended.
- No prior experience with Oracle databases or SQL is required
Course Content
Day 1 — Oracle Database Fundamentals and Basic Queries
Module 1 — Introduction to Oracle Database
- Oracle Database overview, history, and evolution
- Relational database concepts
- Oracle Database architecture
- Oracle Database editions and their features
Module 2 — Retrieving Data with SELECT
- Basic SELECT statement syntax
- Retrieving all columns or specific columns
- Eliminating duplicate results with DISTINCT
- Writing simple WHERE clauses
Module 3 — Restricting and Sorting Data
- Filtering rows with WHERE and comparison operators
- Combining conditions with AND, OR, and NOT
- Sorting results with ORDER BY
- Sorting by multiple columns
Day 2 — SQL Functions, Conditional Logic, and Aggregation
Module 4 — Using Single-Row Functions
- Character functions such as UPPER, LOWER, and SUBSTR
- Numeric functions such as ROUND, TRUNC, and ABS
- Working with dates using SYSDATE
- Formatting dates with TO_CHAR
Module 5 — Converting Data Types and Handling Conditional Logic
- Implicit and explicit data type conversion
- Conversion functions such as TO_NUMBER, TO_DATE, and TO_CHAR
- Handling null values with NVL, NVL2, COALESCE, and NULLIF
- Applying conditional logic with CASE and DECODE
Module 6 — Aggregating Data with Group Functions
- Summarizing data with SUM, AVG, MIN, and MAX
- Using COUNT and understanding how aggregate functions handle null values
- Grouping results with GROUP BY
- Filtering grouped results with HAVING
Day 3 — Joins, Subqueries, and Set Operators
Module 7 — Retrieving Data from Multiple Tables
- Inner joins and equijoins
- Left, right, and full outer joins
- Self-joins and cross joins
- Joining more than two tables
Module 8 — Solving Queries with Subqueries
- Single-row and multiple-row subqueries
- Using subqueries in WHERE and HAVING clauses
- Using scalar subqueries in the SELECT list
- Writing correlated subqueries
- Comparing joins and subqueries for common retrieval tasks
Module 9 — Combining Query Results with Set Operators
- Combining results with UNION and UNION ALL
- Finding common results with INTERSECT
- Finding differences between result sets with MINUS
Day 4 — Data Manipulation, Tables, and Schema Objects
Module 10 — Modifying Data and Controlling Transactions
- Inserting, updating, and deleting rows with INSERT, UPDATE, and DELETE
- Combining insert and update operations with MERGE
- Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT
Module 11 — Creating and Managing Tables with DDL
- Overview of Data Definition Language (DDL)
- Creating and modifying tables with CREATE TABLE and ALTER TABLE
- Removing table data with TRUNCATE TABLE
- Removing tables with DROP TABLE
Module 12 — Working with Other Schema Objects
- Using views to simplify queries
- Understanding indexes and common index types
- Accessing schema objects through synonyms
- Generating numbers with sequences
Module 13 — Controlling User Access
- User authentication, authorization, and password security
- System privileges and object privileges
- Granting and revoking privileges
- Managing access through roles
Day 5 — Schema Management and Advanced Query Techniques
Module 14 — Managing Schema Objects and Inspecting Metadata
- Renaming and moving schema objects
- Flashback and Recycle Bin concepts
- Tablespace allocation, undo and temporary tablespaces, and segment storage concepts
- Inspecting objects with USER_, ALL_, and DBA_ data dictionary views
- Selecting the appropriate data dictionary view for an object or access level
Module 15 — Working with Large Data Sets
- Retrieving data in batches with OFFSET and FETCH FIRST or FETCH NEXT
- Using ROWNUM for row limiting and understanding what ROWID identifies
- Applying deterministic sorting for consistent pagination
- Writing targeted queries and DML statements for large tables
Module 16 — Managing Date and Time Data Across Time Zones
- Working with TIMESTAMP and Oracle’s time zone-aware timestamp types
- Converting timestamps with AT TIME ZONE
- Working with interval data types
- Handling daylight saving time in time zone conversions
Module 17 — Using Regular Expressions in SQL
- Regular expression patterns and syntax
- Filtering rows with REGEXP_LIKE
- Extracting text with REGEXP_SUBSTR
- Replacing matched text with REGEXP_REPLACE
- Combining regular expressions with SQL filters and output expressions
Hardware Requirements:
- Client Devices: The hardware requirements for accessing Oracle Live typically depend on the client devices (computers, smartphones, tablets) used to access the service. These devices should have a compatible web browser or mobile app to access the streaming content.
- Server Infrastructure: Oracle Live is a cloud-based service, so there are no specific hardware requirements for customers. Oracle manages the underlying server infrastructure to deliver streaming content.
Software Requirements:
- Web Browsers: To access Oracle Live from a computer, you typically need a modern web browser with support for HTML5, JavaScript, and media streaming formats. Commonly supported browsers include Google Chrome, Mozilla Firefox, Microsoft Edge, and Safari.
- Mobile Apps: If you’re accessing Oracle Live on a mobile device, you’ll need to install the Oracle Live app from the respective app store (e.g., Google Play Store for Android or Apple App Store for iOS).
- Operating Systems: The software requirements for client devices depend on the platform they run. Oracle Live typically supports major operating systems like Windows, macOS, iOS, and Android.
- Network Requirements: A stable and reasonably fast internet connection is essential to stream content from Oracle Live without interruptions. The required bandwidth can vary depending on the quality of the streaming content (e.g., SD, HD, 4K).
- Authentication and Authorization: Depending on the specific use case and how Oracle Live is integrated into your organization’s systems, you may need to configure authentication and authorization mechanisms. Oracle typically offers identity and access management services that can be integrated with Oracle Live.
- Content Creation Tools: If you plan to create and publish streaming content using Oracle Live, you may need additional software tools for content production, such as video editing software, audio recording tools, or live streaming software.
Other Requirements:
- Strong WIFI Internet Connection
- Headset with mic or Loud Speaker with mic

