Course Outline
Relational database models
- The structure of a relational database
- Types of table relationships
- Database normalization and denormalization
- Relational Database Management System (RDBMS)
Relational Operators
Characteristics of the declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)
- SELECT queries
- Aliasing columns and tables
- Date functions (DATE types, display functions, formatting)
- Grouping features
- Combining internal and external tables
- UNION operator
- Nested Subqueries (in the WHERE clause, for table names, and column names)
- Correlated subqueries
Data Modification Language
- Inserting rows (INSERT clause)
- Inserting via query
- Updating rows (UPDATE)
- Removing rows (DELETE)
Data Definition Language
- Creating, altering ownership, and removing tables (CREATE, ALTER, DROP) Creating tables by query (CREATE TABLE .... AS SELECT ...)
CONSTRAINTS
- NULL and NOT NULL options
- CONSTRAINT clause
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- The COMMIT, ROLLBACK, and SAVEPOINT commands
Language DCL
- Granting and revoking permissions (GRANT, REVOKE)
- Roles
- Creating Users
- Sequences
- Synonyms
- Views
Requirements
- Computer literacy
- Knowledge of any operating system
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 2600 € + 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
