Oracle Database 10g: SQL fundamentals Part I Training
| Aanbieder | Vijfhart |
| Kosten | €2.520,00 |
| Data en locatie(s) |
Iedere werkdag naar keuze (Persoonlijk begeleid) - Nieuwegein In overleg (Persoonlijk begeleid) - Turnhout In overleg (Persoonlijk begeleid) - Zwolle |
Overzicht
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. Volledige omschrijving
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. Volledige omschrijving
Bestemd voor
This course is intended for database administrators, application developers and other computer professionals working with (Oracle) SQL.Programma
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 ... Volledig programmaDoel
The aim of this course is to be able to translate real world situations into SQL statements and run these statements in SQL Developer. InschrijvenBeschrijving
De cursus Oracle Database 10g: SQL fundamentals Part I (4 days) (English) behandelt de volgende onderwerpen:
- 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
Programma
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
Deze gegegevens zijn voor het laatst bijgewerkt op 24 mei 2012.