Course Outline

Limiting results

  • The WHERE clause
  • Comparison operators
  • LIKE Condition
  • Prerequisite BETWEEN ... AND
  • IS NULL condition
  • Condition IN
  • Boolean operators AND, OR and NOT
  • Many of the conditions in the WHERE clause
  • The order of the operators.
  • DISTINCT clause

SQL functions

  • The differences between the functions of one and multilines
  • Features text, numeric, date,
  • Explicit and implicit conversion
  • Conversion functions
  • Nesting functions
  • Viewing the performance of the functions - dual table
  • Getting the current date function SYSDATE
  • Handling of NULL values

Aggregating data using the grouping function

  • Grouping functions
  • How grouping functions treat NULL values
  • Create groups of data - the GROUP BY clause
  • Grouping multiple columns
  • Limiting the function result grouping - the HAVING clause

Subqueries

  • Place subqueries in the SELECT command
  • Subqueries single and multi-lineage
  • Operators Subqueries single-line
  • Features grouping in subquery
  • Operators Subqueries multi-IN, ALL, ANY
  • How NULL values ​​are treated in subqueries

Operators collective

  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator

Further Usage Of Joins

  • Revisit Joins
  • Combining Inner and Outer Joins
  • Partitioned Outer Joins
  • Hierarchical Queries

Further Usage Of Sub-Queries

  • Revisit sub-queries
  • Use of sub-queries as virtual tables/inline views and columns
  • Use of the WITH construction
  • Combining sub-queries and joins

Analytics functions

  • OVER clause
  • Partition Clause
  • Windowing Clause
  • Rank, Lead, Lag, First, Last functions

Retrieving data from multiple tables (if time at end)

  • Types of connectors
  • The use NATURAL JOIN
  • Aliases tables
  • Joins in the WHERE clause
  • INNER JOIN
  • External Merge LEFT, RIGHT, FULL OUTER JOIN
  • Cartesian product

Aggregate Functions (if time at end)

  • Revisit Group By function and Having clause
  • Group and Rollup
  • Group and Cube

Requirements

Recommended attendance on the "Oracle SQL for Beginners" training course

  14 Hours
 

Testimonials

Related Courses

From Data to Decision with Big Data and Predictive Analytics

 21 hours

Audience If you try to make sense out of the data you have access to or want to analyse unstructured data available on the net (like Twitter, Linked in, etc...) this course is for you. It is mostly aimed at decision makers and people who need to

Data Mining and Analysis

 28 hours

Objective: Delegates be able to analyse big data sets, extract patterns, choose the right variable impacting the results so that a new model is forecasted with predictive

Data Mining

 21 hours

Course can be provided with any tools, including free open-source data mining software and applications

Data Mining with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

MonetDB

 28 hours

MonetDB is an open-source database that pioneered the column-store technology approach. In this instructor-led, live training, participants will learn how to use MonetDB and how to get the most value out of it. By the end of this training,

Introductory R for Biologists

 28 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has also found followers among

Statistics with SPSS Predictive Analytics Software

 14 hours

Goal: Learning to work with SPSS at the level of independence The addressees: Analysts, researchers, scientists, students and all those who want to acquire the ability to use SPSS package and learn popular data mining

Data Vault: Building a Scalable Data Warehouse

 28 hours

Data Vault Modeling is a database modeling technique that provides long-term historical storage of data that originates from multiple sources. A data vault stores a single version of the facts, or "all the data, all the time". Its

Data Visualization

 28 hours

This course is intended for engineers and decision makers working in data mining and knoweldge discovery. You will learn how to create effective plots and ways to present and represent your data in a way that will appeal to the decision makers

Foundation R

 7 hours

The objective of the course is to enable participants to gain a mastery of the fundamentals of R and how to work with data.

Data Mining & Machine Learning with R

 14 hours

R is an open-source free programming language for statistical computing, data analysis, and graphics. R is used by a growing number of managers and data analysts inside corporations and academia. R has a wide variety of packages for data

Data Science for Big Data Analytics

 35 hours

Big data is data sets that are so voluminous and complex that traditional data processing application software are inadequate to deal with them. Big data challenges include capturing data, data storage, data analysis, search, sharing, transfer,

Knowledge Discovery in Databases (KDD)

 21 hours

Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing. In

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

Process Mining

 21 hours

Process mining, or Automated Business Process Discovery (ABPD), is a technique that applies algorithms to event logs for the purpose of analyzing business processes. Process mining goes beyond data storage and data analysis; it bridges data with