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

    Default Finally getting some DDL (Update and Insert experience)

    Sounds silly but until recently I have been given only read write access, now I am able to update and insert in some tables. I really like the experience it really helps out a lot and opens up some more doors into SQL. Kind of silly I know but I thought I would share.
    Reply With Quote Quote  

  2. SS
  3. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #2
    As I understand it UPDATE and INSERT are members of DML, but cool that you are getting experience with these!
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  4. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #3
    Yeah I think you are right lol. Either way it's solid experience. I spend my whole day in these tables, I'm getting some serious OJT. Talk about tiring.
    Reply With Quote Quote  

  5. Senior Member Zorodzai's Avatar
    Join Date
    Jul 2012
    Location
    Africa
    Posts
    330

    Certifications
    OCA MySQL, ITIL-F (2012),MCITP: SQL 2008 DB Dev.
    #4
    Nice, the more you practice the quicker it becomes second nature....
    Reply With Quote Quote  

  6. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #5
    The biggest challenge for me now is getting used to the data modeling and how it relates together. I have an HUGE ERD printed from a plotter which is helpful for reference. It helps but there is a huge learning curve for me. I mean HUGE.
    Reply With Quote Quote  

  7. Senior Member
    Join Date
    Feb 2012
    Posts
    2,641
    #6
    Quote Originally Posted by N2IT View Post
    ,,,there is a huge learning curve for me.
    Just take it one day at a time. I'm sure you can do it - . No one knows everything.
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #7
    Thank you very much Paul
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    Feb 2011
    Location
    Wisconsin
    Posts
    143

    Certifications
    A+
    #8
    I'd like to echo what Paul said. It's going to take a little while for you to get settled in and comfortable with the databases you are working with. It took me a good 6 months to be comfortable with the three databases I manage. Don't get flustered man.
    Reply With Quote Quote  

  10. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #9
    With the Excel formulas I was creating (altering) today it was brutal. I was looking forward to getting back into studio.
    Reply With Quote Quote  

  11. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #10
    Once you get through the first book, look for the queries that will be hard to write. You are looking for the ones that make you shudder when you think about how you are going to bring that data together.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  12. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #11
    I have quite a few other those passed down from my boss and some of the database developers. Coalesce, Stuff, No Lock, Case, and a bunch of other commands I am learning. I'm just going to take it one day at a time and continue to grow. The book should arrive in a day or so, and when my wife is off I plan on getting into the office 1 hour early and reading / labbing. Thanks again for the great advice.
    Reply With Quote Quote  

  13. Achieve excellence daily
    Join Date
    May 2012
    Location
    Washington State
    Posts
    1,425

    Certifications
    CISSP
    #12
    You are welcome. Be very careful with nolock. There are few cases that call for it.
    When you go the extra mile, there's no traffic.
    Reply With Quote Quote  

  14. Senior Member
    Join Date
    Apr 2010
    Posts
    7,363
    #13
    Noted! Yeah right now it's all about developing solutions to this companies problems. A lot of the mini projects I am on revolve around reporting so sometimes it's SSMS and other times it's Excel and Access. Huge learning curve for even Excel. Some of the formulas I have been learning (borrowing) are very cumbersome and involved.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks