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
-----------------------------------------------
A Level Computer Science Crash Course 👉🏼 https://rebrand.ly/fodp90j
📹 SUBSCRIBE
------------------------------------------------
Subscribe to learn more about Computer Science: http://bit.ly/3YWK1VT
⏳ 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
------------------------------------------------
Chapter 1 - • Decimal, Binary and Hexadecimal Number Sys...
Chapter 2 - • IPv4 vs IPv6, Subnetting, Type of IP addre...
Chapter 3 - • Drawing Logic Circuit - A Level Computer S...
Chapter 4 - • Tracing Assembly Language with Trace Table...
Chapter 5 - • Program Libraries - A Level Computer Scien...
Chapter 8 - • File-based vs Relational database - A Leve...
🎥 PAPER 2️⃣ PLAYLIST
------------------------------------------------
Chapter 9-12 - • A Level Computer Science 9618 Paper 2: Lin...
🌎 LINKS
------------------------------------------------
Website - https://www.haguin.school
Email - [email protected]
#alevelcomputerscience
#InnerJoin
#SQLjoin
#Database101
#DataManipulationLanguage