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
Testimonials
knowledge and translations
Jan Maksymowski
Substantive preparation, attention to detail
Sebastian Łubik
Very high competence of the trainer!!.
Heino Eilers
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
It is difficult to assess the very consistent training. Everything was liked
Damian Ostrega
A large number of exercises
Wojciech Kozioł
individual and patient approach to each question / problem and understandable explanation / translation / solution
Grzegorz Krzeczek
Possibility to ask questions, adjust the pace to the needs, focus on those elements that from the participants' point of view are the most interesting / needed / difficult.
Aleksandra Wójtowicz
Communicativeness, broad subject knowledge, openness to questions beyond the training program
Michał Woźny
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
A lot of practical examples.
Paweł Miązek
Good atmosphere during the training.
clovis Nebouet
practical
Andrzej Kozak
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Knowledge of the trainer ok. After improving the improvement, I would choose the trainer again.
Michał Komarnicki
I learned a LOOOOOT.
Kamil Szmid
sql works even if I don't know why
Dominik Gardo
A wide knowledge of the trainer and commitment, the ability to be interested in the topic.
Michał Komarnicki
individual approach of the trainer to people participating in the training
Wojciech Gądzikiewicz
exercises (tasks) to be carried out, examples from the professional experience of the trainer
Tomasz Niewiadomski
Showing how well-known mechanisms are performed on the database side, e.g. they are processed in memory
Marcin Czerwiec
The training was perfectly prepared, I liked the way of running based on real-time examples with a detailed discussion of the impact of individual instructions on the database.
Joanna Dymarczyk
a lot of exercise
Łukasz Dziewiński
tempo of classes, flexibility as to the content of the training related to the expectations of users
Karol
Pace, explanation of issues from a completely different angle. Something that explains how everything works from the server side
P4 Sp. z o.o.
number of issues covered
P4 Sp. z o.o.
adaptation to the needs of the participants, very good exploration of the discussed tasks, comprehensive answers to the asked question
Marcin Gołdyn
Work on a physical database.
P4 Sp. z o.o.
adapting to the needs of the listeners, analyzing the problems they report
P4 Sp. z o.o.
Exercises on functions!
WIktor Paprzycki
way of translation
Małgorzata Mieczkowska
exercises
Wiktor Paprzycki
examples, openness of the trainer
INTERNATIONAL PAPER POLSKA
flexibility
dawid bodo
exercises
Mateusz Wilk
A huge trainer experience
Crédit Suisse (Poland) Sp. z o.o.
exercise.
Marzena Marciniak - Bakoma Sp. z o. o.
Exercises :).
Monika Lewalska - Bakoma Sp. z o. o.
Substantive and very easy transfer of information.
Piotr Polański - Bakoma Sp. z o. o.
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
way of conducting and the knowledge of the trainer and the method of its transfer.
Grzegorz Cimochowski - Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.
Exercises :).
Katarzyna Gędziorowska - Bakoma Sp. z o. o.
Loose relationships, answering every question, dreaming of incomprehensible issues.
Bakoma Sp. z o. o.
I have no comments.
Bakoma Sp. z o. o.
very logical and step by step but not too much
Anne Homer - States of Jersey
Well prepared, attached to the agenda, a complete agenda was reviewed, adequate examples.
Luis Gerardo Torres - thyssenkrupp Presta de México SA de CV
I enjoyed the flexibility to explore different areas outside the set training materials.
- BMW Group
everything was OK
- Zakłady Produkcyjno-Usługowe "PRAWDA" sp. z o.o.
n/d
Artur Bryś - Centrum Innowacji ProLearning
Merytoryka
Dariusz Pawłowski - Izabela Hłąd Szkolenia i Doradztwo
The amount of knowledge transferred in such a short time
- Izabela Hłąd Szkolenia i Doradztwo
Clear Knowledge transfer
Dawid Markunas - Izabela Hłąd Szkolenia i Doradztwo
Patience, reordering, knowledge
- Santander Bank Polska S.A.
Lots of exercises
Michał Świerkowski - Santander Bank Polska S.A.
Practice
- Santander Bank Polska S.A.
Phil was incredibly knowledgeable, worked at our pace and took the time to talk us through multiple ways of doing different queries. He consistently took the time throughout the sessions to check both myself and my colleague were on board with what was being discussed, no question was too big/too small. This was my first time taking a training course remotely and I'm completely sold on it - Phil is a credit to you.
Chris Teasdale - Openreach
Pace of the training and detail of content was perfect for a virtual session
Chris Hopton - Openreach
practical
- Swiss International Air Lines Ltd.
Mr. Bless has a very friendly, pleasant personality and with his experience and enthusiasm always motivates the participants and encourages them to do some tricky exercises! He has always made sure that all participants understand the content and has answered any questions. Good exercises help you to use the theory part quickly in practice. In general, the organization and tailoring of the training to the requirements of Nobleprog participants was very professional. Many Thanks!
Timo Koch - Swiss International Air Lines Ltd.
The exercise
Federal Demographic Council
the exercises
Amna AlAli - Federal Demographic Council
The explanation are very clear and the exercises help understand better
Federal Demographic Council
Clear
Mariam Karmostaji - Federal Demographic Council
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
The variety of exercises and presentation, so we had time to deepen every section before the next started. Also, very good the focus on the participants.
Philine Mitrea - Greentube IES GmbH
What I like most about the training are the exercises which really helps me to learn about basic SQL.
Maverick Ivan Oreste - BOSCH SERVICE SOLUTIONS INC.
Related Courses
From Data to Decision with Big Data and Predictive Analytics
21 hoursAudience 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 hoursObjective: 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 hoursCourse can be provided with any tools, including free open-source data mining software and applications
Data Mining with R
14 hoursR 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 hoursMonetDB 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 hoursR 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 hoursGoal: 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 hoursData 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 hoursThis 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 hoursThe 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 hoursR 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 hoursBig 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 hoursKnowledge 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 hoursOracle 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 hoursProcess 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