Raocorp
(Post Master Sr)
08/24/15 01:22 PM
SQfuckingL.....

anyone here know this shit and can give me the dummy version explanation? Statements? wtf?!?!?!?!
My new boss wants me to learn this shit. Reading some tutorials online is sooooooooo boring. We did very little DB stuff in school, fuck. Wish we had done more (because Rye High ).
Gotta learn some VBA too but we did zero of that. Business students should learn some VBA shit IMO rather than be forced into bogus electives.


OracerO
(Post Master Sr)
08/24/15 01:30 PM
Re: SQfuckingL.....

Database manipulation is super powerful to know.

Not that i can help, i'm actually learning it at work, i'm not that great at it.

I had nothing to contribute to this post, sorry.


furball
(Post Master Sr)
08/24/15 01:31 PM
Re: SQfuckingL.....

SQL is one of those things that ... it's fucking cray and you need a separate degree just to understand it... But once you start... it's pretty easy.

I'm in the bucket of SQLtard...

There are also 'visual' DB query apps... I think DBVisualizer is one of them, but was a bitch to get the ODBC connection string...


Euphoricuck
(Post Master Supreme)
08/24/15 01:36 PM
Re: SQfuckingL.....

run a few queries on google ;\)


surprised your boss didnt fire you for not knowing


SuPeR-MaRiO
(Post Master Sr)
08/24/15 01:58 PM
Re: SQfuckingL.....

I can help you out, what exactly do you want/need to know? Why does your boss require you to know it? Are you getting read-only access to some tables and it would be more efficient to just have you create and run your own queries?

Choco 'Nuck
(Post Master Supreme)
08/24/15 02:16 PM
Re: SQfuckingL.....

Dennis (HyperS2k) might be able to help too.

furball
(Post Master Sr)
08/24/15 02:29 PM
Re: SQfuckingL.....

NorthWinds bro...

Big Tasty
(Post Master Supreme)
08/24/15 02:44 PM
Re: SQfuckingL.....

We are moving away from brio to qmf. Can't stand the tool but I am also looking into pulling queries using excel. Looks promising and more of a wysiwyg query builder tool.

I should get into more SQL language though, haven't touched it since school learning Oracle way back in the day.


Raocorp
(Post Master Sr)
08/24/15 03:05 PM
Re: SQfuckingL.....

 Originally Posted By: SuPeR-MaRiO
I can help you out, what exactly do you want/need to know? Why does your boss require you to know it? Are you getting read-only access to some tables and it would be more efficient to just have you create and run your own queries?


I'm just starting using it so I know nothing atm.
From what I understand there's all sorts of data stored on the server and I'm going to have to come up with queries to sort through it all. Are there basic query statements?
All these tutorials I read/watch are all the same. Monotone blah blah blah.
I don't mind doing it, just hate when I have no idea whats infront of me.


Risky Business
(Post Master Supreme)
08/24/15 05:06 PM
Re: SQfuckingL.....

 Originally Posted By: Raocorp
 Originally Posted By: SuPeR-MaRiO
I can help you out, what exactly do you want/need to know? Why does your boss require you to know it? Are you getting read-only access to some tables and it would be more efficient to just have you create and run your own queries?


I'm just starting using it so I know nothing atm.
From what I understand there's all sorts of data stored on the server and I'm going to have to come up with queries to sort through it all. Are there basic query statements?
All these tutorials I read/watch are all the same. Monotone blah blah blah.
I don't mind doing it, just hate when I have no idea whats infront of me.


If I was in the earlier stage of my career I would seriously consider taking a course on this. I've self taught myself basics, enough to 'wow' a few finance people, totally worth it. I no longer churn reports, but definitely a solid skillset to have!


Choco 'Nuck
(Post Master Supreme)
08/24/15 05:39 PM
Re: SQfuckingL.....



LNXGUY
(Post Master Supreme)
08/24/15 06:40 PM
Re: SQfuckingL.....

Select * from lickmyballs
order by ballsize


f22b-dohc
(Post Master Supreme)
08/24/15 07:53 PM
Re: SQfuckingL.....

