Kurs: Oracle Database: SQL Workshop I - NEW


Klasserom3 dagerHeltidKursEngelsk

Dette kurset har ikke oppført noen dato for studiestart. Bruk skjemaet under for å kontakte leverandør for nærmere informasjon.




This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.

Learn To:

  • Understand SQL statements, as well as the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL statements.
  • Manipulate data in relational tables and save the data.
  • Understand the concepts of relational databases and the powerful SQL programming language.
  • Write reports using SQL Statements.

Innhold:

Course Objectives
  • Define the goals of the course
  • List the features of Oracle Database 12c
  • Describe the salient features of Oracle Cloud 12c
  • Discuss the theoretical and physical aspects of a relational database
  • Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS)
  • Identify the development environments that can be used for this course
  • Describe the database and schema used in this course

Course Topics


Introduction
  • Course Objectives, Course Agenda and Appendixes Used in this Course
  • Overview of Oracle Database 12c and Related Products
  • Overview of relational database management concepts and terminologies
  • Introduction to SQL and its development environments
  • What is Oracle SQL Developer?
  • Starting SQL*Plus from Oracle SQL Developer
  • The Human Resource(HR) Schema
  • Tables used in the Course
Retrieving Data using the SQL SELECT Statement
  • Capabilities of the SELECT statement
  • Arithmetic expressions and NULL values in the SELECT statement
  • Column aliases
  • Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
  • Use of the DESCRIBE command
Restricting and Sorting Data
  • Limiting the Rows
  • Rules of precedence for operators in an expression
  • Substitution Variables
  • Using the DEFINE and VERIFY command
Using Single-Row Functions to Customize Output
  • Describe the differences between single row and multiple row functions
  • Manipulate strings with character function in the SELECT and WHERE clauses
  • Manipulate numbers with the ROUND, TRUNC and MOD functions
  • Perform arithmetic with date data
  • Manipulate dates with the date functions
Using Conversion Functions and Conditional Expressions
  • Describe implicit and explicit data type conversion
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Nest multiple functions
  • Apply the NVL, NULLIF, and COALESCE functions to data
  • Use conditional IF THEN ELSE logic in a SELECT statement
Reporting Aggregated Data Using the Group Functions
  • Group Functions
  • Creating Groups of Data
  • Restricting Group Results
Displaying Data From Multiple Tables Using Joins
  • Introduction to JOINS
  • Types of Joins
  • Natural join
  • Self-join
  • Non equijoins
  • OUTER join
Using Subqueries to Solve Queries
  • Introduction to Subqueries
  • Single Row Subqueries
  • Multiple Row Subqueries
Using the SET Operators
  • Set Operators
  • UNION and UNION ALL operator
  • INTERSECT operator
  • MINUS operator
  • Matching the SELECT statements
  • Using ORDER BY clause in set operations
Managing Tables using DML statements
  • Data Manipulation Language
  • Database Transactions
Introduction to Data Definition Language
  • Data Definition Language

Read full course description: Oracle Database: SQL Workshop I
 
Course material
We use official Oracle material in our Oracle trainings. This include eKit (electronic documentation) and Lab environment from Oracle University. 


Stedsbeskrivelse


Our Oracle courses will take place at Glasspaper`s course center at Crayon in Nydalen:
Adress: Crayon, Sandakerveien 114A, 0402 Oslo. 9-16



Forkunnskaper


Required Prerequisites

  • Familiarity with data processing concepts and techniques
  • Familiarity with programming languages


 

Påmelding
Oracle Database: SQL Workshop I - NEW hos Glasspaper
Start her
100% sikkert skjema
Tar ett minutt å fullføre
Hurtig respons

KAMPANJE!!!
Felt som er merket med * må fylles ut
Ønsket valuta *
Dato og sted *
Kursdeltakere
Hvor mange? (Gavekort)
Kampanjekoden er korrekt og rabatt er lagt til.
Fant ingen kampanje. Skrev du kampanjekoden riktig?
Kampanjekode er korrekt, men kampanjen gir ikke bedre pris enn nåværende kampanje.
Deltaker {{$index+1}}
Filen ble lastet opp
Filen ble fjernet
Laster opp... {{item.upload_progress}}%
{{ file.file.name }} Fjern
{{total_price | fprice}} kr {{currency}}
{{total_price-total_with_discount | fprice}} kr {{currency}}
{{total_with_discount | fprice}} kr {{currency}}
{{total_vat | fprice}} kr {{currency}}
X

MVA per produkt:

{{arr[1]}}
Betalingsmåte *
Number: 1+2 *
Vennligst rett opp følgende og forsøk igjen
{{errors_msg}}
Sender...
Vent til opplasting av fil er ferdig

Dette skjemaet er 100% sikkert.
Glasspaper vil snart kontakte deg og bekrefte!



 

Åpen deltakerdiskusjon om kurset eller emnet

Del gjerne din erfaring eller tanker om dette kurset eller temaet med andre!



Anbefalinger fra andre brukere