|
|
|||||||
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. |
||||||||
|
|
|||||||
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. |
||||||||
|
|
|||||||
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... |
||||||||
|
|
|||||||
run a few queries on google surprised your boss didnt fire you for not knowing |
||||||||
|
|
|||||||
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? |
||||||||
|
|
|||||||
Dennis (HyperS2k) might be able to help too. |
||||||||
|
|
|||||||
NorthWinds bro... |
||||||||
|
|
|||||||
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. |
||||||||
|
|
|||||||
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. |
||||||||
|
|
|||||||
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! |
||||||||
|
|
|||||||
|
||||||||
|
|
|||||||
Select * from lickmyballs order by ballsize |
||||||||
|
|
|||||||
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 |
||||||||
|
|
|||||||
transfer it all to ms excell and sort dem cells |
||||||||
|
|
|||||||
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? |
||||||||
|
|
|||||||
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. |
||||||||
|
|
|||||||
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). |
||||||||
|
|
|||||||
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. |
||||||||
|
|
|||||||
Trying using excel, it's pretty straight forward to query data using it. https://www.youtube.com/watch?v=4QbGoDJJuZ4 |
||||||||
|
|
|||||||
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 next thing u know you are taking apart stor procs |
||||||||
|
|
|||||||
Originally Posted By: Euphoric run a few queries on google see what you did there. nice! |
||||||||
|
|
|||||||
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> Coding is ok though - but I haven't touched that in years. |