Is SQL really this easy :gucci:?

[MR. SNIFLES]

I've been working with SQL daily for a few years now. It is simple enough to wrap your head around, but I think that one of the hardest parts about querying databases is that just because your query returns results, doesn't mean that the results are correct. There is an additional layer of QA that is necessary for most tasks that catch a lot of incorrect assumptions, bad data, and the likes. Remember that good data is the results of a lot of other processes going smoothly since inception and that is rarely the case.

This isn't to say that you aren't well on your way to becoming a skilled SQL user, but more to say that database work can be a very humbling act.

I'M NOT A CODER BUT I WAS TAUGHT THAT THE ONLY THING WORSE THAN NO DATA IS BAD DATA THAT APPEARS TO BE GOOD.

 

[calixprynce]

what kind of job can you land by mastering SQL?

 

[Secure Da Bag]

what kind of job can you land by mastering SQL?

DBA, Data Warehousing, and

https://www.thecoli.com/threads/bi-...ce-careers-official-discussion-thread.735663/

 

[Dr. Acula]

SQL syntax wise is easy but gets harder as you deal with more complex databases. Especially keys if there are many dimensions to your data.
The difficulty of using it is not syntax but logic of how to tie various elements together.

 

[Secure Da Bag]

SQL syntax wise is easy but gets harder as you get into more complicated as you deal with more complex databases.
The difficulty of using it is not syntax but logic of how to tie various elements together.

Fair assessment.

 

[Obreh Winfrey]

I was talking with one of my guys about setting up a schema for a pet project he has. When I explained how things might look he started to die a little inside

 

[Secure Da Bag]

I was talking with one of my guys about setting up a schema for a pet project he has. When I explained how things might look he started to die a little inside

Normalized tables are everywhere.

 

[Obreh Winfrey]

Normalized tables are everywhere.

A what ?

 

[daboywonder2002]

One common thing I see with all these clinical analyst and application analyst ibs is that they require SQL. Could I teach myself or do most jobs really expect u to know the ins and outs? I don't know SQL. I'm watching a youtube video on it know but not sure that it's enough to actually put on my resume.

 

[greenvale]

One common thing I see with all these clinical analyst and application analyst ibs is that they require SQL. Could I teach myself or do most jobs really expect u to know the ins and outs? I don't know SQL. I'm watching a youtube video on it know but not sure that it's enough to actually put on my resume.

You can teach yourself. Use something like SQLZoo as a free supplement to your YouTube resume.

SQL skills can vary but at the bare minimum you should be able to easily write joins, basic grouping and aggregation. Pivots too.

 

[MrNoFlyZone]

One common thing I see with all these clinical analyst and application analyst ibs is that they require SQL. Could I teach myself or do most jobs really expect u to know the ins and outs? I don't know SQL. I'm watching a youtube video on it know but not sure that it's enough to actually put on my resume.

I started with this

SQL: Data Reporting and Analysis

 

[F K]

A what ?

This shyt cracks me up every time I come back in here. So much work to normalize tables and it can be so easy to get them de normalized. especially on big dbs.
I'm sitting there working on a feature, I'm like hmmm. I need a new column, add the column, write the code.. run it by my boss in the 1 on 1 and he's like. oh we already had that data in this other table, just use that

 

[Kwabena]

I've been putting off learning SQL for too damn long. Definitely a great tool to have in your repertoire

 

[Secure Da Bag]

I've been putting off learning SQL for too damn long. Definitely a great tool to have in your repertoire

Damn straight.

 

[Secure Da Bag]

One thing, I still struggle on is window functions. I think I just haven't had enough opportunities or scenarios to use them fully.