“My IT students were spending hundreds of rands on tutoring. TechWays and I built a revision programme that focuses on the trouble areas I see my learners struggling with”

Lisa van den Biggelaar

Former Kingsmead IT HOD

PS-012

COPY PLAYER SNIP
HELP GUIDE

Why choose this revision course?

 

Practice with real IEB-style SQL queries

 

Step-by-step video explanations for every concept

 

Interactive database tasks to help you test your knowledge

 

6–8 hours of fast-paced, focused revision

 

Once-off fee: Only R600

PS-015

COPY PLAYER SNIP
HELP GUIDE

Course curriculum

    1. Background

    2. Overview

    1. Overview

    2. Understanding Databases

    3. Types of Databases

    4. QUIZ: Databases

    5. EXERCISE: Database Design

    6. Table Design

    7. TASK: Design a Single-table Database

    1. Overview

    2. SQL

    3. Exercise: INSERT Clause

    4. SELECT & FROM Clauses

    5. WHERE Clause

    6. EXERCISE: Fetching Data

    7. DISTINCT Clause

    8. ORDER BY Clause

    9. LIMIT/TOP Clause

    10. EXERCISE: Ordering Table

    11. UPDATE & SET Clause

    12. DELETE Clause

    13. Task: Modifying The Database

    14. Recap Modifying a Database

    15. Basic Queries

    1. Overview

    2. What is a DBMS

    3. Why use a DBMS

    4. EXERCISE: Installing DBMS

    1. Overview

    2. Types of JOINs

    3. INNER JOIN

    4. IMPORTING Database

    5. EXERCISE 1: Combining Multiple Tables

    6. EXERCISE 2: Combining Multiple Tables

    7. LEFT Join

    8. Right JOIN

    9. EXERCISE: Including Extra Records

    10. FULL JOIN

    11. UNION ALL Clause

    12. Task

About this course

  • $20.00
  • 40 lessons

Discover your potential, starting today

Enroll today
 
Your Player Snips Are Ready to Copy: Watch the Getting Started Video Hover over each one to get the Player Snip code. Then in another window, open your course curriculum. Find the lesson you wish to place the snip into and put the editor into code view. After putting the editor in code view, paste in the Player Snip. Once the snip is pasted, get out of code view, save the course and then preview the lesson sinde the course player. See the latest updates  

Welcome To Player Snips

Please watch the getting started video below before you begin using your new superpowers

SHOW POPUP