|
Introduction to Relational Databases is a book for beginners interesting in learning the fundamental concepts of databases. The book teaches the user how to install a MySQL database and walks them through setting up a sample database, describing the how and why for each step.
Book Outline
1) History of database concepts
2) Intro to relational databases
3) Installing and configuring MySQL
a) Downloading MySQL
b) Installing MySQL
c) Your first database
4) RDBMS Design Considerations
a) Data Integrity
b) Referential Integrity
c) Data Duplication
d) Normalization
e) Description of real-world problem (pet shop) and proposed RDBMS
design solution
5) Queries
a) Data Definition Language (DDL)
b) Data Manipulation Language (DML)
c) SQL Basics
d) SQL Functions
e) Data Aggregation
f) Running reports on our pet shop database
6) Summary |