Query Data with SQL - A Level Computer Science 9618

Published: 01 January 1970
on channel: Haguin School

6,973

172

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 - haguin.school@gmail.com

#alevelcomputerscience
#SQLqueries
#DataManipulationLanguage
#DatabaseQuerying
#9618Paper1

On this page of the site you can watch the video online Query Data with SQL - A Level Computer Science 9618 with a duration of hours minute second in good quality, which was uploaded by the user Haguin School 01 January 1970, share the link with friends and acquaintances, this video has already been watched 6,973 times on youtube and it was liked by 172 viewers. Enjoy your viewing!

523