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
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
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
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.