Course Outline
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
- SELECT clause
- Column aliases
- Table aliases
- Date types and Date functions
- Group function
- Table joins
- JOIN clause
- UNION operator
- Nested queries
- Correlated subqueries
DML (Data Manipulation Language) Overview
- Inserting rows (INSERT)
- Inserting rows using subquery
- Updating rows (UPDATE)
- Deleting rows (DELETE)
DDL (Data Definition Language) Overview
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
- NULL i NOT NULL
- CONSTRAINT clause
- ENUM type
- SET type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT clause
Transactions Overview
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit and explicit rollbacks and commits
SQL Dialects Overview
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Basic computer skills.
Testimonials
Substantive preparation, attention to detail
Sebastian Łubik
The trainer, he was knowledgeable, engaging, and easy to learn from. He encouraged a lot of hands-on learning.
Shawn McAndrew
I learned a LOOOOOT.
Kamil Szmid
sql works even if I don't know why
Dominik Gardo
individual approach of the trainer to people participating in the training
Wojciech Gądzikiewicz
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.
very logical and step by step but not too much
Anne Homer - States of Jersey
I enjoyed the flexibility to explore different areas outside the set training materials.
- BMW Group
n/d
Artur Bryś - Centrum Innowacji ProLearning
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
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.