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
- Defining a database: what it is and its purpose.
- Exploring database types: relational, hierarchical, and NoSQL.
- Evaluating when and why to implement databases.
Database Management Systems (DBMS)
- An overview of DBMS architecture.
- Reviewing popular systems such as SQL Server, MySQL, PostgreSQL, and Oracle.
- Understanding the core responsibilities of a DBMS.
Data Modeling and Design
- Identifying entities, attributes, and relationships.
- Creating Entity-Relationship (ER) diagrams.
- Translating conceptual models into table structures.
Relational Model and Normalization
- Understanding tables, rows, and columns.
- Defining primary and foreign keys.
- Applying normalization levels (1NF, 2NF, 3NF) and understanding denormalization.
Basic SQL for Data Access
- Using SELECT, INSERT, UPDATE, and DELETE statements.
- Implementing filtering, sorting, and join operations.
- Leveraging aggregate functions and subqueries.
Database Security and User Management
- Managing user roles and permissions.
- Implementing authentication and access controls.
- Ensuring data security both in transit and at rest.
Backup, Recovery, and Maintenance Basics
- Developing data backup strategies.
- Considering disaster recovery requirements.
- Performing routine maintenance and monitoring tasks.
Summary and Next Steps
Requirements
- A solid grasp of general IT concepts.
- Proficiency in computer usage and navigating file systems.
- Basic familiarity with data and file organization.
Target Audience
- IT systems support personnel.
- Database administrators.
- Developers or analysts transitioning 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.
