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 Operators
SQL as a Declarative Language
SQL Syntax
SQL Sublanguages: DQL, DML, DDL, and DCL
In-Depth DQL (Data Query Language)
- The SELECT clause
- Use of column aliases
- Use of table aliases
- Date data types and functions
- Aggregate functions
- Combining tables
- The JOIN clause
- The UNION operator
- Nested queries
- Correlated subqueries
Introduction to DML (Data Manipulation Language)
- Adding records (INSERT)
- Populating rows via subqueries
- Modifying records (UPDATE)
- Removing records (DELETE)
Introduction to DDL (Data Definition Language)
- Managing objects through creation, modification, and removal (CREATE, ALTER, DROP)
- Building tables from subquery results (CREATE TABLE ... AS SELECT...)
Understanding Constraints
- NULL vs. NOT NULL
- The CONSTRAINT clause
- ENUM data type
- SET data type
- PRIMARY KEY
- UNIQUE constraint
- FOREIGN KEY
- The DEFAULT clause
Transaction Management
- Committing transactions
- Rolling back changes
- Using SAVEPOINTs
- Implicit versus explicit rollbacks and commits
Overview of SQL Dialects
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Familiarity with basic computer operations.
Testimonials (7)
The SQL simulator designed by Philippe
Jean-Pierre ABRIAL - AGL
Course - SQL Fundamentals
Machine Translated
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
