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
Introduction to SQL Development Bootcamp
Overview of SQL Development
- Data and databases
- Database management systems (DBMS)
- SQL key concepts
Getting Started with SQL Databases
- Installing DBMS software
- Initial configuration
- Connecting existing databases
- Database development methodology
Exploring SQL Statement Fundamentals
- Data definition language statements
- Transaction control statements
- Session and system control statements
- Embedded SQL statements
Working with SQL Data
- Filtering data
- Comparison and logical operators
- Sorting data
- Row limiting clause
- Substitution variables
- Define and verify commands
Using Single Row, Group, Conversion, and General Functions
- Character functions
- Numeric and date functions
- Conversion functions
- Case and decode functions
- Distinct and null values
- Group by clauses
- Having clauses
Working with SQL Join Clauses
- Inner join
- Non-equijoin
- Outer join
- Cross join
Using Subqueries and SET Operators
- Single row subqueries
- Multi row and multi column subqueries
- SET operators
- Correlated subquery
- Data manipulation with subqueries
Creating Databases and Tables
- Data types
- Primary and foreign keys
- Constraints
- Table actions (create, insert, update, delete)
- Data dictionary views
- Conditional expressions
Working with Views, Sequences, Synonyms, and Indexes
- Creating and querying views
- Creating and modifying sequences
- Creating synonyms
- Creating indexes
Managing Schema Objects
- Constraints management
- Temporary tables
- External tables
Controlling User Access
- System privileges
- Object privileges
- Roles
- Revoking privileges
Managing Data in Different Time Zones
- Interval data types
- Time functions
Troubleshooting
Summary and Conclusion
Requirements
- Familiarity with database management and database management systems
Audience
- Beginners
- Programmers
- Database admins
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
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.
A professional and accessible way of transferring knowledge and assistance during training and exercises.
Michal Bialek
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
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).
Raphael Keymer - Markit Valuations Limited
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 lecturer
Paweł Dybowski
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
adapting the material to the knowledge, interests and needs of the interested; a small group of trainers helped in learning more quickly; nice way of conducting, trivia, conversation
Łukasz Madej
a lot of exercise
Łukasz Dziewiński
I enjoyed the attention to detail, knowledge and enthusiasm for the subject.
Bristol City Council
The ability to ask questions at any time and the more informal / less structured style. This allowed us to pursue the areas of knowledge we were most interested in.
Jim Lane
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
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.
The Trainer Subject Knowledge
Rares Serea - eMAG IT Research
I liked that he had actual know how of when to use each technology, that's valuable.
Radu Mazilu - eMAG IT Research
very logical and step by step but not too much
Anne Homer - States of Jersey
He was very friendly and he created a very good environment.
- European Commision, Joint Research Centre
the attitude, the examples and amazing trainer
- Groupon Shared Service Polska
Well prepared, attached to the agenda, a complete agenda was reviewed, adequate examples.
Luis Gerardo Torres - thyssenkrupp Presta de México SA de CV
everything :)
Szymon Lasota - Lingaro Sp. z o.o.
Practical knowledge
Tomasz Bartczak - Lingaro Sp. z o.o.
Exercises on real data
- Lingaro Sp. z o.o.
learning about reading query plans (individual elements)
- Lingaro Sp. z o.o.
Very interesting examples, ease of knowledge transfer by the teacher.
- Lingaro Sp. z o.o.
a large number of topics.
- Lingaro Sp. z o.o.
I genuinely enjoyed the lots of labs and practices.
Vivian Feng - Destination Canada
The exercises/labs were tailored to our own organizational needs.
- Destination Canada
I generally liked the subject matter.
- Destination Canada
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
Individual approach to listeners
- Santander Bank Polska S.A.
A lot of exercises and vivid examples, few PDFs
- Santander Bank Polska S.A.
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
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.
Relevance to BigQuery.
- Spark44
We use BigQuery and the trainer decided we would use BigQuery instead to run all of the codes which was really really useful
- Spark44
A lot of exercises, examples, recalling and discussing cases of practical applications of the issue
- UBS Business Solutions Poland Sp. z o.o.
The training was conducted thoroughly from basic to very advanced ones. Friendly trainer, happy to answer questions.
Anna Gerlich - UBS Business Solutions Poland Sp. z o.o.
the knowledge gained from the training can be used in the job for which he was asked, the code written in VBA certainly no one will remember, so sending this message in the email is useful
- UBS Business Solutions Poland Sp. z o.o.
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
Interactive exercises
Matthew Viner - Thames Water Utilites Ltd
It felt very relatable. The exercises were well picked out and I was able to work well with it due to clear knowledge provided.
Leah Bayliss - Thames Water Utilites Ltd
Phil was great! He was both patient and knowledgeable. The training went at a good pace, moving a team of mixed SQL abilities through the basics into more advanced SQL querying together. The exercises were an excellent way for us to commit our newly learned skills to memory, and Phil's instructions/class discussions on numerous ways to achieve the same thing were interesting.
Sophie Clement - Thames Water Utilites Ltd
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
Oracle SQL Advanced
14 hours