+ Reply to Thread
Results 1 to 15 of 15
  1. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #1

    Default How long did it take you to "get" it? (programming in SQL)

    I've been at it for about 14 months and I feel I am starting to really get it. Windowing, Pivot, etc some of the more difficult concepts. But the main growth is being able to apply it to a reports or business solution.

    I can see why people never take it very far it seems I had to go at it fairly hard for about 6 months to really get solid at query writing.

    For me it came like this

    Selects then shortly after joins. Sub queries took a little longer then moved into some programming techniques like cast and casting. Then eventually picked up pivot and windowing. During this time I learned how to write SP and how to associated them with a job to automate the SP.

    I am still a infant when it comes to experienced pros. Just tricks like using isnumber instead of ticking all your searched items in the where clause. And a big big deal is noting your code and writing it clean. Instead of hitting a table 14 times (guilty as charged) I began using the Pivot feature. Literally 10 times faster.

    I personally feel another year or 2 and I'll be a programmer / analyst rather than just a analyst. This is my end goal if the job direction allows me. I love driving software projects and managing resources, but I never want to be so far away from the technology that I am ineffective from a technology standpoint.

    One side item, since I have gotten a lot stronger with SQL I haven't had to write as much VBA in Excel for reports. This has been a huge plus. And Thank God for CTE's temp tables don't work in MS Query.

    Any one with experience can relate? How did your path go if you don't mind sharing.
    Last edited by N2IT; 06-07-2014 at 08:06 PM.
    Reply With Quote Quote  

  2. SS -->
  3. BOBBY_TABLES RobertKaucher's Avatar
    Join Date
    Dec 2007
    Location
    Lebanon, Ohio - USA
    Posts
    4,274

    Certifications
    MCSD Web Apps/SharePoint Applications, MCITP: DBA 2005/2008, EA, EDA7, Linux+, Sec+, MCSE, MCDST, MCTS
    #2
    I think that it took me about a year as well. It was really going through the stuff in Joe Celko's books and the challenges from Itzik Ben-Gan. I generally tell people that it's going to take a year before you really get a handle on SQL. It seems really simple at first but that's because you aren't looking at any of the really hard, real-world problems that people need to solve. Once you have really learned something that takes a while to get your head around I think you get better at being a learner in general.
    Reply With Quote Quote  

  4. Senior Member Node Man's Avatar
    Join Date
    Dec 2012
    Location
    LV426
    Posts
    600

    Certifications
    CCENT, CCNA R&S, CCNP-R&S, CE-A
    #3
    I learned SQL by running a phpnuke forum. Immediately after setting it up I started reverse engineering it and making my own modules. I would call it a crash course but I was at it years and had a lot of fun doing it.
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #4
    Quote Originally Posted by RobertKaucher View Post
    I think that it took me about a year as well. It was really going through the stuff in Joe Celko's books and the challenges from Itzik Ben-Gan. I generally tell people that it's going to take a year before you really get a handle on SQL. It seems really simple at first but that's because you aren't looking at any of the really hard, real-world problems that people need to solve. Once you have really learned something that takes a while to get your head around I think you get better at being a learner in general.
    Yeah maybe that's true Robert

    The first piece is to slow down and make sure to gather to right requirements. Then follow up to make sure you have the right requirements lol.

    Once I get that piece down I start to build my code so it fits together. I find myself still over thinking things lol.
    Reply With Quote Quote  

  6. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,380

    Certifications
    CISSP
    #5
    It took me about 6 months to a year of writing SQL every day to really feel like I had a good grip on it.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  7. Member
    Join Date
    Mar 2013
    Posts
    33
    #6
    Quote Originally Posted by RobertKaucher View Post
    I think that it took me about a year as well. It was really going through the stuff in Joe Celko's books and the challenges from Itzik Ben-Gan. I generally tell people that it's going to take a year before you really get a handle on SQL. It seems really simple at first but that's because you aren't looking at any of the really hard, real-world problems that people need to solve. Once you have really learned something that takes a while to get your head around I think you get better at being a learner in general.
    I think I am in that situation where I think SQL is really easy. But you saying it isn't that easy. Can you please give one good example of a problem that experienced DBAs usually need to solve?
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Mar 2013
    Location
    Fort Worth, Texas
    Posts
    132

    Certifications
    OCPJP 6, ITIL Foundations, A+, Net+, Sec+, Project+, CIW Web Development Professional
    #7
    Quote Originally Posted by ayubjon View Post
    I think I am in that situation where I think SQL is really easy. But you saying it isn't that easy. Can you please give one good example of a problem that experienced DBAs usually need to solve?
    Efficient Partitioning and Index schemes on a database that is several terabytes in size. This goes into a number of other things, including sql clusters and data file management. You also have to work in secure backups that typically need to trickle down to lower level environments as necessary for application testing and development.
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #8
    I know 20 year vets who don't call SQL easy. They are writing spatial queries now building out shape files etc. It wasn't easy IMO. Just building the structure and then figuring out how to optimize the tables etc took a while and tons of iterations.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #9
    Year 2.5 finally getting better and better. I think it takes 5 years to get really good at it and 10 to become a stud.
    Reply With Quote Quote  

  11. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #10
    I've been on the admin side (Server buildouts, Clustering, System management, etc) of SQL Server for about two years. One of my goals for 2015 is to become more proficient with writing SQL, as it will help me when it comes down to troubleshooting non-server related issues, such as indexes, inefficient queries, etc.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #11
    At Nacho I started piecing together system queries. It get's a little tricky when you start joining on major and minor id's. I believe this is related to the way the sets are set up in the tables. You have tables linked to the major I believe and the columns linked to the minor ids. I actually was able to write out a query that shows database, schema, tables, columns, keys, indexes, constraints, defaults, null or not null, ordinal value (which is great because you can row_number over partition order by and wrangle data into the rows), table descriptions and columns descriptions. It's pretty cool it basically lays out a data dictionary. I also was able to ID which percentage of tables didn't have primary keys which was a big help for removing tables for clean up. (Of course renaming them first then removing).

    Glad to see a another DBA on this forum. I'm more of a techno functional in my role, but I build a lot of objects and report using VBA and SQL.

    Welcome!
    Last edited by N2IT; 12-06-2014 at 05:53 PM.
    Reply With Quote Quote  

  13. Senior Member nachodba's Avatar
    Join Date
    Sep 2014
    Location
    Fairfax, VA
    Posts
    188

    Certifications
    MCSE: Servers, Sec +, MCITP:DBA 2008, MCSA SQL Server 2012/2014
    #12
    Hey N2IT, were there any books you would recommend. I'm currently making my way through Itzik Ben-Gan's 70-461 study guide.
    2017 Goals - MCSA SQL 2016 Database Administration, MCSA Windows Server 2016
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #13
    I still use that one to this day. It's either that or Google to be honest. I did pick up the T SQL Foundations by the same author but 461 covers most of that material.
    Reply With Quote Quote  

  15. Senior Member daviddws's Avatar
    Join Date
    Jan 2012
    Location
    Washington State
    Posts
    293

    Certifications
    ITILv3, MCSA:Server 2012, MCSA:Win7, MCITP, MCTS, MTA:SA, MCP, CTS, VCA-WM, LPIC-1, SCLA, SUSE-TS, A+, Network+, Security+, Linux+, Server+
    #14
    Im also getting ready to study sql. I had some classes in grad school, but would like to get the OCA.
    Reply With Quote Quote  

  16. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #15
    @ David I had several courses as well, was on the SQL BI track at the community college for a while. It helped a lot but getting hammered in the real world is unbelievable. Getting crushed over and over again is the best teacher for me.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks