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
1. Introduction to Relational Databases for Government
- Definition of a Relational Database
- Architecture and Components of PostgreSQL
- Overview of PgAdmin and psql Tools for Government Use
- Connecting to a Database and Understanding Schemas in the Public Sector
2. SQL Basics for Government
- Database Objects: Tables, Columns, and Constraints
- Data Types and NULL Values for Government Databases
- Writing Simple SELECT Queries for Public Sector Applications
- Filtering with WHERE Clauses, Pattern Matching, and Logical Operators in Government Databases
- Sorting and Limiting Query Results for Efficient Data Management
3. Working with Functions and Expressions for Government
- Arithmetic and String Functions in Government Databases
- Conditional Expressions and Case Statements for Public Sector Data
- Handling NULLs and Data Type Conversions in Government Applications
4. Combining and Filtering Data for Government
- Inner and Outer Joins, Self-Joins, and Cross Joins for Government Databases
- Set Operations: UNION, INTERSECT, and EXCEPT in Public Sector Data Management
- Subqueries: Scalar, Correlated, and Table Subqueries for Efficient Querying
- Common Table Expressions (CTEs) and Recursive Queries for Complex Government Data Sets
5. Aggregation and Grouping for Government
- Aggregate Functions: SUM, AVG, COUNT, MIN, MAX in Government Databases
- GROUP BY and HAVING Clauses for Data Analysis in the Public Sector
- Window and Ranking Functions for Advanced Data Manipulation
6. Modifying Data for Government
- Inserting, Updating, and Deleting Records in Government Databases
- Using Transactions and Rollback for Data Integrity in the Public Sector
- Understanding ACID Principles for Reliable Government Data Management
- Safe Data Manipulation Practices for Government Applications
7. Database Objects and Logical Structure for Government
- Creating and Managing Schemas and Tables in Government Databases
- Primary Keys, Foreign Keys, and Unique Constraints for Public Sector Data Integrity
- Creating and Managing Views and Materialized Views for Efficient Data Access
- Introduction to Indexes and Performance Implications in Government Databases
Requirements
- An understanding of fundamental IT and data concepts for government use.
- No prior SQL or database experience is necessary.
- Familiarity with using software tools on Windows or Linux is beneficial.
Audience
- Beginners in database management and analysts for government agencies.
- Developers new to PostgreSQL for government applications.
- Professionals managing or exploring relational databases within the public sector.
14 Hours
Testimonials (1)
advance topics hands on + discussion like timescaleDB and hypertable , trainer's knowledge on the subject :)
