SQL Time&Date Manipulation for Data Scientists

Guide image

Industry skills you will learn and practice

  • Advanced time arithmetics
  • Working with different date and time formats
  • Using timestamps to filter datasets
  • Time series processing
  • Time units conversion
  • Analyzing the evolution of business-critical metrics

What will you find in each module?

  1. Theoretical introduction to the topic
  2. Applications in the industry
  3. Ready-to-reuse SQL code examples (both PostgreSQL and MySQL)
  4. Multiple explained coding exercises and interview questions based on real-life problems for you to practice

Who is this guide for?

  • Are you eager to learn about temporal data to excel in your career?
  • Do you know the basics of SQL Data Manipulation?
  • Want to excel in solving real-life data science problems?
  • Are you a fresh data scientist who wants to make your life easier?
  • Want to access a repository of methods and solutions for time&date manipulation?

Then this guide is for you! Start learning here!

Back to guides

Modules

  1. How to Add or Subtract Time Units?
  2. How to Calculate Duration from Two Timestamps?
  3. How to Count Events per Hour of the Day?
  4. How to Aggregate Data by the Day of the Week or Month?
  5. How to Filter Data in a Specific Timeframe?
  6. How to Find the First or Last Occurrence in a Dataset?
  7. How to Detect Peaks in Time Series?
  8. How to Find a Rolling Metric?

Become a data expert. Subscribe to our newsletter.