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"
Around 2001 our company moved into instructor led training where I started training mainly corporate companies in all the technologies I had learnt. I joined Leading Training in 2011 with a primary focus on technical training and managing the IT infrastructure. In the last 5 years my main focus has shifted back to my roots of back-end web development. This now involves writing web-based applications to automate business workflows. For this I mainly make use of a PHP framework called Laravel and a library called Laravel Livewire.
I am very active in my church in all things technical. I enjoy mixing live sound and assisting with the live streaming of services.
Structured Query Language (SQL) is the most popular language used for querying relational databases. SQL supports a number of advanced features that make your queries more intelligent and efficient and take a lot of the work away from the middle ware.
This course is specifically only for Microsoft SQL Server. For an advanced SQL course focused on Oracle, please contact us.
In this course you will learn how to:
Use loops and branches in queries
Create user defined functions and stored procedures