Course : Oracle SQL

Oracle SQL

Download in PDF format Share this course by email 2

Average of customer reviews Average of customer reviews Average of customer reviews Average of customer reviews
4,5 / 5
Download in PDF format Share this course by email 2

A hands-on course in the essential aspects, logic and syntax, of the SQL language. This course will provide you with a reliable method for writing complex SQL queries.


Inter
In-house
Custom

Practical course in person or remote class

Ref. OSL
Price : 1970 € E.T.
  3d - 21h00
Contact us




A hands-on course in the essential aspects, logic and syntax, of the SQL language. This course will provide you with a reliable method for writing complex SQL queries.

Teaching objectives
At the end of the training, the participant will be able to:
  • Understand the relational model
  • Identify the objects of an Oracle database.
  • Query and classify data in a table
  • Work with data in database tables.
  • Know how to return data

Intended audience
IT specialists who want to use SQL in an Oracle environment.

Prerequisites
Basic computing knowledge.

Course schedule

Introduction

  • The relational model
  • Basic concepts: relationship (table), attributes (columns), integrity constraints.
  • Integrity constraints.

Tools

  • Overview of SQL*Plus.
  • Overview of SQL Developer.

Introduction to SQL.

  • Oracle data types.
  • - Creating tables.
  • Introduction to update instructions.
  • Using sequences.
  • Introduction to querying (SELECT).

Data querying

  • Sorting and deleting duplicates. Aliases and prefixes. Using Fetch and Offset.
  • Handling the NULL value. Using SQL functions.
  • Using pseudo-columns: ROWID and ROWNUM. Using aggregates: COUNT, SUM, AVG, etc.
  • Set operations: union, intersection, difference.
  • Nested queries: IN, EXISTS operators.
  • Use of joins.
  • External joins.
  • Grouping: GROUP BY and HAVING.

Objects of an Oracle database

  • Creating and deleting tables.
  • Integrity constraint management: primary key, uniqueness, non-nullity, CHECK, referential constraints.
  • Use of views.
  • Use of synonyms.
  • Data dictionary.

Complex SQL statements

  • Configuring SQL*Plus scripts.
  • Division and complex queries.
  • Update statements with nested queries.
  • Hierarchical queries.
  • Using regular expressions.


Customer reviews
4,5 / 5
Customer reviews are based on end-of-course evaluations. The score is calculated from all evaluations within the past year. Only reviews with a textual comment are displayed.


Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class