Software Developer‎ > ‎SQL Querying‎ > ‎

DB Design

Introduction to Relational Database Design


Course Material
                                 
You will get a copy of this book as part of the course

Bookings

You can download the course registration form on our home page or by clicking here

Duration and Pricing
  • 5 days full-time (R6995 excl VAT)
Intended Audience

This course is for database developers and administrators at beginner to intermediate level. This course is for newcomers to Relational Database topics and no previous experience is required.

Prerequisites

Matric

Further Training

If you have not yet, you must definitely consider doing the T-SQL Programming course/s.

Certificate

Upon successful completion of the course, you will qualify for an attendance certificate. You will also write a test to asses your knowledge of these topics. If you pass this test with 75%, you will get an additional academic certificate.
A test like this might be written by anyone outside the scope of a training course for a fee of R1000.

Course Info

A database is designed throughout the course. The students will also get an example database which represents the exercises.
1. Approaching RDB Modelling

Database Modelling Past and Present

Database Modelling in the Workplace

Database Modelling Building Blocks

2. Designing RDB Models

Understanding Normalisation

Reading and Writing Data with SQL

Advanced Relational Database Modelling

Understanding Datawarehouse Data Modelling

Building Fast-Performing Database Models
3. Case Study in RDB Design

Planning and Preparation Through Analysis

Creating and refining tables during the design phase

Filling in the details with a detailed design

Business rules and field settings

4. Advanced Topics

Advanced database structures and hardware resources