Excel VBA

This Excel VBA Training Course will boost your MS Office programming skills. Unleash the power of Excel with a bit of coding.

Prerequisite

Good working knowledge of MS Office

Intended Audience

Excel users who want to learn more powerful techniques

Further Training

If you are interested in becoming a programmer, we can recommend VB.NET or C#.NET

Course Material

Included in the course price

Course Info

1: Introducing VBA

  • What is VBA?
  • Jumping right in

2: How VBA works with Excel

  • Working in the Visual basic Editor
  • Introducing the Excel Object Model
  • VBA Sub and Function Procedures
  • Using the Excel Macro Recorder

3: Programming Concepts

  • Essential VBA Language Elements
  • Working with Range Objects
  • Using VBA and Worksheet Functions
  • Controlling Program Flow and Making Decisions
  • Automatic Procedures and Events
  • Error-Handling Techniques
  • Bug Extermination Techniques
  • VBA Programming Examples
4: Communicating with your users

  • Simple Dialog Boxes
  • UserForm Basics
  • Using UserForm Controls
  • UserForm Techniques and Tricks
  • Accessing your Macros through the User Interface

5: Putting it all together

  • Creating Worksheet Functions – and Living to tell about it
  • Creating Excel Add-Inns

6: The part of Tens

  • Ten VBA Questions (and answers)
  • (Almost) Ten Excel Resources

 

Duration and pricing

  • Full-time over 5 days (R9995 excl VAT)
  • Distance-learning over up to 3 months (R9995 excl Vat)

Certificate

1. Upon completion of this course we will issue you with attendance certificate to certify your attendance and / or completion of the prescribed minimum examples.
2. You have the option to get the competency / academic certificate if you :
hand in a project (pre-approved) covering most of the topics in the book.

Schedule

On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.

Bookings

You can download the course registration form on our home page or by clicking here

Brochure

You may download a pdf copy of this page by clicking here.

Questions

Please email us




HTML and CSS

No previous experience required. Whether you are a beginner, keen to start writing your first Web Page or a more experienced programmer seeking to update your skills, we cover practical introductions to these essential languages as well as tips and techniques used by experienced web developers, this HTML / CSS Training Course is for you.

Prerequisites

Matric is recommended, but a will to succeed is better.

Further Training

Web Design and / or Introduction to Computer Programming if you are considering to go into Programming.

Course Material

We give you an original copy of the book: Head First HTML with CSS & XHTML (by O’Reilly Press) as we use this mainly, but we also give additional examples where it falls short.

Course Info

 Day 1:

Getting to know HTML
Going further with hypertext
Building blocks
Day 3:Getting started with CSS
Styling with fonts and colours
The box model
Day 5:Practical project
 Day 2:

Getting connected
Adding images to your pages
Standards, compliance
Day 4:Divs and spans
Layout and positioning
HTML5 markup
Tables and more lists
HTML forms

 

 

  • Duration and pricing

Price group A

  • Certificate

Read about our certificates

  • BookingsYou can download the course registration form on our home page or by clicking hereBrochure

    You may download a pdf copy of this page by clicking on the pdf icon at the top of the page.

    Questions

    Please email us

    Schedule

    On the calendar below. If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our Contact Us page.

[contentblock id=3 img=gcb.png]




Intro to Programming

This Intro to Programming Course will teach you the fundamentals of coding. These topics that are common to all coding languages today: Variables, program flow, data structures, modularisation, functions and how to build basic solutions using these fundamentals. Although we are using JavaScript in this course, the emphasis is not on language, rather on generic coding fundamentals applicable to all coding languages today. Using JavaScript is a bonus because it is the most widely used coding language in the world and used by all other coding environments.

Prerequisites

None. No Matric required, neither any previous training in computer programming for our Intro to Programming course. If you can pass this Entry Test, you may skip this course before doing any Beginner course like Beginner Java, Beginner C#, Beginner PHP , Beginner Python  Beginner C++ and more or any of the Bootcamps.

Intended Audience:

Anybody who has not programmed before and wants to get into programming the right way

Further Training

All Coding Bootcamps and Beginner Courses

