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
From the course: Advanced SQL for Application Development
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…
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.