SQL for Business & Interview Prep

SQL for Business & Interview Prep, available at $19.99, with 18 lectures, 7 quizzes, and has 1 subscribers.

You will learn about A refresher on SQL topics. Real-world practice problems. PgAdmin program for PostgreSQL. Prep for your upcoming interview or build your skills to feel more confident in your current role. This course is ideal for individuals who are This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job. It is particularly useful for This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job.

Enroll now: SQL for Business & Interview Prep

Summary

Title: SQL for Business & Interview Prep

Price: $19.99

Number of Lectures: 18

Number of Quizzes: 7

Number of Published Lectures: 18

Number of Published Quizzes: 7

Number of Curriculum Items: 57

Number of Published Curriculum Objects: 57

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

A refresher on SQL topics.
Real-world practice problems.
PgAdmin program for PostgreSQL.
Prep for your upcoming interview or build your skills to feel more confident in your current role.

Who Should Attend

This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job.

Target Audiences

This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job.

This course is ideal for people who have some existing SQL experience and are either prepping for an interview or need to brush up on SQL skills for their current job. Consider it like a “Level 2” course to be taken after an intro course. It provides a refresher on SQL topics and offers real-world practice problems. Topics covered include GROUP BY, Window functions, Unions and Joins, Subqueries and more. The course includes video introductions by Barbara, a data scientist with 10 years of experience in the field, as well as slide decks with voiceovers where Barbara explains concepts in more detail.

Course Highlights

Real World SQL Application:

You’ll be using the actual PgAdmin program during this course – no fake interface! This is the actual program you’d use on the job if your company uses PostgreSQL. If your company uses something else (Microsoft, Oracle, etc.) don’t worry, PgAdmin is very similar.

Relevant Business Problems:

In addition to review slide decks and videos, this course contains dozens of real world practice problems designed to mimic what you’d face on the job or in an interview.

Support:

Stuck on an exercise? Want to ask general SQL questions? We offer both email and video chat support options. You can even ask questions about other related analytics topics like Excel, Python, or a problem you are having at work.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to SQL Interview Questions

Lecture 2: Getting Started

Chapter 2: Chapter #1

Lecture 1: Chapter 1 Lesson 1: Aggregating Data in SQL

Lecture 2: Chapter 1 Lesson 2: Window Functions in SQL

Lecture 3: Chapter 1 Lesson 3: Aggregation Interview Questions

Chapter 3: Chapter #2

Lecture 1: Intro to Chapter 2

Lecture 2: Chapter 2 Lesson 1: Unions

Lecture 3: Chapter 2 Lesson 2: Inner JOINs

Lecture 4: Chapter 2 Lesson 3: Left JOINs

Lecture 5: Chapter 2, Lesson 4: Multiple JOINs

Lecture 6: Chapter 2 Lesson 5: Case Statements

Chapter 4: Chapter #3

Lecture 1: Intro to Chapter 3

Lecture 2: Chapter 3 Lesson 1: Subqueries in FROM

Lecture 3: Chapter 3 Lesson 2: Filtering with Subqueries in WHERE

Lecture 4: Chapter 3 Lesson 3: Data Cleaning in SQL

Lecture 5: Chapter 3 Lesson 4: Subquery Interview Questions

Chapter 5: Thank you!

Lecture 1: Congratulations! You have completed SQL Interview Questions!

Lecture 2: Thank You & Obtaining Your Certificate

Instructors

Barbara Donnini
Data Scientist

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 0 votes
4 stars: 0 votes
5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu