Skip to main content
Contact Us

COVID-19 READINESS PLAN

Leading Training is open for classroom based training as from the 10th of June. We have put strict safety measures in place, please see our COVID-19 READINESS PLAN

Those not comfortable attending classroom training are welcome to attend via webinar.

Relational Database management systems and related technologies


Course Who Should Attend Prerequisites Duration
Cybertec Introduction To Machine Learning

This course is intended for technical analysts or mid-level managers who are willing to do their first steps in Machine Learning.

Analysts/technical managers with at least 1 year of programming experience (Ideally, also experience in Python)

Days
Cybertec PostgreSQL Administration and Performance Tuning

This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis. We will deal with administration and performance tuning related topics.

  • LINUX FOR POSTGRESQL DBAS
  • SQL
Days
Cybertec PostgreSQL Professional

This course provides a deep insight into advanced PostgreSQL topics like indexing, storage parameters, optimization, replication, monitoring, etc. It covers the technical foundations required for replication, scaling, point-in-time recovery, and the successful operation of synchronous and asynchronous replication solutions. Moreover, details of processing that are essential for optimization and performance tuning are highlighted, so that you can get the most out of your system and queries.

  • LINUX FOR POSTGRESQL DBAS
  • INTRODUCTION TO SQL
days
GIS ESSENTIALS – “GETTING SPATIALLY ENABLED”

This GIS course enables participants to identify potentials of spatial data and to put them to use.

  • SQL
Days
PostgreSQL for Business Intelligence and Mass-data-analysis
  • Business Intelligence Professionals
  • PostgreSQL knowledge
  • SQL
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.
3 Days
MySQL Administration
  • MySQL Database administrator
  • Excellent computer literacy
  • Technically inclined
  • SQL Course or Equivalent Knowledge
2 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
Advanced SQL

Database Administrators, Programmers.

2 days
Analyzing 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
MySQL

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

Computer Literacy and some aptitude for programming.

5 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