Course Outline

Create complex queries to databases

  • Use available operators
  • Queries with multiple conditions

Creating tables and references

  • DDL commands (create, alter, and drop)
  • Create referential integrity
  • Normalization of tables (up to 3 normal form)
  • anomalies and ways to avoid them

Changes in the structure of existing tables

  • ALTER clause

Manipulation of data

  • DML commands (insert, update, delete)

Creating new users and granting permissions

  • DCL commands (grant, revoke)

Linking Tables

  • Internal and external joins

Data Aggregation

  • Features of grouping functions
  • Use the GROUP BY clause and HAVING
  • Grouping multiple column

Subqueries

  • multi-column
  • correlated
  • WITH clause

Requirements

Basic knowledge in Oracle SQL
  14 Hours
 

Need help picking the right course?
Call us +971 4871 6715

Testimonials

Complete knowledge of the lecturer.

Bogusław Stanek

A lot of exercises with different levels of difficulty and individual approach of the trainer to each participant

Agnieszka Cybula

A large number of exercises

Wojciech Kozioł

Quality of training, and explanation of approach methods to issues

Blazej Baron

Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.

UBS Business Solutions Poland Sp. z o.o.

I enjoyed the access to trainers individual support in resolving exercises.

Tomasz Czornak

Nice atmosphere, a large number of examples very well explained. Training materials for every part. The coach is very helpful in repairing mistakes during the exercises. I recommend everyone who wants to get and broaden their knowledge in SQL ...

Sebastian Straczyński - Stowarzyszenie Niżańskie Centrum Rozwoju

Related Courses

SQL in Microsoft Access

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data using Microsoft Access. Course members will learn: how to write SQL queries what relational databases are and how we can use them what
Read More...

Microsoft Access - download the data

  14 hours
The course is designed for persons with pre-information databases using SQL queries or queries.
Read More...

Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server

  14 hours
The aim of this course is to provide a clear understanding of the advanced use of (SQL) for Microsoft SQL Server and the advanced use of Transact-SQL. For more in depth coverage of the topics this course can be run as a three day
Read More...

SQL in SQL Server

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

Transact SQL Basic

  14 hours
Delegates will gain an understanding of the basic principles of Structured Query Language as well as being able to do each of the following: Construct queries to extract and filter data from an SQL Server database Create summarised
Read More...

Transact SQL Advanced

  7 hours
Delegates will gain an understanding of some of the more advanced features of Transact SQL as well as being able to do each of the following: Use queries to return complex result sets Manage database objects to aid query performance Tune
Read More...

SQL Fundamentals

  14 hours
This SQL training course is for people who want to gain the necessary skills to extract and analyse data from any database and create reports. Course members will learn: how to write SQL queries what relational databases are and how we can
Read More...

SQL Advanced in MySQL

  7 hours
This course has been created for people already acquainted with SQL. The course introduces you into secrets common to all SQL databases as well as MySQL specific syntax, functions and
Read More...

SQL in MySQL

  14 hours
How to build a query? What is a relational database? What is the structure and SQL commands?
Read More...

ORACLE PL/SQL Fundamentals

  21 hours
This 3 day course gives an introduction to ORACLE PL/SQL, an application development environment that enables the writing of stored procedures, functions and triggers using both SQL and PL/SQL commands. The course takes the format of a workshop,
Read More...

ORACLE SQL Fundamentals

  14 hours
This 2 day course gives an introduction to SQL Developer, SQL*Plus and to SQL, the Structured Query Language used to access a Relational Database and includes the new features of the latest version of ORACLE. The principles learnt may also be
Read More...

Oracle SQL Language

  14 hours
The course answers questions How to build a query? What possibilities have SQL? What is a relational database? What is the structure and SQL commands
Read More...

Oracle SQL for beginners

  21 hours
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
Read More...

Oracle SQL Advanced

  14 hours
Listeners This course is designed for people who want to use the advanced features of SQL in Oracle The course answers the questions How to build advanced queries? How to create advanced
Read More...

Developing Applications with Oracle Application Express (APEX)

  21 hours
Oracle APEX or Oracle Application Express is an application development service in Oracle Database. It provides a fully-integrated, secure, and low-code platform for building and deploying applications. This instructor-led, live training (online
Read More...