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.

Instructor
Mary Clair Thompson | Office of Information Technology
I am a Data Engineer and Data Scientist on OIT’s Data Analytics team, with previous industry experience working with big data in the cloud.

This class will be hosted via Zoom. You will receive an email with the Zoom link a day before the class. Attendance will be taken and the session will be recorded.

About Course

Outline

  • Temporary tables
  • Window functions
  • Partitions, ordering, and bounds for window functions

Objectives

  • Construct appropriate temporary tables in the context of writing complicated queries
  • Understand how to use a variety of window functions properly
  • Use bounds correctly for windows

Tools

Free-tier access to Google Cloud Big Query

Prerequisites

SQL – Grouping, Joins, and Aggregations (2/3) OR • Some level of proficiency with SQL syntax and table structure

This class is part of our Databases Track

See the whole track

Suggested Courses

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 – 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

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

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