Introduction to SQL

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Beginner

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Data scientists transform raw data into actionable insights. Relational databases are structured tables. These databases store large amounts of data from all over the world, including transaction histories for customers and electronic medical records. Data scientists use these tables to modify and extract data using SQL language. This course will teach you syntax for SQL common to multiple databases such as PostgreSQL and MySQL. This course will provide all the information that you need to get started working with databases.

Course Overview

Virtual Labs

Job Assistance

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

You'll also learn about arithmetic in SQL and how to use aliases to make your results more readable

You'll learn about their structure, how to talk about them using database lingo, and how to begin an analysis using simple SQL commands to select and summarize columns from database tables

You'll learn how to use basic comparison operators, combine multiple criteria, match patterns in text, and much more

Course Content

Expand all sections

Module 1: Selecting columns

Module 2: Filtering rows

Module 3: Aggregate Functions

Module 4: Sorting and grouping

Course Instructors

Nick Carchedi

Product Manager at DataCamp

Nick is a Product Manager at DataCamp. Prior to joining DataCamp, he earned his master's degree at Johns Hopkins Biostatistics and worked as a data scientist for McKinsey. Nick's passion for teaching...