2.2.3 SQL - Revise GCSE Computer Science

Revise how to use an SQL command to get data from a database, find out about the three essential keywords: SELECT, FROM, and WHERE. Revise this important skill for GCSE Computer Science!
0:00 SQL and Databases
0:25 SELECT...FROM...WHERE
0:56 Running an SQL Query
1:57 Using multiple conditions
3:09 Using wildcards (* and %)

[albo]

Never seen it explained so simply and clearly thank you so much

[kluksy]

This guy is helping me achieve grade 9

[manny__]

Thank you so much for this one sir, very quick, helpful and easy to understand!

[emmet]

the fact I legit have a test about this tommorow and I was struggling so much on the topic this helped loads THANK U

[_Ali]

bro your the best man! really easy to understand, keep it up!

[oise]

Your videos are so helpful, thanks sm for keeping it short and simple, great for a quick revision

[quantumgaming]

nice video and got straight to the point

[daboss]

Easy to understand and very helpful thanks

[PedroPony]

Pls upload the rest of the spec, these videos are amazinggg

[adan]

The result shouldn't be included in your enquiry right?

[asarma]

Does this apply for the aqa 8525 specification for the gcse computer science paper 2?

[nlilley]

LIKE "M*", not LIKE "M%" surely? J277 spec? I know W3 Schools uses %, but it confuses the kids. And % is not allowed on the mark schemes I've seen for use as a wildcard.

[antonywarnes]

Thanks for this, though - why is it like "A%" and not "A*"?
Also, would be handy if you had a link to the previous video in the description - not always easy to find!