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 the concept of a database
- Examining database types: relational, hierarchical, and NoSQL
- Identifying the appropriate use cases for database solutions
Database Management Systems (DBMS)
- An overview of DBMS architecture
- Exploring popular platforms such as SQL Server, MySQL, PostgreSQL, and Oracle
- Understanding the core responsibilities of a DBMS
Data Modeling and Design
- Analyzing entities, attributes, and their relationships
- Creating Entity-Relationship (ER) diagrams
- Translating conceptual models into database tables
Relational Model and Normalization
- Exploring the structure of tables, rows, and columns
- Defining primary and foreign keys
- Applying normalization levels (1NF, 2NF, 3NF) and understanding denormalization
Basic SQL for Data Access
- Mastering SELECT, INSERT, UPDATE, and DELETE statements
- Implementing filtering, sorting, and join operations
- Utilizing aggregate functions and subqueries
Database Security and User Management
- Configuring user roles and permissions
- Managing authentication and access control mechanisms
- Implementing security measures for data 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
- 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 personnel
- Database administrators
- Developers or analysts moving 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.
