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
RDBMS (Relational Database Management System)
Relational Operations
SQL as a Declarative Language
SQL Syntax
SQL Sub-languages: DQL, DML, DDL, DCL
In-Depth DQL (Data Query Language)
- SELECT statements
- Column aliases
- Table aliases
- Date data types and functions
- Aggregation functions
- Joining tables
- JOIN clauses
- UNION operator
- Nested queries
- Correlated subqueries
DML (Data Manipulation Language) Fundamentals
- Adding records (INSERT)
- Adding records via subqueries
- Modifying records (UPDATE)
- Removing records (DELETE)
DDL (Data Definition Language) Fundamentals
- Creating, modifying, and removing objects (CREATE, ALTER, DROP)
- Creating tables from subqueries (CREATE TABLE ... AS SELECT...)
Understanding Constraints
- NULL vs NOT NULL
- CONSTRAINT clauses
- ENUM type
- SET type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT clause
Transaction Management
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit vs explicit rollback and commit
SQL Dialects Comparison
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Foundational computer literacy.
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.
