Intermediate SQL

Name: Intermediate SQL
Brand: Careervira
Price: 74 USD
Availability: InStock
Rating: 1 (1 reviews)

via

DataCamp

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

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