I Taught SQL to Complete Beginners: Here's What Actually Happened
The author taught SQL to complete beginners with no prior coding experience, using relatable analogies and real-world datasets to explain core concepts. The course progressed from basic queries to advanced topics like JOINs, window functions, and CTEs, with students gradually gaining confidence and insight. Teaching SQL proved to be a rewarding experience as students transitioned from confusion to mastering analytical thinking with data.
- ▪The students came from non-technical backgrounds such as accounting and operations, with some relying on Excel for data management.
- ▪Key SQL concepts taught included SELECT, WHERE, HAVING, JOINs, window functions like RANK and LAG, and the use of CTEs for readable queries.
- ▪Real-world datasets like a fictional school and hospital were used to make learning relatable and practical.
Opening excerpt (first ~120 words) tap to expand
try { if(localStorage) { let currentUser = localStorage.getItem('current_user'); if (currentUser) { currentUser = JSON.parse(currentUser); if (currentUser.id === 3934612) { document.getElementById('article-show-container').classList.add('current-user-is-article-author'); } } } } catch (e) { console.error(e); } Navas Herbert Posted on May 16 I Taught SQL to Complete Beginners: Here's What Actually Happened #sql #postgres #beginners #teaching Let me set the scene. A room full of people who had never written a single line of SQL in their lives. Some came from accounting. Some from operations. One person told me they still used Excel to track hospital records manually. And they were all looking at me like I was about to teach them magic. Honestly? I kind of was.
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at DEV.to (Top).
Discussion
0 commentsMore from DEV.to (Top)
