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.

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.

 

View Enrollment Sessions

About Course

Outline

  • Set operators
  • Nested queries
  • Basic arithmetic and date functions
  • Basic table operations

Objectives

  • Understand set operations
  • Create simple nested queries
  • Create tables, insert data in a variety of ways, update and modify table structure, delete data and tables

Tools

Free-tier access to Google Cloud Big Query

Prerequisites

• Basic SQL syntax • Basic understanding of tables and database structure

Enroll

Interested in taking this class? Enroll in one of the sessions below!

3/4/2021

3:00 PM - 5:00 PM

Location: Online

7 seats left!

Enroll

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

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