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
- Key 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
- Executing SELECT queries
- Assigning aliases to table columns
- Handling date services (DATE data types, display functions, and formatting)
- Grouping features
- Merging internal and external tables using the JOIN clause
- Using the UNION operator
- Implementing nested subqueries (in the WHERE clause, table names, and column names)
- Writing correlated subqueries
Data Modification Language
- Inserting rows (using the INSERT clause)
- Inserting rows via queries
- Updating rows (UPDATE)
- Removing rows (DELETE)
Data Definition Language
- Creating, altering, and dropping objects (using CREATE, ALTER, and DROP)
- Creating tables based on subqueries (CREATE TABLE .... AS SELECT...)
CONSTRAINTS
- Options for NULL and NOT NULL
- Using the CONSTRAINT clause
- ENUM data type
- SET data type
- PRIMARY KEY condition
- UNIQUE condition
- FOREIGN KEY condition
- DEFAULT clause
Transactions
- Using COMMIT, ROLLBACK, and SAVEPOINT commands
Requirements
- Basic 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.
