Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
- SELECT clause
- Column aliases
- Table aliases
- Date types and Date functions
- Group function
- Table joins
- JOIN clause
- UNION operator
- Nested queries
- Correlated subqueries
DML (Data Manipulation Language) Overview
- Inserting rows (INSERT)
- Inserting rows using subquery
- Updating rows (UPDATE)
- Deleting rows (DELETE)
DDL (Data Definition Language) Overview
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
- NULL i NOT NULL
- CONSTRAINT clause
- ENUM type
- SET type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT clause
Transactions Overview
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit and explicit rollbacks and commits
SQL Dialects Overview
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Basic computer skills.
Testimonials
the fact that we did a lot of exercises and Philip as an experienced trainer walked us through the answers
Angela - Anca Daescu, Ness
SQL Fundamentals Course
The structure of the course was perfect for my training style. For the time that we had here i think that the balance between theoretical work and practical work was perfect.
Matei - Anca Daescu, Ness
SQL Fundamentals Course
tonality, rhythm, good structure
Mihalache Dana - Anca Daescu, Ness
SQL Fundamentals Course
Related Courses
SQL Advanced in MySQL
7 hours
SQL in SQL Server
14 hours
SQL in Microsoft Access
14 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Transact SQL Basic
14 hours
Transact SQL Advanced
7 hours
SQL in MySQL
14 hours
Oracle SQL Language
14 hours
Oracle SQL for beginners
21 hours
Oracle SQL Advanced
14 hours
Microsoft Access - download the data
14 hours