Intermediate SQL for data analysis (no installation needed!)
- 4.5
Brief Introduction
An SQLcourse that puts an emphasis on solving interesting analysis problems. No need to install databases.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.
Requirements
- 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.)