SQL: Let your heart and SQL out here

[Razer0]

Hey guys,

Thinking of going into SQL for a full time hobby, possibly maturing into a healthy career.

Can I get your thoughts, opinions, favourite moments, expressions, etc etc here to help make an informed decision.

Thanks

 

[Urist]

Do it
Understanding SQL can be very useful for many companies.

 

[Razer0]

Do it
Understanding SQL can be very useful for many companies.

In its purest form?
I'm feeling like I'd be expected to know JavaScript on the burner to "be a worthwhile employee"

 

[Rocket-Boy]

Razer0 from bf2 days???

 

[phil77]

I use SQL a lot(mostly) since we work on the database. You will need to know the procedural side of it as well.

 

[Urist]

In its purest form?
I'm feeling like I'd be expected to know JavaScript on the burner to "be a worthwhile employee"

I'd recommend understanding how relational databases work and the concepts behind it, and then the actual syntax and scripting.
itzik ben-gan explains it quite well in his mcse exam prep books. Useful to learn sql alongside programming, can't go wrong.

 

[Thor]

Add NoSQL

 

[Thor]

Add NoSQL

 

[Razer0]

Razer0 from bf2 days???

Hey bro what's happening?!?

 

[Dan C]

Add NoSQL

Select unique

 

[Herr der Verboten]

Hey guys,

Thinking of going into SQL for a full time hobby, possibly maturing into a healthy career.

Can I get your thoughts, opinions, favourite moments, expressions, etc etc here to help make an informed decision.

Thanks

just linqpad it

 

[Razer0]

Is

I use SQL a lot(mostly) since we work on the database. You will need to know the procedural side of it as well.

Is it fun? Exciting?
Details, details I need moar!

 

[phil77]

Is

Is it fun? Exciting?
Details, details I need moar!

I find it fun, I have always worked with databases so I might say, I don't have experience in anything else different. There is more to it than just select * from table; it gets fun when you have to optimise slow queries and using complex functions.

You almost need to work in an environment where you use a lot of data to really appreciate SQL.

 

[Razer0]

I find it fun, I have always worked with databases so I might say, I don't have experience in anything else different. There is more to it than just select * from table; it gets fun when you have to optimise slow queries and using complex functions.

You almost need to work in an environment where you use a lot of data to really appreciate SQL.

That does sound like fun.

I imagine some turning around and walking out the door at this point *borriinnnnng

I'm keen to try. 30min a day?

Just need to keep my focus. I like Urist's recommendation:

"understanding how relational databases work and the concepts behind it"

Now I need to do some digging and find some jewels.. motivation..

 

[Rocket-Boy]

Hey bro what's happening?!?

Not much gaming these days unfortunately.

So on the SQL side, I work for a really big IT company and we have tons of SQL only guys. Some are DBA's but others are just SQL guys.
They pull out reports when requested and fix the odd small problem from time to time.
So really I think it comes down to the size of the company, the bigger the staff the more specialized people become.

 

[Hamster]

My favourite part is using Postgres to generate GUID IDs but for that to happen I need an extension enabled but for that to happen on Azure I need super user access which means code first deployments (EF) require super user credentials...

Whereas with MSSQL you don't. But you have to pay a lot for this basic luxury.

 

[Razer0]

My favourite part is using Postgres to generate GUID IDs but for that to happen I need an extension enabled but for that to happen on Azure I need super user access which means code first deployments (EF) require super user credentials...

Whereas with MSSQL you don't. But you have to pay a lot for this basic luxury.

That sounds exhaustive and complex.
What is a GUID ID?

 

[Hamster]

That sounds exhaustive and complex.
What is a GUID ID?

GUID = Global Unique Identifier. Looks like this: e65fa27d-c44a-4f1f-9a0f-cdee0fce3b36

So instead of using a numeric value for an ID (Primary Key) you use those. Why would you do this? Various reasons. Why wouldn't you do this? Various reasons.

 

[Razer0]

Not much gaming these days unfortunately.

So on the SQL side, I work for a really big IT company and we have tons of SQL only guys. Some are DBA's but others are just SQL guys.
They pull out reports when requested and fix the odd small problem from time to time.
So really I think it comes down to the size of the company, the bigger the staff the more specialized people become.

Oh no, that's not good Always make time to play doesn't necessarily have to be gaming tho. Could also just be kicking a ball back at you off a wall.

Cool that's motivating. Thanks rocket boy. Good to see you again.

 

[Razer0]

GUID = Global Unique Identifier. Looks like this: e65fa27d-c44a-4f1f-9a0f-cdee0fce3b36

So instead of using a numeric value for an ID (Primary Key) you use those. Why would you do this? Various reasons. Why wouldn't you do this? Various reasons.

Why specifically would one use postgres to generate GUID's?