Course Material

Provided

International Alignment

We cover various internationally known syllabi e.g.

Course Info

DAY 1

Programming the Web

  • What Is Programming?
  • Talking to Computers
  • Choosing a Language
  • What Is JavaScript?
  • Get Your Browser Ready
  • Opening the Web Developer Tools
  • Introducing the JavaScript Console
  • Running Your First JavaScript Commands
  • Having Fun with Math

Understanding Syntax

  • Saying Precisely What You Mean
  • Making a Statement
  • Following the Rules

Giving and Receiving Data

  • Mastering Variables
  • Understanding Data Types
  • Prompting the User for Input
  • Responding to Input
  • Combining Input and Output

Fiddling with Web Applications

  • Introducing JSFiddle
  • Creating a JSFiddle Account
  • Sharing Your Fiddle
  • Saving Your App

JavaScript and HTML

  • Writing HTML
  • Knowing Your HTML Elements
  • Adding Attributes to Elements
  • Changing HTML with JavaScript

DAY 2

JavaScript and CSS

  • Meet the JavaScript Robot
  • CSS Basics
  • CSS Properties Give You Style
  • Customize Your Own JavaScript Robot!

Building an Animated Robot

  • Changing CSS with JavaScript
  • Make The Robot Dance

Operands

  • Knowing Your Operands
  • Working with Objects
  • Configuring Your Dream Car

Operators

  • Introducing the Super‐Calculator
  • Super‐Calculator Tricks

Creating A JavaScript Word Game

  • Creating a Variable Story
  • Creating the Word Replacement Game

DAY 3

Arrays

  • What Are Arrays?
  • Creating and Accessing Arrays
  • Changing Array Element Values
  • Working with Array Methods
  • Learning the Ways of Arrays

Making It Functional with Functions

  • Understanding Functions
  • Knowing What Functions Are Made Of
  • Building Function Junction

Creating a Wish List Program

  • Introducing the Wish List Program
  • Writing the HTML
  • Writing the JavaScript Code

Making Decisions

  • If…Else Statement
  • Boolean Logic
  • Introducing if…else Statements
  • Combining Comparisons with Logical Operators
  • Freshening Up the JavaScript Pizzeria

Switch Statement

  • Writing a Switch
  • Building an Activity‐of‐the‐Day Calendar

DAY 4

Coding An Adventure Story Game

  • Planning the Story
  • Playing the Game
  • Forking the Code
  • Tiptoeing through the HTML and CSS
  • Writing the Martian Rescue! JavaScript

Loops

  • Introducing the for Loop
  • Random Weather Forecasting App

While Loops

  • Writing a while Loop
  • Coding a Lunch Game
  • Moving to Your Own Website

Building a Lemonade Stand Game

  • Playing the Game
  • A Lesson in Business
  • Building the Game
  • Improving the Lemonade Game

DAY 5

  • Practical Projects
  • Assesments

Duration and pricing

Pricing Group C

Certificate

Read about our certificates

Bookings

You can download the course registration form on our home page or by clicking here

Brochure

You may download a pdf copy of this page by clicking on the pdf icon at the top of the page.

Questions

Please email us

Schedule

On the calendar below. If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our Contact Us page.




SQL Querying Beginner (incl MTA)

Prerequisites

None

Intended Audience

    • This Beginning SQL Querying training course is for anyone who wants to get into the world of Database Developers / Administrators or Business Intelligence.
    • Some familiarity with spreadsheets, relational databases and basic SQL might be helpful. Some coding experience might be helpful.
    • This is also the first course in the MCSA track.

After this course you should

    • Know SQL syntax
    • Know SQL database design concepts
    • Know advanced querying
    • Know how to do hard core database manipulation with Subqueries, Joins and Transactions
    • Understand effective and efficient database design and creation
    • Be able to query, normalize and join data
    • Be ready to prepare for the MTA DBA Fundamentals Exam 98-364

Alignment

This course is generally presented in MySQL, and also covers MS SQL ‘s MTA Certification. We guide and support you on the preparation of MTA exam. (MTA Exam not included in course price)

Further Training

