About This Course

Who this course is for:

  • Data Analysts
  • Business Owners
  • Business Developers

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

Requirements: 

  • No prior knowledge is required to take 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.

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.

Course Curriculum

Section 1 - SQL Overview
Relational Databases 00:00:00
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 Variants 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
Filtering Data 00:00:00
Subqueries 00:00:00
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
Partitioning 00:00:00
Date And Time Part One 00:00:00
Date And Time Part Two 00:00:00
Section 4 - Programming With SQL
Mathematical Functions 00:00:00
Variables 00:00:00
Conditional Logic 00:00:00
Loops 00:00:00
Custom Functions 00:00:00
Section 5 - Connecting Data Analytics Software
Exporting Data 00:00:00
Connecting Excel With GUI 00:00:00
Connecting Excel With VBA 00:00:00
Connecting IBM SPSS Statistics 00:00:00
Connecting R 00:00:00
Connecting Python 00:00:00
top
Template Design © VibeThemes. All rights reserved.

Setup Menus in Admin Panel