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
- The definition and purpose of a database
- Overview of database types: relational, hierarchical, and NoSQL
- Scenarios for database implementation
Database Management Systems (DBMS)
- An overview of DBMS architecture
- Leading systems such as SQL Server, MySQL, PostgreSQL, and Oracle
- The primary functions and responsibilities of a DBMS
Data Modelling and Design
- Defining entities, attributes, and their relationships
- Constructing Entity-Relationship (ER) diagrams
- Translating conceptual models into table structures
Relational Model and Normalization
- Understanding tables, rows, and columns
- The role of primary and foreign keys
- Applying 1NF, 2NF, and 3NF, along with denormalization
Basic SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, and DELETE
- Techniques for filtering, sorting, and joining data
- Using aggregate functions and subqueries
Database Security and User Management
- Managing user roles and permissions
- Authentication mechanisms and access control
- Protecting data both in transit and at rest
Backup, Recovery, and Maintenance Basics
- Developing data backup strategies
- Considerations for disaster recovery
- Routine maintenance tasks and system monitoring
Summary and Next Steps
Requirements
- A working knowledge of general IT concepts
- Practical experience in using computers and navigating file systems
- A foundational understanding of data and file organisation
Target Audience
- IT systems support specialists
- Database administrators
- Developers or analysts moving into data-focused roles
40 Hours
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.
