About This Course
This course was created by experts from the Scandinavian Institute of Business Analytics, experts who know what matters and how to teach. With this course, you’ll learn exactly what skills matter when using SQL for data analysis. You will learn how to use the top-notch technologies available in Microsoft SQL Server, the math behind the statistical functions, how to write your custom functions effectively, transform the data, and connect it with analytics software.
Did you know that the way you learn new things matters the most? The Internet is full of scattered information. There might be even books and courses on the topic you’re interested in. But by picking the wrong book or an ineffective course, you’re at risk of wasting your time, money, and most importantly, falling behind your potential competitors. Upon completion, you’ll have the core SQL skills that data scientists need.
What you’ll learn:
- How to define data with SQL
- Learn to create tables and load data
- How to use conditional logic
- Connect Excel with GUI
Our Promise to You
By the end of this course, you will have learned about data analysis with SQL.
30 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about SQL for data analysis.
|Section 1 - SQL Overview|
|Data Manipulation With SQL||00:00:00|
|Data Definition With SQL Part One||00:00:00|
|Data Definition With SQL Part Two||00:00:00|
|SQL Server Installation||00:00:00|
|SQL Server Data Types||00:00:00|
|Dataset For Section 1||00:00:00|
|Section 2 - Statistics With SQL|
|Create Table And Load Data||00:00:00|
|Count, Min, Max, Top, And Distinct||00:00:00|
|Statistical Functions in SQL||00:00:00|
|Dataset For Section 2||00:00:00|
|Section 3 - Data Preparation With SQL|
|Combining Tables: Part One||00:00:00|
|Combining Tables: Part Two||00:00:00|
|Creating A View||00:00:00|
|Grouping And Ordering||00:00:00|
|Date And Time Part One||00:00:00|
|Date And Time Part Two||00:00:00|
|Section 4 - Programming With SQL|
|Section 5 - Connecting Data Analytics Software|
|Connecting Excel With GUI||00:00:00|
|Connecting Excel With VBA||00:00:00|
|Connecting IBM SPSS Statistics||00:00:00|