Course code: D80190« Back

Oracle Database: SQL Workshop I Ed 2

The Oracle Database: SQL Workshop I Ed 2 course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class 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.

 DateDurationCourse priceHandbook priceCourse languageLocation 
9/23/2019 3 36 588 CZK included in course price Anglický jazyk Virtual Class Oracle
 
10/14/2019 3 36 588 CZK included in course price Český jazyk GOPAS Praha_GTT
 
11/25/2019 3 36 588 CZK included in course price Anglický jazyk GOPAS Praha_GTT
 
1/13/2020 3 36 588 CZK included in course price Český jazyk GOPAS Praha_GTT
 
3/2/2020 3 36 588 CZK included in course price Český jazyk GOPAS Praha_GTT
 
4/20/2020 3 36 588 CZK included in course price Český jazyk GOPAS Praha_GTT
 
10/14/2019 3 36 588 CZK included in course price Český jazyk GOPAS Brno_GTT
 
11/25/2019 3 36 588 CZK included in course price Anglický jazyk GOPAS Brno_GTT
 
1/13/2020 3 36 588 CZK included in course price Český jazyk GOPAS Brno_GTT
 
3/2/2020 3 36 588 CZK included in course price Český jazyk GOPAS Brno_GTT
 
4/20/2020 3 36 588 CZK included in course price Český jazyk GOPAS Brno_GTT
 
10/14/2019 3 1 350,00 EUR included in course price Slovenský jazyk GOPAS Bratislava_GTT
 
11/25/2019 3 1 350,00 EUR included in course price Anglický jazyk GOPAS Bratislava_GTT
 
1/13/2020 3 1 350,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
3/2/2020 3 1 350,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 
4/20/2020 3 1 350,00 EUR included in course price Český jazyk GOPAS Bratislava_GTT
 

AffiliateDurationCatalogue priceHandbook priceITB*
Praha3 36 588 CZK included in course price 45
Brno3 36 588 CZK included in course price 45
Bratislava3 1 350,00 EUR included in course price 45

*Body se vztahují pouze na kurzy realizované v prostorách Gopasu.

Who is the course for

  • Identify what a SQL statement is.
  • Understand the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL Statements.
  • Manipulate data in relational tables and save the data.

Students use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the fundamental concepts.

Teaching materials

Oracle guide book for this course.

Course outline

  • Introduction
  • Retrieving Data using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables Using Joins
  • Using Subqueries to Solve Queries
  • Using the SET Operators
  • Managing Tables using DML statements
  • Introduction to Data Definition Language

Previous courses

no preceding courses

Next courses

no following course
Oracle University eKit

Price:
included in course price
The prices are without VAT.


Graph of course relations