It is important to view knowledge as sort of a semantic tree— make sure you understand the fundamental principles, ie the trunk and big branches, before you get into the leaves/details or there is nothing for them to hang on to.
-- Elon Musk
- Joins
- Top N
- Subquery
- Subquery as a Derived Table
- Subquery as an Expression
- Subquery to Correlate Data
- Window Function
- Set Operators
- UNION
- INTERSECT
- EXCEPT
- CTE
- Recursive CTE
- View
- Stored Procedures
- Functions
- Trigger
- Normalization Process
- Transaction
- Concurrency and Isolation Levels
- Performance Tuning
- Indexing
-
- Fundamentals
- Functions
- Callbacks & Closures
- DOM
- Events
- Local storage and Session storage, Cookies
- Promise
- Async and Await
-
- Language Fundamentals
- OOP
- Generics & Collections
- Delegates
- LINQ
-
- Dapper + Async Method
- Entity Framework
- MVC
- Razor view
- Security
- REST API
- Unit Test