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 of a database
- Types of databases: relational, hierarchical, NoSQL
- Use cases and benefits of databases
Database Management Systems (DBMS)
- Overview of DBMS architecture
- Popular systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Core responsibilities of a DBMS
Data Modeling and Design
- Entities, attributes, and relationships
- Entity-Relationship (ER) diagrams
- Translating models into tables
Relational Model and Normalization
- Tables, rows, and columns
- Primary and foreign keys
- 1NF, 2NF, 3NF and denormalization
Basic SQL for Data Access
- SELECT, INSERT, UPDATE, DELETE statements
- Filtering, sorting, and joins
- Aggregate functions and subqueries
Database Security and User Management
- User roles and permissions
- Authentication and access control
- Securing data in transit and at rest
Backup, Recovery, and Maintenance Basics
- Data backup strategies
- Disaster recovery considerations
- Routine maintenance and monitoring
Summary and Next Steps
Requirements
- A solid understanding of general IT concepts
- Experience using computers and navigating file systems
- Basic knowledge of data and file organization
Target Audience
- IT systems support personnel
- Database administrators
- Developers or analysts transitioning into data-related roles
40 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
