Platform
Business Intelligence
Embedded Analytics
Professional Services
Security
Features
bipp Data Modeling Layer
Visual SQL Data Explorer
Data Visualization
Git-based Version Control
In-Database
SQL Editor
Scheduled Delivery and Alerts
Real Time BI
Pricing
Resources
Blog
Reports
Release Notes
Community
Compare
Learn
Documentation
bipp Tutorial
Why bipp?
SQL Tutorial
Definitions
Company
About
Meet The Team
Careers
News
Case studies
Disclosure
Privacy
Terms
Connect
Request Demo
Support
Contact Us
Sign in
Try for free
Contents
SQL Tutorial Home
Basic SQL
SQL SELECT Statement
SQL ORDER BY and SQL LIMIT
Using SQL WHERE Clause With Comparison Operators
Using Logical Operators in WHERE clause
SQL BETWEEN and SQL LIKE in WHERE Clause
SQL IS NULL Operator in WHERE Clause
SQL Data Types
SQL CASE Clause in SQL Queries
Intermediate SQL
SQL GROUP BY Clause in a SELECT Query
Aggregate Functions in SQL
SQL Having Clause
SQL Subqueries: The Super Powerful SQL Feature
SQL DISTINCT Clause
SQL Date and Time Functions and Data Types
SQL String Functions
Advanced SQL
SQL Correlated Subqueries Increase the Power of SQL
SQL Window Functions
SQL Window Function Examples
Selecting Data From Multiple Tables: SQL JOINS
Visual Representation of SQL JOINS
Query Optimization
SQL Indexes
PostgreSQL
1. Basics
How to Compare Arrays in PostgreSQL
How to Concatenate Strings in PostgreSQL
How to Convert the Case of a String
How to Create an Array
How to Insert Array Data Into a Table
How to Insert Data Into an Array
How to Modify Arrays
How to Query Arrays
How to Replace Substrings
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
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 a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
How to Convert Local Time to UTC
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Use generate_series 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 Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total
MS-SQL
1. Basics
How to Concatenate Strings in MS-SQL Server
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim Strings
How to Use string_agg()
How to Use substring()
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table in MS-SQL
How to Drop a Table in MS-SQL
How to Rename a Table in MS-SQL
How to Truncate a Table in MS-SQL
How to Duplicate a Table in MS-SQL
How to Add a Column in MS-SQL
How to Drop a Column in MS-SQL
How to Rename a Column in MS-SQL
How to Add a Default Value to a Column in MS-SQL
How to Remove a Default Value From a Column in MS-SQL
How to Add a Not Null Constraint in MS-SQL
How to Remove a Not Null Constraint in MS-SQL
How to Create an Index in MS-SQL
How to Drop an Index in MS-SQL
How to Create a View in MS-SQL
How to Drop a View in MS-SQL
How to Alter Sequence in MS-SQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MS-SQL
How to Group by Time
How to Extract a Component From a Datetime
4. Analysis
How to Use Lateral Joins
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MS-SQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total
MySQL
1. Basics
How to Concatenate Strings in MySQL
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to use group_concat()
How to do you Use a substring()
How to Use substring() with Regular Expressions
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Table in MySQL
How to Drop a Table in MySQL
How to Rename a Table in MySQL
How to Truncate a Table in MySQL
How to Duplicate a Table in MySQL
How to Add a Column in MySQL
How to Drop a Column in MySQL
How to Rename a Column in MySQL
How to Add a Default Value to a Column in MySQL
How to Remove a Default Value From a Column in MySQL
How to Add a Not Null Constraint in MySQL
How to Remove a Not Null Constraint in MySQL
How to Create an Index in MySQL
How to Drop an Index in MySQL
How to Create a View in MySQL
How to Drop a View in MySQL
How to Alter Sequence in MySQL
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time in MySQL
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting in MySQL
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Calculate Cumulative Sum-Running Total
OracleSQL
1. Basics
How to Concatenate Strings in Oracle
How to Convert the Case of a String
How to Replace Substrings
How to Trim Strings
How to Use listagg()
How to Use substring()
How to Use substring() with Regular Expressions
How to Insert
How to Update
How to Delete
2. Database Management
How to Create a Table
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 a Default Value to a Column
How to Remove a Default Value From a Column
How to Add a Not Null Constraint
How to Remove a Not Null Constraint
How to Create an Index
How to Drop an Index
How to Create a View
How to Drop a View
How to Alter Sequence
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Use BETWEEN Correctly
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Import a CSV
How to Use Coalesce
How to Write a Case Statement
How to Query a JSON Column
How to Use Filter Clause to Have Multiple Counts
How to Calculate Cumulative Sum-Running Total
BigQuery
1. Basics
How to Concatenate Strings in BigQuery
How to Convert the Case of a String
How to replace a Substring in a String
How to Trim a String
How to Use string_agg()
How to use substring() function
How to Use substring() with Regular Expressions
How to Use BETWEEN Correctly
How to use insert into statement
How to use Update statement in SQL
How to use Delete SQL Statement
2. Database Management
How to Create a Database in BigQuery
How to Create a Table in BigQuery
How to Drop a Table in BigQuery
How to Rename a Table in BigQuery
How to Truncate Table in BigQuery
How to Duplicate a Table in BigQuery
How to Add a Column in BigQuery
How to Drop a Column in BigQuery
How to Add a Default Value to a Column in BigQuery
How to Add a Not Null Constraint in BigQuery
How to Remove a Not Null Constraint in BigQuery
How to Create a View in BigQuery
How to Drop a View in BigQuery
3. Dates And Time
How to Exclude Current or Partial Weeks
How to Query Date and Time
How to Group by Time
How to Round Timestamps
4. Analysis
How to Use nullif()
How to Get the First Row per Group
How to Do Type Casting
How to Write a Common Table Expression
How to Compare Two Values When One Is Null
How to Use Coalesce
How to Write a Case Statement
How to Calculate Cumulative Sum-Running Total
SQL tutorial
>
postgreSQL
PostgreSQL
1. Basics
How to Compare Arrays in PostgreSQL
Start now
How to Concatenate Strings in PostgreSQL
Start now
How to Convert the Case of a String
Start now
How to Create an Array
Start now
How to Insert Array Data Into a Table
Start now
How to Insert Data Into an Array
Start now
How to Modify Arrays
Start now
How to Query Arrays
Start now
How to Replace Substrings
Start now
How to Trim Strings
Start now
How to Use string_agg()
Start now
How to Use substring()
Start now
How to Use substring() with Regular Expressions
Start now
How to Insert
Start now
How to Update
Start now
How to Delete
Start now
How to Compare Arrays in PostgreSQL
Start now
How to Concatenate Strings in PostgreSQL
Start now
How to Convert the Case of a String
Start now
How to Create an Array
Start now
How to Insert Array Data Into a Table
Start now
How to Insert Data Into an Array
Start now
How to Modify Arrays
Start now
How to Query Arrays
Start now
How to Replace Substrings
Start now
How to Trim Strings
Start now
How to Use string_agg()
Start now
How to Use substring()
Start now
How to Use substring() with Regular Expressions
Start now
How to Insert
Start now
How to Update
Start now
How to Delete
Start now
How to Compare Arrays in PostgreSQL
Start now
How to Concatenate Strings in PostgreSQL
Start now
How to Convert the Case of a String
Start now
How to Create an Array
Start now
How to Insert Array Data Into a Table
Start now
How to Insert Data Into an Array
Start now
How to Modify Arrays
Start now
How to Query Arrays
Start now
How to Replace Substrings
Start now
How to Trim Strings
Start now
How to Use string_agg()
Start now
How to Use substring()
Start now
How to Use substring() with Regular Expressions
Start now
How to Insert
Start now
How to Update
Start now
How to Delete
Start now
2. Database Management
How to Create a Table
Start now
How to Drop a Table
Start now
How to Rename a Table
Start now
How to Truncate a Table
Start now
How to Duplicate a Table
Start now
How to Add a Column
Start now
How to Drop a Column
Start now
How to Rename a Column
Start now
How to Add a Default Value to a Column
Start now
How to Remove a Default Value From a Column
Start now
How to Add a Not Null Constraint
Start now
How to Remove a Not Null Constraint
Start now
How to Create an Index
Start now
How to Drop an Index
Start now
How to Create a View
Start now
How to Drop a View
Start now
How to Alter Sequence
Start now
How to Create a Table
Start now
How to Drop a Table
Start now
How to Rename a Table
Start now
How to Truncate a Table
Start now
How to Duplicate a Table
Start now
How to Add a Column
Start now
How to Drop a Column
Start now
How to Rename a Column
Start now
How to Add a Default Value to a Column
Start now
How to Remove a Default Value From a Column
Start now
How to Add a Not Null Constraint
Start now
How to Remove a Not Null Constraint
Start now
How to Create an Index
Start now
How to Drop an Index
Start now
How to Create a View
Start now
How to Drop a View
Start now
How to Alter Sequence
Start now
How to Create a Table
Start now
How to Drop a Table
Start now
How to Rename a Table
Start now
How to Truncate a Table
Start now
How to Duplicate a Table
Start now
How to Add a Column
Start now
How to Drop a Column
Start now
How to Rename a Column
Start now
How to Add a Default Value to a Column
Start now
How to Remove a Default Value From a Column
Start now
How to Add a Not Null Constraint
Start now
How to Remove a Not Null Constraint
Start now
How to Create an Index
Start now
How to Drop an Index
Start now
How to Create a View
Start now
How to Drop a View
Start now
How to Alter Sequence
Start now
3. Dates And Time
How to Exclude Current or Partial Weeks
Start now
How to Use BETWEEN Correctly
Start now
How to Query Date and Time
Start now
How to Group by Time
Start now
How to Round Timestamps
Start now
How to Convert Local Time to UTC
Start now
How to Exclude Current or Partial Weeks
Start now
How to Use BETWEEN Correctly
Start now
How to Query Date and Time
Start now
How to Group by Time
Start now
How to Round Timestamps
Start now
How to Convert Local Time to UTC
Start now
How to Exclude Current or Partial Weeks
Start now
How to Use BETWEEN Correctly
Start now
How to Query Date and Time
Start now
How to Group by Time
Start now
How to Round Timestamps
Start now
How to Convert Local Time to UTC
Start now
4. Analysis
How to Use Lateral Joins
Start now
How to Use nullif()
Start now
How to Get the First Row per Group
Start now
How to Use generate_series to Avoid Gaps In Data
Start now
How to Do Type Casting
Start now
How to Write a Common Table Expression
Start now
How to Import a CSV
Start now
How to Compare Two Values When One Is Null
Start now
How to Use Coalesce
Start now
How to Write a Case Statement
Start now
How to Query a JSON Column
Start now
How to Use Filter Clause to Have Multiple Counts
Start now
How to Calculate Cumulative Sum-Running Total
Start now
How to Use Lateral Joins
Start now
How to Use nullif()
Start now
How to Get the First Row per Group
Start now
How to Use generate_series to Avoid Gaps In Data
Start now
How to Do Type Casting
Start now
How to Write a Common Table Expression
Start now
How to Import a CSV
Start now
How to Compare Two Values When One Is Null
Start now
How to Use Coalesce
Start now
How to Write a Case Statement
Start now
How to Query a JSON Column
Start now
How to Use Filter Clause to Have Multiple Counts
Start now
How to Calculate Cumulative Sum-Running Total
Start now
How to Use Lateral Joins
Start now
How to Use nullif()
Start now
How to Get the First Row per Group
Start now
How to Use generate_series to Avoid Gaps In Data
Start now
How to Do Type Casting
Start now
How to Write a Common Table Expression
Start now
How to Import a CSV
Start now
How to Compare Two Values When One Is Null
Start now
How to Use Coalesce
Start now
How to Write a Case Statement
Start now
How to Query a JSON Column
Start now
How to Use Filter Clause to Have Multiple Counts
Start now
How to Calculate Cumulative Sum-Running Total
Start now