Intermediate SQL for data analysis (no installation needed!)

Intermediate SQL for data analysis (no installation needed!), available at $19.99, has an average rating of 3.65, with 31 lectures, based on 36 reviews, and has 3202 subscribers.

You will learn about sql sql server analytics data analysis no installation required This course is ideal for individuals who are junior analysts or beginner analysts or college students or graduates in data driven fields or data scientists or developers that want to improve their sql or any corporate user who has access to data bases and wants to do more than just retrieve data into spreadsheets It is particularly useful for junior analysts or beginner analysts or college students or graduates in data driven fields or data scientists or developers that want to improve their sql or any corporate user who has access to data bases and wants to do more than just retrieve data into spreadsheets.

Enroll now: Intermediate SQL for data analysis (no installation needed!)

Summary

Title: Intermediate SQL for data analysis (no installation needed!)

Price: $19.99

Average Rating: 3.65

Number of Lectures: 31

Number of Published Lectures: 31

Number of Curriculum Items: 31

Number of Published Curriculum Objects: 31

Original Price: $69.99

Quality Status: approved

Status: Live

What You Will Learn

sql

sql server

analytics

data analysis

no installation required

Who Should Attend

junior analysts

beginner analysts

college students or graduates in data driven fields

data scientists or developers that want to improve their sql

any corporate user who has access to data bases and wants to do more than just retrieve data into spreadsheets

Target Audiences

junior analysts

beginner analysts

college students or graduates in data driven fields

data scientists or developers that want to improve their sql

any corporate user who has access to data bases and wants to do more than just retrieve data into spreadsheets

This course is for people who already own basic knowledge of SQL who want to expand their knowledge and really become data savvy and either land a BI job, improve their skills,  or become a self reliant business user in their organization. If you want to get work as a data analyst, if you are a junior analyst and want to get better fast, or if you are a developer, a data scientist or a student who is used to working with R and Python but need to up your SQL game – this is the course for you. If you are a sophisticated business user who uses sql mainly to extract data to worksheets and continue in excel – you will be delighted in what you’ll be able to do WITHOUT excel after this course. The course focuses on tackling real life day to day problems, and does not waste time with endless joins and needless focus on syntax. Syntax is always a google search away, understanding what’s possible (i.e., know what you don’t know) is not.

Course Curriculum

Chapter 1: 3 short technicalities before we start

Lecture 1: 3 sho

Chapter 2: connecting to the azure server – and other options

Lecture 1: important: im taking down the remove server, pls see download instructions

Lecture 2: IDE option 1: if you have a windows/mac you control: Microsoft SSMS

Lecture 3: IDE option 2: if you have a windows/mac you cant install on: sqldbx

Lecture 4: IDE Optioon 3: browser based (for Chromebooks etc.) – Mode (browser)

Chapter 3: before we start, a short explanation on temp objects

Lecture 1: CTE vs. Subquery vs. Temp Table

Chapter 4: Subquery, correlated Subquery, and using functions over partitions

Lecture 1: using Subqueries and partitions to obtain totals and subtotals of data

Lecture 2: excercise 1 – using Subqueries and partitions for totals and subtotals

Lecture 3: correlated subqueries

Lecture 4: exercise 2 -correlated subqueries

Chapter 5: Case Statements

Lecture 1: Case statements – categorize your data

Lecture 2: Case statements – nested cases statements

Lecture 3: Excercise 3 – nested case statements

Lecture 4: Case statements – aggregating and pivoting data

Lecture 5: Exercise 4 – aggregating and pivoting with case statements

Lecture 6: Case Statements – cascading case statements – order matters!

Chapter 6: Window Functions

Lecture 1: Window functions – Lag and Lead

Lecture 2: Exercise 6 – Lag and Lead

Lecture 3: Window f – Row number and ranking

Lecture 4: Exercise 7 – Row number and ranking

Lecture 5: Window Functions – Running totals

Lecture 6: Exercise 8 – Running totals

Lecture 7: Window functions – Ntiles

Lecture 8: Exercise 9 – Ntiles

Chapter 7: Joins (with a few twists!)

Lecture 1: Joins – the boring joins (quick review) – inner, left, right

Lecture 2: Joins – the interesting joins: Full outer join and coalesce

Lecture 3: Exercise 10 – Full outer join and coalesce for data reconciliation

Lecture 4: Joins – the interesting joins: Cross join for ad hoc what-if anaysis

Chapter 8: Bonus: cleaning up data with text functions and regex

Lecture 1: Text functions and Regex (kind of) – cleaning up messy text data

Lecture 2: Exercise 11 (part one – phones) – text functions Regex (kind of)

Lecture 3: Exercise 11 (part two – emails) – text functions Regex (kind of)

Instructors

Guy Manova
Data Nerd

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 8 votes

4 stars: 8 votes

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