What is Big-O? What should software developers know about it? Will it come up in interviews? How do I find the Big-O notation for my code?
Use dependency injection to write service objects that can have pure unit tests that don't hit the database.
React Hooks + Context is a viable pattern for Global State. It cuts the boilerplate and cruft that Redux introduces.
A look at techniques to find hotspots and index opportunities. We'll cover some things to keep in mind to avoid over indexing, and when indexing is the wrong solution.
Let's build a mental model to understand how indexes help apps perform and scale. SQL knowledge is assumed but aimed at beginners to indexing.
Build a website with a modern front end & content management stack.
What are the implications of using a CTE instead of a subquery?
SQL works better when you write what rather than how. Describe the data you want. Let the engine decide how to get it.