Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
Partea de exercitii ne-a ajutat sa aprofundam mai lectiile prezentate.
Dragos - Tudor Constantin, Siemens
Mi-a placut ca s-a bazat pe partea practica si au fost date toate detaliile si explicatiile necesare .
Alixandru Ionut - Tudor Constantin, Siemens
Mi-a placut foarte mult ca a fost un curs aplicat cu foarte multe exemple si exercitii. A fost un curs interactiv fara prea multa teorie ceea pentru mine a fost perfect.
Vlad - Tudor Constantin, Siemens
Disponibilitatea trainerului de a explica si a clarifica toate informatiile prezentate
Tudor Constantin, Siemens
the practical nature of it
Anca Daescu, Ness
it was an excelent opportunity to add knowledges and to strenghten the old ones.
Titus - Anca Daescu, Ness
the training pace, the patience, the structured information, the logical flow of the training, the breaks (just right), checking each time for any questions/concerns. Extremely p[professional.
Mihai - Anca Daescu, Ness
the fact that he explained step by step how he thought about the method used to write the query
Vasile - Anca Daescu, Ness
the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers
Angela - Anca Daescu, Ness
The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.
Matei - Anca Daescu, Ness
tonality, rhythm, good structure
Mihalache Dana - Anca Daescu, Ness
the practices and the trainer notes
Hamda AlMahri - Maryam Almutairi , Dubai Courts
Mr. Khobeib was a great lecturer and trainer. As a beginner to PL/SQL, Khobeib explained the basics and was patient with us while going through the training material. He answered all our questions thoroughly and showed a lot of examples when we asked him to. I definitely learned a lot and can start doing tasks with PL/SQL.
Abdulrahman Alsalami - Maryam Almutairi , Dubai Courts
the trainer helpful all the time
Maitha Alselais - Maryam Almutairi , Dubai Courts
The trainer was fantastic in all aspects. He was very interactive and engaging. Most importantly, the topics were taught very clearly and at a perfect pace to complete the course. I really appreciate it and would like to give a huge thank you to the trainer.
Vivek Thomas - Estée Lauder BV
It was quite hands-on, not too much theory.
David Lambaerts - Estée Lauder BV
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Trainers respect and non judgement. Felt very comfortable to ask questions.
GP Strategies Poland sp. z o.o.
The practice questions
GP Strategies Poland sp. z o.o.
I could have trained basics and trainer checked and/or helped if any issues
Przemysław Wadowski - GP Strategies Poland sp. z o.o.
Knowledge provided in a very approachable way, good peace and nice examples.
Anna Rozek - GP Strategies Poland sp. z o.o.
Working on examples, not just theory.
GP Strategies Poland sp. z o.o.
The fact that it wasn't just pure knowledge but there was also hand on training which helped to understand everything a lot more. Those exercises were very useful.
Paweł Biały - GP Strategies Poland sp. z o.o.
trainer's approach, good pace, detailed explanations, hands-on experience
Paweł Baka - GP Strategies Poland sp. z o.o.
Interactive way of teaching (interacting with us), sticking to one sample database and doing all the excercises there
Johanna Fiedler - ING Germany
Writing the queries, I genuinely had fun with it and I feel like I learned from the provided exercises the most.
Karol Kamiński - GP Strategies Poland sp. z o.o.
- a lot of exercises
GP Strategies Poland sp. z o.o.
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
The exercises and the trainer :)
Eliza Ciobanu - OTP BANK ROMANIA S.A.
The trainer was very attentive to each student and explained until we understood.
OTP BANK ROMANIA S.A.
The training was applied, with many exercises, exactly as we wanted.
Lorena Anton - OTP BANK ROMANIA S.A.
Exercises from the day 2
Amelia Bontu - OTP BANK ROMANIA S.A.
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 explanation are very clear and the exercises help understand better
Federal Demographic Council
the exercises
Amna AlAli - Federal Demographic Council
The exercise
Federal Demographic Council
I like fact, that after each section we had excercises. It helps to remember discused topic.
Adam Bińczycki
good atmosphere during the training
clovis Nebouet
very high competence of the trainer!!
Heino Eilers
Access to trainers individual support in resolving exercises.
Tomasz Czornak
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.
Rady dotyczące optymalizacji działania kodu
Daria Klamann, Sygnity S.A.
Ilość wiedzy i sposób jej przekazania były naprawdę rewelacyjne.
Daria Klamann, Sygnity S.A.
Wszystko było udowodnione na przykładach
Marcin - Daria Klamann, Sygnity S.A.
Omówienie rzadziej używanych, ale użytecznych funkcjonalności PL/SQL
Daria Klamann, Sygnity S.A.
The training materials.
Mona Dobre - Oana Panceaa, DB Global Technology
That the trainer provide alot of materials , files and reference to return to them later once need and for self study .
Abdulrahman E. Al Qahtani, Saudi Azm for Communication and Information Technology Co
Related Courses
Data Mining
21 hours
Data Mining with R
14 hours
Data Mining and Analysis
28 hours
Introductory R for Biologists
28 hours
Data Visualization
28 hours
Data Science for Big Data Analytics
35 hours
Process Mining
21 hours
MonetDB
28 hours
Foundation R
7 hours