Intermediate SQL for data analysis (no installation needed!)

An SQLcourse that puts an emphasis on solving interesting analysis problems. No need to install databases.

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.

What you’ll learn

  • sql.
  • sql server.
  • analytics.
  • data analysis.
  • no installation required.

Course Content

  • 3 short technicalities before we start –> 1 lecture • 2min.
  • connecting to the azure server – and other options –> 3 lectures • 10min.
  • before we start, a short explanation on temp objects –> 1 lecture • 17min.
  • Subquery, correlated Subquery, and using functions over partitions –> 4 lectures • 23min.
  • Case Statements –> 6 lectures • 40min.
  • Window Functions –> 8 lectures • 1hr 7min.
  • Joins (with a few twists!) –> 4 lectures • 44min.
  • Bonus: cleaning up data with text functions and regex –> 3 lectures • 33min.

Intermediate SQL for data analysis (no installation needed!)

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 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.