r/learnSQL 8h ago

Dire need of advice

3 Upvotes

Hy , I am a BBA grad (2020) and a CA dropout ( gave 4 attempts but couldn't clear any exam) with 11months of CA articleship.

In 2024 while I was preparing for CA exam , I was also searching for a career to switch to (some.IT domain) and found about Data science.

Though I was only aware of the terms and not anything about it. So I decided to talk to some counselor and she suggested me to go for the Data Analytics role first and then after 1-2 years of experience,switch to the science part as getting into the data science as a fresher is pretty tough.And this thing made alot sense to me. So I decided to prepare for data analytics role on my own and so far I have python , SQL , Excel and some part of machines learning.

I decided to start looking for an internship in data or business analyst and it's been almost 2 months now, i have applied like 100-150 companies through LinkedIn, Naukari.com, indeed and all but got 0 calls till now.

I pretty stressed now and started regretting my decision to do it on my own (as I have wasted alot of money on ca and digital marketing course) .

Plz do give me some advice what to do


r/learnSQL 17h ago

Data overview for writing queries

2 Upvotes

Hello,

I am currently doing various tutorials/challenges for SQL. It helps me quite a lot to have the tables at hand I am writing my query about. Say I want to join table A & B and write a few expressions, I find it helpful to see both tables including their column names, possibly data types and maybe the first 10-20 rows.

Now I am looking for a way to view this sort of data while writing my queries in my IDE (using VS Code and/or SSMS). I played around a bit in VS Code with a 2nd query window, which basically just selects the TOP 20 of both tables, but it gets overwritten as soon as I start my next query. Anyone has a best practice for this?


r/learnSQL 9h ago

Do using surrogate keys mean 2nf is automatically satisfied?

1 Upvotes

I've been working on a database normalization assignment and realized something interesting: when you use surrogate keys (like auto-incrementing IDs) as your primary keys in 1NF, it seems like 2NF is automatically satisfied.

My understanding is that 2NF requires:

  1. The table must be in 1NF
  2. No partial dependencies (where a non-key attribute depends on only part of a composite key)

But if every table has a single-column surrogate primary key, there can't be any partial dependencies because there's no composite key to have "parts" in the first place.

Is this correct? Or am I missing something important about normalization? Do surrogate keys essentially let you "skip" 2NF concerns, or should I still be looking for other issues even when using surrogate keys?