SQL in 10 Minutes - Access SQL Beginner Lesson

preview_player
Показать описание

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
Рекомендации по теме
Комментарии
Автор

I know you had set this up for Access. I went the Microsoft SQL Server Management route. Did you do the initial setup for that also by chance? And if so I was following the initial setup and got stuck on the last 2 steps thinking that they were incomplete.
9. Copy and paste contents if Populate
(Where exactly does this get pasted?)
10. Test it with SELECT * FROM Customers; (How do you run a test?)

daylarfarshot
visit shbcf.ru