FI2BCDC75 Databases and Cloud Services
FI2BCDC75 Databases and Cloud Services
- Course description
- Course codeFI2BCDC75
- Level of study5.1
- Program of studyData Analyst 1
- Credits7.5
- Course coordinatorBertram Haskins, Alec Du Plessis
This course introduces the core concepts of databases, databasing, and cloud-based data services. Candidates will learn how to use the SQL data language to reliably create, read, update, and delete (CRUD) data into relational databases. Candidates will learn about data warehouses and the standard extract, transform, and load (ETL) practices to stage data in different access layers. Candidates will then be introduced to cloud-based databases and acquire the skills to access data sources using native cloud tools. At the end of the module, candidates can distinguish the use case of on-premises versus cloud databases and have the skills needed to work with either scenario.
This course brings a new and relevant concept into the data analysis course: large and reliable data storage. Candidates are taught the theory behind database use; the technical skills required to access and maintain data records using the SQL language and native database tools. Candidates will also study the different use cases for database architecture and will be able to identify suitable working conditions for offline versus online storage.
The candidate:
- has knowledge of data warehouses and the standard extract, transform, and load (ETL) practices that are used to stage data in different access layers
- has knowledge of industry-relevant database components that are used to build and maintain a functional database for use with data analysis tools
- has knowledge of SQL data language that is used to interface with data stored within databases
- has knowledge of decision-making techniques that are used to distinguish advantages and disadvantages between on-premises and cloud-based databases
- is familiar with the history, traditions and distinctive nature of the databases and cloud services
- has insight into own opportunities for development in the SQL data language and the newest industry-relevant trends within databases and cloud services
The candidate:
- can explain vocational choices for cloud-based native tools to interact with cloud databases using a web browser or terminal
- can explain vocational choices for database implementation to determine between on-premises and cloud-based databases solutions for a given a project
- can explain vocational choices to extract, transform, and load practice to stage data from databases into access layers
- can reflect on own insight on data warehouse use cases during project decision-making and adjust it under supervision
- can reflect over own use of SQL data language to create, read, update and delete data stored with databases and adjust it under supervision
- can find and refer to database documentation and guides to assist in the applied implementation
- can find and refer to study material related to data warehouses used within the industry
The candidate:
- can plan and carry out database and cloud services-related vocational tasks alone or as part of a group and in accordance with ethical requirements and principles
- can contribute to developing effective work methods in the creation of database solutions based on the desired data project
In this course, the following teaching and learning methods can be applied, but are not limited to:
- Lecture: Educator-led presentations or activities providing knowledge, skills, or general competencies in the subject area.
- Group work: Collaborative activities where students work together to solve problems or complete tasks.
- Tutoring: One-on-one or small group sessions with an instructor for personalized guidance and support.
- Student presentations: Opportunities for students to demonstrate their understanding of course material by presenting to peers.
- Online lessons: Digital content delivered via an online learning platform.
- Guidance: Individualized advice and direction from instructors to support students in their learning journey.
- Workshops: Practical sessions focused on hands-on application of theoretical concepts or skills.
- Self-study: Independent study where students engage with course material on their own without any teacher support.
Teaching materials, reading lists, and essential resources will be shared in the learning platform and software user manuals where applicable.
| Form of assessment | Grading scale | Grouping | Duration of assessment |
|---|---|---|---|
Course Assignment | Pass / Fail | 1 Week(s) |