Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence CBT
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence SQL

SQL - Master Class For Data Analysis

Writing SQL Server queries for Data Analysis
Rating: 4.5 out of 54.5 (936 ratings)
5,289 students
Created by Paul Scotchford
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

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 !

Requirements

  • Only have a Mac ? You can use Virtual Box, Windows Server Trial edition and SQL 2014 Express or later
  • Want to learn from a rated Top-responding instructor (Yes, I answer Q&A within 24 hours or less!) ?
  • As you will learn the A-Z here, start easy then boom - the hard work of data analysis starts
  • This course is presented using SQLServer 2014 Express which is free from Microsoft (& later versions e.g 2016 Express can be used)

Description

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


Who this course is for:

  • Data Analysts and Data Scientists
  • Students
  • DBA's
  • New graduates
  • Technical marketing people
  • Those looking to acquire new skills
  • Research shows students don’t learn by hearing or seeing, they learn by doing, a model often called active learning.

Featured review

dynk dynkums
dynk dynkums
28 courses
7 reviews
Rating: 5.0 out of 510 months ago
I liked the pace of the lessons. Each topic was given the time it deserved. Paul also cleared up questions that I had during his explanations. A very useful course. One complaint--the music at the beginning of each lecture was too loud (or I'm too old).

Course content

8 sections • 58 lectures • 7h 42m total length

  • Preview02:47
  • How to download and install SQL Server 2014 Express
    10:41
  • How to download the course sample data (from Dropbox)
    04:57
  • Navigating SQL management studio
    10:38
  • Preview09:42
  • Pop Quiz - Key points before the next chapter
    10 questions

  • Preview05:52
  • Download chapter 2 sample database and restore it via the SQL Management Studio
    07:22
  • The SELECT statement
    10:23
  • Practice session using SELECT exercises
    5 questions
  • The SELECT statement with a WHERE predicate (Condition)
    12:22
  • Practice session - using SELECT and the WHERE clause excersises
    5 questions
  • Let's explore GROUP BY and HAVING to answer a marketing team question
    12:04
  • Practice session - Challenging brain teaser excercises
    5 questions
  • What are data types ?
    10:09
  • Pop Quiz - Do you remember the datatypes ?
    5 questions

  • Download chapter 3 sample database and restore it via SQL management studio
    04:20
  • Overview of Chapter 3 database and the PK,FK model
    11:43
  • Brain Teaser
    10 questions
  • Working with the INNER JOIN (JOIN) statement
    11:13
  • Prac time
    1 question
  • Working with the LEFT OUTER join
    08:26
  • Prac time
    1 question
  • Working with the RIGHT OUTER join
    05:46
  • Prac time
    1 question
  • Working with the FULL OUTER join
    06:39
  • Prac time
    1 question
  • Working with the CROSS join
    06:59
  • Prac time
    1 question
  • Working with the SELF join (Overview)
    05:13
  • Working with the SELF join (Providing initial insight)
    07:29
  • Working with a SELF join (Add value to the insight)
    04:47
  • Working with a SELF join (Finally the last join)
    08:00
  • Prac time
    1 question
  • A CROSS join can be your buddy (Pt 1)
    08:50
  • A CROSS join can be your buddy (Final)
    09:27
  • Brain teaser
    5 questions
  • Working with CROSS and OUTER APPLY (Pt1)
    11:14
  • Working with CROSS and OUTER APPLY (Pt2)
    08:05
  • Working with CROSS and OUTER APPLY (Final)
    05:13
  • So you want more eh ?
    5 questions

  • Download chapter 4 insurance database and restore it via SQL management studio
    05:49
  • Preview11:22
  • Prac count()
    1 question
  • Adding it all up using the Sum() function
    10:16
  • Prac sum()
    1 question
  • Finding the mean with the Avg() function
    08:21
  • Prac avg()
    1 question
  • Using Min() to find first value
    07:29
  • Prac min()
    1 question
  • Preview05:47
  • Prac max()
    1 question
  • Just how do we calculate a median value ?
    07:17
  • Prac median
    1 question
  • Using the CASE...END statement (if,then,else)
    08:07
  • Prac case
    1 question
  • Show me how to calculate quartiles
    07:53
  • Prac quartile
    1 question

  • Download and restore the sample Web Analytics database (and scripts)
    03:25
  • Project 1 - Website visitor analysis
    12:54
  • Prac Project 1 (Challenge #1)
    1 question
  • Prac Project 1 (Challenge #2)
    1 question
  • Prac Project 1 (Challenge #3)
    1 question
  • Prac Project 1 (Challenge #4)
    1 question
  • Project 2 - Insurance claims margin analysis
    09:51
  • Prac Project 2 (Challenge #1)
    3 questions
  • Project 3 - Ranking customers and products by sales
    08:10
  • Prac Project 3 (Challenge #1 )
    3 questions
  • Project 4 - Category performance analysis (time series)
    10:13
  • Prac Project 4 (Challenge #1)
    2 questions

  • What is cohort analysis ?
    04:42
  • How do I do cohort analysis in SQL (Pt 1) ?
    11:18
  • How do I do cohort analysis in SQL (Pt 2) ?
    04:02
  • How to analyse customer acquisition in SQL (Pt 1) ?
    09:33
  • How to analyse customer acquisition in SQL (Pt 2) ?
    11:19

  • Create database and a table from scratch
    09:42
  • Creating a table from a SQL Query
    11:06
  • How to create a view
    08:14
  • What is a Union query ?
    06:42
  • How to code the insert statement (crud 1)
    09:47
  • How to code the update statement (crud 2)
    09:10
  • How to code the delete statement (crud 3)
    04:46
  • What is date arithmetic and how to code it ?
    06:48
  • Using the case statement to discretize (aka Banding,Bucketizing) data
    07:12
  • How to import raw data from files
    06:23
  • How to obtain your certificate
    00:00

  • How to download/install Qlik Sense desktop and register for a QSD lic file.
    04:46

Instructor

Paul Scotchford
Data Analyst and Qlik Development Specialist @ awari
Paul Scotchford
  • 4.5 Instructor Rating
  • 8,582 Reviews
  • 98,047 Students
  • 5 Courses

G'Day and Welcome,

My name is Paul Scotchford and I am stoked that you are reading this.

When I get reviews like this one "oh my goodness. I cracked an Interview using this course" then I know the course material is hitting the spot ...

News: Just released - SQLServer 2019 Data Analytics & Tableau Data Visualisation , this is a deep dive for beginner Data Analysts looking to become highly proficient in SQL and data visualisation, in this course you cover everything and the display results in Tableau.

As well as my normal consulting work in business and government I teach here on Udemy, there are 3 very distinct technology specialisations I work within and these are QlikView, Qlik Sense and SQL Server for delivering Data Analytics and Visualisations and in my downtime I go out and fly as a private pilot (that's my passion too) .

I have also been flagged as a Top-responding instructor which means that your Q&A will typically be answered within 24 Hours. In addition my Qlik courses are now offered on Udemy For Business (UFB)  .

QlikView and QlikSense

Professionally I have been delivering QlikView  solutions to business and government users for the past 8 years and Qlik Sense since it first released in 2014. Qlik delivers these products to the market and is an industry leader in the BI and Analytics world.

SQL Server

I have been delivering data analytics with the SQL Server (Tech Stack) for more than 17 years as this technology (in my humble opinion) is the best Relational Database and Data Warehouse (Mart) product on the market and will continue to be well into the future.

Summary

Because of my passion and experience working with these technologies in the real-world you can be assured that you will be getting first class training from my courses here on Udemy.

I am super stoked and looking forward to sharing my ongoing experience and passion for data analytics with you. 

Looking forward to seeing you in one of my courses soon.

News: Coming in Feb/March 2021 a highly detailed Qlik Sense course , stay tuned!

Stay safe and well , looking forward to you joining in the courses.

Kind Regards

Paul

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.