Intro to Analytics in SQL

Course Content

  • Introduction to Database
  • SQL 1
  • SQL 2
  • Delivery Data Problem Set
  • Fraud Detection Project

Who This Course is For

For completely new programmers and enthusiastic learners who are looking for a comprehensive SQL tutorial.

Sign Up Now

What You Get

  • Lifetime access to online content.
  • An industry project to showcase on your resume.
  • 3 Lessons, 1 Problem Set, and 1 Project.
  • [Enterprise Plan] Customized curriculums for your org.
  • [Enterprise Plan] Live instructor support.
  • [Enterprise Plan] Code reviews on your work.
  • [Academic Plan] Professor content support.
  • [Academic Plan] Dashboard for student progress.

Sign Up NowFAQ

Request A Demo!For Academic or Enterprise Pricing

Student Success

Michael's testimonial for Intro to Machine Learning
"Out of the many different online resources I have found, Leada was probably one of the most useful in terms of actually learning something on a scheduled basis. It’s difficult learning new things on your own completely unguided, which is why Leada was so practical and so valuable. The personalized instruction was definitely the biggest sell for me, as often times before Leada I would get stuck with questions that I would waste hours trying to find the answers for. Even though the price tag may seem a bit high for an online resource (especially given the fact that I’m a student and have yet to start making a regular income), the time invested by the Leada teachers and the quality of the course material make it worth it."
Michael Cai, Student at NYU

Lessons

Cloud hosting

Introducing SQL

Estimated Time 00:45

We'll get you set up on using the SQL database we provide.

Sql 1

SQL - 1

Estimated Time 03:08

We'll start covering basics in SQL, including Database, Tables, Data Types, Queries etc.

Sql 2

SQL - 2

Estimated Time 03:13

We'll cover more advanced topics such as Aggregate Functions, Subqueries, Advanced Joins etc.

Practice Problems

Matching and deduplicating

SQL Problem Set

Estimated Time 01:03

Given the data prepopulated in your SQL database, we'll dig into the data via some SQL queries.

Projects

Ab testing

Fraud Analytics Using SQL

02:54

In this project you are tasked with analyzing data from Joe Department Store's customer loyalty program. The goal is to find fraudulant activity and users.