SQL Master Class For Data Analysis

Learn to write SQL Server queries for Data Analysis in a day

Created by: Paul Scotchford
Data Analyst and Qlik Development Specialist @ awari

What Will I 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)

Target audience

• 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.