Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 14 hours
Course Outline
Relational Database Management Systems (RDBMS)
Relational Operations
SQL as a Declarative Language
SQL Syntax Standards
SQL Sub-languages: DQL, DML, DDL, and DCL
In-Depth Analysis of DQL (Data Query Language)
- Utilizing the SELECT clause
- Defining column aliases
- Assigning table aliases
- Handling date types and date functions
- Applying aggregate functions
- Combining data via table joins
- Using the JOIN clause
- Leveraging the UNION operator
- Constructing nested queries
- Implementing correlated subqueries
Overview of DML (Data Manipulation Language)
- Adding new records (INSERT)
- Populating tables using subqueries
- Modifying existing records (UPDATE)
- Removing records (DELETE)
Overview of DDL (Data Definition Language)
- Managing objects through creation, modification, and deletion (CREATE, ALTER, DROP)
- Creating tables from query results (CREATE TABLE .... AS SELECT...)
Overview of Constraints
- Managing NULL and NOT NULL values
- Applying the CONSTRAINT clause
- Working with ENUM types
- Utilizing SET types
- Defining PRIMARY KEYs
- Enforcing UNIQUE constraints
- Establishing FOREIGN KEY relationships
- Configuring DEFAULT values
Overview of Transactions
- Executing COMMIT operations
- Performing ROLLBACK actions
- Utilizing SAVEPOINTS
- Understanding implicit and explicit commit/rollback mechanisms
Overview of SQL Dialects
- MySQL specific features
- Microsoft Access and SQL Server variations
- Oracle and PostgreSQL differences
Requirements
Familiarity with fundamental computer operations.
Select an available course date
- Format Online
- Language Polish
- Course Public course
- Start Date 2026-11-23
- Duration 2 days (14 hours)
BOOK - 390 EUR
Net price per participant
Testimonials (7)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
The way in which it was organized on virtual machines, easily accessed by the trainer
Alexandru Tudorache
Course - SQL Fundamentals
Providing information and knowledge of the training topic
Patryk Pietrzyk - Nacomi Group
Course - SQL Fundamentals
Learned new things and advanced myself with knowledge
Todor - MYPOS TECHNOLOGIES
Course - SQL Fundamentals
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
style, knowledge
Cristina - Banca Transilvania
Course - SQL Fundamentals
He had a lot of patience with all the students.
