ALl Classes + Events

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.

Lunch will be provided.

sql-fbObjectives

At the end of this workshop, students should be able to:

  • Use entity-relationship modeling to build a logical database schema
  • Install a Postgresql database on a cloud-hosted server
  • Build a physical database schema using SQL Data Definition Language
  • Use foreign keys to enforce data integrity
  • Load data into a database interactively and in bulk
  • Query a database using SQL SELECT statements
  • Use joins to create queries that span multiple tables
  • Manipulate data using SQL UPDATE and DELETE statements
  • Improve performance using indexing
  • Understand what the most critical security considerations are when exposing a database to users
  • Understand what people mean by NoSQL, and when to consider using it

You can find a more detailed course outline here.

Prerequisites

  • Students will find it easier to understand relational database concepts if they have some basic familiarity with spreadsheets.
  • We will be using text editors and command-line terminal applications to create, populate and manipulate our database.
  • All Windows and Macintosh machines have plenty of built-in and/or freely available text editor and terminal options, and previous experience is not required. However, students may wish to brush up a bit on the available options in advance of the class.

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

Location

This workshop will be held at Betamore’s campus on the 4th Floor at 1111 Light Street, Baltimore, MD 21230. For parking + directions visit: bit.ly/betamorepark

Reserve Your Spot Now

  • date_range
    Fri, Mar 24th

    8:30am – 5:30pm

    Instructor
    Photo of Doug Lay
    Doug Lay

    Vice President of IT at DinnerTime.com

    Doug Lay is the Vice President of IT at DinnerTime.com, the most highly customizable meal planning application on the Internet.  DinnerTime was a 2014 finalist in the DBED InvestMaryland challenge.  Prior to joining DinnerTime, Doug was Director of Web Technology at the highly-trafficked USNews.com Web site.  Doug has a Master of Library Science degree from the University of Maryland and a Master of Computer Science degree from Johns Hopkins University.  During the rare times that Doug isn’t working or exploring the Internet, he enjoys hiking, cooking, banging on the drums and listening to every kind of music under the sun.

Stay Connected

Sign up for our weekly list of classes & events