Geo-ICT Training Center, The Netherlands

200 courses, 20 online supports,

60 moocs, 30 trainees

Cursus: Oracle SQL Fundamentals

  • Description
  • Planning and Registration

The ORACLE SQL Fundamentals course lasts 3 days and costs € 1499. In the Oracle SQL Fundamentals course, participants learn the syntax and use of the query language SQL in the context of an Oracle database. After an introduction to relational databases and Oracle, the Oracle installation, environment and tooling, the basic aspects and backgrounds of SQL are discussed.
Firstly, we will discuss how to make and execute SQL statements in Oracle. It then takes a step-by-step look at the different parts of SQL, such as Data Definition Language with CREATE TABLE, Data Manipulation Language with INSERT and UPDATE and SELECT queries. Grouping data by means of GROUP and HAVING clauses is also part of the course program and the various functions in SQL are discussed. It then goes on to combine data from different tables through joins. The various types of joins are discussed. Finally, attention is paid to the application of SET operators, such as UNION and INTERSECT, and the command line interface of SQL * Plus is discussed. The theory is discussed on the basis of presentation slides. Demos are used to clarify the theory. There is ample opportunity to practice. The course works with Oracle 11g but is also suitable for other Oracle versions.

Course content

Module 1: Oracle Introduction

  • Databases
  • DBMS Systems
  • Types of Database Models
  • Entities and relationships
  • Relational databases
  • Oracle tools
  • Installing Oracle
  • Oracle versions

Module 2: SQL Introduction

  • SQL Foundations
  • SQL Developer
  • Connection Navigator
  • Creating and Using Connections
  • SQL Worksheet
  • Statements and execution
  • SQL History
  • Failure statements

Module 3: Data Definition

  • CREATE TABLE
  • DESCRIBE
  • SQL Steps
  • Specifying Columns
  • ALTER TABLE
  • NULL and Default Values
  • DROP COLUMN
  • DROP TABLE
  • PURGE
  • FLASHBACK TABLE
  • Virtual columns

Module 4: Data Manipulation

  • Data Manipulation Language
  • Transaction control
  • Inserting rows
  • INSERT statement
  • Updating rows
  • UPDATE statement
  • DELETE statement
  • TRUNCATE TABLE
  • DML on virtual columns

Module 5: SQL Queries

  • Selecting rows
  • SELECT statement
  • FROM clause
  • Specifying conditions
  • WHERE clause
  • Sorting with ORDER BY
  • NULLs, FIRST, LAST
  • Removing Doubles

Module 6: Grouping

  • Grouping Functions
  • GROUP BY clause
  • Nesting
  • Filtering groups
  • HAVING clause
  • Operators
  • String and Date Operators
  • Concatenate operator
  • Quote operator q
  • Operators for patterns
  • Operators for intervals
  • BETWEEN, IN, ANY, ALL

Module 7: Functions

  • Function of column values
  • Using functions
  • SELECT clause functions
  • WHERE clause functions
  • GROUP BY clause functions
  • HAVING clause functions
  • ORDER BY clause functions
  • String and Arithmetic functions
  • Nesting functions
  • Date and Conversion functions
  • National Language Support
  • NLS parameters
  • Cast

Module 8: Joins

  • Joining Multiple Tables
  • Normal Joins
  • Outer Join
  • More tables
  • ANSI joins
  • Inner join
  • Natural join
  • ANSI outer join
  • Cross join
  • Multiple join conditions
  • Subselections
  • EXISTS

Module 9: SET Operators

  • SET Operators
  • UNION
  • UNION ALL
  • INTERSECT
  • MINUS
  • Nesting or SET operators

Module 10: SQL * Plus

  • SQL * Plus
  • Working with SQL * Plus
  • Connect statement and / nolog
  • SQL buffer
  • Failure statements
  • Spool files
  • Command files
  • Transaction control
  • Learning goals
  • Using the SQL query language in an Oracle database
  • Grouping data by means of Group and Having clauses
  • Combining data from different tables using joins
  • Applying SET operators
  • Handling the command line interface of SQL * Plus

    Voer de volgende code in: captcha