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
