Most SQL courses I’ve seen teach it in the same old way that I struggled with when I first learned SQL. I set out a long time ago to come up with a better way to approach the topic that would be much easier and faster to learn. This new method has worked well and now you have the chance to learn from this method also!
What You’ll Learn
The five fundamentals of SQL – The theory behind SQL
How to use the five fundamentals to guide your SQL query development and understanding
How to read, write, and understand inner and outer joins
How to read, write, and understand groupings and aggregate functions
Use joins and grouping patterns that will help you validate data assumptions and explore data
Why Learn SQL?
SQL is a skill that is in high demand. Take it from me, I am a data professional and there is certainly no shortage of great paying jobs and career paths using data and SQL. I’ve also interacted with many people that are not data professionals, that all wished they knew SQL better because it was a part of their job as well!
What’s So Special About This Course?
There are a lot of SQL courses out there. Most of the time it’s basically a long winded list of code, syntax, and descriptions of what things are, but with no real application or teaching on how they work together and what’s really going on. In other words, nobody actually understands it well enough to query their own databases after the class is over. It also takes years of practice to really get it. I can personally attest to this problem. When I took my first database class in college, I didn’t do very well and I even decided I’d never deal with databases again. It was very frustrating! This class aims to fix this issue by teaching you how to approach any query in a repeatable process, and to teach you what properties of a dataset to pay attention to in order to assure understanding, query success, and data accuracy.
Specification: SQL Essentials – A Whole New Way of Learning SQL for Anyone!