Select * from csi
Where region = 'Ontario"
and "Car" = 'S2000'


Result:

Hyper
F22b
Iamfob

Now....

Play with this later... Fun

Future owner of said s2000 is crying





loudsubz
(Post Master Supreme)
08/24/15 08:27 PM
Re: SQfuckingL.....

transfer it all to ms excell and sort dem cells \:\)

Raocorp
(Post Master Sr)
08/24/15 09:21 PM
Re: SQfuckingL.....

 Originally Posted By: loudsubz
transfer it all to ms excell and sort dem cells \:\)


thats what i'm doing now but its too much.
Any one know any good online resources?


SilverSiR2
(Post Master Supreme)
08/25/15 09:51 AM
Re: SQfuckingL.....

What do you need to learn? Is the data already in a SQL DB and you just need to learn how to query data or you need to build a database from scratch? Data modelling can get especially complicated if your raw data is complex with many models.

SuPeR-MaRiO
(Post Master Sr)
08/25/15 10:18 AM
Re: SQfuckingL.....

Do you understand basic database principles?

Might sound dumb but how about SQL For Dummies? (download link). It might help provide some background info and bridge the gap.

Otherwise there are a lot of online tutorials out there, paid and for free.

Udemy has a bunch of them. Check out their Introduction to Databases and SQL Querying (its free). They also have other free ones and if you like their style and are interested in any of the paid ones let me know as they can be sourced. I don't have any personal experience with this company (there are tons of them out there).


Raocorp
(Post Master Sr)
08/25/15 10:58 AM
Re: SQfuckingL.....

 Originally Posted By: SilverSiR2
What do you need to learn? Is the data already in a SQL DB and you just need to learn how to query data or you need to build a database from scratch? Data modelling can get especially complicated if your raw data is complex with many models.


No data is already there, I just need to learn how to come up with useful queries.

 Originally Posted By: SuPeR-MaRiO
Do you understand basic database principles?

Might sound dumb but how about SQL For Dummies? (download link). It might help provide some background info and bridge the gap.

Otherwise there are a lot of online tutorials out there, paid and for free.

Udemy has a bunch of them. Check out their Introduction to Databases and SQL Querying (its free). They also have other free ones and if you like their style and are interested in any of the paid ones let me know as they can be sourced. I don't have any personal experience with this company (there are tons of them out there).


Yes I do understand basic database. I know about tables and their relations. But I don't know how they relate in my particular situation yet. I need to understand that as well. thanks for the links Super M. I defi have some homework to do.


The hardest part is getting through all the bs. After being at work on a computer for 8+ hrs a day, last thing I want to do is spend more time reading this non-sense. Thats the biggest hurdle for me atm, plus working on CPA stuff too. All these tutorials seem to be essentially the same.


Big Tasty
(Post Master Supreme)
08/25/15 11:16 AM
Re: SQfuckingL.....

Trying using excel, it's pretty straight forward to query data using it.

https://www.youtube.com/watch?v=4QbGoDJJuZ4


f22b-dohc
(Post Master Supreme)
08/25/15 11:54 AM
Re: SQfuckingL.....

i learned SQL on the job...

one thing that's helped me is having a spreadsheet that has all the tables and column values...

or even select top 10 * from (table) to see what values are there...

once u get a nice sql with join and tmp tables you should be good...

save it and manipulate \:D

next thing u know you are taking apart stor procs


Just A Troll
(Post Master)
08/25/15 03:17 PM
Re: SQfuckingL.....

 Originally Posted By: Euphoric
run a few queries on google ;\)


see what you did there. nice!


hyper-s2k
(Post Master Supreme)
08/26/15 04:24 PM
Re: SQfuckingL.....

 Originally Posted By: Chocolate Canuck
Dennis (HyperS2k) might be able to help too.


I actually suck at DB / SQL shiet.

Simple queries are fine - it's when you throw in joints and dealing with multiple tables in a query then I am screwed.

When in doubt:

drop table <table_name>

\:D

Coding is ok though - but I haven't touched that in years.