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.
The Wild SQL Query I Wrote For Work This Week

The Wild SQL Query I Wrote For Work This Week

61
Comments 1
7 min read
Intro to SQL User Defined Functions (UDFs) in Redshift

Intro to SQL User Defined Functions (UDFs) in Redshift

8
Comments
5 min read
Access Google BigQuery Data with Entity Framework 6

Access Google BigQuery Data with Entity Framework 6

7
Comments
3 min read
API data persistence

API data persistence

10
Comments
3 min read
Best way to store array type data inside database?

Best way to store array type data inside database?

31
Comments 22
1 min read
Free SQL hosting providers ?

Free SQL hosting providers ?

28
Comments 23
1 min read
🤔 How to create a MySQL connection and run queries with Python3

🤔 How to create a MySQL connection and run queries with Python3

13
Comments 1
1 min read
Good sources (courses, books, sites) on database design and data modeling?

Good sources (courses, books, sites) on database design and data modeling?

14
Comments 2
1 min read
SQL Conceitos Básicos. Postgres + Docker

SQL Conceitos Básicos. Postgres + Docker

12
Comments
10 min read
SMSS -'Connect to Server' Hell

SMSS -'Connect to Server' Hell

6
Comments
1 min read
Basic DB Using SQL Server (Part 3) - retrieve data using SQL

Basic DB Using SQL Server (Part 3) - retrieve data using SQL

11
Comments
6 min read
Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

Basic DB Using SQL Server (Part 2) - modify columns and learn some constraints

8
Comments
8 min read
Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

Scraping Yelp and Facebook with Node. Displaying data with ASP.NET Core

15
Comments
5 min read
Documenting SQL with Markdown and Diagrams

Documenting SQL with Markdown and Diagrams

27
Comments 5
2 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.