SQL in 10 Minutes - Access SQL Beginner Lesson
In this video I cover the following book Sams Teach Yourself SQL in 10 Minutes, Fourth Edition located at Amazon at the following link: https://www.amazon.com/gp/product/B00...
Topics covered in this Access SQL video include:
SELECT statements
SELECT multiple columns
SELECT all columns
ALIAS AS
WHERE to filter tables
Table relationships
Primary Keys
Foreign Keys
Enforce Referential Integrity
ORDER BY
WHERE with AND and OR
WILDCARD *
WILDCARD ?
WILDCARD []
Concatenate with +
RTRIM, LTRIM, and TRIM
Mathematical calculated field with +, -, /, and *
NOW Function
COUNT Function
ABS Function
Sum Function
DATEPART
YEAR Function
GROUP BY Clause
HAVING Clause (Same as WHERE FILTER but used on GROUPS)
SELECT SUBQUERIES
Multiple SELECT Subqueries
Inner Join
Left Join
Right Join
UNION
UNION ALL
SELECT INTO
INSERT INTO
UPDATE
UPDATE multiple columns
UPDATE with NULL
DELETE column
CREATE TABLE
ALTER TABLE
DROP COLUMN
DELETE TABLE
CREATE TABLE with REFERENCES for foreign KEY
CREATE TABLE with PRIMARY KEY
CREATE TABLE NULL vs NOT NULL