Platform for starters in the geo sector

200 courses, 20 online supports, 60 moocs,

10 work to work trajectories,

30 trainees

Course: Oracle SQL Fundamentals

Description

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.

Content of Course: Oracle SQL Fundamentals

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.

De volgende modules komen aan bod tijdens deze cursus:

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

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

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

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

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

  • 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

  • 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

  • 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

  • SET Operatoren
  • UNION
  • UNION ALL
  • INTERSECT
  • MINUS
  • Nesting of SET operators

  • SQL*Plus
  • Working with SQL*Plus
  • Connect statement and /nolog
  • SQL buffer
  • Storing statements
  • Spool files
  • Command files
  • Transaction control

Learning objectives during this course:

  • Registration

    Group discount

    If you register several students for this course, a discount of 25% on the 2nd student, 50% on the 3rd student and 75% on the 4th, 5th, 6th, 7th and 8th student.