From the course: Advanced SQL for Application Development

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Understanding schema changes

Understanding schema changes

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Understanding schema changes

- [Instructor] Software applications change frequently. Sometimes we're adding new features or fixing bugs, but whatever the reason for the change, some of those changes require changes to the underlying database, and we're going to take a look at some of the issues that we have to be concerned about when we're making changes to an underlying database schema. Now, it's just a fact of life that database structures change over time. Typically in response to changes in application features, but there may be other reasons too. For example, you may determine better ways to optimize performance of the database, so you want to make changes to the underlying data structures. Often times, these changes come in the form of adding new tables or columns or indexes, or sometimes dropping some of those things, like dropping a column that you no longer need, or dropping an index that you find is not actually used that much and so it's…

Contents