From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Challenge
(chill music) - [Instructor] Here's a challenge with regards to database schema migrations. Consider what you would need to do to add a new attribute, called export code, which is a string of length 15, and we're going to add that to the products table in our ecommerce database. We're then going to add 10 new products to the product table, and they're going to have their export code attribute set to restricted. Also, the existing products that are in the table already must have their export code column set to unrestricted. So describe the DDL commands required to implement these changes.
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.