Redshift
Redshift, Powered for Insights: Learn with DataReportive.
This tutorial walks you through Redshift from basics to advanced reporting. Discover how to structure, query, and optimize your data to fuel smarter dashboards, reports, and analytics—directly aligned with real-world use cases from the DataReportive platform.
Database Management
How to Create a TableHow to Use DISTKEY, SORTKEY and Define Column Compression Encoding
How to Drop a Table
How to Rename a Table
How to Truncate a Table
How to Duplicate a Table
How to Add a Column
How to Drop a Column
How to Rename a Column
How to Add or Remove Default Values or Null Constraints to a Column
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
Dates and Times
How to Query Date and TimeHow to Group by Time
How to Round Timestamps
How to Convert UTC to Local Time Zone
Analysis
How to Use CoalesceHow to Get First Row Per Group
How to Avoid Gaps in Data
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Compare Two Values When One is Null
How to Write a Case Statement
How to Query a JSON Column
How to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total
How to Calculate Percentiles