Oracle Database 10g: SQL fundamentals Part I (4 days) (English)

SQL is a computer language designed for managing data within a relational database.
This course introduces students to the fundamentals of SQL. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

In this course, students use Oracle SQL Developer as the main tool and SQL*Plus is introduced as an optional tool.

• Introduction to Oracle
• Introduction to SQL
• Basic Data Definition
• Data Manipulation
• Retrieving Information
• Grouping
• Operators
• Functions of Column Values
• Multiple Tables - Joins
• Multiple Tables - Subqueries
• SET Operators
• SQL*Plus

Klik hier voor een gedetailleerde onderwerpenlijst

• De cursus OCA Fasttrack SQL.
• De cursus Oracle Database 10g: Databasegebruik voor ontwikkelaars.
• De cursus Oracle Database 10g: SQL fundamenten deel I (4 dagen).
• De cursus Oracle Database 10g: SQL fundamenten deel I (5 dagen).
• De cursus Oracle Database 10g: SQL fundamenten deel II.
• De cursus Oracle Database 10g: SQL fundamenten deel III.
• De cursus Oracle SQL opfriscursus.
• De cursus Oracle8i-11g SQL nieuwe features.
• De cursus SQL statement tuning 10g.
• De cursus SQL voor applicatiegebruikers.
• Het traject SQL10GPLUS.
• De cursus Toad voor Oracle SQL.
• De cursus Workshop SQL fundamenten deel I en II.

Gedetailleerde onderwerpenlijst

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Database 10g: SQL fundamentals Part I (4 days) (English) behandeld zullen worden:

• Introduction to Oracle
• Preface
• Database
• Relational database
• Oracle tools
• Using Oracle
• Introduction to SQL
• Introduction
• Foundations of SQL
• SQL Developer
• Connection Navigator
• Using an existing connection
• Creating a New Connection
• Delete a Connection
• SQL Worksheet
• SQL Worksheet toolbar
• SQL Worksheet Tabs
• Entering and Executing Statements
• Messages
• SQL History
• Toolbar
• Menus
• Changing the screen layout
• Saving statements
• Basic Data Definition
• Introduction
• CREATE TABLE
• DESCRIBE
• SQL Guideline
• Column specifications
• ALTER TABLE - modifying the table
• NULL values
• Default values
• DROP COLUMN
• DROP TABLE
• PURGE - empty the recyclebin
• FLASHBACK TABLE
• Virtual columns (Oracle 11g)
• Data Manipulation
• Introduction
• Transaction control
• INSERT - adding rows
• Multitable insert
• UPDATE - change data
• DELETE - remove rows
• GUIDELINE for the DELETE statement
• DML on virtual columns (Oracle 11g)
• Retrieving Information
• Introduction
• Selection of rows
• SELECT clause - choosing columns (projection)
• FROM clause - choosing the tables
• Flashback query clause
• WHERE clause - entering conditions
• ORDER BY clause - ordering the result
• Eliminate redundant rows
• Sample option
• Grouping
• Introduction
• Aggregate functions
• GROUP BY clause - grouping rows
• HAVING clause - filtering groups
• Operators
• Introduction
• Mathematical operators
• Operators for date fields
• Operators for strings
• Common operators
• Operators for word patterns
• Operators for ranges
• BETWEEN
• IN
• ANY
• ALL
• Functions of Column Values
• Introduction
• The use of functions
• Functions in the SELECT clause
• Functions in the WHERE clause
• Functions in the GROUP BY clause
• Functions in the HAVING clause
• Functions in the ORDER BY clause
• String functions
• Mathematical functions
• Nesting
• Date functions
• Conversion functions
• Format masks
• National Language Support
• NLS parameters
• Miscellaneous functions
• Cast .
• Multiple Tables - Joins
• Introduction
• Ordinary joins
• The outer join
• Multiple Tables - ANSI Joins
• Introduction
• ANSI join types
• Inner join
• Natural join
• The ANSI outer join
• Cross join
• Multiple join conditions
• Multiple Tables - Subqueries
• Introduction
• Subquery categories
• Single-row subquery
• Multiple-row subqueries
• Correlated subqueries
• Subqueries versus joins
• EXISTS
• SET Operators
• Introduction
• Hierarchical queries
• Combining multiple SELECT statements - set operators
• UNION
• UNION ALL
• INTERSECT
• MINUS
• SQL*Plus
• Introduction
• Working with SQL*Plus
• The SQL buffer
• The line editor
• Saving statements
• Spool files
• Editor of choice
• Command files
• Other commands

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.