00. Intro (5:02)
01. Creating a Table (14:32)
Importance of SQL table design
CREATE TABLE command
TEXT field
Length of a TEXT field
Multiple Fields
Make a text box to hold our SQL
Bind SQL form to table
DROP TABLE
02. Access SQL Data Types (8:30)
Access to SQL Aliases
TEXT
MEMO
BYTE
SMALLINT
INTEGER
SINGLE
DOUBLE
CURRENCY
COUNTER
DATETIME
YESNO
OLEOBJECT
Hyperlink
Attachment
Lookup
Start COUNTER at different value
Inflate AutoNumber value
SQL view in query designer
03. Indexing (14:32)
NULL
NOT NULL
PRIMARY KEY
UNIQUE
CREATE INDEX
CREATE UNIQUE INDEX
DROP INDEX
WITH DISALLOW NULL
WITH IGNORE NULL
WITH PRIMARY
ASC, DESC
04. Altering Tables (16:12)
ALTER TABLE
ADD COLUMN
ALTER COLUMN
DROP COLUMN
ALTER COLUMN NOT NULL
Altering tables in EXTERNAL databases
Cannot alter LINKED tables
Dim DB as database
OpenDatabase command
DB.Execute
Adding tables to external database
CREATE link to external table
05. Constraints (10:49)
CONSTRAINT
PRIMARY KEY
DROP CONSTRAINT
ADD CONSTRAINT
UNIQUE
Multi Field Index
Index spanning 2 or more fields
06. Relationships (9:37)
Relationships review
CONSTRAINT FOREIGN KEY
Relationships Window
07. ANSI-92 SQL (8:32)
Differences between 89 and 92
Wildcard characters
Switch database from 89 to 92
Broken queries
LIKE to ALIKE
08. CHECK & DEFAULT (11:24)
CHECK
CONSTRAINT CHECK
Multi Field CHECK Constraint
Table-Level Validation Rules
DEFAULT value
ALTER SET DEFAULT
ALTER DROP DEFAULT
09. Referential Integrity (6:16)
ON UPDATE CASCADE
ON DELETE CASCADE
10. VIEWS & PROCEDURES (11:08)
CREATE VIEW
Views vs. Queries
DROP VIEW
Parameters
CREATE PROCEDURE
Action Queries
Append, Delete, Update
EXECUTE procedure
DROP procedure
11. Database Security (11:44)
ALTER DATABASE PASSWORD
Open Exclusive Mode
GRANT, REVOKE
USER, GROUP
CREATE, ALTER, DROP
Privileges
SELECT, DELETE, INSERT, UPDATE
DROP, CREATE
SELECTSCHEMA, SCHEMA
UPDATEOWNER, CONNECT
12. Review (5:01)