I am a final year student and I'm just about to enter placements and I'm trying for data analyst roles in my college and I wanted to know working on sql in hackerrank is good ? Will it be respected I am currently 4 stars and does it make sense for me to go and get the 5th star and keep a good profile? Or is some other site worth more please give advice
So i was planning to learn sql(i actually started),excel, python and power bi but the question is do i have to learn all of these to get a job or can i learn some of them to get a job and while working learn the other things?
I don't have any background in programming it's my first time trying this and i wanna achieve something in it I've tried alot of other things and everytime i stop and don't continue but this time i wanna become something in this path.
I learned count (*), distinct, substring, concat, extract, where (=<>),in, between, like and i have been asking Gemini to give me challenges based on what i learned and I won't say I'm getting all of them right but I'm getting better so now my problem is group by i feel like I'm stuck at it and can't understand it.
so i know basics of sql and all,but in interviews/oa if they ask i kinda freeze,it takes me a bit of time to come to solutions,i feel that can avoided with practice..So which platform did u guys find useful ?
I've spent the last few months building something and I'm finally at the point where I want to share it properly rather than just quietly hoping people find it.
The idea came from a frustration I kept seeing (and feeling myself): SQL tutorials teach the syntax fine but there's never a reason to care about the answer. You filter a table called employees, get a result, and nothing happens. Your brain doesn't bother keeping it.
I wanted to try a different approach. QueryCase teaches SQL through detective investigations. You get a briefing from Chief Fox (our mascot), a real database to query, and a mystery to crack. The JOIN matters when a suspect has an alibi. The WHERE clause matters when you're trying to find who entered the building at 22:13. The SQL is the tool for solving something, not the point in itself.
Here's what's actually in it:
I'm a solo developer and this is genuinely early days. I'm sharing here because this community is exactly the kind of people I built it for, and I'd rather get honest feedback now than find out later I've built the wrong thing.
What's missing? What would make you actually stick with something like this versus what you've used before?
querycase.com if you want to take a look.
Any feedback appreciated!
I recently tried a fun little experiment to make SQL feel a bit more approachable—using hand-drawn cat doodles to explain SQL concepts. 😸
So far I've made two lessons:
Lesson 1: SELECT and FROM
PAWQL = SQL for Cat People Lesson #1
Lesson 2: WHERE
PAWQL = SQL for Cat People Lesson #2
The idea is to explain SQL visually, with simple doodles instead of walls of text. I'm still experimenting with the format, so I'd genuinely love to hear what works, what doesn't, and what could be improved.
Thanks for taking a look, and I appreciate any feedback! 😊
I'm a fresher trying to understand what SQL skills are expected in a real data analyst role.
For those with 3–4 years of experience:
How advanced is the SQL you write day to day?
What kinds of business questions or requests do you typically solve using SQL?
Which SQL concepts do you use most often, and which ones are rarely used?
I'd love to hear some real-world examples of the tasks you work on.
Which platform is more widely used for data analyst roles: Snowflake or Databricks?
If you could learn only one first, which would you choose and why? I'm particularly interested in which one is more commonly used in day-to-day analytics work across companies.
I'm preparing for SQL interviews and was wondering if there's a good website to practice SQL problems like we use LeetCode for DSA. Looking for interview-style questions and hands-on query practice.
Any recommendations?
I'm a fresher preparing for a data analyst role, and I'd love to understand how SQL is used in day-to-day work.
For those with experience as data analysts, what does your daily SQL work look like? What types of queries do you write most often? Do you spend more time writing new queries, optimizing existing ones, creating views or stored procedures, or something else?
I'd really appreciate hearing about your real-world experience.
My campus internship OAs are gonna take place after 2 weeks...I have like 10 days to prepare for SQL. I don't know anything about SQL or DBMS right now and my target is just to clear the OA questions (even if i am not a master of databases) which are mostly SQL based...i can devote 3-4 hours everyday (cuz i have to revise dsa as well, so can't be doing sql the whole day).
Suggest me what you did (cuz i am sure many of you would've been in the same situation) - one shot / article / question practice (i just know about the LC 50 right now) etc...so that i can get the max return in whatever time I have.
context: this internship is college-assisted and is for the 2027 summer...so, even i would have 1 full year to upskill before my actual internship begins - i just need to get in somehow.
Hey guys, can you please suggest a really good, valuable power BI, SQL Course that a beginner can do in a less time, and which makes you ready for entry level jobs in risk domain.
Hello finance major here, I was looking into different types of certificates I can do like sql. Does anyone have done SQL and how does that helped you with your job or even getting a job? What are the best platforms to learn SQL from? What are other certificates or skills I can learn?? Please if you can help me I’d appreciate it.
hey guys, so i’d like to have a career in data analytics/ data science and right now i’m trying to learn excel and sql.
i was wondering if anyone could give me some examples of questions a business might ask a data analyst (or just general questions you could ask about certain data), because i’d like to do some projects and maybe start to build a portfolio, but i’m kinda lost on where to begin.
​
I'm preparing for a data analyst role and have been learning SQL, Power BI, and Python. One area I'm struggling with is domain knowledge and business thinking.
How did you learn about different business domains (e-commerce, banking, healthcare, etc.)? What resources or approach helped you the most?
Also, when you're given a business problem, how do you approach it? How do you break it down, decide which metrics to analyze, and identify the root cause?
I'd really appreciate any advice or resources that helped you when you were starting out.
It's not perfect, and I'm still a beginner with both html and sql, so sorry if I got anything wrong. Html is hell. I had to ask help from my teacher and chatgpt just to figure out how to do things with html like making a heart.
Never again
Went from a pdf to this
https://alejandronuez94.github.io/SQL-project-made-for-beginners-/
Hi I'm a bit confused with how to organise multiple projects in postgres.
I have 2 main databases I'm using one a database for my gardening and another for a football group and league that I run. I also do courses and stuff so have a lot of learning tables.
But I cannot find how to organise these, how people separate it what good practices for naming and layouts I should use.
I just seem to be adding more tables.
Hi Everyone,
Currently, refreshing my memory for SQL and I came across the below question on HackerRank:
Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than 38.7880 and less than 137.2345 . Truncate your answer to decimal places.
My Solution:
select truncate(sum(LAT_N),4) from station
where LAT_N > 38.7880 AND LAT_N <137.2345;
Error:
Compiler Message
Runtime Error
Your Output (stdout)
What am I missing ?
Thanks in advance for your support .
Hi, I have 5 days off coming up this weekend and really want to grind out learning SQL or at least spending most my days in learning that I can continue practicing after grasping the basics. I tried using W3Schools and MySQL and am willing to spend a few bucks on a course that I can learn and apply SQL while learning. Also maybe down the road one that has a project I can update on my resume. I work in healthcare and am trying to transition into a role with more flexibility and slightly more pay and am hoping this would help. Thanks.
Hi everyone, I’m in the process of interviewing at this AI company and the next step is to use bigquery dialect of SQL where I will cover real-worlds scenarios and build tables.
Problem is I have never used SQL and I am just finding out about what it is, I’ve never heard of it. I will be watching a few YouTube videos but wanted to see if anybody has gone thru this process before?
Any tips?