Techways
Menu
Home
About Us
IEB TechWays A.I. Hackathon
News
Events
Student Projects
Blog
FAQs
Courses
Contact Us
Login
Menu
Home
About Us
IEB TechWays A.I. Hackathon
News
Events
Student Projects
Blog
FAQs
Courses
Contact Us
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?
