Inner Join with SQL - A Level Computer Science 9618

This video explains the concept of inner join in data manipulation language and demonstrates how to perform it using two tables with different data but matching columns. The tutorial uses an example of finding a student's name who took a particular course on a specific date, and shows how to do it using both a manual process and a single step process using inner join.

Whether you're a student preparing for the Cambridge International AS & A Level Computer Science 9618 Paper 1 exam on Chapter 8: Databases or a professional seeking to broaden your knowledge, this video is ideal for you.

🔥 EXAM RESOURCES
-----------------------------------------------

📹 SUBSCRIBE
------------------------------------------------

⏳ TIMESTAMPS
------------------------------------------------
00:00 Intro
00:04 What You Will Learn
00:09 What is Inner Join
00:29 Method 1
05:57 Method 2
06:48 Past Year Question

🎥 PAPER 1️⃣ PLAYLIST
------------------------------------------------

🎥 PAPER 2️⃣ PLAYLIST
------------------------------------------------

🌎 LINKS
------------------------------------------------

#alevelcomputerscience
#InnerJoin
#SQLjoin
#Database101
#DataManipulationLanguage

[ibrahimsiddiqui]

5:36 can we SELECT only STUDENT.StudentName if we want only the name and not the coursename or coursedate?

[huzaifasohail]

Sir will you upload about the topic normal forms in databases ?

[sofiaburdun]

Would the first line "SELECT COUNT (DEVICE.DeviceID)" or " SELECT COUNT (DEVICE.DeviceID), STAFF.StaffID, DEVICE.Staff ID"
be correct ?

[nourmuneer]

why did you select coursename and course date when the question only requires student name

[ibrahimsiddiqui]

SELECT COUNT(DEVICE.DeviceID)
FROM STAFF, DEVICE
WHERE STAFF.FirstName = "Ali" AND STAFF.LastName = "Khan"
AND STAFF.StaffID = Device.StaffID;

[nourmuneer]

SELECT DEVICE.DeviceID FROM
DEVICE, STAFF
WHERE STAFF.FirstName = 'Ali' AND STAFF.LastName = 'Khan'
AND STAFF.StaffID = DEVICE.DeviceID;

[nnwld]

SELECT COUNT(DEVICE.DeviceID), STAFF.FirstName, STAFF.LastName
FROM STAFF
INNER JOIN DEVICE
ON STAFF.StaffID=DEVICE.StaffID
WHERE STAFF.FirstName='Ali' AND STAFF.LastName='Khan';

[alaabadwi]

SELECT STAFF.FIRSTNAME, STAFF.LASTNAME, DEVICE.COUNT(DEVICEID)
FROM STAFF, DEVICE
WHERE STAFF.FIRSTNAME="Ali" AND STAFF.LASTNAME="Khan"
AND STAFF.STAFFID=DEVICE.STAFFID
please tell me if im wrong

[maramatif]

SELECT COUNT(DeviceID)
FROM DEVICE
INNER JOIN STAFF
ON STAFF.StaffID = DEVICE.StaffID
WHERE STAFF.FirstName = "Ali" AND STAFF.LastName = "Khan"

[kingzmash]

SELECT COUNT(DEVICE.DeviceID), STAFF.StaffID, DEVICE.StaffID
FROM STAFF
INNER JOIN DEVICE
ON STAFF.StaffID = DEVICE.StaffID
WHERE STAFF.FirstName = 'ALI' AND STAFF.LastName = 'Khan';