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.
Visit website for registration details.