lesson-01-measuring-your-database-performance
lesson-02-minimizing-memory-usage
lesson-03-getting-one-record-from-has-many-relationships
lesson-04-creating-dynamic-relationships-using-sub-queries
lesson-05-calculating-totals-using-conditional-aggregates
lesson-06-optimizing-circular-relationships
lesson-07-setting-up-multi-column-searching
lesson-08-getting-like-to-use-an-index
lesson-09-faster-options-than-where-has
lesson-10-when-it-makes-sense-to-run-additional-queries
lesson-11-using-unions-to-run-queries-independently
lesson-12-fuzzier-searching-using-regular-expressions
lesson-13-running-authorization-policies-in-the-database
lesson-14-faster-ordering-using-compound-indexes
lesson-15-ordering-by-has-one-relationships
lesson-16-ordering-by-belongs-to-relationships
lesson-17-ordering-by-has-many-relationships
lesson-18-ordering-by-belongs-to-many-relationships
lesson-19-ordering-with-nulls-always-last
lesson-20-ordering-by-custom-algorithms
lesson-21-filtering-and-sorting-anniversary-dates
lesson-22-making-n-plus-1-issues-impossible
lesson-23-ordering-data-for-humans-using-natural-sort
lesson-24-full-text-searching-with-rankings
lesson-25-getting-the-distance-between-geographic-points
lesson-26-filtering-by-geographic-distance
lesson-27-ordering-by-geographic-distance
lesson-28-filtering-by-geospatial-area
Folders and files Name Name Last commit message
Last commit date
parent directory Aug 24, 2022
Aug 24, 2022
Aug 24, 2022
Aug 24, 2022
View all files
You can’t perform that action at this time.
