SQL - Master Class 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 !
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.
Course content
- Preview02:47
- 10:41How to download and install SQL Server 2014 Express
- 04:57How to download the course sample data (from Dropbox)
- 10:38Navigating SQL management studio
- Preview09:42
- 10 questionsPop Quiz - Key points before the next chapter
Instructor
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