Course Outline
Relational Database Models
- The architecture of a relational database
- Types of table joins
- Database normalization and denormalization
- Relational Database Management Systems (RDBMS)
Relational Operators
Characteristics of the declarative SQL language, syntax structure, and language division into DQL, DML, DDL, and DCL.
Data Query Language (DQL):
- SELECT statements
- Column and table aliases
- Date handling (DATE data types, display functions, formatting)
- Grouping features
- Combining internal and external tables
- The UNION operator
- Nested subqueries (in the WHERE clause, table names, column names)
- Correlated subqueries
Data Manipulation Language (DML)
- Inserting rows (INSERT statement)
- Inserting data via queries
- Updating rows (UPDATE)
- Deleting rows (DELETE)
Data Definition Language (DDL)
- Creating, altering ownership, and dropping tables (CREATE, ALTER, DROP). Creating tables from queries (CREATE TABLE .... AS SELECT ...)
Constraints
- NULL and NOT NULL options
- The CONSTRAINT clause
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- Commands: COMMIT, ROLLBACK, SAVEPOINT
Data Control Language (DCL)
- Granting and revoking privileges (GRANT, REVOKE)
- Roles
- Creating users
- Sequences
- Synonyms
- Views
Requirements
- Basic computer literacy
- Familiarity with any operating system
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
