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
From the course: Advanced SQL for Application Development
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.