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 Management System (RDBMS)
Relational Operators
SQL as a Declarative Language
SQL Syntax
SQL Sublanguages: DQL, DML, DDL, DCL
Detailed Overview of DQL (Data Query Language)
- SELECT Clause
- Column Aliases
- Table Aliases
- Date Types and Date Functions
- Group Functions
- Table Joins
- JOIN Clause
- UNION Operator
- Nested Queries
- Correlated Subqueries
Overview of DML (Data Manipulation Language)
- Inserting Rows (INSERT)
- Inserting Rows Using a Subquery
- Updating Rows (UPDATE)
- Deleting Rows (DELETE)
Overview of DDL (Data Definition Language)
- Creating, Altering, and Dropping Objects (CREATE, ALTER, DROP)
- Creating Tables Using a Subquery (CREATE TABLE ... AS SELECT ...)
Overview of Constraints
- NULL and NOT NULL
- CONSTRAINT Clause
- ENUM Type
- SET Type
- PRIMARY KEY
- UNIQUE
- FOREIGN KEY
- DEFAULT Clause
Overview of Transactions
- COMMIT
- ROLLBACK
- SAVEPOINT
- Implicit and Explicit Rollbacks and Commits
Overview of SQL Dialects for Government Use
- MySQL
- Microsoft Access and SQL Server
- Oracle and PostgreSQL
Requirements
Essential computer competencies for government employees include proficiency with standard software applications and digital tools necessary to perform daily tasks efficiently. These skills ensure effective communication, data management, and compliance with cybersecurity standards in a public sector environment.
14 Hours
Testimonials (3)
It was very interactive and it kept us interested.
Raluca Alexandra PUNGA
Course - SQL Fundamentals
Small group, in-person for 3 days,
Annina - Ricardo AG
Course - SQL: Basics to Intermediate
I liked the pace of the training and the level of interaction. All participants were encouraged to actively partake in discussions around exercise solutions, etc.
