Techways
Menu
Home
About Us
News
Student Projects
Blog
Courses
Learner Courses
Teacher Courses
Events
IEB-TechWays AI Hackathon
Webinars & Workshops
Contact Us
FAQs
Login
Menu
Home
About Us
News
Student Projects
Blog
Courses
Learner Courses
Teacher Courses
Events
IEB-TechWays AI Hackathon
Webinars & Workshops
Contact Us
FAQs
Login
Start now
SQL Databases
Current Status
Not Enrolled
Price
R700
Get Started
Sign-up now
SQL Databases
Click here to start
Course Content
Expand All
Welcome
2 Topics
Sample Chapter
Expand
Chapter Content
0% Complete
0/2 Steps
Background
Overview
Databases
6 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/6 Steps
Understanding Databases
Types of Databases
QUIZ: Databases
Databases
EXERCISE: Database Design
Table Design
TASK: Design a Single-table Database
Basic Queries
13 Topics
|
1 Quiz
Expand
Chapter Content
0% Complete
0/13 Steps
SQL
EXERCISE: INSERT Clause
SELECT & FROM Clauses
WHERE Clause
EXERCISE: Fetching Data
DISTINCT Clause
ORDER BY Clause
LIMIT/TOP Clause
EXERCISE: Ordering Table
UPDATE & SET Clause
DELETE Clause
TASK: Modifying the Database
QUIZ
Basic Queries
Database Management System (DBMS)
3 Topics
Expand
Chapter Content
0% Complete
0/3 Steps
What is a DBMS?
Why use a DBMS?
EXERCISE: Installing DBMS
Multi-Table Queries
11 Topics
Expand
Chapter Content
0% Complete
0/11 Steps
Types of JOINs
INNER JOIN
Importing Database (Detour topic)
EXERCISE 1: Combining Multiple Tables
EXERCISE 2: Combining Multiple Tables
LEFT JOIN
RIGHT JOIN
EXERCISE: Including Extra Records
FULL JOIN (For Your Information)
UNION ALL Clause
TASK
Recap
Login
Accessing this course requires a login. Please enter your credentials below!
Username or Email Address
Password
Remember Me
Lost Your Password?