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.

Key considerations

Key considerations

From the course: Advanced SQL for Application Development

Start my 1-month free trial

Key considerations

- [Dan] Developing database applications is a complicated process. And working with databases is much more than running select statements or inserting data. So here's some key design considerations that you should keep in mind when you start planning for database application development. So the things we want to keep in mind, first and foremost is always a SQL query performance. How will we write our queries and how will they perform especially as data grows and our number of users that are working with our application increases? One of the ways we can keep our performance meeting our demand, is by using adequate indexing and here the idea is we don't want too many indexes, or we don't want too few. We really need to hit the Goldilocks zone with that sweet spot between not too many and not too few indexing. And sometimes you can make good guesses early on, in the application design phase as to which indexes that will be…

Contents