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
- Database categories: relational, hierarchical, and NoSQL
- Purposes and applications of databases
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Core functions and responsibilities of a DBMS
Data Modeling and Design
- Entities, attributes, and inter-entity relationships
- Entity-Relationship (ER) diagramming
- Transitioning from conceptual models to table structures
Relational Model and Normalization
- Structure of tables, rows, and columns
- Role of primary and foreign keys
- Normalization forms (1NF, 2NF, 3NF) and the concept of denormalization
Essential SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, DELETE
- Data filtering, sorting, and joining techniques
- Utilizing aggregate functions and subqueries
Database Security and User Management
- Defining user roles and permissions
- Authentication mechanisms and access control
- Protecting data during transmission and in storage
Backup, Recovery, and Maintenance Fundamentals
- Strategies for data backup
- Considerations for disaster recovery
- Scheduled maintenance and system monitoring
Conclusion and Future Directions
Requirements
- A solid grasp of general IT principles
- Proficiency in computer usage and file system navigation
- Familiarity with basic data and file organization
Target Audience
- IT support staff
- Database administrators
- Developers or analysts moving into data-centric 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.
