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 for Government
- Relational Operators
- Characteristics of Declarative SQL Language
- SQL Syntax
- Division Language DQL, DML, DDL, DCL
Data Query Language for Government
- SELECT Queries
- Aliases for 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 for Government
- Inserting Rows (INSERT Clause)
- Inserting Rows by Request
- Variation of Rows (UPDATE)
- Delete Rows (DELETE)
Data Definition Language for Government
- Creating, Altering, and Dropping Objects (CREATE, ALTER, DROP)
- Creating Tables Using Subquery (CREATE TABLE .... AS SELECT...)
Constraints for Government
- Options NULL and NOT NULL
- CONSTRAINT Clause
- ENUM Type
- Type SET
- PRIMARY KEY Condition
- UNIQUE Condition
- FOREIGN KEY Condition
- DEFAULT Clause
Transactions for Government
- The Command 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.
