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 Declarative SQL Language
- SQL Syntax
- Division of Languages: DQL, DML, DDL, DCL
Data Query Language (DQL)
- SELECT Queries
- Alias Columns in Tables
- Date Handling (DATE Types, Display Functions, Formatting)
- Grouping Features
- Combining Internal and External Tables (JOIN Clause)
- UNION Operator
- Nested Subqueries (WHERE Clause, Table Name, Column Name)
- Correlated Subqueries
Data Modification Language (DML)
- Inserting Rows (INSERT Clause)
- Inserting Rows by Request
- Updating Rows (UPDATE)
- Deleting Rows (DELETE)
Data Definition Language (DDL)
- 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
- Commands: COMMIT, ROLLBACK, SAVEPOINT
Requirements
- Computer literacy for government
- Knowledge of any operating system
14 Hours
Testimonials (1)
The course built lesson to lesson, and the pacing was a big deal for me.
