Databases Courses

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)

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

• LINUX FOR POSTGRESQL DBAS
• INTRODUCTION TO SQL

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

• SQL
  

• Business Intelligence Professionals

• PostgreSQL knowledge
• 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

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

• MySQL Database administrator

• Excellent computer literacy
• Technically inclined
• SQL Course or Equivalent Knowledge

Database administrators, developers, IT support staff.

SQL course or equivalent knowledge.

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

Database Administrators, Programmers.

• At least one months experience using SQL
• Intermediate Microsoft Excel experience recommended 

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.

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

Computer Literacy and some aptitude for programming.

Database Administrators, Programmers.

• At least one months experience using SQL
• Intermediate Microsoft Excel experience recommended 

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.