Captain Planet Posted April 12, 2014 Report Share Posted April 12, 2014 Who has used either? Need to learn both for career aspirations, SQL looks pretty straight forward. Just wanna talk about it tbh. Quote Link to comment Share on other sites More sharing options...
Heero Yuy Posted April 12, 2014 Report Share Posted April 12, 2014 I use both heavily on a daily basis, what do you need to know? Quote Link to comment Share on other sites More sharing options...
Captain Planet Posted April 12, 2014 Author Report Share Posted April 12, 2014 Wanna understand their purposes and capabilities, I've been talking to some ex real estate analyst about career and he told me those were crucial for the field. What purpose do you use each for? Is SQL more database lookups and VBA for synthesising data? Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 SQL is for interacting with databases, inserting, retrieving, manipulating data. These have to be SQL databases of course, of which there are many kinds. MS Excel and Access (which don't provide SQL databases) use VBA as a programming language to work with data in them. Quote Link to comment Share on other sites More sharing options...
Captain Planet Posted April 12, 2014 Author Report Share Posted April 12, 2014 Oh kl Didn't know it was that straightforward Can you write complex program's in VBA? Or should I just see it as a highly flexible extension of excel formulae Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 VB = visual basic VBA = visual basic for (Microsoft) applications, so its a more special-purpose version VBA is mainly for making macros (your 'extension of excel formulae') but you'll learn VB basics in doing so which you can use to make more complex programs. Though, if you wanted to learn generally how to program most people wouldn't direct you to VB these days. Quote Link to comment Share on other sites More sharing options...
Captain Planet Posted April 12, 2014 Author Report Share Posted April 12, 2014 I've learnt the basic programming syntax using ruby and writing silly text based programs to run via command console So if I was to fast track to macros I may as well learn via VBA and not VB? Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 well yeah, if you go through "learning vba" tutorials and books they'll probably start you from the basics that are shared between variants anyway, after you've learnt the basics you should probably try to get some impression from your guy of what they'll actually be used for, because aimlessly learning a programming language without ideas of how you'd use it makes it harder SQL-wise I can dig out some coursework I was asked to help with from someone's Databases unit at Greenwich Uni which will set a decent task for you to work on once you know the basics Quote Link to comment Share on other sites More sharing options...
Captain Planet Posted April 12, 2014 Author Report Share Posted April 12, 2014 VBA - noted SQL I would much appreciate that if you could Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 PMd I think it mentions using an Oracle SQL database, but I think SQLite is easiest to set up. Firefox has an extension which works as a decent frontend https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ I imagine Visual Basic has an SQL interface but its probably not something you'd wanna start messing with straight away. 3 Quote Link to comment Share on other sites More sharing options...
Yardie 2.0 Posted April 12, 2014 Report Share Posted April 12, 2014 dub, beg you send me a copy too Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 done Quote Link to comment Share on other sites More sharing options...
Yardie 2.0 Posted April 12, 2014 Report Share Posted April 12, 2014 nice one bro. Quote Link to comment Share on other sites More sharing options...
Benicio del Toney Posted April 12, 2014 Report Share Posted April 12, 2014 Planet I swear you had a website before, if you still have the hosting package it probably has mysql on it with phpmyadmin. You can create a database in there and mess around with it. You work in property so the site your company has I'm guessing will have info about all the listings in a database, you can output that data on the website using php to interact with it. Quote Link to comment Share on other sites More sharing options...
dub Posted April 12, 2014 Report Share Posted April 12, 2014 Doesn't really make sense to run it through the web unless that's what you want out of it (to have results on a website). But if you do end up wanting that then yes PHP is a way to go, however if you have knowledge in VB then you can implement a solution with ASP.NET (which allows usage of VB code). But if its for the purpose of an analyst's job I imagine you're not looking for a website solution. I imagine the SQL variant you'd be using would be Microsoft SQL Server, the different versions don't vary too much but if you want experience in that I think they do have a free download for it. Quote Link to comment Share on other sites More sharing options...
Yoshie Posted April 12, 2014 Report Share Posted April 12, 2014 dub, beg you send me a copy too Quote Link to comment Share on other sites More sharing options...
Simply D Posted April 12, 2014 Report Share Posted April 12, 2014 dub, beg you send me a copy too safe Quote Link to comment Share on other sites More sharing options...
Guest28 Posted April 12, 2014 Report Share Posted April 12, 2014 i done sql in uni, my course basically based around it Quote Link to comment Share on other sites More sharing options...
Captain Planet Posted April 12, 2014 Author Report Share Posted April 12, 2014 Planet I swear you had a website before, if you still have the hosting package it probably has mysql on it with phpmyadmin. You can create a database in there and mess around with it. You work in property so the site your company has I'm guessing will have info about all the listings in a database, you can output that data on the website using php to interact with it. Not used for these precise applications tbh See rentonomy.com they use market data to release all sorts of cool blog posts about London, also created an algorithm to match people looking for properties to the actual properties, that's their business model to try take on conventional lettings agents. Quote Link to comment Share on other sites More sharing options...
Guest28 Posted April 12, 2014 Report Share Posted April 12, 2014 SQL is for interacting with databases, inserting, retrieving, manipulating data. These have to be SQL databases of course, of which there are many kinds. ur perfectly right, to under standard sql u need to understand those basics above this site helps with the coding side of things, http://www.w3schools.com/sql/default.asp?PHPSESSID=300ae3404d5fa2612f238abeebb8869c and the system with used was called "oracle" Quote Link to comment Share on other sites More sharing options...
Benicio del Toney Posted April 13, 2014 Report Share Posted April 13, 2014 Planet I swear you had a website before, if you still have the hosting package it probably has mysql on it with phpmyadmin. You can create a database in there and mess around with it. You work in property so the site your company has I'm guessing will have info about all the listings in a database, you can output that data on the website using php to interact with it. Not used for these precise applications tbh See rentonomy.com they use market data to release all sorts of cool blog posts about London, also created an algorithm to match people looking for properties to the actual properties, that's their business model to try take on conventional lettings agents. fak, that's clever. Quote Link to comment Share on other sites More sharing options...
Niall Ferguson Posted April 13, 2014 Report Share Posted April 13, 2014 Easy to learn, hard to master. To make money out of them, you need to master them. The reality is, you're behind thousands of people who use them on a daily basis and have high level degrees in them. Go figure. 1 Quote Link to comment Share on other sites More sharing options...
dub Posted April 13, 2014 Report Share Posted April 13, 2014 ignore him, you don't need to master shit 1 Quote Link to comment Share on other sites More sharing options...
imhim Posted April 13, 2014 Report Share Posted April 13, 2014 u need to be a top geek with a phd to master such languages the world will then be your oyster 1 Quote Link to comment Share on other sites More sharing options...
Niall Ferguson Posted April 13, 2014 Report Share Posted April 13, 2014 ignore him, you don't need to master sh*t Yes, my response was somewhat flippant, but the time it takes to learn and become proficient will be negated by those who already have experience. If OP has a business idea, he may as well pay someone who is already proficient. Opportunity cost and all that. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.