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.
Duration 21 hours
Course Outline
Overview of Database Systems
- Definition and purpose of databases
- Categorization of database architectures
- Foundations of relational data structures
- Overview of Database Management Systems (DBMS) for government environments
- Core operational functions of a DBMS
- Standardized DBMS platforms
Principles of Database Design
- Conceptual, logical, and physical data modeling
- Foundations of Entity-Relationship (ER) modeling
- Construction of ER diagrams
- Identification of entities, attributes, and associations
Data Normalization and Structural Integrity
- Standard normal forms (1NF, 2NF, 3NF, BCNF)
- Operational advantages of normalization
- Illustrative cases of normalization processes
- Application of denormalization strategies
Foundations of SQL Syntax
- Structural components of SQL commands
- Supported data types in SQL
- Structural modification commands (CREATE, ALTER, DROP)
- Data integrity constraints (PRIMARY KEY, FOREIGN KEY, UNIQUE, NOT NULL)
SQL Data Operations
- Insertion of records via the INSERT command
- Execution of bulk data entry operations
- Modification and removal of records using UPDATE and DELETE
- Application of conditional filters with the WHERE clause
Data Retrieval using SQL
- Execution of SELECT queries
- Filtering datasets using conditional clauses
- Ordering results with the ORDER BY directive
- Controlling result set size using LIMIT and OFFSET
Advanced SQL Querying Techniques
- Join operations (INNER, LEFT, RIGHT, FULL)
- Construction and execution of subqueries
- Aggregation and filtering with GROUP BY and HAVING
- Utilization of aggregate functions (COUNT, SUM, AVG, MAX, MIN)
Database Indexing and View Management
- Creation and application of database indexes
- Analysis of indexing performance and resource implications
- Design and administration of database views
- Leveraging views to enhance query clarity
Security Controls and Transaction Management
- Configuration of user roles and access permissions
- Adherence to security best practices for government systems
- Enforcement of ACID properties
- Transaction control via COMMIT and ROLLBACK
Performance Tuning and Maintenance Protocols
- Evaluation and optimization of SQL query performance
- Analysis of execution plans using EXPLAIN
- Implementation of data backup strategies
- Database recovery and restoration procedures
Conclusion and Recommended Progression
Requirements
- Familiarity with fundamental computer operations
Target Audience
- Database administrators
- Information technology specialists
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
