Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Intermediate SQL for data analysis (no installation needed!)

An SQLcourse that puts an emphasis on solving interesting analysis problems. No need to install databases.
3.8
3.8/5
(33 reviews)
3,191 students
Created by

8.0

CourseMarks Score®

8.0

Freshness

6.7

Feedback

8.6

Content

Platform: Udemy
Video: 3h 55m
Language: English
Next start: On Demand

Table of contents

Description

This course is for people who already own basic knowledge of SQL who want to expand their knowledge and really become data savvy and either land a BI job, improve their skills,  or become a self reliant business user in their organization. If you want to get work as a data analyst, if you are a junior analyst and want to get better fast, or if you are a developer, a data scientist or a student who is used to working with R and Python but need to up your SQL game – this is the course for you. If you are a sophisticated business user who uses sql mainly to extract data to worksheets and continue in excel – you will be delighted in what you’ll be able to do WITHOUT excel after this course. The course focuses on tackling real life day to day problems, and does not waste time with endless joins and needless focus on syntax. Syntax is always a google search away, understanding what’s possible (i.e., know what you don’t know) is not.

You will learn

✓ sql
✓ sql server
✓ analytics
✓ data analysis
✓ no installation required

Requirements

• basic knowledge of sql
• select statements (from, group by, where, having, order by)
• joins (left, inner)
• built in functions (sum, min/max, count, count distinct etc.)

This course is for

• junior analysts
• beginner analysts
• college students or graduates in data driven fields
• data scientists or developers that want to improve their sql
• any corporate user who has access to data bases and wants to do more than just retrieve data into spreadsheets
Data Nerd
During the last decade+ I have worked in tech start ups analyzing and visualizing data, building data products and designing and engineering data flows and data automation. I love to teach and share knowledge, and believe you can’t be successful in today’s work places without being extremely data literate – able to obtain data by yourself, analyze it, understand it, and be aware of it’s pitfalls, misrepresentations and biases.
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 3h 55m
Language: English
Next start: On Demand

Students are also interested in