SQL for advanced analytics

12 Lessons

14 Videos

Intermediate

Skill Level

12 hours

Duration

English

Language

Share This Class:

Overview

Structured Query Language is one of the oldest languages taught at Techmine and it’s also one of the most important languages in the arsenal of languages available to data and programming professionals. Originally created to manipulate data in relational databases, SQL has become ubiquitous across different kinds of databases and data activities. It’s been described as a beautiful and intuitive language because it is descriptive rather than procedural, but that does not mean it is simple.

Some say it takes a lifetime of experience to learn SQL, that you must wait for situations that call upon you to plumb its depths. We disagree. Technology and data are moving too fast to waste any time coming to grips with this elegant and powerful language.

SQL contains within it many very powerful constructs and techniques, that when deployed in the correct settings, can save enormous amounts of programming effort, ensure better performance and guarantee consistent results to your project. We cover these hard to find advanced analytic techniques in this course.

Completing this course will help you:

Get the most power out of lateral joins, complex joins and aggregations
Use partitions within your SQL for fine-grained calculations
Escape the chaos of subselects and raise your analysis the next level by using the With clause
Harness the power of cubes, rollups and transformations

Who is the course for?

This course is for anyone who knows enough about SQL to confidently retrieve simple datasets from a database but still finds herself having to manipulate that data in spreadsheets. This course will push more of that work, if not all of it, into the database itself, thereby saving time and ensuring greater accuracy.

Play Video

Learning Path - TBD

Lesson 1 - Know Your Audience

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent eu orci faucibus orci malesuada semper eget non tellus. Cras sed dignissim purus. Mauris varius neque leo, eu pellentesque justo venenatis et. Sed ultricies risus non turpis tempus, nec nulla suscipit. In comdo urna eu turpis accumsan, et viverra mauris fringillaCras interdum