Database Systems

Online

Delivery mode

6 x 4-hr sessions

duration

Advanced

Skill Level

R14,5000

cost

Share This Course:

Overview

The JCSE is offering a six session course on Database Systems. This course is an accredited Wits University Short Course targeted at a post-graduate or professional developer level.

Large information models are an important component in many modern engineering and commercial applications. This course covers the principles underlying information modelling and database design and implementation.

After discussing the fundamentals of relational database, normalisation, database design and SQL, the course moves on to various business intelligence concepts, like data warehousing, dimensional modelling and OLAP. Finally, time is spent on various aspects of Big Data, including associated means of data storage and management, like Hadoop and NoSQL databases. The exact content of the course may vary slightly each time it is presented as database systems evolve continuously.

Completing this course will help you:

Understand the relationship between data, information and knowledge
Understand the theories and principles upon which relational databases are based
Demonstrate an introductory knowledge of Business Intelligence and Data Warehousing
Gain exposure to Dimensional Modelling as an alternative method of database design.
Demonstrate an introductory knowledge of Big Data and some of the technologies that support itList Item

Who is the course for?

This is an advanced-level course. It is aimed at those who are professional developers with 5 or more years of relevant experience. Although there are no formal educational pre-requisite courses required for this course, familiarity with programming
and database management systems will be an advantage.

Hey!

I'm Lyrice Cohen - your lecturer for this course

I’m a Lecturer in the Wits Department of Information Systems. I have many years of experience working with data and teaching others to do so.

Learning Path

Session 1: Database theory: relational databases; normalisation and SQL

Session 2: Database design

Session 3: In-memory database

Session 4: Business Intelligence: data warehousing and associated decision support tools

Session 5: Dimensional modelling as an alternative database design technique

Session 6a: Introduction to Big Data and NoSQL Databases

Session 6b: Hadoop and MapReduce as a means of storing and accessing Big Data

What people are saying

“In the wake of Covid19 it's important that we are abreast of times and we become proactive as a country. I am glad to be part of a program that does this diligently and at the same time gives me a real chance of bettering myself as well as standout. High five to the individuals who are making this happen @Noel @lance. ”

Do you want to apply?

More Courses

Course 1

Software Engineering Principles and Methods

Leading organisations apply modern approaches to delivering software more quickly, with higher quality and at competitive costs. These outcomes rely on the adoption of appropriate software engineering principles and methods.

Learn about key development concepts from plan-driven to agile

This course is certified as an official Wits University short course.

Both online and face-to-face versions of this course. Six 2-hour sessions + tutorials + exam.

View Course

Course 2

The Digital Transformation Lifecycle

All organisations - from the very large to the very small - are feeling increasing pressure to "go digital". This course covers a general digital transformation journey and provides practical guidance at each stage.

How should business leaders and owners tackle digital transformation?

This is a new course, currently being reviewed pending its certification as a Wits Short Course.

Both online and face-to-face versions of this course. Six 2 hour sessions + tutorials + group project + exam.