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
Introduction to Databases
- What constitutes a database?
- Different types of databases: relational, hierarchical, and NoSQL.
- Contexts for utilizing databases and their benefits.
Database Management Systems (DBMS)
- Overview of DBMS architecture.
- Popular systems including SQL Server, MySQL, PostgreSQL, and Oracle.
- The responsibilities and functions of a DBMS.
Data Modeling and Design
- Entities, attributes, and relationships.
- Entity-Relationship (ER) diagrams.
- Translating models into database tables.
Relational Model and Normalization
- Understanding tables, rows, and columns.
- Primary and foreign keys.
- Normalization forms (1NF, 2NF, 3NF) and the concept of denormalization.
Basic SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, DELETE.
- Filtering, sorting, and performing joins.
- Aggregate functions and subqueries.
Database Security and User Management
- Defining user roles and permissions.
- Authentication mechanisms and access control.
- Securing data both in transit and at rest.
Backup, Recovery, and Maintenance Basics
- Strategies for data backup.
- Considerations for disaster recovery.
- Routine maintenance tasks and monitoring practices.
Summary and Next Steps
Requirements
- A foundational understanding of general IT concepts.
- Experience using computers and navigating file systems.
- Basic knowledge of data and file organization.
Target Audience
- IT systems support personnel.
- Database administrators.
- Developers or analysts transitioning into data-centric roles.
40 Hours
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.
