Oracle SQL for beginners Training Course

Primary tabs

Duration Duration

21 hours (usually 3 days including breaks)

Requirements Requirements

  • Computer literacy
  • Knowledge of any operating system

Overview Overview

Listeners

This training is addressed for people starting to work with the SQL language in Oracle database

The course answer for questions:

  • How to build a query?
  • What possibilities have SQL?
  • What is a relational database?
  • What is the structure and SQL commands

Course Outline Course Outline

Relational database models

  • The structure of a relational database
  • Connection types of tables
  • The normalization and denormalization database
  • Relational Operators

Download the data

  • Rules for writing SQL queries
  • The syntax for the SELECT
  • Selecting all columns
  • Inquiries from arithmetic operations
  • Aliases columns
  • Literals
  • Concatenation operator

Limiting results

  • The WHERE clause
  • Comparison operators
  • LIKE Condition
  • Prerequisite BETWEEN ... AND
  • IS NULL condition
  • Condition IN
  • Boolean operators AND, OR and NOT
  • Many of the conditions in the WHERE clause
  • The order of the operators.
  • DISTINCT clause

Sorting Data

  • The ORDER BY clause
  • Sorting by multiple columns or expressions

SQL functions

  • The differences between the functions of one and multilines
  • Features text, numeric, date,
  • Explicit and implicit conversion
  • Conversion functions
  • Nesting functions
  • Viewing the performance of the functions - dual table
  • Getting the current date function SYSDATE
  • Handling of NULL values

Aggregating data using the grouping

  • Grouping functions
  • How grouping functions treat NULL values
  • Create groups of data - the GROUP BY clause
  • Grouping multiple columns
  • Limiting the function result grouping - the HAVING clause

Retrieving data from multiple tables

  • Types of connectors
  • The use NATURAL JOIN
  • Aliases tables
  • Joins in the WHERE clause
  • INNER JOIN Inner join
  • External Merge LEFT, RIGHT, FULL OUTER JOIN
  • Cartesian product

Subqueries

  • Place subqueries in the SELECT command
  • Subqueries single and multi-lineage
  • Operators Subqueries single-line
  • Features grouping in subquery
  • Operators Subqueries multi-IN, ALL, ANY
  • How NULL values ​​are treated in subqueries

Operators collective

  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator

Insert, update, and delete data

  • INSERT command
  • Copy data from another table
  • UPDATE command
  • DELETE command
  • TRUNCATE command

Transactions

  • Commands COMMIT, ROLLBACK, and SAVEPOINT

DDL commands

  • The main database objects
  • Rules for naming objects
  • Creating tables
  • The data types available for columns
  • DEFAULT option
  • Option NULL and NOT NULL

Managing tables

  • Referential integrity CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
  • Create a table by the query
  • Delete a table DROP TABLE
  • DESCRIBE command

Other schema objects

  • Sequences
  • Synonyms
  • Views

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
From 2148PLN
(19)
Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet. More Information

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Remote
1 2148PLN 4800PLN
2 1974PLN 3300PLN
3 1916PLN 2800PLN
4 1887PLN 2550PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories

Related Courses


Upcoming Courses

