Table of Contents
Preface
Section 1 – Operational/OLTP Databases
Chapter 1: Introduction to Databases
Overview of relational databases
Files
Relational databases
Introduction to Structured Query Language
Different categories of SQL
Understanding the database schema
Impact of intended usage patterns on database design
Understanding relational theory
Pillar 1 – Elements of a set are not ordered
Pillar 2 – All elements in a set are unique
Keys
Types of keys
Choosing the primary key
Integrity
The Check and Unique constraints
Types of workload
OLTP
OLAP
Summary
Chapter 2: Entity Analysis
Scope
Project scope
Product scope
Understanding entity relationship diagrams
Entities
Understanding super- and sub-entities
Naming entities
Relationships
Types of ...
Get Data Modeling for Azure Data Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
