January 4, 2017 at 5:17 pm
Hi all,
I'm a DBA who got dragged into Development, went years, I mean YEARS without knowing you had to put parentheses around functions (ie Select Min (ColName) ), and did fairly well. But am getting tired of hunting online for coding help, and want to close this deficiency once and for all. Be the who gives help on forums, not asks for it all the time.
SO...
Lemme start with giving help.
1) Get meaningful data - ploughing through Adventureworks is about as sexy as watching the Williams sisters play Monopoly. A great way to do this is to copy any table online from a website, whatever topic interests you, (Wikipedia has plenty) paste into Excel, then import into SQL. I keep a DB called 'Practice' and import into a different table for each topic.
2) Pore over the data, and see what kind of results you wish you could glean; The hours will just fly by.
Ok, you can have fun looking for patterns in data, running selects, dividing one column by another, ordering results, to yield where Ed Snowden's priciest stays per embassy were, but - here's ME asking for tips- how about more serious stuff? Datatype conversion, joining tables, updating temp tables?
Did I mention - any tips welcome???
🙂
JB
January 5, 2017 at 1:33 am
Many, many years ago when I was trying to learn stuff, rather than just run the reports our department ran, I sought the advice of others. The most useful suggestion was to rip mp3 files from your cd collection onto your pc - not so common then, before the download generation.
Then from those files create a sql database that could import and maintain a CD library, by importing the listing, normalising it, updating tables, creating views etc. The most import thing I learnt from this is that you can look up code anywhere, but you must understand the data to work with it effectively.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply