Query Data with SQL - A Level Computer Science 9618
Discover how to write SQL scripts to query database tables using essential Data Manipulation Language (DML) commands like SELECT FROM, WHERE, ORDER BY, GROUP BY, SUM, COUNT, and AVG. This video tutorial also demonstrates how to use advanced commands like AND and LIKE in your WHERE clause for more precise data retrieval.
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:11 DML Query Commands
01:03 How to Write a DML Query
01:31 WHERE
02:43 ORDER BY, COUNT, GROUP BY
04:54 AND
05:36 LIKE, SUM
06:47 AVG
07:25 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...
🌎 IMPORTANT LINKS
------------------------------------------------
Website - https://www.haguin.school
Email - [email protected]
#alevelcomputerscience
#SQLqueries
#DataManipulationLanguage
#DatabaseQuerying
#9618Paper1