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.
Transpose rows to columns in Oracle SQL using Oracle PIVOT clause
Cover image for Transpose rows to columns in Oracle SQL using Oracle PIVOT clause
prsharankumar profile

Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

#transpose #sql #oracle #pivot
12
Comments
1 min read
Using MySQL Together With Go
Cover image for Using MySQL Together With Go
dak425 profile

Using MySQL Together With Go

#go #sql #tutorial #video
3
Comments
1 min read
Data Architecture as a Utility Tool
Cover image for Data Architecture as a Utility Tool
mattarderne profile

Data Architecture as a Utility Tool

#sql #database #datascience #architecture
5
Comments
10 min read
Querying CSV files in AWS S3 from Go, using SQL
mihaichiorean profile

Querying CSV files in AWS S3 from Go, using SQL

#aws #go #sql
11
Comments
5 min read
Oracle SQL Analytic Functions - Part 1
Cover image for Oracle SQL Analytic Functions - Part 1
markbdsouza profile

Oracle SQL Analytic Functions - Part 1

#database #oracle #sql #tutorial
13
Comments
10 min read
When to use NoSQL over SQL ?
Cover image for When to use NoSQL over SQL ?
sanchit170054 profile

When to use NoSQL over SQL ?

#watercooler #sql #datascience #career
9
Comments 4
2 min read
Algebraic data types in SQL
koredefashokun profile

Algebraic data types in SQL

#help #sql
5
Comments 5
1 min read
1 SQL Query You Should Stop Using
Cover image for 1 SQL Query You Should Stop Using
abdisalan_js profile

1 SQL Query You Should Stop Using

#sql #database #performance
369
Comments 43
3 min read
5 Trends In Big Data And SQL To Be Excited About In 2020
Cover image for 5 Trends In Big Data And SQL To Be Excited About In 2020
seattledataguy profile

5 Trends In Big Data And SQL To Be Excited About In 2020

#news #sql #database #datascience
28
Comments
8 min read
Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2
Cover image for Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2
wpreble1 profile

Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2

#googlecloud #javascript #sql #sequelize
13
Comments
4 min read
How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs
Cover image for How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs
seattledataguy profile

How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs

#sql #datascience #database
43
Comments 1
6 min read
SQLcl, a nicer SQL*PLUS alternative
Cover image for SQLcl, a nicer SQL*PLUS alternative
project42 profile

SQLcl, a nicer SQL*PLUS alternative

#sql #sqlcl #database #tutorial
9
Comments
6 min read
Choosing a Database: SQL or NoSQL? - Building a Blog
shadowphoenix profile

Choosing a Database: SQL or NoSQL? - Building a Blog

#database #sql #learning #codenewbie
3
Comments
3 min read
What is Neo4j?
Cover image for What is Neo4j?
sukhbirsekhon profile

What is Neo4j?

#neo4j #sql #database #graphql
16
Comments
4 min read
Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1
Cover image for Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1
wpreble1 profile

Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1

#googlecloud #sql #javascript #cloudsql
10
Comments
4 min read
All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!
Cover image for All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!
mhomol profile

All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!

#m365 #azure #sql #search
3
Comments
14 min read
SQL vs NoSQL: Explained with Examples
techparida profile

SQL vs NoSQL: Explained with Examples

#sql #mysql #tutorial #codenewbie
3
Comments
1 min read
mvn Liquibase:updateSql DatabaseException
damcosset profile

mvn Liquibase:updateSql DatabaseException

#help #java #liquibase #sql
15
Comments 4
3 min read
Build RESTful APIs Using ASP.NET Core and Entity Framework Core
aramt87 profile

Build RESTful APIs Using ASP.NET Core and Entity Framework Core

#net #netcore #c #sql
3
Comments
1 min read
Tutorial: Setting up HarperDB Cloud
stephengoldberg profile

Tutorial: Setting up HarperDB Cloud

#database #tutorial #sql #microservices
20
Comments
2 min read
Databases for Windows Desktop Development: Welcome to the Jungle
Cover image for Databases for Windows Desktop Development: Welcome to the Jungle
vicobiscotti profile

Databases for Windows Desktop Development: Welcome to the Jungle

#dotnet #database #sql #windows
5
Comments
6 min read
Is there such thing as a truly free cloud database?
Cover image for Is there such thing as a truly free cloud database?
micahlt profile

Is there such thing as a truly free cloud database?

#discuss #database #sql #node
37
Comments 31
1 min read
What they don’t tell you about being an analyst
Cover image for What they don’t tell you about being an analyst
alexantra profile

What they don’t tell you about being an analyst

#data #analysis #sql #database
29
Comments 2
13 min read
Flyway & Azure DevOps : Rodando Flyway Localmente
Cover image for Flyway & Azure DevOps : Rodando Flyway Localmente
higor profile

Flyway & Azure DevOps : Rodando Flyway Localmente

#devops #azure #sql #database
1
Comments 2
2 min read
Flyway & Azure DevOps : Azure SQL Database
Cover image for Flyway & Azure DevOps : Azure SQL Database
higor profile

Flyway & Azure DevOps : Azure SQL Database

#azure #devops #sql #database
6
Comments 1
3 min read
loading...