Skip to main content
O'Reilly home
    • Sign In
    • Try Now
    • Teams
      • For business
      • For government
      • For higher ed
    • Individuals
    • Features
      • All features
      • Courses
      • Certifications
      • Interactive learning
      • Live events
      • Answers
      • Insights reporting
    • Blog
    • Content sponsorship

Data Modeling for Azure Data Services by Peter ter Braake

Get full access to Data Modeling for Azure Data Services and 60K+ other titles, with a free 10-day trial of O'Reilly.

There are also live events, courses curated by job role, and more.

Start your free trial

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.

Start your free trial

About O’Reilly

  • Teach/write/train
  • Careers
  • Press releases
  • Media coverage
  • Community partners
  • Affiliate program
  • Submit an RFP
  • Diversity
  • O’Reilly for marketers

Support

  • Contact us
  • Newsletters
  • Privacy policy
linkedin-logo youtube-logo

International

  • Australia & New Zealand
  • Hong Kong & Taiwan
  • India
  • Indonesia
  • Japan

Download the O’Reilly App

Take O’Reilly with you and learn anywhere, anytime on your phone and tablet.

Apple app store Google play store

Watch on your big screen

View all O’Reilly videos, Superstream events, and Meet the Expert sessions on your home TV.

Roku Payers and TVs Amazon appstore

Do not sell my personal information

O'Reilly home

© 2023, O’Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners.

Terms of service • Privacy policy • Editorial independence

Don’t leave empty-handed

Download a free report before you go.

Cover of DevOps and Business

DevOps and Business

Get it now
Cover of Multicloud Architecture Migration and Security

Multicloud Architecture Migration and Security

Get it now
Cover of Machine Learning at Enterprise Scale

Machine Learning at Enterprise Scale

Get it now

Check it out now on O’Reilly

Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.

Start your free trial Become a member now