Course Outline
Introduction to Databases for Government
- What is a database?
- Types of databases: relational, hierarchical, NoSQL
- When and why to use databases in government operations
Database Management Systems (DBMS) for Government
- Overview of DBMS architecture for government applications
- Popular systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Responsibilities of a DBMS in the public sector
Data Modeling and Design for Government
- Entities, attributes, and relationships in government data
- Entity-Relationship (ER) diagrams for public sector use
- Translating models into tables for government systems
Relational Model and Normalization for Government
- Tables, rows, and columns in government databases
- Primary and foreign keys for ensuring data integrity in government records
- 1NF, 2NF, 3NF, and denormalization strategies for efficient government data management
Basic SQL for Data Access in Government
- SQL commands: SELECT, INSERT, UPDATE, DELETE
- Filtering, sorting, and joins for government data retrieval
- Aggregate functions and subqueries for comprehensive data analysis
Database Security and User Management for Government
- User roles and permissions in government systems
- Authentication and access control for secure government databases
- Securing data in transit and at rest for government compliance
Backup, Recovery, and Maintenance Basics for Government
- Data backup strategies for government agencies
- Disaster recovery considerations for ensuring continuity of operations
- Routine maintenance and monitoring for optimal performance of government databases
Summary and Next Steps for Government
Requirements
- An understanding of general IT concepts for government
- Experience with using computers and navigating file systems
- Basic knowledge of data and file organization
Audience
- IT systems support personnel
- Database administrators
- Developers or analysts transitioning into data-related roles within the public sector
Testimonials (3)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
