Introduction to Advanced SQL Topics
This section of the course covers more advanced SQL topics, such as database design strategies, how to leverage diagrams to model relationships, and an analysis of SQL indexing.
Guide Tasks
  • Read Tutorial
  • Watch Guide Video
Video locked
This video is viewable to users with a Bottega Bootcamp license

Great job in making it through the course.

In this last section, we're going to talk about some advanced sequel topics. We're going to talk about the concept of sequel and database indices. An index is something that can allow your program to be able to run faster queries but there are times to use them and times not to use them and we're going to discuss how those should work.

We're also going to get into some more advanced topics around database structuring. We're going to talk about database normalization which is the process of being able to make sure that our databases are built and designed as efficiently as possible. Then we're going to finish off with talking about modeling and diagramming our databases so that we can visually see how the data in the tables are all mapped together.