Intro to Databases Posted Lectures as of Sep 28W11

Do you want a preview of what you'll learn when you take Stanford's FREE Introduction to Databases class? Here are the posted lectures as of Sep 28, Wednesday, 2011. The class officially starts on Oct 10M11 but they have decided to have a few lectures and assignments posted in advanced.

Database Class Preview:

INTRODUCTION

• Introduction to the course (14 min)

RELATIONAL DATABASES

• The relational model (9 min)
• Querying relational databases (6 min)

XML DATA

• Well-formed XML (13 min)
• DTDs, IDs & IDREFs (18 min)
• XML Schema (13 min)

RELATIONAL ALGEBRA
Prerequisite: Relational Databases

• Select, project, join (18 min)
• Set operators, renaming, notation (20 min)

SQL
Prerequisite: Relational Databases; Recommended: Relational Algebra

• Introduction to SQL (5 min)
• Basic SELECT statement (10 min)
• Table variables and set operators (11 min)
• Subqueries in WHERE clause (20 min)
• Subqueries in FROM and SELECT (8 min)
• Aggregation (25 min)
• NULL values (6 min)
• Data modification statements (15 min)