Oracle SQL Fundamentals - China

Oracle SQL Fundamentals Course Outline

Day 1: Oracle SQL Basics & Data Retrieval (8 Hours)

Module 1: Introduction to Oracle SQL and Relational Databases

• What is Oracle Database?
• Oracle RDBMS vs. Other Databases
• Oracle SQL vs. ANSI SQL
• Understanding Tables, Columns, and Data Types in Oracle
• Primary Keys, Foreign Keys, and Constraints in Oracle

Module 2: Using Oracle SQL Tools

• Introduction to SQL*Plus and SQLcl
• Working with Oracle SQL Developer
• Executing Queries in SQL Developer & SQL*Plus
• Common SQL*Plus Commands

Module 3: Retrieving Data with SELECT Statement

• SELECT Statement Basics
• Using WHERE Clause for Filtering
• Sorting Data with ORDER BY
• Removing Duplicates with DISTINCT
• Using Aliases for Column and Table Names

Module 4: Oracle SQL Functions and Expressions

• Single-Row Functions
• Character Functions (UPPER, LOWER, INITCAP)
• Number Functions (ROUND, TRUNC, MOD)
• Date Functions (SYSDATE, CURRENT_DATE, LAST_DAY)
• Conversion Functions (TO_CHAR, TO_NUMBER, TO_DATE)
• Dual Table for Function Testing

Day 2: Data Manipulation, Joins & Aggregation (8 Hours)

Module 5: Using Joins in Oracle SQL

• Introduction to Joins in Oracle
• Types of Joins in Oracle
• Using Equijoins and Non-Equijoins

Module 6: Using Subqueries in Oracle

• Introduction to Subqueries
• Single-Row Subqueries vs. Multi-Row Subqueries
• Using Subqueries in WHERE and FROM Clauses
• Using EXISTS and NOT EXISTS

Module 7: Aggregation and Grouping Data

• Aggregate Functions (AVG, SUM, MAX, MIN, COUNT)
• GROUP BY and HAVING Clause
• Advanced Grouping: ROLLUP, CUBE, GROUPING SETS

Module 8: Data Manipulation in Oracle SQL (DML)

• Inserting Data into Tables (INSERT Statement)
• Updating Existing Data (UPDATE Statement)
• Deleting Records from Tables (DELETE and TRUNCATE)
• Using MERGE for UPSERT Operations
• Controlling Transactions: COMMIT, ROLLBACK, SAVEPOINT

Day 3: Managing Schema Objects & Performance Optimisation (8 Hours)

Module 9: Managing Tables in Oracle SQL (DDL)

• Creating and Altering Tables
• Creating Temporary Tables in Oracle
• Dropping & Truncating Tables

Module 10: Managing Indexes, Views & Synonyms

• Indexes in Oracle
• Views in Oracle
• Synonyms in Oracle

Module 11: Hierarchical Queries in Oracle

• Working with Parent-Child Relationships
• Using CONNECT BY PRIOR for Tree Structures
• Using START WITH for Root Identification

Module 12: Oracle SQL Performance Optimisation

• Understanding Oracle Execution Plans (EXPLAIN PLAN)
• Optimising Queries with Indexing
• Using Hints for Performance Tuning
• Partitioning Large Tables for Performance

Who should attend this Oracle SQL Fundamentals Course?

The Oracle SQL Fundamentals Course is designed for individuals who want to develop a solid understanding of SQL (Structured Query Language) using Oracle's Database Management System. This Oracle Training Course can benefit a wide range of professionals, including:

• Database Baeginners
• Database Developers
• Database Administrators
• Business Analysts
• Software Developers
• Data Scientists
• IT Professionals

Prerequisites of the Oracle SQL Fundamentals Course

There are no formal prerequisites for attending the Oracle SQL Fundamentals Course. However, a prior understanding of databases and exposure to Information Technology would be helpful for delegates. 

Oracle SQL Fundamentals Course Overview

Oracle SQL Fundamentals is a comprehensive introduction to the Structured Query Language (SQL), the industry-standard language for interacting with relational databases. This Oracle Course provides a solid foundation in SQL concepts and syntax, enabling delegates to effectively query, manipulate, and manage data stored in Oracle databases.

Proficiency in Oracle SQL is crucial for anyone working with Oracle databases, including Database Developers, Database Administrators, Data Analysts, and business users. It empowers individuals to access, analyse, and extract valuable insights from data, supporting informed decision-making and enhancing business operations.

This intensive 3-day Oracle Training empowers us to teach delegates the fundamental concepts of SQL. During this training, representatives will thoroughly understand database management, which includes monitoring, administering, and maintaining a database and its groups in the enterprise. They will also acquire knowledge of sequential numbers produced by the sequence generator to automatically generate unique primary keys and coordinate keys across multiple rows or tables.

Course Objectives

• To understand the fundamentals of relational databases and the SQL language
• To create and modify database tables using DDL statements
• To insert, update, and delete data using DML statements
• To retrieve data using SELECT statements with various clauses
• To use single-row functions to enhance query results
• To apply aggregate functions to summarise data
• To combine data from multiple tables using joins
• To utilise subqueries and set operators for advanced data manipulation

After completing this Oracle Course, delegates can create Oracle SQL statements to query database tables and use standard aggregate functions. They can also implement extended SQL functions and perform flashback operations.

What’s included in this Oracle SQL Fundamentals Course?

• World-Class Training Sessions from Experienced Instructors  
• Oracle SQL Fundamentals Certificate
• Digital Delegate Pack

You’ll also get access to the MyTKA Training Portal, which will be your go to hub for all your training.
Hands-On Labs: Included as part of our online instructor-led delivery, these labs provide real-world exercises in a simulated environment guided by expert instructors to enhance your practical skills.