Primary tabs

Short Course
on
Structured Databases and Data Warehouses
The financial and other industries currently have a shortage of people with the necessary data science skills to address problems relating to large and/or complex data sets. Nowadays financial institutions are confronted with an abundance of data, and so in order to maintain a competitive advantage, it is imperative to have analysts with these necessary data science skills. This short course will address one of the topics needed to become a skillful data scientist.

Purpose of the course:

This short course aims to equip participants with the skills necessary to understand and implement the main activities in the database cycle which include modelling, query development in SQL, and reporting. Additional to transactional systems the course also covers data warehouse design and modelling.

Admission requirements:

Admission requirements: 
NQF level 7 majoring in either Mathematics/Statistics/Engineering/Computer Science.
Learning assumed to be in place: 
NQF level 7.

Course outcomes and assessment criteria :

Course outcomes and the associated assessment criteria: 

Study Unit

Outcomes

Assessment Criteria

  After completion of this course, participants will: Participant will be assessed on the following criteria:
 
  1. Demonstrate applied knowledge and understanding of the nature and architecture of structured databases and data warehouses and understand how it is applied in practice. 
  2. Demonstrate an ability to identify real-world practical problems that can be solved using analysis of large quantities of structured data and then apply data modelling and query methods to solve these problems.
  3. Demonstrate an ability to use a range of data modelling, query and reporting skills to identify, analyse and address complex problems. 
  1. Explain the characteristics of structured data sources
  2. Explain the characteristics of data warehouses and the lifecycle of data warehouse development
  3. Use tools to store and manipulate structured data in relational databases and multidimensional data sources.
  4. Use tools to query and report on structured data
  5. Solve a business problem using a structured data solution.

 

Assessment: 
Assignments and participation
Method of assessment: 
Learning objectives will be accomplished through the successful completion of assignments and participation in short course activities, proving insight into the topics at hand.

Additional information

Mode of delivery: 
Mixed
Target group: 
Graduates and/or industry professionals working in fields that require data science and analytical skills.
Contact us
Name: 
Me M Cockeran
Telephone number: 
018 299 2552