#8338668 - 08/24/15 01:22 PM
SQfuckingL.....
|
Raocorp
Cougar Slayer
Post Master Sr
Registered: 10/10/02
Posts: 7768
Loc: Toronto
|
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.
|
Top
|
|
|
|
#8338684 - 08/24/15 01:30 PM
Re: SQfuckingL.....
[Re: Raocorp]
|
OracerO
Post Master Sr
Registered: 10/07/02
Posts: 3949
Loc: GTA
|
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.
|
Top
|
|
|
|
#8338866 - 08/24/15 03:05 PM
Re: SQfuckingL.....
[Re: SuPeR-MaRiO]
|
Raocorp
Cougar Slayer
Post Master Sr
Registered: 10/10/02
Posts: 7768
Loc: Toronto
|
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.
|
Top
|
|
|
|
#8339081 - 08/24/15 05:06 PM
Re: SQfuckingL.....
[Re: Raocorp]
|
Risky Business
Provides a Great Work Environment. he/him
Post Master Supreme
Registered: 05/17/10
Posts: 44797
|
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!
|
Top
|
|
|
|
#8339125 - 08/24/15 05:39 PM
Re: SQfuckingL.....
[Re: Risky Business]
|
Choco 'Nuck
Proud Member of BLM
Post Master Supreme
Registered: 07/10/01
Posts: 17568
Loc: Somewhere out there
|
|
Top
|
|
|
|
#8339165 - 08/24/15 06:40 PM
Re: SQfuckingL.....
[Re: Choco 'Nuck]
|
LNXGUY
Post Master Supreme
Registered: 08/06/00
Posts: 106985
Loc: Barrie, Ont,
|
Select * from lickmyballs order by ballsize
_________________________
-Bill The GN would OWN you, your children and your children's children. '09 E90 335 d
|
Top
|
|
|
|
#8339243 - 08/24/15 07:53 PM
Re: SQfuckingL.....
[Re: LNXGUY]
|
f22b-dohc
Post Master Supreme
Registered: 09/09/05
Posts: 11227
Loc: canadia
|
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
Edited by f22b-dohc (08/24/15 08:00 PM)
_________________________
JB weld is your friend Chewbacca makes me yawn *Yawn* "rolling -----on my 2.0, with the rag top down so my hair can blow..."
|
Top
|
|
|
|
#8339289 - 08/24/15 08:27 PM
Re: SQfuckingL.....
[Re: f22b-dohc]
|
loudsubz
Post Master Supreme
Registered: 08/16/01
Posts: 11333
Loc: Ontario, Canada
|
transfer it all to ms excell and sort dem cells
|
Top
|
|
|
|
#8339790 - 08/25/15 10:18 AM
Re: SQfuckingL.....
[Re: SilverSiR2]
|
SuPeR-MaRiO
Post Master Sr
Registered: 06/28/01
Posts: 6118
Loc: Toronto, Ontario
|
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).
|
Top
|
|
|
|
#8339865 - 08/25/15 10:58 AM
Re: SQfuckingL.....
[Re: SuPeR-MaRiO]
|
Raocorp
Cougar Slayer
Post Master Sr
Registered: 10/10/02
Posts: 7768
Loc: Toronto
|
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.
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.
|
Top
|
|
|
|
#8342357 - 08/26/15 04:24 PM
Re: SQfuckingL.....
[Re: Choco 'Nuck]
|
hyper-s2k
Post Master Supreme
Registered: 12/01/05
Posts: 14556
Loc: T dot O dot, Canada
|
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>
Coding is ok though - but I haven't touched that in years.
_________________________
'08 //M3 - now @ 90,xxx km - wtf did i do? '13 x1 - now @ 99,xxx km - a2b car '10 x3 - now @ 123,xxx km - time 2 go? '03 s2k - now @ 80,xxx km - a2a car '08 535i - sold @ 149,421 km - cashed out just in time! '08 impreza 2.5i - sold @ - 64,147 km - smh POS '01 rav4 - killed @ 155,879 km - RIP old friend
"Driving in the snow is like sex. If you want to avoid accidents, abstinence is the best policy. If you're gonna take her for a spin, use protection." - Rick Mercer
|
Top
|
|
|
|
Moderator: c2k, LNXGUY, TheRealCSnapper, Professor Paki
|
|