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
Testimonials (5)
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
Amelia Bontu - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.