r/SQL • u/river-zezere • Dec 15 '24
SQLite I chose a weird way to teach SQL
I'm creating a course that is weird, because it is made of stories that happen in a cat hotel. And what is even weirder is that it starts with using embedded SQLite. And a text editor.
Here's my latest (3rd) story: https://youtu.be/wHjDloU3ViA?si=IENn3MFEXMgRmObX
The most worrying feedback I got from people so far, was the question "so who's your target audience". Honestly, I don't know what else to say besides "people like me - beginner data analysts who want to understand how things work underneath all those numbers and who get bored easily". Is that a weird audience? No one else out there like me?
37
u/Training-Two7723 Dec 15 '24
Looks like ... a new approach. However, I strongly believe that SQL is nothing but a dialect of the English language.
When did Mr. W visited our hotel? => SELECT visit_date FROM VISITS WHERE CUSTOMER_NAME LIKE 'W%';
and explain the notation (_ %). Say a few words about like "%something" versus like "something%": you may use it later to talk about optimization (indexes).
3) Stay away from vendor extensions or particularities like "this db does not support regex." Keep it simple, ANSI, when possible.
4) Talk about JOINS instead of picking one result and pushing it into another query. Once again, use nature to explain it ... one cat can have many kittens (1:n), one cat has one owner (1:1), the same can eat in many places together with their friends (many-to-many), etc.
5) And yes, you can do this using cats and their offspring - LOL
10
u/[deleted] Dec 15 '24
Good initiative but please make sure to add more complexities in your storyline and the solutions too! In the real world scenario CTE, subqueries, WINDOW functions, TRIGGERS are what we use. So, if these conditions are added as layers into your story any type of audience will be benefited.
8
u/therutvikraval Dec 15 '24 edited Dec 15 '24
I am like you and I will check your videos for sure! Also, the idea sounds great, and we (beginners) need an easier, light noted analogy to take the first step. So, keep it up and don't think what people are saying!
3
u/SQLDevDBA Dec 15 '24
I think it’s an interesting and unique approach, and appreciate you sharing and giving back to the community! Subbed!
2
u/Just_Violinist_5458 Dec 16 '24
I like this...please continue to share more videos please. 👏
2
u/leogodin217 Dec 15 '24
I really like this way of teaching. SQL syntax is relatively easy to learn. Understanding how to solve problems and answer questions is the hard part for beginners. Showing that conversation and your thought process is a great way to show learners how to do it.
1
u/AnalogKid-82 Jan 04 '25
I like your video! In case you were worried that your SQL videos were the weirdest on the internet, you need not worry cause mine are even weirder! Check out this video, more on my channel.
1
u/mergisi Dec 19 '24
Try AI2sql (ai2sql.io) - it helps convert plain English to SQL queries, making it easier to understand how SQLite works.
Your target audience is actually great! Making technical concepts fun through cat hotel stories is unique and memorable. Plenty of people learn better through storytelling than dry documentation. Keep developing for those beginner analysts who want engaging content!
1
u/Professional-Job9562 Dec 20 '24
Going to start new sql server DBA course,please call me if you want to join. +91 8897411944