Intro to Relational Databases + SQL
Relational databases are the world’s most popular tool for storing digital information, populating everything from billion-user web applications and large enterprises to tiny embedded systems. This course will teach you how to design, create, and query a relational database, using the industry-standard Structured Query Language (SQL). We will take a hands-on approach, working as a group and individually to build a database powering the operations of a hypothetical web/mobile startup.
Class exercises will use the Postgresql relational database management system (RDBMS) running on cloud-hosted Amazon Web Services instances. Postgresql is a powerful open-source RDBMS that is widely used to power Web and mobile applications. Very little of the class material is specific to Postgresql. Most of what we learn will apply to any modern RDBMS, including MySQL, SQLite or Microsoft SQL Server.
Instructor: Doug Lay, Vice President of IT at DinnerTime.com
What to Bring:
A laptop (OS X, Windows or Linux, it doesn’t matter)
All participants will need Amazon Web Services accounts, as database development will be done on AWS virtual machines. The virtual machines we are using are free of charge, but AWS signup does require a credit card
Lunch will be provided.