Bernard has more than 15 Years of experience as part-time and full-time lecturer and trainer: University of Pretoria (Hons class in Informatics), Monash (First Year Introduction to Business Computing and Second Year Software Development), University of Witwatersrand ("Organization, Data, Information and Business Intelligence") and Oracle University.
Technical courses include :
Oracle Business Intelligence
Microsoft Power BI
Oracle Data Warehousing
Information Technology experience includes: IT blueprints, outsourcing, data migration, and software development. The project environments include: research, financial services, medical services, telecommunications, short-term insurance, mining, retail and IT outsourcing.
Project Management experience include acting as senior project manager on IT Projects, setting up project approaches and project offices, acting as a project mentor and trainer, and as an IT Team Service Manager
Project Management Society of South Africa
ACM (Signatory to Code of Ethics)
Award: Oracle University: â€œBest Fusion Middleware Lecturer. ZA FY2010 and ZAFY2011â€
Relevant Qualifications and Training:
Date: 2014 APM Group. Passed Agile Practitioner. Certificate Number 02905943-01-L9LH Date: 2005 APM Group, on behalf of the Office of Government Commerce (United Kingdom), London Passed PRINCE2 Practitioners Examination and certified as a "PRINCE2 Practitioner". Date: 1998 University of Pretoria Advanced Certificate in Information Systems Management (cum laude). Project Management and Decision Support were amongst the subjects Date: 1993 University of the Witwatersrand, Johannesburg Course in "Managing People in Software Development"
Ryan's formal qualifications include:
National Diploma: Engineering: Computer Systems
1999 Tshwane University of Technology
2005 Linux Professionals Institute LPI level 1 certification
Save up to 10% by booking and paying
10 business days before the course.
Information may change without notice.
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
Course Outline / Curriculum
What is SQL
SQL and Standards
Client - Server
Overview of SELECT
Selecting One Field
Selecting Multiple Fields
Using a Wild Card
Oracle's Dual table
Sorting and Filtering
Using AND/OR and NOT
Aggregate (Group) Functions
Filtering Using Having
Implicit inner join syntax
Using table aliases in joins
The Using statement
Joining Multiple Tables
EXCEPT or MINUS
Table Level Constraints
CREATE TABLE AS
DELETE and TRUNCATE
Schedule Dates and Booking
To apply for a booking, click on the relevant "Book Now" button below.
Note: places are only fully secured once payment has been made.