Brief Introduction
Writing SQL Server queries for Data AnalysisDescription
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
Requirements
- 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)
Paul Scotchford
4.5 Raiting
Data Analysis Essentials Using Excel
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn to apply the important concepts and techniques of data analysis using Excel. Ibadullah Khalil - 5 Stars “A great instructor and guide for the course....
Lean Six Sigma Yellow Belt Certification (Accredited)
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Accredited Certified Lean Six Sigma Yellow Belt | 40+ Yellow Belt Tools | Yellow Belt Case Study | Minitab Introduction LEAN SIX SIGMA YELLOW BELT CERTIFICATION...
Ultimate PHP, Laravel, CSS & Sass! Learn PHP, Laravel & Sass
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Learn PHP,Laravel,PDO,Security and create layouts using CSS GRID, Bootstrap, Flexbox,topped up with JavaScript and Ajax This course now is updated with Laravel!...
Algorithmic Toolbox
- 4.6
-
![]()
![]()
![]()
![]()
![]()
The course covers basic algorithmic techniques and ideas for computational problems arising frequently in practical applications: sorting and searching, divide and conquer, greedy algorithms, dynamic programming....
