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 Operations
SQL as a Declarative Language
SQL Syntax and Grammar
SQL Sub-languages: DQL, DML, DDL, and DCL
In-depth Look at DQL (Data Query Language)
- The SELECT statement
- Using column aliases
- Applying table aliases
- Date data types and related functions
- Aggregation functions
- Joining tables
- The JOIN statement
- The UNION operator
- Subqueries
- Correlated subqueries
Overview of DML (Data Manipulation Language)
- Adding new records (INSERT)
- Populating data via subqueries
- Modifying existing records (UPDATE)
- Removing records (DELETE)
Overview of DDL (Data Definition Language)
- Managing objects: creating, modifying, and removing (CREATE, ALTER, DROP)
- Generating tables from query results (CREATE TABLE ... AS SELECT...)
Understanding Constraints
- NULL and NOT NULL specifications
- The CONSTRAINT statement
- Enumerated types (ENUM)
- Set types
- Primary keys
- Uniqueness constraints
- Foreign keys
- Default value clauses
Transaction Management
- Committing changes (COMMIT)
- Reversing changes (ROLLBACK)
- Setting savepoints
- Implicit versus explicit commits and rollbacks
Exploring SQL Dialects
- MySQL specifics
- Microsoft Access and SQL Server considerations
- Oracle and PostgreSQL variations
Requirements
Familiarity with fundamental 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.
