Page 1 of 1 1
Topic Options
#8338668 - 08/24/15 01:22 PM SQfuckingL.....
Raocorp Offline
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 Offline
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
#8338689 - 08/24/15 01:31 PM Re: SQfuckingL..... [Re: Raocorp]
furball Offline
Post Master Sr


Registered: 09/24/03
Posts: 9483
Loc: Toronto, ON
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...

Top
#8338697 - 08/24/15 01:36 PM Re: SQfuckingL..... [Re: furball]
Euphoricuck Offline
Post Master Supreme


Registered: 11/05/03
Posts: 92703
Loc: Canadistan
run a few queries on google ;\)


surprised your boss didnt fire you for not knowing
_________________________

Top
#8338728 - 08/24/15 01:58 PM Re: SQfuckingL..... [Re: Euphoricuck]
SuPeR-MaRiO Offline
Post Master Sr


Registered: 06/28/01
Posts: 6111
Loc: Toronto, Ontario
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?
Top
#8338782 - 08/24/15 02:16 PM Re: SQfuckingL..... [Re: SuPeR-MaRiO]
Choco 'Nuck Offline
Proud Member of BLM
Post Master Supreme


Registered: 07/10/01
Posts: 17568
Loc: Somewhere out there
Dennis (HyperS2k) might be able to help too.
Top
#8338802 - 08/24/15 02:29 PM Re: SQfuckingL..... [Re: Choco 'Nuck]
furball Offline
Post Master Sr


Registered: 09/24/03
Posts: 9483
Loc: Toronto, ON
NorthWinds bro...
Top
#8338823 - 08/24/15 02:44 PM Re: SQfuckingL..... [Re: furball]
Big Tasty Offline
Post Master Supreme


Registered: 02/10/02
Posts: 19600
Loc: Toronto
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.

Top
#8338866 - 08/24/15 03:05 PM Re: SQfuckingL..... [Re: SuPeR-MaRiO]
Raocorp Offline
Cougar Slayer
Post Master Sr


Registered: 10/10/02
Posts: 7768
Loc: Toronto
 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.

Top
#8339081 - 08/24/15 05:06 PM Re: SQfuckingL..... [Re: Raocorp]
Risky Business Offline
Provides a Great Work Environment. he/him
Post Master Supreme


Registered: 05/17/10
Posts: 44789
 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!

Top
#8339125 - 08/24/15 05:39 PM Re: SQfuckingL..... [Re: Risky Business]
Choco 'Nuck Offline
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 Moderator Offline
Post Master Supreme


Registered: 08/06/00
Posts: 106841
Loc: Barrie, Ont,
Select * from lickmyballs
order by ballsize
_________________________
-Bill
The GN would OWN you, your children and your children's children.
'09 E90 335d

Top
#8339243 - 08/24/15 07:53 PM Re: SQfuckingL..... [Re: LNXGUY]
f22b-dohc Offline
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 Offline
Post Master Supreme


Registered: 08/16/01
Posts: 11333
Loc: Ontario, Canada
transfer it all to ms excell and sort dem cells \:\)
Top
#8339345 - 08/24/15 09:21 PM Re: SQfuckingL..... [Re: loudsubz]
Raocorp Offline
Cougar Slayer
Post Master Sr


Registered: 10/10/02
Posts: 7768
Loc: Toronto
 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?

Top
#8339737 - 08/25/15 09:51 AM Re: SQfuckingL..... [Re: Raocorp]
SilverSiR2 Offline
Post Master Supreme


Registered: 04/10/02
Posts: 12624
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.
_________________________

Top
#8339790 - 08/25/15 10:18 AM Re: SQfuckingL..... [Re: SilverSiR2]
SuPeR-MaRiO Offline
Post Master Sr


Registered: 06/28/01
Posts: 6111
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 Offline
Cougar Slayer
Post Master Sr


Registered: 10/10/02
Posts: 7768
Loc: Toronto
 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.

Top
#8339905 - 08/25/15 11:16 AM Re: SQfuckingL..... [Re: Raocorp]
Big Tasty Offline
Post Master Supreme


Registered: 02/10/02
Posts: 19600
Loc: Toronto
Trying using excel, it's pretty straight forward to query data using it.

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

Top
#8339986 - 08/25/15 11:54 AM Re: SQfuckingL..... [Re: Big Tasty]
f22b-dohc Offline
Post Master Supreme


Registered: 09/09/05
Posts: 11227
Loc: canadia
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
_________________________
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
#8340365 - 08/25/15 03:17 PM Re: SQfuckingL..... [Re: Euphoricuck]
Just A Troll Offline
Curved Street Thug Life
Post Master


Registered: 09/24/09
Posts: 2221
 Originally Posted By: Euphoric
run a few queries on google ;\)


see what you did there. nice!
_________________________
I don't need to use this space to show off my car or my camera gear.

Top
#8342357 - 08/26/15 04:24 PM Re: SQfuckingL..... [Re: Choco 'Nuck]
hyper-s2k Offline
Post Master Supreme


Registered: 12/01/05
Posts: 14556
Loc: T dot O dot, Canada
 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.
_________________________
'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
Page 1 of 1 1


Moderator:  c2k, LNXGUY, TheRealCSnapper, Professor Paki 
Hop to:
Shout Box

CSi Sponsors

DiGBiC Lighters
DiGBiC Lighters
DallasColo
Dallas Colocation
ClubSi.com Shirts
ClubSi-Shirts
GameStop
Black-Friday Specials
Big Brake Kits
StopTech.Sale BBK Clearance
Brake Kits
Buy Brake Kits
EBC Brake Kits
EBC Brake Kits
BuyBrakes
Brake Kits-Pads & Rotors Sets
StopTech Brake Kits
StopTech
StopTech NZ
StopTech
StopTech Australia
StopTech
Hawk Brake Pads
Hawk Brake Pads
Samys Camera
GoPros, Cameras, Gear
Brake Specials Near Me
Brake Specials Near Me
Brake Pad Coupons
Coupon Code "hondafetish"
Porsche Brakes
Porsche Brake Upgrades
2-Piece Rotors-Civic Type-R
2-Piece Civic Rotors
Advertisement

| Brake Pads | | How To Change Brake Pads | | Drilled Slotted Brake Kits Cheap | EBC Brake Kits | Performance Brake Kits | Brake Specials Near Me | How To Replace Brake Pads