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
Control user access
- User Management
- System permissions and object
- Granting
- Receiving permission
- Roles
- Using the links
Managing schema objects
- ALTER TABLE command
- Adding, modifying, and deleting columns
- Add, remove, turn off constraintów
- Create indexes
- Flashback operations
- External tables
Operations on large data sets
- MERGE command
- DML operations of podzapytaniami
- DML operations with RETURNING clause
- INSERT command multi tables
Conditional expressions
- CASE expression
- DECODE expression
Generate reports by grouping related data
- The GROUP BY clause
- The HAVING clause
- Aggregating data - ROLLUP and CUBE operators
- Identification summaries - GROUPING function
- Aggregating data - GROUPING SETS operator
Managing data in different time zones
- Time zones
- Variations TIMESTAMP
- Differences between DATE and TIMESTAMP
- Conversion operations
Advanced subqueries
- Subqueries
- Multi-column subqueries
- The subquery in the FROM clause
- Correlated subqueries
- WITH clause - re-use query blocks
Join tables
- Inequality in the WHERE clause and the FROM clause
- Semijoin
- Antijoin
The processing of hierarchical data
- The tree structure
- hierarchical Queries
- Pseudo column
- Sort data in a hierarchical query
- Useful functions
Regular expressions
- Simple and complex patterns
Requirements
Oracle SQL undergoing a course in the first part
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
SQL in Microsoft Access
14 hours
Microsoft Access - download the data
14 hours
SQL in SQL Server
14 hours
Transact SQL Basic
14 hours
Transact SQL Advanced
7 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
SQL in MySQL
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Oracle SQL Language
14 hours
Oracle SQL for beginners
21 hours