Oracle SQL - Basic/Intermediate Training

Suitable for anyone who want to improve their basic skills in Oracle SQL and also refresh already gained knowledge.

Course:
Oracle SQL - Basic/Intermediate Training
Duration:
2 Days
Delivery:
Instructor led with hands on exercises or self learning
Numbers:
10-15 max

Agenda:

DAY 1 

  • Introduction to Oracle Databases  
    • Oracle Databases  
    • Introduction to SQL  
    • What is SQL? 
    • SQL Editors 
    • SQL Commands types (DDL/DML, ETC) 
    • SQL Tables and Columns 
    • SQL Column Data types 
    • SQL Table and Column Aliases 
  • Connecting to Oracle Databases  
    • SQL Developer  
    • SQL Plus  
    • Oracle DCL (Data Control Language) commands - GRANT and REVOKE 
  • Oracle SQL DDL (Data Definition Language) commands + LAB 
    • CREATE 
    • ALTER  
    • DROP 
    • TRUNCATE  
    • RENAME 
    • Oracle Integrity Constraints (PRIMARY KEY, NOT NULL, CHECK, FOREIGN KEY, UNIQUE)  
  • Oracle SQL DML (Data Manipulation Language) commands + LAB 
    • INSERT INTO SELECT 
    • INSERT ALL 
    • UPDATE 
    • DELETE 
    • MERGE 
  • Oracle SQL TCL (Transaction Control Language) commands + LAB 
    • COMMIT 
    • ROLLBACK  
    • SAVEPOINT 
  • Oracle SQL SELECT Statement 
    • SELECT 
    • SELECT DISTINCT 
    • ORDER BY CLAUSE 
    • WHERE CLAUSE (apply conditions as AND, OR, NOT, IS BETWEEN, IN, LIKE, IS NULL, EXISTS, NOT EXISTS, ANY, ALL) 
  • Oracle SQL JOIN QUERIES + LAB 
    • Inner Join 
    • Outer Join 
    • Self-Join 

DAY 2 

  • Oracle SQL SELECT Statement Advanced + LAB 
    • GROUP BY queries and sub-queries 
    • HAVING CLAUSE 
    • CASE EXPRESSION 
    • WITH CLAUSE 
    • Formatting Output in SQL * Plus, including PIVOT and UNPIVOT commands 
  • Oracle SQL Functions + LAB 
    • Number Functions (Math Functions) 
    • Character Functions 
    • Miscellaneous Functions 
    • Aggregate Functions 
    • Date and Time Functions 
  • Oracle SQL UNION Operators + LAB 
    • UNION 
    • UNION All 
    • INTERSECT 
    • MINUS 
  • Oracle SQL Views + LAB 
    • CREATE  
    • CREATE WITH CHECK OPTION 
    • DROP 
    • REPLACE 
  • Oracle Analytics Functions examples (RANK) 
  • AOB 

Interested in this course? Contact us for more information