We learned some new SQL and expanded on some old friends. We learned how to update a set of rows using values from a different table. We also learned how to delete troublesome data using delete from. We touched briefly on analytical functions that we'll be using more in the next section. We got into trouble using check constraints but also learned they can help us sleep soundly at night. We had some fun using generated columns and saved ourselves some time later on by denormalizing (sort of) our table. And finally we learned about range queries using IN, a very popular way to find intersecting records.

You're not logged in...

I can't tell you how much fun I had making this video! Hopefully it comes through - feel free to watch the free ones (no label on them) and you'll see what I mean. To watch the other ones, you need to either login or purchase the course. It takes just a minute!