日本综合久久_特级丰满少妇一级aaaa爱毛片_91在线视频观看_久久999免费视频_99精品热播_黄色片地址

   SQL in Microsoft Access培訓

RDBMS (Relational DataBase Management System)
Relational Operators
SQL as Declarative Language
SQL Syntax
SQL Sublanguages DQL, DML, DDL, DCL
DQL (Data Query Language) in Detail
SELECT clause
Column aliases
Table aliases
Date types and Date functions
Group function
Table joins
JOIN clause
UNION operator
Nested queries
Correlated subqueries
DML (Data Manipulation Language) Overview
Inserting rows (INSERT)
Inserting rows using subquery
Updating rows (UPDATE)
Deleting rows (DELETE)
DDL (Data Definition Language) Overview
Creating, altering and dropping objects (CREATE, ALTER, DROP)
Creating tables using subquery (CREATE TABLE .... AS SELECT...)
CONSTRAINTS Overview
NULL i NOT NULL
CONSTRAINT clause
ENUM type
SET type
PRIMARY KEY
UNIQUE
FOREIGN KEY
DEFAULT clause
Transactions Overview
COMMIT
ROLLBACK
SAVEPOINT
Implicit and explicit rollbacks and commits
SQL Dialects Overview
MySQL
Microsoft Access and SQL Server
Oracle and PostgreSQL