A database is a specialized program for storing large amounts of data in a way that can be searched and retrieved efficiently. For instance, a popular website like Amazon.com uses databases to store product and customer information. The most commonly used databases are relational databases, which structure data in the style of the relational model. The programs we write typically communicate with a relational database using a query language called SQL (pronounced “sequel”, Structured Query Language).
Please read: SQL for Web Nerds
Week 1
Relational Databases - Lecture 1
Practice SQL Queries 1
Week 2
Week 3
Relational Databases - Lecture 4
Practice SQL Queries 2
Week 4
Relational Databases - Lecture 5
Week 5
Relational Databases - Lecture 6
Project
Send and email to Michael McGuire authorizing him to add you to the Academic Alliance to download the software necessary. (Download SQL and Windows Server)
Install Windows Server (2008 or 2012) - Watch this video to learn how
Install SQL Server (Enterprise is OK) - You might need to install the prerequisites. Watch this!
Make sure when you install SQL if there is an option to install the sample databases do so.
Other Resources:
- Database Tutorials