Table Design

suggest change

Remarks

The Open University (1999) Relational Database Systems: Block 2 Relational Theory, Milton Keynes, The Open University.

Found a mistake? Have a question or improvement idea? Let me know.

Table Design:

*Table Design

*Properties of a well designed table.

Table Of Contents

0Getting started with SQL

1SELECT

2JOIN

3Example Databases and Tables

4UPDATE

5Indexes

6CREATE TABLE

7UNION, UNION ALL

8ALTER TABLE

9CASE

10INSERT

11Primary Keys

12ORDER BY

13GROUP BY

14Filter results using WHERE and HAVING

15Window Fnctions

16Common Table Expressions

17Views

18LIKE operator

19Functions Aggregate

20DELETE

21String Functions

22Data Types

23AND OR operators

24Triggers

25TRUNCATE

26MERGE

27Foreign Keys

28Finding Duplicates on a Column Subset with Detail

29Sequence

30Comments

31Subqueries

32Execution blocks

33Stored Procedures

34DROP Table

35Row number

36Transactions

37CREATE FUNCTION

38SQL Group by vs. Distinct

39Table Design

40CROSS APPLY and OUTER APPLY

41Synonyms

42CREATE database

43SKIP TAKE pagination

44EXPLAIN and DESCRIBE

45Information Schema

46IN clause

47NULL

48SQL Injection

49Cascading Delete

50Order of Execution

51DROP or DELETE database

52EXCEPT

53TRYCATCH

54XML

55GRANT and REVOKE

56Functions ScalarSingle Row

57Relational Algebra

58EXISTS CLAUSE

59Materialized Views

60Functions Analytic

61SQL CURSOR

62Identifier

63Clean Code in SQL

64Contributors