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 models
- Relational operators
- Characteristics of declarative SQL language
- SQL syntax
- Division language DQL, DML, DDL, DCL
Data Query Language
- SELECT queries.
- Aliases columns of tables
- Service date (DATE types, display functions, formatting)
- Group Features
- Combining internal and external tables (JOIN clause)
- UNION operator
- Nested Subqueries (the WHERE clause, the table name, column name)
- Correlated subqueries
Data Modification Language
- Inserting rows (INSERT clause)
- Inserting rows by request
- Variation of the rows (UPDATE)
- Delete rows (DELETE)
Data Definition Language
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
- Options NULL and NOT NULL
- CONSTRAINT clause
- ENUM type
- type SET
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- The command COMMIT, ROLLBACK, SAVEPOINT
Requirements
- Computer literacy
- Knowledge of any operating system
14 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3200 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
The course built lesson to lesson, and the pacing was a big deal for me.
