SQL
- ACID
- BASE
- Connection Pool
- DAO vs. Repository
- DbCommand/IDbCommand/SqlCommand
- Foreign Key Mapping
- Indexes/Indices
- MySQL
- Primary Keys
- Referential Integrity
- Service Broker
- SqlLocalDB
- utility
- connection string
(localdb)\MSSQLLocalDB
- SQL Server 2016 Express LocalDB
- registry entries:
HKEY_CURRENT_USER\SOFTWARE\Microsoft\Microsoft SQL Server\UserInstances\{GUID}
,HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\RefCount\SqlLocalDB13
- String search db stored proc
- Table schema
- Temporary Tables
- Views
- Sample databases
- PostgreSQL