Course Contents

 Day 1:

  • Data and Tables – a place for everything
  • Data in categories
  • What’s in a Database
  • CREATE TABLE Statement
  • Data types
  • DESCribed
  • INSERT Statement
  • NULL, NOT NULL
  • DEFAULT
  • The SELECT Statement – gifted data retrieval
  • How to query data types
  • Comparison Operators
  • AND, OR, LIKE, BETWEEN, IN, NOT IN

Day 3:

  • Advanced SELECT – Seeing your data with new eyes
  • CASE expression
  • ORDER BY
  • SUM, MIN, MAX, AVG, GROUP BY
  • COUNT, LIMIT
  • Multi-table Database Design – Outgrowing your table
  • Schema
  • How to go from one table to two
  • Create a table with a Foreign Key
  • Relationships between tables
  • Patterns of data
  • Junction table
  • 1NF
  • Partial functional dependency
  • Transitive functional dependency
  • 2NF
  • 3NF

Day 5:

  • Constraints, Views and Transactions
  • CHECK CONSTRAINT
  • Creating a view
  • Inserting, updating and deleting with views
  • View with CHECK OPTION
  • Transactions
  • The ACID Test
  • Security – protecting your assets
  • GRANT statement
  • GRANT variations
  • REVOKE privileges
  • REVOKING a used GRANT OPTION
  • MTA-Exam 98-364 Review Prep
  • Comptency Assesment Project
 Day 2:

  • DELETE and UPDATE – a change will do you good
  • Smart table design – why be normal?
  • Atomic data
  • Primary Key
  • ALTER – Rewriting the past
  • Renaming the table
  • DROP column
  • UPDATE, SET


Day 4:

  • JOINS and multi table operations
  • CREATE, SELECT, INSERT at the same time
  • AS, column aliases
  • Inner JOINS
  • Subqueries – Queries within queries
  • Natural Join
  • Noncorrelated subqueries
  • Correlated subqueries
  • EXISTS and NOT EXISTS
  • OUTER JOINS, SELF JOINS and UNIONS
  • Left and right outer join
  • A self-referencing foreign key
  • INTERSECT and EXCEPT
  • Turning a subquery into a join

Duration and pricing

Certificate

Read about our certificates

Questions

Please email us

Schedule for Johannesburg

On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.




WordPress

Prerequisites
You should have a good knowledge of HTML, CSS and XHTML .

Intended Audience
Anyone who wants to become a better web designer.

Further Training
Introduction to Computer Programming if you are considering to go into Programming.

Course Material
Included in the course price.

Course Contents

Day 1

  • Thinking like WordPress
  • Planning your site for WordPress
  • Installing WordPress
  • Admin Area Overview
  • Basic Admin Settings
  • Adding a new post – overview
  • Working with the text editor
  • Laying out text

Day 2

  • Advanced Post Postings
  • Adding a new Page
  • The basics of handling media files
  • The upload / insert window tabs
  • Image options in detail
  • Editing and laying out images
  • Working with Image galleries.

Day 3

  • Adding video and audio
  • Adding documents
  • Managing posts and pages
  • Managing media files
  • Managing post categories and tags
  • Managing widgets and menus
  • The links manager
  • Managing comments
  • Bringing in content from other sites

Day 4

  • Helping others to connect to your site
  • Having multiple site users
  • Overview of WordPress themes
  • Creating a child theme
  • Basic customisation of your design
  • Optimising your content
  • Optimising your site as a whole
  • How is your site doing?

Day 5

  • Keeping up to date
  • Backing up your site
  • Installing and activating plugins
  • Two example plugins
  • Other common uses for plugins
  • Running multiple sites with WordPress
  • Customising WordPress
  • Troubleshooting WordPress

Duration and pricing

Certificate

Read about our certificates

Schedule

On the calendar on this page below.
If your browser doesn’t display the calendar below, please click on this link or try using Google Chrome, alternatively please enquire via our ‘Contact Us’ page.

Bookings
You can download the course registration form on our home page or by clicking here

Brochure
You may download a pdf copy of this page by clicking here.

Questions
Please email us