SQL Server
SQL Server, Powered for Insights: Learn with DataReportive.
This tutorial walks you through SQL Server 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 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 a Default Value to a Column
How to Remove a Default Value to a Column
How to Add a NOT NULL Constraint
How to Remove a NOT NULL Constraint
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
How to Create an Index
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 SQL PivotHow to Query JSON Object
How to Calculate Cumulative Sum/Running Total
How to Have Multiple Counts
How to Write a Case Statement
How to Use Coalesce
How to Avoid Gaps in Data
How to Import a CSV
How to Get First Row Per Group
How to Compare Two Values When One is NULL
How to Write a Common Table Expression
How to Calculate Percentiles
How to Do Type Casting