Databases Track

Introduction

Any web application requiring data to be inputted or accessed by users or administrators needs that data to be stored somewhere. Data storage is typically synonymous with databases. In this track on databases you will be introduced to the different concepts and utilization of databases on the web.
This track is offered in collaboration with the Master in Interdisciplinary Data Science (MIDS) program, and aims to provide classes to get you up and running quickly with SQL databases, from basic concepts to more advanced features.

Upcoming Roots Sessions

Course Location Date Time

Roots Workshops

Active Courses

Inactive Courses

These are courses that we've offered in the past, and hope to offer again in the future. Check back again soon to see if we have a session planned for these courses, or sign up for our newsletter to hear when we announce new opportunities.

Course Graphic

Intro to Databases

Come to this course to learn about databases and their importance across a multitude of fields. This class will provide students with a basic introduction to what databases are and how to interact with them.

Learn More
Course Graphic

Intro to mySQL

Take this class to learn more about databases. This course will provide students with a basic introduction to the popular open source Database Management System (DBMS) named “MySQL”.

Learn More
Course Graphic

SQL for Data Scientists: Baseline coverage of most important SQL concepts (1/2)

Baseline coverage of most important aspects of SQL. Participants will learn the basics of schemas, data types, constraints, and how to debug SQL queries. The goal of this class is to provide a strong foundation for learning more advanced SQL in the future.

Learn More
Course Graphic

SQL for Data Scientists: Advanced concepts, RDBMS features, related technologies (2/2)

Baseline coverage of most important SQL concepts, deeper dive into some core concepts, examine some related concepts such as security, DBA, performance. This is part 2 of a 2-part course.

Learn More
Course Graphic

SQL – Beyond the Basics (1/3)

This course will provide an introduction to intermediate SQL concepts, including data manipulation with built-in arithmetic and date functions, set operations, and nested queries. The skills gained in this course will allow users to answer a variety of questions about their data.

Learn More
Course Graphic

SQL – Grouping, Joins, and Aggregations (2/3)

This course will provide an introduction to a few advanced sql concepts, including grouping and aggregations. Users will also learn the differences between the various types of joins.

Learn More
Course Graphic

SQL – Temporary Tables and Windows (3/3)

This course will show students how to create and use temporary tables when constructing queries, and provide an introduction to the concept of windowing. Students will also learn how to apply bounds to their windows for advanced data analysis.

Learn More