Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

SQL - Master Class For Data Analysis

via Udemy

Overview

Writing SQL Server queries for Data Analysis

What you'll learn:
  • 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 SQLdatabases, how can we get at it ?

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

Coding SQL to analyse datacan be a daunting andcomplex task, hence the reason for building this course.

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

Ask yourself these simple questions ...

Do you know all of theTABLEJOINtypes that can be applied in a SQLquery?

Have you everused OUTERAPPLY, which is so easy andpowerful to use ?

Can you write arunning totalin a singleline 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 ofthis 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


Taught by

Paul Scotchford

Reviews

4.9 rating at Udemy based on 1023 ratings

Start your review of SQL - Master Class For Data Analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.