Applying SQL to Real-World Problems

DataCamp

(3)

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Now you are ready to learn SQL basics to develop practical skills. This course will be using a database that was created by a fictional rental company. The database is complex and large so you'll be able see the problems of working with databases. This course will teach SQL skills that can be used to solve business-driven questions. This course will give you the skills to find the tables you need. This will enable you to manage data in the views and tables you create. This will allow you to create code that communicates clearly your intent and is easily read.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Find tables, store and manage new tables and views, and write maintainable SQL code to answer business questions

You will learn new skills that will empower you to find the tables you need

You will then learn how to store and manage this data in tables and views that you create

Course Content

Expand all sections

Module 1: Use Real-World SQL

Module 2: Find Your Data

Module 3: Manage Your Data

Module 4: Best Practices for Writing SQL

Course Instructors

Dmitriy Gorenshteyn

Lead Data Scientist at Memorial Sloan Kettering Cancer Center

Dmitriy is a Lead Data Scientist in the Strategy Innovation department at Memorial Sloan Kettering Cancer Center. At MSK he develops predictive models for programs aimed at improving patient care. Pr...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%