Course Outline
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as a Declarative Language
SQL Syntax
SQL Sublanguages: DQL, DML, DDL, DCL
In-Depth DQL (Data Query Language)
- The SELECT clause
- Using column aliases
- Applying table aliases
- Date data types and functions
- Aggregation functions
- Table joins
- The JOIN clause
- The UNION operator
- Nested queries
- Correlated subqueries
Overview of DML (Data Manipulation Language)
- Inserting records (INSERT)
- Populating tables via subqueries
- Modifying records (UPDATE)
- Removing records (DELETE)
Overview of DDL (Data Definition Language)
- Managing objects: Creation, modification, and removal (CREATE, ALTER, DROP)
- Generating tables from query results (CREATE TABLE ... AS SELECT...)
Constraints Overview
- NULL and NOT NULL
- The CONSTRAINT clause
- ENUM data type
- SET data type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- The DEFAULT clause
Transactions Overview
- COMMIT
- ROLLBACK
- SAVEPOINT
- Managing implicit and explicit transactions
SQL Dialects Overview
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Foundational computer literacy.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
