SQL for Data Analysis: Core Data Scientist’s Skills

Name: SQL for Data Analysis: Core Data Scientist’s Skills
Rating: 4.1 (271 reviews)

Learn everything you need to know about SQL and Microsoft SQL Server for successful data science work

Free tutorial

(271 ratings)

6,589 students

1hr 59min of on-demand video

Created by Scandinavian Institute of Business Analytics

English

Write programs in SQL (custom function, loops, and more)

Understand math behind SQL statistical functions

SQL commands needed for advanced data analysis

Ways for importing data with T-SQL

Connection codes for R, Python, Excel VBA and IBM SPSS

Key features of Microsoft SQL Server Management Studio

Requirements

Basic knowledge of Windows
Understanding programming notions (like 'variable' and 'function')

Description

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.

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.

Upon completion, you’ll have the core SQL skills that data scientists need. Your SCANBA certificate will prove it to others.

Who this course is for:

Data analysis practitioners
Professionals interested in data science
Individuals interested in mastering their SQL skills for data analysis

Featured review

Igor R.

139 courses

33 reviews

2 years ago

This is one of the best courses I've participated. I specially liked the in depth explanations at the beginning of every lecture. The pace of the course is perfect, and the lecturer speaks very clearly and in understandable way. The examples are rely useful and the student can practice them and also make some changes to see the results. I recommend the course with pleasure. Thank you SCANBA.

Scandinavian Institute of Business Analytics

SCANBA Online

4.0 Instructor Rating
1,385 Reviews
13,791 Students
7 Courses

The Scandinavian Institute of Business Analytics (SCANBA) is a business analytics consulting company with operations in Finland and Sweden. SCANBA helps companies and their employees to become significantly more effective and successful by implementing business analytics in their organizations and by increasing employees’ professional skills.

SCANBA provides a broad range of services, including training and certification in business analytics, data management auditing, business process auditing and optimization, predictive analytics implementation, and decision system management.