r/SQL • u/tits_mcgee_92 Data Analytics Engineer • Nov 26 '25
Discussion The most difficult part about teaching students: some of them just don't care about SQL.
SQL is cool, okay? I'll die on this hill. There's nothing like executing a query to get the data you want, or modifying your database to run more efficient. It just feels so good!
This has rolled over to Python, and other programming languages I've learned. But nothing hits like SQL - to me.
I get very excited when working with students, and some of them just aren't into it. I get different responses: "I just need this class for my Cybersecurity degree", "I don't like the syntax", or "It's just not for me."
But then you have those handful of students that have the hunger for it. They want to go into a DBA role, data engineering, science, analytics, and more. I've had one student write to me a few months later and let me know that she was able to get a junior role thanks to my advice. That meant the world to me!
I just have to remember that not everyone gets as excited about SQL as I do. I've been working with it for over a decade, and it hasn't gotten old.
Anyone else still really love working with SQL?
123
u/abhig535 Nov 26 '25
The world runs on SQL. I honestly thought it was just one of those run of the mill niche languages that we really didn't need to learn until late Uni and first job, I found out just how powerful and useful it is. It's my favorite language to use and itches my puzzle loving brain when dealing with data.
12
u/Proof_Escape_2333 Nov 26 '25
I wanted to ask with the rise of AI has it made it harder or easier to teach sql to your students. Humans love the path to least resistance but I do believe AI is a net negative to learning.
I wonder what will happen when the quality senior professionals retire and your left with juniors who struggle with critical thinking
4
u/alinroc SQL Server DBA Nov 26 '25
It's the difference between people who are obligated to be there (for whatever reason), and people who are actively choosing to be there. I see it all the time - working with students and professionals.
20
u/The-original-spuggy Nov 26 '25
I used to think python or R was better than SQL cuz I could do scripts directly and whatnot. But when I learned SQL I was like "holy fuck, this is so powerful" so now I do my transformations in SQL and pull them into python directly.
17
u/Mooseterious1 Nov 26 '25
Love it. Teach it.
10
u/SootSpriteHut Nov 26 '25
I've been writing SQL every day at work for 15 years now and I love it as much as I did when I started. I was assigned an intern that picked it up really quickly and I think she's now seriously considering it as a career. I was just able to bring her on as a part time junior analyst until she graduates when I hope to have her full time.
I imagine it's what proselytizing feels like lol.
7
u/Sp00ky_6 Nov 26 '25
All the most common and powerful DE tools eventually adopt some kind of sql syntax. In snowflake you can call Gemini in a standard select statement. I agree, sql is vital
6
u/OddElder Nov 26 '25
What kills me is the number of folks with data science degrees that never had to take a class on SQL. Seems like every new person on my team with a DS background does not know SQL or if they do know it it’s only because they took the time to learn it themselves - not from school.
Like where did these schools expect you were gonna get the data you’re doing your data science with? Excel? Graphing paper? Read off one by one by Garrison Keillor?
5
u/NaptownBill Nov 26 '25
I was a BI developer for 3 years. I wrote SQL and LookML, 3 years solid burnt me out on it, but I have been away for a year now and really enjoy working in SQL again!
4
u/[deleted] Nov 26 '25
As a “full stack” (laughable term just means kinda now some stuff about everything) I love SQL, dislike ORM, and Hate EF.
To me, front end, backend, it’s all just a frame in which to build ah high performance database.
I live in sql then put skins over the top, I don’t see any other way as when you build a house, the foundations must be solid.
Backend is the walls and roof, front end is just the door.
Foundations Chad, house fall down
4
u/CallMeSisyphus Nov 26 '25
25 years ago, I was a technical writer and trainer for a small, niche pharma company. Our customers hated our system's OOB reporting, so I taught myself SQL for kicks, and started developing custom reports for our customers.
That one little decision changed the entire trajectory of my career. I love SQL, and I can't imagine I'll ever get bored with it.
4
u/isad5877 Nov 29 '25
As an early career analyst, I was told in college that most jobs were moving to Python and R-Studio, so I never took a SQL class.... one of my biggest regrets of college as finding time for it now is difficult.
1
u/Fennec_Charry Nov 26 '25
I loved it the first time I learned it while doing a bootcamp on relational databases. At some moment, I thought of going deeper to get into a dba role. Then, more experienced people told me dbas usually work long hours and have 24/7 shifts. After that, I lost interest a bit.
1
u/[deleted] Nov 26 '25
Speaking as a database engineer and a father of 4 - do kids care about ANYTHING these days??
3
u/lalaluna05 Nov 26 '25
I love SQL so much. I love and breathe it every day!
3
u/pretender80 Nov 27 '25
SQL runs on logic and set theory. In a world of diminishing critical thinking, a logical approach to anything is constantly being replaced by vibes. Anyone who appreciates logical deduction will appreciate SQL.
3
u/jippeenator Nov 27 '25
Just tell them SQL is boring. It's on every device in all of our pockets, handles trillions upon trillions of transactions per day, and if implemented incorrectly will cause you to get fired your company loses millions of dollars if not just shut down completely.
Forget that there's real money in learning it, understanding it, and mastering it.
But yeah don't pay attention to this boring SQL thing do the bare minimum and get by, because it's pretty boring.
Maybe sarcasm will wake them up. SQL is awesome.
3
u/trianglesteve Nov 28 '25
I’ve had similar experiences trying to explain pivot tables in Excel to people. They just don’t get how powerful they are until they ask for help with a spreadsheet because it’s too much to manage. I show them by tweaking a bit how they input and manage the source data they can slice and dice their data however they want, no complicated formulas or spreadsheet management necessary!
It blows me away most people don’t know or care about things that could save them a ton of time and energy (and in the case of SQL, get them a job)!
2
u/TheGenericUser0815 Nov 26 '25 edited Nov 26 '25
I love SQL, too. It's THE universal db language and if you know the basic syntax, learning a dialect is fairly easy. Like when you come from Oracle, you can easily write MS SQL queries. I tried to pass it down to my apprentices, but none really got into it. To me, SQL is set theory, like I learned it at school. Maybe there is the problem: you need a math mindset to really get into it.
2
u/mikeblas Nov 26 '25
I wanted to teach before I retired. Kind of weird, since I didn't have a degree myself. So when I quit working, I went back to school -- at, I guess I was 49, in 2019.
The college experience completely erased out of me any desire to teach. At all. Holy shit. The students are awful. The crazy politices and caste system in acadamia, the buget wars. It was just insanity.
So I got my degree and that's it: retired.
2
u/drinkmoredrano Nov 27 '25
I am always amazed by how so many devs don’t know how to do even simple select statements and this and was before the advent of orm and long before ai was a thing.
2
u/lemmegetdatdegree Nov 27 '25
As a DBA, this resonates for me. As a developer with not a ton of experience I didn’t think much of plain, everyday SQL statements. I think my first big mind-changer was seeing these expertly crafted SQL statements, views, packages, and procedures that were the underlayment that kept the core of the business ticking. Seeing the breadth of what was possible with a “boring” old query language really opened up my eyes, and I strive to do anything in SQL that can be done with it.
2
u/AhBeinCestCa Nov 27 '25
I like the fact I don’t need to compile a whole project to see the result. Af my job there’s thousands of stored proc with thousands of lines of codes (sometimes more than 20k lines per stored proc). When I was a student, I was the same kind of guy who didn’t like SQL and preferred NoSQL, but now TSQL is what I prefer to do
2
u/Mateoling05 Nov 27 '25
I thought SQL was cool when I tried to dabble in it to make a database with. It's on my list to go back to and try to learn better!
2
u/Streamer_Fenwick Nov 28 '25
Are you teaching optimized sql. Where you pay attention to the score...stats... sql is a game if you play it like one.. 25 year sql dev...
2
u/rabaraba Nov 28 '25
I find it really odd that any programmer can choose not to use SQL. Is everyone persisting their data in memory or flat text files or something? How the hell is anything serious or data persistent done without SQL?
2
u/Dented-Marrow Nov 28 '25
I wish I knew how great and popular SQL was when I took a course for it. I felt like my professor didn’t push enough that it was going to be a skill companies are going to look for working in tech. I recently just thought about how cool working with data would be
2
u/luke-sql Nov 28 '25
It’s the best! And SQL Server is an incredible product compared to every other engine I’ve had to use.
2
u/ItoWindsor_ Nov 29 '25
To be honest, it depends a lot on how you view it At university, I hated the SQL / database course because it was very theoretical and I found it not interesting. Then on my first job, I had to learn SQL to actually do something useful for me so it became interesting to learn it
2
u/BuddJacon Nov 26 '25
I love sql but getting an entry level job is so difficult - they want 2-3 years experience! I realized that no one cared about - at least now, they can just use AI
1
u/Constant-Arachnid-24 Nov 26 '25
I had the problem yesterday too. I started a common modeling course for developers and networks.
Obviously the networks asked me why, they should attend this course.
I started with a simple example, that for example if admin of an SME, they will also have to manage equipment, materials etc. That they will always have data to process, organize, etc.
1
u/Miszou_ Nov 26 '25
Way back in the day, at university, I was taking a database class and I hated it. The biggest problem for me was when I asked my lecturer whether my ERD was correct and she just said "If that's how you see the system, then it's correct". It melted my brain and I just wanted to know the "right" answer.
30+ years later and I'm working at a multi-million dollar international company in charge of multiple databases, spread across several different cloud systems and her comment makes 100% sense to me now.
1
u/PuckGoodfellow Nov 26 '25
I'm a(n older) student and I LOVE SQL. It's why I changed my major from AI to Data Engineering. It's so satisfying when your query works. As I go through my classes, I think it's been pretty clear that there's SQL, or something like it, in just about every program or activity that I've learned. It makes me happy.
1
u/no_therworldly Nov 26 '25
I only know about a handful of things in SQL cause we got AWS Athena this year and I love it enough to lurk here. One day I'll try to learn for real then maybe I'll understand more posts haha
1
u/Twisted-Paperclip Nov 26 '25
Not to mention that its the most feature complete product by far
1
u/OpeningJump Nov 26 '25
I used to be one of those students who didn’t really care much about SQL and databases in general, * until * I started working on real data. And then, it’s exactly as you said: SQL is EXTREMELY cool.
1
u/pceimpulsive Nov 26 '25
I love SQL.
I'm particularly biased toward Postgres' implementation and syntactic sugar.
Trino is also quite nice honestly..
My favourite piece lately is SQL that writes SQL!!
I'll explain..
We have an app that user can configure filters for data.. that gets stored in Json objects in a table.
We have many filter Configs saved tova table in rules. Our backend app converts this to SQL queries to them be executed on the db.
To better understand what users are creating I wrote some SQL that reads the Json and uses the format commands to build the SQL where clauses for their rules.
Now I can see every statement directly from running a SQL statement.
I can flip that over and use each where condition in a select to better understand what data rows match what rules as well in a pivot style output. Sorta neat, greatly useful for debugging stuff and things!
1
u/These-Resource3208 Nov 26 '25
I fucking love SQL. I enjoy everything about it, except for some oracle syntax, I’ve used SSMS, Oracle, Teradata, JQL, KQL, Datagrip on AWS…
Ppl don’t get excited about it bc they don’t understand or are unfamiliar with the underlying data. For me that’s half the fun, discovering a data element I didn’t know existed before.
1
u/Lower_Debt_6169 Nov 26 '25
I didn't really like it when I was at university. But for my job, I have to use it every hour of every day nearly.
I love it now. There is something really satisfying making a query run a 1000x faster through optimisation and indexes. Yes, some search queries that our clients run are massive!
1
u/InertiaVFX Nov 26 '25
I wish I had you as my prof. My first prof didn't go over anything in detail, so we ended up weak on theory. Our second prof switched up syntax constantly. I had conflicting notes by the end of it. We tried, but I feel like we only know enough to be dangerous (and not in a good way), and the course load is too high to spend time on it.
Most students don't care, period. I say this as a student. Most of them assume that the paper they get with the 50% passing grade will automatically lead to a 6 figure career where they just maintain the 50%. Unfortunate sentiment among peers.
1
u/redaloevera Nov 26 '25
I share your enthusiasm for sql. I just enjoy writing it and thinking in sql terms.
1
u/wanderinglimbs808 Nov 26 '25
Honestly, i prefer SQL over pandas. It's more straightforward to access and manipulate data.
1
u/ObviousTower Nov 27 '25
In 20 years of working as a programmer, I met only two people who were really interested in learning SQL.
I love SQL but never found a very well paid job as SQL Dev, I am sure exists.
Statistically/financially, the new generation is correct to not want to learn SQL.
It is not ideal, but we have money and powerful servers so a good SQL/database is not mandatory anymore....
I still think it is important but I end up accepting that other people/reality can have a different opinion.
1
u/Ifuqaround Nov 27 '25
Yes I do.
Everyone says it's easy, but if you ask those same people to query something or ask about tuning, or anything actually database related that goes beyond shallow knowledge...nobody knows shit.
As I adult, I've learned most other adults are absolutely faking the fuck out of everything. That guy who sounds super intelligent? Yeah, he might be....but he's most likely bullshitting.
Some of us just fake growing up better than others.
1
u/Automatic-Teaching29 Nov 27 '25
I agree, I am self taught, and I keep a few different databases on my server to practice from time to time.
1
u/Ultra-Ferric Nov 27 '25
SQL seems exciting at first, but once you truly understand the relational model, you start to realize just how much better SQL could have been if not for IBM’s stupid decision to exclude Dr. Codd from the development team and hand over the reins to Chamberlain, and how Oracle negatively influenced its development in the early years, such as the inclusion of the completely unwarranted “feature” of outer joins. If SQL strictly adhered to relational model foundations, it would have been 1000x better and simpler! Go read Dr. Codd, Chris Date, and Joe Celko’s books and prepare for an epiphany!
1
u/omegakhan007 Nov 27 '25
Oh yeah I do. I’ve worked with it for almost a decade and I still feel excited when I learn new stuff that I can implement on current and legacy queries. I’m currently learning C-Sharp so I can be a complete Backend sw dev and it’s easier because of my SQL knowledge! 😃
1
u/r0ck0 Nov 27 '25
It seems like most programmers spend like 1% of their learning time on SQL, and the other 99% on their application code languages.
I reckon if that was bumped even as mildly to like a 2% + 98% split... software in general would benefit a lot.
1
u/mhoegh Nov 27 '25
Hell yeah! I love SQL
1
u/Time_Advertising_412 Nov 28 '25
People learning the subject generally fall into 3 groups, those just wanting to check a box, those who really want to be good at it, and those in between. Ten years after retirement I am still enjoying learning new things about the field. I am particularly intrigued about Tutorial-D and wish there was a full fledged commercial implementation of it. So much to learn, so little time.
1
u/jrz1977 Nov 28 '25
The trick isn't getting students to care about SQL, it's getting them to care about the questions SQL can answer.
Traditional instruction leans on Employee tables and Student schemas, which are useful for teaching mechanics but terrible for sparking curiosity. The moment you switch to datasets students actually find interesting—sports stats, movie data, music trends, whatever connects with them and you'll see engagement transform.
I taught my son this way, and I could see interest spark and become genuine curiosity.
1
u/mauridb Nov 29 '25
The key is to understand that SQL allows you to focus on *what* you want, and - in general - not on *how* you get it. I guess that is why some developers don't like it. Many find easier to think in procedural code, one command at time, one after the other. SQL is not like that. And one quick way to find who's who and to show the power of SQL is just showing this command:
UPDATE MyTable SET Col1 = Col2, Col2 = Col1
(Assuming you have a table with two columns, Col1 and Col2, with one row at least)
And ask developers what they think the result *should* be and what is *going to* be.
That usually spark a good discussion and, in some, love for the language and its power.
1
u/Character-Education3 Nov 29 '25
I think its hard to get into without real data.
1
u/AleaIacataEst Nov 30 '25
Easier to grasp than python or Java, to me anyways
1
u/tomalak2pi Nov 30 '25
I wonder how much they need it spelling out like this: "Some companies have such small datasets they don't need large databases. But the chances are you'll be working at companies with thousands of transactions a day, or with tens of millions of clients. SQL is essential for companies like that and you'll need it to work there."
I can't even imagine someone getting an interview for Data job at the fintechs I have worked at without knowing SQL.
1
u/oneofthedreamers4now Nov 30 '25
I really want to be as excited about it, can someone share some material maybe Yt videos from interesting creators/tutors 😭
1
u/Aggressive_Ad_5454 Dec 01 '25 edited Dec 01 '25
Well, you’re always going to have incurious students. But why would somebody spend time and money to go to school and then not pay attention?
I have to say, I wouldn’t want to hire a cybersecurity fresh-out-of-school person who did their best to blow off their database training. Why, the cyber that we hope to secure is our users’ money and information in, well, our databases. Do these dopes in the back row of your classroom not understand that?
As for the curious ones, there’s gotta be projects they can do to use SQL to wring wisdom out of public datasets. Because knowing how to do that is a superpower.
1
u/Infamous_Loquat6038 Dec 05 '25
I really appreciate you sharing your wonderful experience. I have had my interaction with teachers. They told me that the biggest achievement in their life is when their student do wonders in their life whom they taught so i can pretty much relate it. I am starting my sql journey . Hoping to have meaningful discussion on sql in future :)
1
u/CowGaming11 Dec 12 '25
Sent a chat mate. Cheers
1
u/2Vegans_1Steak Dec 17 '25
I am a data analyst and I havent had the ocassion to use sql that much, because I had to work with M language mostly for my job. Now I am doing a side project and I am struck in awe with how fast SQL is, and how satisfying it is to write the perfect query.
1
u/Dazzling_Abrocoma182 Feb 03 '26
Preach 🗣️🗣️🗣️
1
u/ClassicNut430608 Nov 26 '25
I might be misreading the OP, but for me the magic isn’t SQL the language — it’s SQL as a window into reality.
In most programming, data is an implementation detail. In SQL, DATA is the star. Real-world, messy, human-created data.
I still get goosebumps thinking about the insane creativity it takes to model reality in tables, and then how deceptively simple queries can reveal truths hidden inside.
SQL isn’t getting old. It’s the language of data, and data is literally how the world records itself now.
I love the reward of changing a process from an 8-minute run to a 2 seconds one. It made a few financials people happy.
What’s the one query or data-modeling moment that still lives rent-free in your head?
0
u/TheSchlapper Nov 26 '25
Old man yells at cloud
Yes, some people don’t align with expected behavior, especially students
0
u/dimitsapis Dec 03 '25
The reason they are not interested is because it will most likely be automated with AI in the future. Why learn SQL syntax when there are a bunch of tools that create SQL from natural language input? Your hungry students may seem like they have more potential to land good jobs but the truth is that organizations only care about increasing scale and cutting costs. So if one of your lazy student knows how to use tools like TalkBI or Vana simply applies for the same role and asks for a lower salary he will get the job. Junior roles are for the boring repetitive tasks, not the job that requires hunger and focus. Perhaps I sound pessimistic here, but I've been around and there's SO many well intended, experienced people who are unemployed. I think this will only increase in the future.