Free Preview: Relational Databases

A History Mini-Lesson

04:09

A History Mini-Lesson

Even if you haven’t studied relational databases, you’ve probably heard some of the lingo flung around online. In this screencast, we put some of those terms into context to give you a better understanding of our topic. We also look at some of the history of the relational model.

1.Introduction
1 lesson, 01:31

Free Preview
1.1
Introduction
01:31

2.History and Terms
3 lessons, 17:06

Free Preview
2.1
A History Mini-Lesson
04:09

2.2
Codd's Twelve Commandments
08:21

2.3
Terminology
04:36

3.Relational Components
5 lessons, 38:40

3.1
Data Types
08:07

3.2
Primary Keys
07:36

3.3
Foreign Keys and Relationships
07:46

3.4
Normalization
07:31

3.5
Queries
07:40

4.Database Usage
6 lessons, 29:51

4.1
Views
06:09

4.2
Database Servers and Users
03:08

4.3
Designing a Data Model
04:55

4.4
A Practical Look at SQLite: Part 1
07:13

4.5
A Practical Look at SQLite: Part 2
06:45

4.6
Other Database Models
01:41

5.Conclusion
1 lesson, 00:18

5.1
Conclusion
00:18


About Andrew Burgess
Hi! I'm Andrew Burgess, a Staff Writer here on Tuts+. I've been hanging around the Tuts+ since early 2009; I discovered the site when I was looking for an introduction to jQuery. Since discovering the site, my web development skills have skyrocketed; I think that's the default experience! Now, I've been writing for Tuts+ regularly since late 2009. I've been working with the computers since I was pretty young, and with the web since 2006. I've dabbled with over a dozen programming languages, but I'm most comfortable in JavaScript and Ruby. Currently, I'm a university student, studying computer science.
+ Expand Bio- Collapse Bio