Feb 24: Final Application Deadline for Spring Bootcamp! Apply Now

SQL

Foundations

Details

PREREQUISITES

Basic analytics experience

LENGTH

2 Days

LOCATION

On-site or Live Online

STUDENT PROFILE

Analysts or those who work with data in similar analytical roles

Course Description

This course provides foundational SQL skills for data and analytics professionals. Attendees will learn how to use SQL to create and modify tables, retrieve and analyze data, and combine tables using joins. This course is geared towards individuals who have little to no SQL experience and work regularly on analytics projects. Lessons incorporate both lectures and hands-on exercises with a focus on cultivating practical skills.

We offer in-person training, as well as remote training via our Live Online technology. We are able to blend these capabilities so we can teach your entire team, even if they’re not all in one place.

Course Outcomes

Upon completion of the course, attendees should be able to:

Use SQL to store, retrieve, wrangle, and analyze data.

Training Content

DAY 1:

Introduction to Databases & SQL

Introduction to relational databases

SQL flavors

Tables

SQL data types

Queries

Aggregate functions

DAY 2:

Joins and Subqueries

Review Day 1

Combining data with joins

Working with subqueries

Client Testimonial

I would recommend Metis because of their training approach to SQL. They emphasized working through practical examples as compared to concentrating on theoretical aspects.

SQL FOUNDATIONS STUDENT

Details

PREREQUISITES

Basic analytics experience

LENGTH

2 Days

LOCATION

On-site or Live Online

STUDENT PROFILE

Analysts or those who work with data in similar analytical roles