 | Introduction
 | Relations |
| Data normalization |
| Keys: primary v foreign |
| SQL
 | Data Definition Language (DDL)
| Create/drop table |
| Create/drop index |
|
| Data Manipulation Language (DML)
|
|
| Joins |
|
| Overview of Legacy Database APIs
| Open Database Connectivity (ODBC) |
| Remote Data Object (RDO) |
| Data Access Object (DAO) |
| Embedded SQL |
| DB-Library |
|
| Object Linking and Embedding/Database (OLE DB)
| UDA support web based application |
| MDAC implements UDA |
| MDAC includes ODBC, OLE DB and ADO |
| OLE DB Servers |
| ADO and Web scripting |
| C++ and Visual Basic |
| Wizards support OLE DB record sets |
|
| Active Data Objects
| Connections |
| Commands |
| Recordsets
| Paging |
| Filtering |
| Indexing |
| Sorting |
|
| Data shaping |
| Remote Data Services (RDS) |
|
| ADO.NET
| Connections |
| Commands |
| Datasets replace Recordsets |
| Adapters |
| Readers |
| OleDB v. SQL classes |
|
