To solve this exercise I wrote: update departments set dept_name= 'Data Analysis' where dept_name = 'Bussiness Analysis'; Is it a best practice?

Hi Lizeth! Thanks for reaching out. Although the piece of code you shared should work, is quite legible and straight-to-the-point, I'd think one would rather use a reference to a primary key in the WHERE condition, rather than the previous value occupied in the field you are currently trying to change the data. In our case, this would mean referring to the department number (dept_no). Of course, in such cases one could follow company coding and/or formatting guidance and for the completion of this course, you don't need to focus so much on this aspect. Nevertheless, you must constantly be aware of it. Therefore, your question is very on point. Hope this helps. Kind regards, Martin

Follow this topic

Lizeth Alexandra Estevez Joya

Last answered:

11 Nov 2022

Posted on:

10 Nov 2022

Resolved: About the exercise

in SQL / The UPDATE Statement - Part II

1 answers ( 1 marked as helpful)

Martin Ganchev

Instructor

Posted on:

11 Nov 2022

Helpful answer

Resolved: About the exercise

Submit an answer

related questions