9618 - A Level - Paper 1 Databases: All SQL syntax
ฝัง
- เผยแพร่เมื่อ 21 ก.พ. 2024
- The SQL syntax is not too complicated to understand, but it's a pain to memorise it all. That's why I created a list of 19 simple questions to help you out!
Download the exercises and solutions: paulgieske.gumroad.com/l/xpedx
In this video we cover all the SQL syntax for the Cambridge International A Level syllabus 9618.
DML (Data Manipulation Language): - SELECT - WHERE
- ORDER BY - SUM - COUNT - AVG - INSERT INTO - DELETE FROM - UPDATE - GROUP BY - INNER JOIN
DDL (Data Definition Language): - CREATE DATABASE - CREATE TABLE - ALTER TABLE - PRIMARY KEY - FOREIGN KEY … REFERENCES …
Very helpful sir. Thank you a lot.
Create more videos about AS Computer science. Need them really much
Amazing!
Thanks!
But more and simpler explanation for the 10th question would be much appreciated!
Thanks again!
It's amazing video, a few variations and possible mistakes, but as a refresher it's amazing. THANK YOU!!!
Thanks. Let me know in the comments if you saw a specific mistake.
what is "inner left"?
Don't worry, it's not on the syllabus. But basically it is the same is inner join, but while inner join only shows the records where both keys match, inner join left shows all records in the left table.