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
Getting Started with Databases
- Definition and purpose of a database.
- Database categories: relational, hierarchical, and NoSQL.
- Identifying scenarios where databases are most effective.
Understanding Database Management Systems (DBMS)
- Architectural overview of a DBMS.
- Leading platforms such as SQL Server, MySQL, PostgreSQL, and Oracle.
- Core functions and responsibilities of a DBMS.
Data Modeling and Structural Design
- Identifying entities, attributes, and interconnections.
- Creating Entity-Relationship (ER) diagrams.
- Translating conceptual models into table structures.
The Relational Model and Normalization Processes
- Understanding tables, rows, and columns.
- Defining primary and foreign keys.
- Applying 1NF, 2NF, 3NF standards and understanding denormalization.
Essential SQL Commands for Data Interaction
- Using SELECT, INSERT, UPDATE, and DELETE statements.
- Techniques for filtering, sorting, and joining data.
- Utilizing aggregate functions and subqueries.
Security Protocols and User Administration
- Managing user roles and authorization levels.
- Implementing authentication and access controls.
- Protecting data during transmission and storage.
Foundations of Backup, Recovery, and Upkeep
- Developing data backup strategies.
- Considerations for disaster recovery planning.
- Performing routine maintenance and system monitoring.
Recap and Future Learning Paths
Requirements
- Familiarity with general information technology principles.
- Practical experience with computer usage and file system navigation.
- A foundational understanding of 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.
