Contact Us

Relational Database management systems and related technologies

Course Who Should Attend Prerequisites Duration
Advanced SQL

Database Administrators, Programmers.

 2 days
Analysing Data with Excel

This course is intended for students who are experienced with Microsoft Excel and who wish to add Business intelligence techniques and visualization. The course will take students beyond the capabilities of tables and charts using Pivot Charts, the Excel Data Model and Power BI.

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals.
  • Basic knowledge of data analytics equivalent to having attended Excel Dashboards.
 3 days
Data Visualization with Python
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Python Course or equivalent knowledge

 

 2 Days
Data Visualization with R
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's R Programming Course or equivalent knowledge

 4 Days
GIS ESSENTIALS – “Getting Spatially Enabled”

This GIS course enables participants to identify potentials of spatial data and to put them to use.
  • SQL
 3 Days
Introduction to Statistics

This course is for anyone interested in pursuing studies in data science, marketing, HR analytics, or science.
  • Maths at NQF Level 4
  • English at NQF Level 3
 2 days
Machine Learning with R
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Introduction to R Programming or equivalent knowledge

 Days
MySQL

The MySQL course targets Programmers, Database Administrators, Database Designers and Web Developers.

Computer Literacy and some aptitude for programming.

 5 Days
MySQL Administration
  • MySQL Database administrator
  • Excellent computer literacy
  • Technically inclined
  • SQL Course or Equivalent Knowledge
 2 Days
PLSQL

Database Administrators, Programmers.

 2 days
PostgreSQL

The PostgreSQL course targets Programmers, Database Administrators, Database Designers and Web Developers.

Basic Linux/Unix shell commands and some aptitude for programming. The  Linux Essentials course is recommended.

 7 Days
PostgreSQL Administration

Database administrators, developers, IT support staff.

SQL course or equivalent knowledge.

Linux Shell Commands course or experience with using the Linux command line.

 2 Days
PostgreSQL for Business Intelligence and Mass-data-analysis
  • Business Intelligence Professionals
  • PostgreSQL knowledge
  • SQL
 3 Days
Python Pandas and Jupyter ETL and Data wrangling
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

 

Leading Training's Python Course or equivalent knowledge
Python Regression
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Python Course or equivalent knowledge

 4 Days
R, Into the Tidyverse (Data Wrangling and ETL)
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Python, Introduction to R or equivalent knowledge

 4 Days
Regression with R
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Introduction to R Programming or equivalent knowledge

 4 Days
SQL
  • Report Writers (anyone required to produce reports from a relational database)
  • Web developers wanting to add database interaction to their web sites.
  • Programmers who quickly wants to add SQL to their skills set.
  • The hobbyist who wants to begin creating SQL scripts for upload to their own ISP.
  • Students, and to those seeking a career in computing, who need a fundamental understanding of database administration with SQL.
  • Above average computer literacy
  • If you are bringing along your own laptop and you are using Microsoft SQL Server, it will be helpful to pre-install the database server and client software. Please call for assistance or arrive at least one hour before on the first day of the course so we can help you with the
 3 Days
SQL Online
  • Report Writers (anyone required to produce reports from a relational database)
  • Web developers wanting to add database interaction to their web sites.
  • Programmers who quickly wants to add SQL to their skills set.
  • The hobbyist who wants to begin creating SQL scripts for upload to their own ISP.
  • Students, and to those seeking a career in computing, who need a fundamental understanding of database administration with SQL.
  • Above average computer literacy
  • If you are bringing along your own laptop it will be helpful to pre-install the database server and client software. Please call for assistance or arrive at least one hour before on the first day of the course so we can help you with the software installation. You will also need full administrator privileges on your laptop.
Statistics with R
  • Data scientists
  • Programmers
  • Business analysts 
  • Engineers
  • Scientists

Leading Training's Introduction to R or equivalent knowledge

 4 Days