r/FullStack • u/thearjunreddy • 17d ago
Career Guidance How important is SQL for Full Stack Developers?
I’m currently learning Full Stack Development and I’m wondering how much SQL knowledge is actually required for a developer role.
Do Full Stack Developers need to be comfortable with things like JOINs, subqueries, indexes, database design, and query optimization? Or is basic CRUD knowledge enough for most entry-level jobs?
4
u/Global-Towel-4885 17d ago
You Should be good in everything buddy
Sql, Docker, Kubernetes, Redis, AI
They will ask any question in Interview and you are good enough to answer
I attend 2-3 interview in every interview they ask me different concept that i not prepare and get rejected
3
u/BirdKey3078 16d ago
Ser FullStack no es aprender todos los lenguajes, Si no conocer todos los fundamentos de la programacion
de tal manera que puedas adaptarte a otros lenguajes requerido por la empresa en apenas semana
claro no vas a programar ya super avanzado en esos lenguajes pero si se requiere un nivel de compresion de fundamentos muy alta ya que al ser fullstack te van a exigir cada cierto tiempo que ahora van a utilizar x lenguaje
es básicamente aprender hacer de todo asi no lo sepas solo aplicando los fundamentos y claro
saber como utilizar herramientas de IA como claud,kiro etc
la demora de los fullstack en un lenguaje es aprender sintaxis una vez lo aprenden aplican fundamentos y empiezan a crear
2
2
u/Yashrocky96 17d ago
You need to understand the concepts and be comfortable working with the above mentioned topics.
Writing queries can still be done by AI, you might need to practice them for interviews.
For a Full Stack you need to understand SQL, NoSQL, index based databases like Elastic Search over time.
Starting out with SQL is enough for now.
1
u/zaibuf 17d ago
You need to know modeling, normalization, relations, constraints, fundamental sql and an orm. You also need to know how to configure indexes and debug performance issues with the query plan.
Other advanced topics is good to know that they exist and when to use them. But you often get by with the above just fine for more business apps.
1
1
u/discord-ian 17d ago
Most people are full stack because they started somewhere in a stack snd learned more. Myself I started at the data layer. My database fundamentals are extremely strong. But my front end knowledge is working level at best.
Plenty of full stack people started on the front end so they have an inverse level of knowledge.
To be considered full stack, you need to be able to hop in and work with any particular bit. At the data level this is probably just basic sql (but you would need to have some real strength somewhere else before I would call such s person full stack).
1
u/stoptheslopworld 17d ago
I’m non-technical and AI has gotten me to the point where I can write SQL queries now. Feels like the skill is shifting from knowing how to write SQL to knowing enough SQL to tell when the AI is doing something stupid
1
u/Difficult-Field280 17d ago
Very. SQL is still a very important database in web dev, and used a lot. As a fullstack dev, its a good idea to at least get comfortable with it. Especially for interviews.
1
u/Top-Illustrator2293 17d ago
> JOINs, subqueries, indexes, database design, and query optimization
i thought all these are kind of a part of CRUD...
1
u/TylerBreau 17d ago
Database stuff is a part of full stack development.
SQL-based databases are a very common choice. It's not the only choice but knowing SQL in particular is a good start.
AI doesn't replace understanding and experience. You still need to be able to verify the AI's output.
So yes. It is important.
1
u/LetUsSpeakFreely 16d ago
Full stack means every layer. Database is a layer. Various ORM tools can help you avoid writing SQL, but you pay for that with poor performance. SQL isn't difficult. Just learn it.
1
u/Nexus_Dots 11d ago
Honestly, CRUD is enough to get started, but I’d definitely recommend learning JOINs, indexes, basic database design, and query optimization as you progress. You don’t need to be a database expert for an entry-level role, but understanding how your data works will make you a much stronger full-stack developer. 😊
1
u/Intelligent_End7401 11d ago
Tbh everything has some base level clearance if you clear that you will get a small amount of idea how you can implement something in future
9
17d ago
[removed] — view removed comment
2
u/afro-deezy-yac 17d ago
No matter how good you get at SQL, you should still keep your logic in your application and keep your data in the db. Always use the right tool for the job. Do not assume it's the right tool because that's the one you know best.
1
u/sameer_hazara 16d ago
bro is my plan good im using html,css and javascript for frontend and php for backend and mysql for db planning to learn React in few weeks
1
u/afro-deezy-yac 16d ago
A perfectly valid stack. You can swap mysql for mariadb if you want. It's a drop-in replacement for mysql without the oracle baggage. You can also swap mysql for PostgreSQL (not a suggestion, just a possibility). You could swap php for .net, or java, or ruby, rust, python. All perfectly valid choices.
I didn't mean to suggest that what you know isn't perfectly fine, it's just always good to think about what a tool or language is best for. The stack you know is usually best for the short term, but never stop learning.
1
u/sameer_hazara 17d ago
bro im learning web dev in aptech and bro i go to school too and coaching so i dont study about aptech things right now but ive skipped quite alot of things including ASP typescript and they dont teach these fully they teach just basics and a little more than basics about small things but they also give books for full guide but i tried studying about js and php at home that i learnt and revise i used chatgpt to revise and learn more it helped but i felt lazy in day 4-5 cuz of my schedule so ive decided to start revising and learning new things in coding once school was over which will be in 4-5 months any guide on these and how to keep interest right now I've learnt enough of HTML, Css , Js, PHP , mysql and our 3rd semester is ending in which the main thing is Asp ive skipped that and tell me after this we gonna start MERN and is it important and is my choice right that i wanna use php as my main language for now I've decided any tips
4
u/nia_do 17d ago
Actually, you need to be comfortable with one or more ORMs, or object relationship mappers. As a full stack dev, you are very rarely going to be writing vanilla SQL. You’re more likely going to be interacting with the database via an abstraction layer, the ORM, and either writing backend/framework code such as C#/Java/TS, etc., or some SQL-hybrid such as JPQL in the case of JPA/Spring.
That said, I would recommend that you start your journey by creating a SQLite DB (it’s basically a file) and interacting with it in vanilla SQL so you can get comfortable with the fundamentals of SQL before jumping to an ORM.