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
- Definition and purpose of a database
- Database types: relational, hierarchical, and NoSQL
- Scenarios where databases are most beneficial
Database Management Systems (DBMS)
- Architectural overview of a DBMS
- Key systems such as SQL Server, MySQL, PostgreSQL, and Oracle
- Core responsibilities of a DBMS
Data Modeling and Design
- Entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into table structures
Relational Model and Normalization
- Structure of tables, rows, and columns
- Primary and foreign keys
- Normalization levels (1NF, 2NF, 3NF) and denormalization
Basic SQL for Data Access
- Commands for SELECT, INSERT, UPDATE, and DELETE
- Filtering, sorting, and joining tables
- Use of aggregate functions and subqueries
Database Security and User Management
- Managing user roles and permissions
- Authentication mechanisms and access control
- Protecting data during transit and while stored
Backup, Recovery, and Maintenance Basics
- Developing data backup strategies
- Considerations for disaster recovery
- Routine maintenance and system monitoring
Summary and Next Steps
Requirements
- Familiarity with general IT concepts
- Proficiency in using computers and navigating file systems
- Basic understanding of data and file organization
Target Audience
- IT systems support staff
- Database administrators
- Developers or analysts moving into data-centric 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.
