Intermediate SQL

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

What can you do next after you have mastered the ability to combine and join data from different tables in your database? What can you do to transform your data and make them meaningful? Intermediate-level training will teach you how to organize, filter and categorize data within relational databases. This training will help you increase your SQL knowledge and solve difficult questions. You will learn CASE statements, subqueries, and window functions. Through the European Soccer Database, you'll also discover interesting facts about football.

Course Overview

Virtual Labs

Job Assistance

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Joining Data in SQL is recommended to take first

What You Will Learn

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL

You will learn the robust use of CASE statements, subqueries, and window functions—all while discovering some interesting facts about soccer using the European Soccer Database

Course Content

Expand all sections

Module 1: We'll take the CASE

Module 2: Short and Simple Subqueries

Module 3: Correlated Queries, Nested Queries, and Common Table Expressions

Module 4: Window Functions

Course Instructors

Mona Khalil

Data Scientist, Greenhouse Software

As a senior data scientist at Greenhouse, Mona answers questions related to how the hiring process can be improved to find better candidates quicker and reduce bias in the hiring process. They previo...