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 a database
- Database types: relational, hierarchical, and NoSQL
- Criteria for selecting and utilizing databases
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Core responsibilities of a DBMS
Data Modeling and Design
- Identifying entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into database tables
Relational Model and Normalization
- Understanding tables, rows, and columns
- Primary and foreign key mechanisms
- Application of 1NF, 2NF, 3NF and the concept of denormalization
Basic SQL for Data Access
- Executing SELECT, INSERT, UPDATE, and DELETE commands
- Techniques for filtering, sorting, and joining data
- Utilizing aggregate functions and subqueries
Database Security and User Management
- Configuring user roles and permissions
- Implementing authentication and access controls
- Protecting data both in transit and at rest
Backup, Recovery, and Maintenance Basics
- Strategies for data backup
- Considerations for disaster recovery
- Regular maintenance and monitoring practices
Summary and Next Steps
Requirements
- Familiarity with general IT concepts
- Practical experience using computers and navigating file systems
- Basic understanding of data and file organization
Intended Audience
- IT systems support staff
- Database administrators
- Developers or analysts moving into data-centric roles
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
