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 what a database is
- Database categories: relational, hierarchical, and NoSQL
- Scenarios for utilizing databases
Database Management Systems (DBMS)
- Insight into DBMS architecture
- Leading systems including SQL Server, MySQL, PostgreSQL, and Oracle
- Core functions and responsibilities of a DBMS
Data Modeling and Design
- Exploring entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into database tables
Relational Model and Normalization
- Structure of tables, rows, and columns
- Role of primary and foreign keys
- Understanding 1NF, 2NF, 3NF, and denormalization
Basic SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, and DELETE
- Techniques for filtering, sorting, and joining data
- Use of aggregate functions and subqueries
Database Security and User Management
- Managing user roles and permissions
- Implementing authentication and access control
- Ensuring data security during transmission and storage
Backup, Recovery, and Maintenance Basics
- Strategies for data backup
- Considerations for disaster recovery
- Routine maintenance and system monitoring
Summary and Next Steps
Requirements
- Familiarity with general IT principles
- Proficiency in computer usage and navigating file systems
- Foundational knowledge 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.
