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
- Relational operators
- Characteristics of the declarative SQL language
- SQL syntax
- Data Query Language (DQL), Data Manipulation Language (DML), Data Definition Language (DDL), and Data Control Language (DCL)
Data Query Language
- SELECT queries.
- Table column aliases
- Date handling (DATE types, display functions, formatting)
- Grouping features
- Combining internal and external tables (JOIN clause)
- UNION operator
- Nested subqueries (in the WHERE clause, table names, column names)
- Correlated subqueries
Data Manipulation Language
- Inserting rows (INSERT clause)
- Inserting rows via queries
- Modifying rows (UPDATE)
- Deleting rows (DELETE)
Data Definition Language
- Creating, altering, and dropping objects (CREATE, ALTER, DROP)
- Creating tables using subqueries (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
- NULL and NOT NULL options
- CONSTRAINT clause
- ENUM type
- SET type
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- COMMIT, ROLLBACK, and SAVEPOINT commands
Requirements
- Computer literacy
- Familiarity with any operating system
14 Hours
Testimonials (1)
The course built lesson to lesson, and the pacing was a big deal for me.