VenueCourse DateCourse Price [Remote / Classroom]
Łódź, ul. Tatrzańska 11Tue, 2017-10-10 09:004800PLN / 2448PLN
Warszawa, ul. Złota 3/11Tue, 2017-10-10 09:004800PLN / 2148PLN
Wrocław, ul.Ludwika Rydygiera 2a/22Mon, 2017-10-16 09:004800PLN / 2148PLN
Rzeszów, Plac Wolności 13Tue, 2017-10-24 09:004800PLN / 2148PLN
Gliwice ul. Karola Marksa 11 Tue, 2017-10-24 09:004800PLN / 2598PLN

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Visual Basic for Applications (VBA) in Excel - Advanced Warszawa, ul. Złota 3/11 Mon, 2017-09-25 09:00 3069PLN / 1623PLN
DTP (InDesign, Photoshop, Illustrator, Acrobat) Katowice ul. Opolska 22 Mon, 2017-09-25 09:00 5940PLN / 3730PLN
Programming in C++ Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-09-25 09:00 5445PLN / 2815PLN
Creating and managing Web sites Poznan, Garbary 100/63 Mon, 2017-09-25 09:00 5841PLN / 2298PLN
Java Performance Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-09-25 09:00 9801PLN / 3000PLN
SQL in Microsoft Access Kraków, ul. Rzemieślnicza 1 Tue, 2017-09-26 09:00 10266PLN / 3911PLN
OCUP2 UML 2.5 Certification - Foundation Exam Preparation Kraków, ul. Rzemieślnicza 1 Wed, 2017-09-27 09:00 6930PLN / 3510PLN
Visual Basic for Applications (VBA) for Analysts Poznan, Garbary 100/63 Wed, 2017-09-27 09:00 2970PLN / 1590PLN
Adobe InDesign Katowice ul. Opolska 22 Thu, 2017-09-28 09:00 1881PLN / 1327PLN
Design Patterns in C# Rzeszów, Plac Wolności 13 Thu, 2017-09-28 09:00 3861PLN / 2331PLN
Tworzenie aplikacji na platformie Android Łódź, ul. Tatrzańska 11 Mon, 2017-10-02 09:00 4455PLN / 3128PLN
Statistical and Econometric Modelling Warszawa, ul. Złota 3/11 Mon, 2017-10-02 09:00 20483PLN / 6807PLN
Effective interpersonal communication with elements of assertiveness Kraków, ul. Rzemieślnicza 1 Tue, 2017-10-03 09:00 5148PLN / 1830PLN
Web Development with Symfony3 Kielce, ul. Warszawska 19 Mon, 2017-10-09 09:00 5554PLN / 2483PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Szczecin, ul. Sienna 9 Mon, 2017-10-09 09:00 3564PLN / 1891PLN
Analiza biznesowa i systemowa z użyciem notacji UML - warsztat praktyczny dla PO w metodyce Scrum Łódź, ul. Tatrzańska 11 Tue, 2017-10-10 09:00 7722PLN / 3474PLN
Access Basics Szczecin, ul. Sienna 9 Tue, 2017-10-10 09:00 3465PLN / 1550PLN
MS-40361 Software Development Fundamentals MTA Exam 98-361 Gdynia, ul. Ejsmonda 2 Wed, 2017-10-11 09:00 6138PLN / 2610PLN
PostgreSQL for Administrators Gdynia, ul. Ejsmonda 2 Wed, 2017-10-11 09:00 12326PLN / 4235PLN
UML Analysis and Design Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-11 09:00 8910PLN / 4170PLN
Agile w projektach zdalnych Katowice ul. Opolska 22 Mon, 2017-10-16 09:00 5049PLN / 1962PLN
Programming in C++ Bielsko-Biała, Al. Armii Krajowej 220 Mon, 2017-10-16 09:00 5445PLN / 3565PLN
Programming in C++ Łódź, ul. Tatrzańska 11 Mon, 2017-10-16 09:00 5445PLN / 3315PLN
Programming in C# Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 4851PLN / 1870PLN
Stress management Gdynia, ul. Ejsmonda 2 Wed, 2017-10-18 09:00 5148PLN / 1530PLN
Business Analysis Kraków, ul. Rzemieślnicza 1 Wed, 2017-10-18 09:00 7722PLN / 3774PLN
Nginx Setup, Configuration and Administration Wrocław, ul.Ludwika Rydygiera 2a/22 Wed, 2017-10-18 09:00 6930PLN / 2700PLN
Projektowanie stron na urządzenia mobilne Kielce, ul. Warszawska 19 Thu, 2017-10-19 09:00 2624PLN / 1305PLN
Adobe Premiere Pro Gdynia, ul. Ejsmonda 2 Mon, 2017-10-23 09:00 3960PLN / 2480PLN
Administration of Linux System Gdynia, ul. Ejsmonda 2 Tue, 2017-10-24 09:00 4950PLN / 3225PLN
Node.js Olsztyn, ul. Kajki 3/1 Thu, 2017-10-26 09:00 3861PLN / 2431PLN
Effective working with spreadsheet in Excel Warszawa, ul. Złota 3/11 Thu, 2017-10-26 09:00 2475PLN / 1225PLN
SQL Advanced in MySQL Warszawa, ul. Złota 3/11 Thu, 2017-11-02 09:00 1881PLN / 1141PLN
Android - The Basics Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 9801PLN / 4180PLN
Java Spring Wrocław, ul.Ludwika Rydygiera 2a/22 Mon, 2017-11-06 09:00 14414PLN / 5970PLN
Nagios Core Gdańsk, ul. Powstańców Warszawskich 45 Mon, 2017-11-13 09:00 13919PLN / 4968PLN
Data Analysis with Oracle 11g - workshop Gdynia, ul. Ejsmonda 2 Mon, 2017-11-13 09:00 9900PLN / 4664PLN

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients