Introduction to Database Systems Modeling and Administration

James M. Reneau Ph.D.

  • Table of Contents and Chapter Material
  • Sample Databases
  • Author Bio
  • Purchase

Table of Contents and Material

Introduction

Chapter 1 – What is a Model and Why Model Data?

Chapter 2 – Entities

Chapter 3 – Relationships Between Entities (CDM)

Chapter 4 – Attributes

Chapter 5 – Keys

Chapter 6 – Logical Data Model (LDM)

Chapter 7 – SQL Selecting Data

Chapter 8 – Arithmetic Operators, Selected Numeric Functions and Aliasing a Column

Chapter 9 – SQL Limiting Rows

Chapter 10 – SQL Order Matters

Chapter 11 – Normalization and the Physical Data Model

Chapter 12 – SQL Joining Tables

Chapter 13 – SQL Aggregate Functions

Chapter 14 – SQL Grouping data.

Chapter 15 – SQL Dates, Times, and DateTimes

Chapter 16 – SQL A Few String Functions

Chapter 17 – SQL Attribute Logic

Chapter 18 – SQL Maintain Tables and Indexes

Chapter 19 – SQL Inserting, Modifying, and Deleting Data

Chapter 20 – SQL Subqueries

Chapter 21 – SQL Variables and Stored Procedures

Appendix A – Sample SQL Databases

Resources

Introduction to Database Systems Modeling and Administration

Resources and more for the book.

  • Privacy Policy

C) 2025 James M. Reneau Ph.D. – All Rights Reserved

Designed with WordPressC