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 40 hours
Course Outline
Introduction to Databases
- What constitutes a database?
- Types of databases: relational, hierarchical, and NoSQL.
- When and why to utilize databases.
Database Management Systems (DBMS)
- Overview of DBMS architecture.
- Popular systems such as SQL Server, MySQL, PostgreSQL, and Oracle.
- The responsibilities of a DBMS.
Data Modeling and Design
- Entities, attributes, and relationships.
- Entity-Relationship (ER) diagrams.
- Translating models into tables.
Relational Model and Normalization
- Tables, rows, and columns.
- Primary and foreign keys.
- First, Second, and Third Normal Forms (1NF, 2NF, 3NF) and denormalization.
Basic SQL for Data Access
- SELECT, INSERT, UPDATE, DELETE commands.
- Filtering, sorting, and joins.
- Aggregate functions and subqueries.
Database Security and User Management
- User roles and permissions.
- Authentication and access control.
- Securing data both in transit and at rest.
Backup, Recovery, and Maintenance Basics
- Data backup strategies.
- Disaster recovery considerations.
- Routine maintenance and monitoring.
Summary and Next Steps
Requirements
- A solid understanding of general IT concepts.
- Experience with 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-related roles.
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
