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.
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
- Assigning column aliases
- Defining table aliases
- Date types and date-related functions
- Aggregate functions
- Table joining techniques
- Using the JOIN clause
- The UNION operator
- Constructing nested queries
- Implementing correlated subqueries
DML (Data Manipulation Language) Fundamentals
- Inserting records (INSERT)
- Populating tables via subqueries
- Modifying records (UPDATE)
- Removing records (DELETE)
DDL (Data Definition Language) Fundamentals
- Managing objects: creation, modification, and deletion (CREATE, ALTER, DROP)
- Generating tables from subqueries (CREATE TABLE .... AS SELECT...)
Overview of CONSTRAINTS
- NULL vs NOT NULL
- Applying the CONSTRAINT clause
- ENUM data type
- SET data type
- Defining PRIMARY KEY
- Ensuring UNIQUE values
- Establishing FOREIGN KEY
- Setting DEFAULT values
Transaction Management
- Executing COMMIT
- Performing ROLLBACK
- Using SAVEPOINT
- Implicit versus explicit rollback and commit operations
Comparison of SQL Dialects
- MySQL specifics
- Microsoft Access and SQL Server variations
- Differences in Oracle and PostgreSQL
Requirements
Familiarity with basic computer operations.
14 Hours
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.
