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
- The structure of a relational database
- Connection types of tables
- The normalization and denormalization database
- Database Management System (RDBMS)
Relational Operators
Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)
- SELECT queries
- Aliases columns, tables
- Service date (DATE types, display functions, formatting)
- Group Features
- Combining internal and external tables
- UNION operator
- Nested Subqueries (the WHERE clause, the table name, column name)
- Correlated subqueries
Data Modification Language
- Inserting rows (INSERT clause)
- Inserting via query
- Updating rows (UPDATE)
- Removing rows (DELETE)
Data Definition Language
- Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)
CONSTRAINTS
- Options NULL and NOT NULL
- CONSTRAINT clause
- Condition PRIMARY KEY
- Condition UNIQUE
- Condition FOREIGN KEY
- DEFAULT clause
Transactions
- The command COMMIT, ROLLBACK, SAVEPOINT
Language DCL
- Granting and revoking permissions (GRANT, REVOKE)
- Roles
- Creating Users
- sequences
- Synonyms
- The views (perspective)
Requirements
- Computer skills
- 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 (7)
I found his methods very informative
Adnan - Computerbits
Course - Oracle SQL Language
Trainer being really "relaxed" and "easy going". A lot of exercises that helped with understanding all subjects covered in the course. Also, all questions asked were answered with examples!
Karol J. - Computerbits
Course - Oracle SQL Language
The way Lucasz was explaining things.
Matija - Computerbits
Course - Oracle SQL Language
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
The exercises and the trainer :)
Eliza Ciobanu - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
The training was applied, with many exercises, exactly as we wanted.
Lorena Anton - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
Exercises from the day 2
