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
Relational Database Management System (RDBMS)
Relational Operators
SQL as a Declarative Language
SQL Syntax
SQL Sublanguages: DQL, DML, DDL, and DCL
In-Depth Look at DQL (Data Query Language)
- Understanding the SELECT clause
- Using column aliases
- Utilizing table aliases
- Date types and date-related functions
- Aggregate (group) functions
- Implementing table joins
- Mastering the JOIN clause
- The UNION operator
- Nested queries
- Correlated subqueries
Overview of DML (Data Manipulation Language)
- Inserting new rows (INSERT)
- Inserting rows via subqueries
- Modifying existing rows (UPDATE)
- Removing rows (DELETE)
Overview of DDL (Data Definition Language)
- Creating, altering, and dropping database objects (CREATE, ALTER, DROP)
- Creating tables based on query results (CREATE TABLE ... AS SELECT ...)
Overview of Constraints
- NULL and NOT NULL specifications
- Using the CONSTRAINT clause
- ENUM data type
- SET data type
- PRIMARY KEY definition
- UNIQUE constraints
- FOREIGN KEY relationships
- DEFAULT value clauses
Overview of Transactions
- COMMIT operations
- ROLLBACK procedures
- Setting SAVEPOINTs
- Understanding implicit and explicit commits and rollbacks
Overview of SQL Dialects
- MySQL specifics
- Microsoft Access and SQL Server nuances
- Oracle and PostgreSQL characteristics
Requirements
Basic computer proficiency is required.
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.
