Are you a(n):
Or are you just generally curious about the best ways to view, analyze, and work with data to get stuff done? If so, this workshop is for you!
The Introduction to Databases workshop explores common methods used to work with data, including hierarchical and object models of data as well as spreadsheets. We’ll look at when these approaches work well and when they break down.We will introduce the relational model of data, and contrast the relational model with other approaches. We’ll learn how to build a simple but realistic database using the relational model, beginning with logical modeling and continuing with physical implementation in a relational database management system. In the second week of the class, we will learn how to query and update our relational database using the industry-standard Structured Query Language (SQL). We’ll examine best practices in database management, including relational, non-relational, and hybrid approaches to data management.
We will take a hands-on approach throughout, using a hypothetical e-commerce startup as the basis of most of our in-class examples. Course participants will also have the opportunity to design, populate and query databases in support of their own projects.
At the end of this workshop, students will be able to:
Some familiarity with spreadsheets is helpful, especially for course participants who come from a business background rather than a software development background. Prior programming experience is NOT required.
A laptop running a relatively current version of OS X, Windows or Linux. Course exercises will use SQLite, a simple, free, and powerful relational database management system that can be installed on any of the above platforms. (SQLite runs on Android and iOS as well but these platforms are NOT recommended for this class.) Note that installing SQLite on a laptop will require security permissions. If you are using a work laptop please check with your administrator.
This workshop will be held at Betamore’s City Garage campus at 101 W. Dickman Street, Baltimore, MD 21230. Parking is available onsite.
If you are looking for additional information on workshop details, please email firstname.lastname@example.org.
Sign up for our weekly list of classes & events