Oracle Database 12c: SQL I – Introduction

Duration

3 days

Overview

Learning the SQL language is one of the most basic tasks required for the use of a relational database. SQL proficiency is essential for business users, database developers, database administrators and any other database professional. This textbook introduces the basics of the SQL language and the Oracle Relational Database Management System (RDBMS). One will become acquainted with the differences in the working environment between a traditional on-premise database installation and the Oracle database service cloud-computing platform.

Since SQL is an industry standard language, many of the topics presented and many of the skills you will acquire will be applicable to other database platforms, such as Microsoft SQL Server, IBM DB2, the open-source databases MySQL and PostgreSQL, and others.

This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.

Course Objectives

The first portion of this course considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data.

Prerequisites

No prerequisites needed, although some affinity with the Oracle Database and Oracle SQL is recommended.

Course Content

  • Relational Databases & Data Models

  • Selection & Setup Of The Database Interface

  • Using The Database Interface

  • Introduction To The SQL Language

  • The SELECT statement

  • Restricting results with the WHERE clause

  • Sorting data with the ORDER BY clause

  • Pseudo columns, Functions & TOP N Queries

  • JOINING Tables

  • Using the SET operators

  • Summary Functions

  • Using SUB-Queries

  • Aggregating data within groups

  • Use DDL to create and manage tables

  • Use DML to manipulate Data

Certification

The Exam Oracle SQL Expert exam 1Z0–047 is retired on July 31, 2017. The suggested alternative is 1Z0-071  to earn the Oracle Database SQL Certified Associate Certification.

Get in touch with the Test Center in Kontich or Hasselt.

What’s next?

This training prepares you for the Oracle Database 12c: SQL II - Intermediate course.

Note that this course is a recommended prerequisite for Oracle Database 12c: PL/SQL I - Introduction.

 
 

Next training dates

  • 15 to 17 January 2019

  • 13 to 15 March 2019

  • 13 to 15 May 2019

  • 3 to 5 July 2019

Training cost

2.250 EUR (VAT excluded) per person

Practical details

3 days
Classroom
From 9 AM to 5 PM

Language

English

Location

De Villermontstraat 9
2550 Kontich
Belgium

This training in-company?

Upon your request we can organize this training for you.