Oracle Database: SQL Fundamentals part 1 (English)
Startdata en plaatsen
placeNieuwegein 1 apr. 2024 tot 5 apr. 2024check_circle Startgarantie Toon roosterevent 1 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 2 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 3 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 4 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 5 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 2 apr. 2024 tot 8 apr. 2024check_circle Startgarantie Toon roosterevent 2 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 3 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 4 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 5 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 8 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 3 apr. 2024 tot 9 apr. 2024check_circle Startgarantie Toon roosterevent 3 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 4 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 5 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 8 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 9 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 4 apr. 2024 tot 10 apr. 2024check_circle Startgarantie Toon roosterevent 4 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 5 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 8 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 9 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 10 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 5 apr. 2024 tot 11 apr. 2024check_circle Startgarantie Toon roosterevent 5 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 8 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 9 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 10 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 11 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 8 apr. 2024 tot 12 apr. 2024check_circle Startgarantie Toon roosterevent 8 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 9 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 10 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 11 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 12 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 9 apr. 2024 tot 15 apr. 2024check_circle Startgarantie Toon roosterevent 9 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 10 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 11 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 12 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 15 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 10 apr. 2024 tot 16 apr. 2024check_circle Startgarantie Toon roosterevent 10 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 11 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 12 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 15 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 16 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 11 apr. 2024 tot 17 apr. 2024check_circle Startgarantie Toon roosterevent 11 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 12 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 15 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 16 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 17 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 12 apr. 2024 tot 18 apr. 2024check_circle Startgarantie Toon roosterevent 12 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 15 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 16 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 17 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 18 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 15 apr. 2024 tot 19 apr. 2024check_circle Startgarantie Toon roosterevent 15 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 16 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 17 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 18 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 19 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 16 apr. 2024 tot 22 apr. 2024check_circle Startgarantie Toon roosterevent 16 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 17 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 18 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 19 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 22 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 17 apr. 2024 tot 23 apr. 2024check_circle Startgarantie Toon roosterevent 17 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 18 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 19 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 22 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 23 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 18 apr. 2024 tot 24 apr. 2024check_circle Startgarantie Toon roosterevent 18 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 19 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 22 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 23 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 24 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 19 apr. 2024 tot 25 apr. 2024check_circle Startgarantie Toon roosterevent 19 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 22 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 23 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 24 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 25 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 22 apr. 2024 tot 26 apr. 2024check_circle Startgarantie Toon roosterevent 22 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 23 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 24 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 25 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 26 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 23 apr. 2024 tot 29 apr. 2024check_circle Startgarantie Toon roosterevent 23 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 24 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 25 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 26 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 29 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 24 apr. 2024 tot 30 apr. 2024check_circle Startgarantie Toon roosterevent 24 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 25 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 26 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 29 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 30 april 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 25 apr. 2024 tot 1 mei. 2024check_circle Startgarantie Toon roosterevent 25 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 26 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 29 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 30 april 2024, 08:45-16:00, Nieuwegein, Day 4 event 1 mei 2024, 08:45-16:00, Nieuwegein, Day 5 |
placeNieuwegein 26 apr. 2024 tot 2 mei. 2024check_circle Startgarantie Toon roosterevent 26 april 2024, 08:45-16:00, Nieuwegein, Day 1 event 29 april 2024, 08:45-16:00, Nieuwegein, Day 2 event 30 april 2024, 08:45-16:00, Nieuwegein, Day 3 event 1 mei 2024, 08:45-16:00, Nieuwegein, Day 4 event 2 mei 2024, 08:45-16:00, Nieuwegein, Day 5 |
Beschrijving
Vijfhart, dat klopt voor jou!
- Oefenomgeving tot 3 maanden na afronding beschikbaar
- Flexgarantie: wissel eenvoudig van virtueel naar fysiek, of andersom
- Kennisgarantie: volg jouw cursus gratis nog een keer, fysiek of virtueel
- Ontvang een gratis proefexamen bij meerdere opleidingen
Lesmethode :
Persoonlijk begeleid
Algemeen :
This course is guaranteed to start and therefore will always take place.
During this five-day course you will first have an introduction to Oracle and various Oracle tools. After that there will be a more detailed look into SQL and Oracle SQL. There will be an emphasis on structured writing of SQL statements. This course is suitable for everyone that works with 11g and higher versions of the database. Version dependent features are indicated specifically.
SQL is a computer language designed to manage data within a relational database. To interact with the Oracle database, we will use Oracle's SQL tool: SQL Developer.
Doel :
The aim of this cours…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Vijfhart, dat klopt voor jou!
- Oefenomgeving tot 3 maanden na afronding beschikbaar
- Flexgarantie: wissel eenvoudig van virtueel naar fysiek, of andersom
- Kennisgarantie: volg jouw cursus gratis nog een keer, fysiek of virtueel
- Ontvang een gratis proefexamen bij meerdere opleidingen
Lesmethode :
Persoonlijk begeleid
Algemeen :
This course is guaranteed to start and therefore will always
take place.
During this five-day course you will first have an introduction to
Oracle and various Oracle tools. After that there will be a more
detailed look into SQL and Oracle SQL. There will be an emphasis on
structured writing of SQL statements. This course is suitable for
everyone that works with 11g and higher versions of the database.
Version dependent features are indicated specifically.
SQL is a computer language designed to manage data within a
relational database. To interact with the Oracle database, we will
use Oracle's SQL tool: SQL Developer.
Doel :
The aim of this course is to be able to translate common and actual work situations into SQL statements and run these statements in SQL Developer.
Doelgroep :
This course is intended for starting Database Administrators, starting Application Developers and other starting computer professionals who are going to work with (Oracle) SQL.
Voorkennis :
There are no specific mandatory prerequisites for this course. However, some prior knowledge of other computer languages is considered to be helpful.
Onderwerpen :
- Module 1 - Introduction to Oracle
- Preface- Introduction to Oracle
- Database
- Relational database
- Oracle tools
- The Oracle Cloud
- Accessing the Oracle database
- Module 2 - Introduction to SQL
- Preface - Introduction to SQL
- Foundations of SQL
- Local Database
- SQL Developer
- Connection Navigator
- SQL Worksheet
- Toolbar
- Menus
- Change the screen layout
- Saving statements
- Module 3 - Data definition
- Data definition - preface
- Reading a syntax diagram
- CREATE TABLE
- Column specification
- ALTER TABLE
- NULL values
- Identity columns
- Default values
- DROP COLUMN
- Invisible columns
- DROP TABLE
- PURGE - empty the recycle bin
- FLASHBACK TABLE
- Virtual columns
- Module 4 - Data manipulation
- Data manipulation - preface
- Transaction control
- INSERT - add rows
- UPDATE - change data
- DELETE - remove rows
- TRUNCATE TABLE
- DML on an identity column
- DML on virtual columns
- Transaction control settings
- Module 5 - Retrieving information
- Retrieving information - preface
- Selection of rows
- SELECT clause - projection
- FROM clause - specify tables
- WHERE clause - specify conditions
- ORDER BY clause - sort the result
- Eliminate duplicate rows
- Module 6 - Grouping
- Grouping - preface
- Aggregate functions
- GROUP BY clause - grouping rows
- Nesting group functions
- HAVING clause - filter groups
- Module 7 - Operators
- Operators - preface
- Arithmetic operators
- Operators for date fields
- Operators for strings
- Comparison operators
- Operators for string patterns
- Operators for ranges
- Module 8 - Functions
- Functions - preface
- The use of functions
- String functions
- Numeric functions
- Nested functions
- Date functions
- Conversion functions
- National Language Support
- Miscellaneous functions
- Cast
- Module 9 - Constraints
- Constraints - preface
- Definition of constraints
- NOT NULL constraints
- Unique key constraints
- Primary key constraints
- Foreign key constraints
- Check constraints
- Module 10 - Multiple tables - joins
- Joins - preface
- Ordinary joins
- Outer joins
- Module 11 - Multiple tables - ANSI joins
- ANSI joins - preface
- ANSI jointypes
- Module 12 - Multiple tables - subqueries
- Subqueries - preface
- Subquery types
- Subqueries versus joins
- EXISTS
- Subqueries in a SELECT clause
- Inline views
- Module 13 - SET Operators
- SET Operators - preface
- SET operator types
- Nesting SET operators
- Module 14 - Extra data definition
- Extra data definition - preface
- Users and schemas
- Object names
- The Data dictionary
- CREATE / ALTER / DROP VIEW - virtual tables
- CREATE SYNONYM
- RENAME
- COMMENT- add information to an object
- Sequences
- Indexes
- Module 15 - SQL Scripts
- SQL Scripts - Preface
- Comments
- Substitution variables
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.