Finally getting some DDL (Update and Insert experience)

N2ITN2IT Posts: 7,483Inactive Imported Users
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.

Comments

  • NotHackingYouNotHackingYou Posts: 1,452Registered Members ■■■■■■■■□□
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • ZorodzaiZorodzai Posts: 341Registered Members
    Nice, the more you practice the quicker it becomes second nature....
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • paul78paul78 Posts: 2,792Registered Members ■■■■■■■■■■
    N2IT wrote: »
    ,,,there is a huge learning curve for me.
    Just take it one day at a time. I'm sure you can do it - icon_thumright.gif. No one knows everything.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    Thank you very much Paul
  • j-manj-man Posts: 143Registered Members
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    With the Excel formulas I was creating (altering) today it was brutal. I was looking forward to getting back into studio.
  • NotHackingYouNotHackingYou Posts: 1,452Registered Members ■■■■■■■■□□
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
  • NotHackingYouNotHackingYou Posts: 1,452Registered Members ■■■■■■■■□□
    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.
  • N2ITN2IT Posts: 7,483Inactive Imported Users
    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.
Sign In or Register to comment.