Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sff1234
Starting Member
3 Posts |
 Posted - 2011-02-09 : 14:03:33
|
| I was asked during a job interview about a timeline for learning SQL. I have used SAS for two years with another company in the same industry. What are your thoughts on this?Stephen F. Flick |
|
|
MIK_2008
Master Smack Fu Yak Hacker
1054 Posts |
Posted - 2011-02-09 : 14:09:44
|
well in case of interview i think it wont be bad if you reply one or two months  |
 |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-09 : 14:31:02
|
That is a good start. If you have used SAS and employed Proc SQL the transition will be smooth enough. You will just have to retrain your brain to think set-based instead of row based ;)
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sff1234
Starting Member
3 Posts |
Posted - 2011-02-10 : 13:05:52
|
| What is the difference between a set-based mindset and a row-based mindset?Stephen F. Flick |
|
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2011-02-10 : 14:08:05
|
In sas, often times the coding is done with the mindset of "what do I want to do to each ROW"..which is fine for that software and what it does. Even the code itself has to be written with that in mind. For best SQL you need to start thinking "what do I want to do with this entire set of data".Overly general but do a google search of SQL Set Based Thinking...you will see what I mean.
Poor planning on your part does not constitute an emergency on my part. |
|
|
|
sff1234
Starting Member
3 Posts |
Posted - 2011-02-10 : 15:07:00
|
| Thank you for the feedback dataguru. I am adjusting from the database as a means to accessing data to the database being the only way to understanding the data.Stephen F. Flick |
|
|
|
|
|
|
Timeline for learning SQL