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.
Codecadmey Data Science Course Part IV

Codecadmey Data Science Course Part IV

4
Comments 2
6 min read
How to Install Oracle SQL Developer on Ubuntu 20.04

How to Install Oracle SQL Developer on Ubuntu 20.04

61
Comments 36
4 min read
Python JDBC connection into IRIS database - a quick note

Python JDBC connection into IRIS database - a quick note

4
Comments
9 min read
Qué son las bases de datos orientadas a grafos y para qué se usan

Qué son las bases de datos orientadas a grafos y para qué se usan

8
Comments
4 min read
Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!*

Free Text Search: The Way To Search Your Text Fields That SQL Developers Are Hiding From You!*

3
Comments
4 min read
Codecademy Data Science Course Part III

Codecademy Data Science Course Part III

3
Comments
2 min read
Flask Login-Register-Logout Implementation

Flask Login-Register-Logout Implementation

21
Comments 6
7 min read
Passed the test, next class that covers Psudo Programing [WGU basics]

Passed the test, next class that covers Psudo Programing [WGU basics]

2
Comments
1 min read
Codecademy Data Science Course Part II

Codecademy Data Science Course Part II

3
Comments
3 min read
Codecademy Data Science Course Part I

Codecademy Data Science Course Part I

4
Comments 2
2 min read
Dica Rápida: Paginando no MSSQL considerando escala

Dica Rápida: Paginando no MSSQL considerando escala

8
Comments 7
2 min read
Azure Data Studio Custom Theme

Azure Data Studio Custom Theme

3
Comments
3 min read
Dica rápida: Paginando no MSSQL com Offset e Fetch

Dica rápida: Paginando no MSSQL com Offset e Fetch

8
Comments
2 min read
Master your Database using C# with EF Core 5.0

Master your Database using C# with EF Core 5.0

40
Comments
1 min read
What is a relational database and relational database management system?

What is a relational database and relational database management system?

32
Comments
2 min read
Databases and MySQL

Databases and MySQL

7
Comments
4 min read
MySQL Tutorial: the beginner's guide to using MySQL

MySQL Tutorial: the beginner's guide to using MySQL

25
Comments
12 min read
SQL Knowledge 101

SQL Knowledge 101

5
Comments
4 min read
Advanced SQLAlchemy Features You Need To Start Using

Advanced SQLAlchemy Features You Need To Start Using

25
Comments
10 min read
A Take on Empowering ActiveRecord

A Take on Empowering ActiveRecord

48
Comments 8
3 min read
Inner Join Tables in SQL

Inner Join Tables in SQL

5
Comments
3 min read
PL/SQL Cheat Sheet

PL/SQL Cheat Sheet

3
Comments
1 min read
Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

22
Comments 1
30 min read
Efficient INSERT MULTIPLE with Postgres

Efficient INSERT MULTIPLE with Postgres

7
Comments
4 min read
clientsdb - A docker image with clients comments

clientsdb - A docker image with clients comments

8
Comments
2 min read
HarperDB: A NewSQL Database.

HarperDB: A NewSQL Database.

38
Comments 1
5 min read
Using SUBSTR and INSTR functions in ORACLE PLSQL

Using SUBSTR and INSTR functions in ORACLE PLSQL

4
Comments
1 min read
When to choose NoSQL over SQL?

When to choose NoSQL over SQL?

210
Comments 22
2 min read
Why is SQL injection still a thing?

Why is SQL injection still a thing?

4
Comments 1
1 min read
LMDB Deep Dive: Interview with a CTO on using the Open Source Key Value Store

LMDB Deep Dive: Interview with a CTO on using the Open Source Key Value Store

28
Comments 1
13 min read
PL/SQL Nested Queries

PL/SQL Nested Queries

8
Comments
5 min read
How to Query a JSON in PostgreSQL

How to Query a JSON in PostgreSQL

8
Comments
3 min read
Multiplatform Encryption with SQLDelight and SQLCipher

Multiplatform Encryption with SQLDelight and SQLCipher

17
Comments
3 min read
Extracting SQL code from SSIS dtsx packages with Python lxml

Extracting SQL code from SSIS dtsx packages with Python lxml

2
Comments 1
3 min read
Snowflake Field Notes

Snowflake Field Notes

8
Comments
12 min read
Deep Dive: NewSQL Databases

Deep Dive: NewSQL Databases

69
Comments 3
8 min read
Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

Transpose rows to columns in Oracle SQL using Oracle PIVOT clause

6
Comments
1 min read
Using MySQL Together With Go

Using MySQL Together With Go

3
Comments
1 min read
Data Architecture as a Utility Tool

Data Architecture as a Utility Tool

5
Comments
10 min read
Limit MySQL subquery results inside a WHERE IN clause, using Laravel's Eloquent ORM

Limit MySQL subquery results inside a WHERE IN clause, using Laravel's Eloquent ORM

11
Comments 1
5 min read
Querying CSV files in AWS S3 from Go, using SQL

Querying CSV files in AWS S3 from Go, using SQL

10
Comments
5 min read
Oracle SQL Analytic Functions - Part 1

Oracle SQL Analytic Functions - Part 1

13
Comments
10 min read
When to use NoSQL over SQL ?

When to use NoSQL over SQL ?

9
Comments 4
2 min read
Algebraic data types in SQL

Algebraic data types in SQL

5
Comments 5
1 min read
1 SQL Query You Should Stop Using

1 SQL Query You Should Stop Using

369
Comments 43
3 min read
5 Trends In Big Data And SQL To Be Excited About In 2020

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

28
Comments
8 min read
Deploy a Full-Stack App on GCP with a Cloud SQL Connection: Part 2

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

11
Comments
4 min read
How To Write Better SQL: Advanced SQL Episode 2 - Please Stop Using So Many CTEs

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

43
Comments 1
6 min read
SQLcl, a nicer SQL*PLUS alternative

SQLcl, a nicer SQL*PLUS alternative

6
Comments
6 min read
Choosing a Database: SQL or NoSQL? - Building a Blog

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

3
Comments
3 min read
What is Neo4j?

What is Neo4j?

13
Comments
4 min read
Deploy a Full-Stack App on GCP & Make a Cloud SQL Connection: Part 1

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

9
Comments
4 min read
All of the Things! Custom MS Search Vertical of Serverless Azure DB and the new SQL Graph Connector!

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

3
Comments
14 min read
SQL vs NoSQL: Explained with Examples

SQL vs NoSQL: Explained with Examples

3
Comments
1 min read
mvn Liquibase:updateSql DatabaseException

mvn Liquibase:updateSql DatabaseException

15
Comments 4
3 min read
Build RESTful APIs Using ASP.NET Core and Entity Framework Core

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

3
Comments
1 min read
Tutorial: Setting up HarperDB Cloud

Tutorial: Setting up HarperDB Cloud

18
Comments
2 min read
Databases for Windows Desktop Development: Welcome to the Jungle

Databases for Windows Desktop Development: Welcome to the Jungle

4
Comments
6 min read
Is there such thing as a truly free cloud database?

Is there such thing as a truly free cloud database?

37
Comments 31
1 min read
What they don’t tell you about being an analyst

What they don’t tell you about being an analyst

29
Comments 2
13 min read
loading...