125 Summer Street 13th Floor
Boston MA 02110
Follow this workshop series to get an email the next time it’s scheduled.
Sign-up not required
SQL provides powerful but reasonably simple tools and concepts for analysis and processing of data. We’ll cover the use of queries to combine data from a variety of tables, as well as for analysis and workflow tasks. This workshop will take absolute beginners through the basics of SQL to an ability to write queries with confidence.
Session I: Basics of database setup and single table queries
Session II: Using JOIN to combine data from two tables into a single table
Session III: Using subqueries to bring data and analyses into a query - Use of simple subqueries in query expressions - Strategies for using simple subqueries - Use of correlated subqueries
Basic technical aptitude and orientation to computers, and curiosity to learn new tools. Willingness to learn about a text-based / principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.
We will be pausing to let students run and write queries of their own, so students should bring laptops with an installed SQL implementation (MySQL, Postgres, SQL Server; Access is strongly discouraged). Instructions for installing MySQL will be distributed prior to class.
Enter your email to start following
You’re following A Practical Introduction to SQL.
Start following any program. No need to enter your email again.