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
- Study Plan 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
Digital Learning Resources
The learning management system (LMS) is the primary learning platform where students access most of their course materials. The content is presented in various formats, such as text, images, models, videos or podcasts. Each course follows a progression plan, designed to lead students through weekly modules at their own pace. Exercises and assignments (individual or in groups) are embedded throughout the courses to support continuous practice and assessment of the learning outcomes.
Campus Resources
In addition to the digital learning resources, campus students participate in physical learning activities led by teachers as part of the overall delivery.
Guidance
Guidance and feedback from teachers support students' learning journeys, and may be provided synchronously or asynchronously, individually or in groups, via text, video or in-person feedback.
| Form of assessment | Grading scale | Grouping | Duration of assessment |
|---|---|---|---|
Course Assignment | Pass / Fail | Individual | 1 Week(s) |