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
- Defining a database
- Database categories: relational, hierarchical, and NoSQL
- Contexts for database application
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Core responsibilities of a DBMS
Data Modeling and Design
- Identifying entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into table structures
Relational Model and Normalization
- Understanding tables, rows, and columns
- Primary and foreign key mechanics
- Normalization stages (1NF, 2NF, 3NF) and denormalization
Basic SQL for Data Access
- Executing SELECT, INSERT, UPDATE, and DELETE commands
- Applying filtering, sorting, and joins
- Using aggregate functions and subqueries
Database Security and User Management
- Managing user roles and permissions
- Authentication processes and access control
- Protecting data during transmission and storage
Backup, Recovery, and Maintenance Basics
- Formulating data backup strategies
- Considerations for disaster recovery
- Scheduling routine maintenance and monitoring
Summary and Future Directions
Requirements
- Familiarity with general IT concepts
- Proficiency in using computers and navigating file systems
- Foundational knowledge of data and file organization
Target Audience
- IT systems support staff
- Database administrators
- Developers or analysts transitioning into data-focused 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.
