Hey! Want to unlock the full course?

Purchase the course to view more content

Basic

$ 249
One-time
  • Lifetime access
  • 6 course modules: Content Planning, Equipment, Recording, Editing, and Publishing

Complete

$ 299
One-time
  • Lifetime access
  • 6 basic course modules
  • Strategies for crafting a compelling content plan
  • A breakdown of the most important equipment you need - and what you can skip
  • Techniques for painless recording sessions
  • An editing philosophy and little-known tips to get polished results, quickly
  • Methods for publishing your screencasts and getting your content in front of your audience
  • 2 premium course modules
  • Content and philosophy guidelines for growing your social media following via video
  • See the course techniques applied in an ever-growing library of teardowns. Learn from Aaron's reviews real-world screencasts.
MOST POPULAR!

Hands-on

$ 1,000
One-time
  • Lifetime Access
  • All 8 Complete course modules including how to get your video seen on social media + real-life teardowns
  • 40-minute, private 1-on-1 consultation with Aaron to get personalized guidance and advice on your videos

Section 5: Editing

11. 2 Freeze 2 Frames: even more power

Buy the course to watch this lesson! Sign Up Today

Query Optimization Techniques: Making Queries Run Faster

In our everyday code, there are often instances where we need to optimize queries for them to run faster. By doing so, we significantly improve the performance of our code and save a great deal of time. Here is a comprehensive walkthrough of an optimization involving geolocation data where the difference in the running time of the query by adding redundant conditions and indexing was considerable.

Unlock the full lesson

Sign Up

Sign up to get access to the course