SQL Fundamentals for Data Analysts

SQL Fundamentals for Data Analysts, available at $39.99, has an average rating of 4.9, with 13 lectures, based on 37 reviews, and has 187 subscribers.

You will learn about How to create and run SQL queiries to efficiently Writing basic select statements Limiting Results Filtering Results with Where More Ways to Filter Queries Answering Analytical Questions with Aggregate Functions Filtering Data with Aggregates Handling NULL Values Aliasing Columns and Tables Using IN and BETWEEN Clauses Filtering with LIKE Operator This course is ideal for individuals who are Data analysts looking to learn SQL It is particularly useful for Data analysts looking to learn SQL.

Enroll now: SQL Fundamentals for Data Analysts

Summary

Title: SQL Fundamentals for Data Analysts

Price: $39.99

Average Rating: 4.9

Number of Lectures: 13

Number of Published Lectures: 13

Number of Curriculum Items: 13

Number of Published Curriculum Objects: 13

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

How to create and run SQL queiries to efficiently

Writing basic select statements

Limiting Results

Filtering Results with Where

More Ways to Filter Queries

Answering Analytical Questions with Aggregate Functions

Filtering Data with Aggregates

Handling NULL Values

Aliasing Columns and Tables

Using IN and BETWEEN Clauses

Filtering with LIKE Operator

Who Should Attend

Data analysts looking to learn SQL

Target Audiences

Data analysts looking to learn SQL

Do you want to get a high-paying job in Data and Business Analytics? Want to be more productive in analyzing data? Are you tired of having a limited understanding of SQL? Hate manually transforming data, but need the value it provides? If the answer is “yes” then look no further. With the SQL Fundamentals Course, you’ll gain fundamental knowledge related to the Structured Query Language or SQL, the language every database speaks.

You’ll learn:

How to connect, filter and retrieve data using SQL Queries (Select, Limit, Where, And)

Aggregate Data using Functions and Grouping Operations (Count, Sum, Avg & Group By)

How to use Conditional Logic to limit data to specific text or phrases (In, Between, Like)

Quick and easy to follow video tutorials along with step-by-step instructions make this course perfect for the SQL novice. By the end of this course, you will be able to analyze data faster and more efficiently.

I’ve worked in the data field for over 20+ years and have consulted at silicon valley’s largest companies. Now my focus is on sharing my passion and knowledge with others. If you enjoy this course, feel free to check out the rest of my library. I cover everything from SQL to Data Governance to Tableau.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and What Youll Learn

Lecture 2: Setup and Loading Data

Chapter 2: Querying Data

Lecture 1: Basic Select Statement

Lecture 2: Limiting Results

Lecture 3: Filtering Results with Where

Lecture 4: More Ways to Filter Queries

Chapter 3: Analyzing Data

Lecture 1: Answering Analytical Questions with Aggregate Functions

Lecture 2: Filtering Aggregates

Lecture 3: Handling NULL Values

Lecture 4: Aliasing Columns and Tables

Lecture 5: Using IN and BETWEEN Clauses

Lecture 6: Filtering with LIKE Operator

Chapter 4: Next Steps

Lecture 1: Next Steps

Instructors

Ben Sullins
Helping Advance Your Career in Data

Rating Distribution

1 stars: 0 votes

2 stars: 1 votes

3 stars: 3 votes

4 stars: 10 votes

5 stars: 23 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!