Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Relational database models
- Relational operators
- Characteristics of declarative SQL language
- SQL syntax
- Division language DQL, DML, DDL, DCL
Data Query Language
- SELECT queries.
- Aliases columns of tables
- Service date (DATE types, display functions, formatting)
- Group Features
- Combining internal and external tables (JOIN clause)
- UNION operator
- Nested Subqueries (the WHERE clause, the table name, column name)
- Correlated subqueries
Data Modification Language
- Inserting rows (INSERT clause)
- Inserting rows by request
- Variation of the rows (UPDATE)
- Delete rows (DELETE)
Data Definition Language
- Creating, altering and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
- Options NULL and NOT NULL
- CONSTRAINT clause
- ENUM type
- type SET
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- The command COMMIT, ROLLBACK, SAVEPOINT
Requirements
- Computer literacy
- Knowledge of any operating system
Testimonials
A professional and accessible way of transferring knowledge and assistance during training and exercises.
Michal Bialek
The course built lesson to lesson, and the pacing was a big deal for me.
Bradford Moore - Regis College
Related Courses
SQL in Microsoft Access
14 hours
Microsoft Access - download the data
14 hours
SQL in SQL Server
14 hours
Transact SQL Basic
14 hours
Transact SQL Advanced
7 hours
SQL language in MSSQL
14 hours
SQL Fundamentals
14 hours
SQL Advanced in MySQL
7 hours
ORACLE PL/SQL Fundamentals
21 hours
ORACLE SQL Fundamentals
14 hours
Oracle SQL Language
14 hours
Oracle SQL for beginners
21 hours
Oracle SQL Advanced
14 hours