DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
SQL 101: How Databases and Tables Are Structured

SQL 101: How Databases and Tables Are Structured

9
Comments
5 min read
The difference between regular views and materialized views in PostgreSQL

The difference between regular views and materialized views in PostgreSQL

7
Comments
1 min read
Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

Forget SQL vs NoSQL - Get the Best of Both Worlds with JSON in PostgreSQL

18
Comments
8 min read
10 Things I Hate About SQL

10 Things I Hate About SQL

15
Comments 16
8 min read
SQL query from the view: considered hazardous!

SQL query from the view: considered hazardous!

8
Comments 4
5 min read
Using a PlSql cursor in a FOR loop example

Using a PlSql cursor in a FOR loop example

4
Comments
3 min read
SQL Server 2019 for Data Professionals

SQL Server 2019 for Data Professionals

2
Comments
2 min read
Create and drop oracle table example

Create and drop oracle table example

5
Comments 1
2 min read
SQL Review - WHERE, SELECT

SQL Review - WHERE, SELECT

3
Comments
2 min read
SQL Learning notes

SQL Learning notes

3
Comments
2 min read
Slow Queries? 10X Query Performance with a Database Index

Slow Queries? 10X Query Performance with a Database Index

6
Comments
5 min read
写给女朋友的 SQL 教程——数据模型

写给女朋友的 SQL 教程——数据模型

2
Comments
1 min read
Reacty Loops : fully web-based music production

Reacty Loops : fully web-based music production

7
Comments 2
1 min read
WishList Feature for eCommerce App using Java and Spring Boot

WishList Feature for eCommerce App using Java and Spring Boot

12
Comments
7 min read
Get the current unix timestamp in oracle

Get the current unix timestamp in oracle

7
Comments
1 min read
Implementing months_between() function in BigQuery

Implementing months_between() function in BigQuery

12
Comments 3
6 min read
UUIDs vs Auto-Incrementing Primary Keys in SQL

UUIDs vs Auto-Incrementing Primary Keys in SQL

30
Comments 1
7 min read
For relational algebra, there will be better alternatives to SQL (the language)?

For relational algebra, there will be better alternatives to SQL (the language)?

8
Comments 2
1 min read
Reporting in Power BI - Quick Steps

Reporting in Power BI - Quick Steps

3
Comments
1 min read
Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

Taking Ownership of Our Data Pipelines: Analytics Engineering Using dbt

7
Comments
14 min read
SQL is 50 Years Old. What Can We Learn From Its Success?

SQL is 50 Years Old. What Can We Learn From Its Success?

5
Comments
11 min read
SQL for Beginners

SQL for Beginners

4
Comments
4 min read
Hacking Ecto: Constructing Ecto Query from Raw SQL

Hacking Ecto: Constructing Ecto Query from Raw SQL

6
Comments
3 min read
Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

Trigger Warning! A Complete Guide to SQL Triggers - Setting up DB Tracking in Postgres

2
Comments
10 min read
Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

Step by step guide on how to create an Asp.Net Core MVC CRUD, Ef Core code first approach

25
Comments
8 min read
loading...