4.3  942 reviews on Udemy

SQL - Master Class For Data Analysis

Writing SQL Server queries for Data Analysis
Course from Udemy
 5323 students enrolled
 en
Install and use SQL Server database engine and studio
Analyse data looking for patterns and behaviours
Expertly code quantitative analysis using SQL
Write SQL using LAG(), NTILE(), OVER, PARTITION logic and many more analytics functions
Understand Primary and Foreign keys
Understand the difference between DML and DDL
Understand the relational database model
Make data driven decisions in your enterprise
Master all types of table joins (incl. Complex Apply joins)
Answer those gnarly interview questions, yes we will always have those !

Hi  

With so much data stored in SQL databases, how can we get at it ?

You use SQL to get at this data, no matter what the SQL Database product is (e.g SQL Server, Oracle and many more). 

Coding SQL to analyse data can be a daunting and complex task, hence the reason for building this course.

In this course I will teach you how code SQL to perform data analysis in order to answer complex questions that you will encounter daily in your job.  

Ask yourself these simple questions ...

Do you know all of the TABLE JOIN types that can be applied in a SQL query ? 

Have you ever used OUTER APPLY, which is so easy and powerful to use ?

Can you write a running total in a single line of SQL ? 

Where do you use a ROLLUP statement and why would you use it ? 

What is LAG() ?

If you could not answer these simple questions then this course will definitely change all of that for you.

You definitely should know all of this to survive the SQL environment you work in ! 

All course materials are provided e.g. Sample databases (with real data), code scripts, practice exercises and quizzes.

Don't forget, there is a 30 Day money back guarantee if this course does not deliver what you expected.

Stay safe and well

Best Regards

Paul

Data Analyst and Visualisation Engineer


SQL - Master Class For Data Analysis
$ 29.99
per course
Also check at

FAQs About "SQL - Master Class For Data Analysis"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK