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.
Related Blog Posts
More Courses for Your Team