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.
14 SQL Query Performance Tuning Tips

14 SQL Query Performance Tuning Tips

10
Comments
9 min read
nodejs feat Seqeuelize Course

nodejs feat Seqeuelize Course

6
Comments
1 min read
Transform SQL Query into MongoDB Query

Transform SQL Query into MongoDB Query

7
Comments
1 min read
New Formatting Profiles in SQL Complete v6.3

New Formatting Profiles in SQL Complete v6.3

7
Comments
2 min read
Sequelize, your favorite database library

Sequelize, your favorite database library

7
Comments
3 min read
MySql? What is it?

MySql? What is it?

8
Comments
3 min read
Angular 8 Button disable?

Angular 8 Button disable?

4
Comments 2
1 min read
How to Group in C# Like in SQL

How to Group in C# Like in SQL

5
Comments
1 min read
SQL is Insecure

SQL is Insecure

6
Comments 31
2 min read
Makers Week 4: Databased on a True Story

Makers Week 4: Databased on a True Story

6
Comments
2 min read
What do you need to know to get into Data Science as a Beginner?

What do you need to know to get into Data Science as a Beginner?

71
Comments 8
1 min read
Display records from Database one at a time

Display records from Database one at a time

5
Comments 1
2 min read
Creating a materialized view with SQL procedures

Creating a materialized view with SQL procedures

8
Comments
3 min read
How did I reduce the load time of my application?

How did I reduce the load time of my application?

16
Comments 2
1 min read
SQL: Union Operator

SQL: Union Operator

22
Comments
2 min read
Error-logging Patterns and Practices

Error-logging Patterns and Practices

66
Comments
6 min read
SQL, NoSQL and modern data practices

SQL, NoSQL and modern data practices

53
Comments
2 min read
Query PDFs with SQL

Query PDFs with SQL

9
Comments
1 min read
SQL: Inner Join

SQL: Inner Join

23
Comments 4
2 min read
Getting Started with Microsoft SQL Server on Mac and Windows in 2020

Getting Started with Microsoft SQL Server on Mac and Windows in 2020

13
Comments
1 min read
SQL vs NoSQL

SQL vs NoSQL

8
Comments
2 min read
Jumpstarting Applications with ActiveRecord

Jumpstarting Applications with ActiveRecord

12
Comments 1
7 min read
Vectorized SQL in CockroachDB

Vectorized SQL in CockroachDB

9
Comments
1 min read
View and Read SQL Server Transaction Log Data

View and Read SQL Server Transaction Log Data

5
Comments 1
1 min read
Learning about how to connect a Database

Learning about how to connect a Database

7
Comments 2
1 min read
Creating a Postgres database + user

Creating a Postgres database + user

5
Comments
1 min read
Starting my journey!

Starting my journey!

5
Comments 2
1 min read
Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

2
Comments
2 min read
#SQL30 Day 16: Dev Badges

#SQL30 Day 16: Dev Badges

7
Comments
4 min read
#SQL30 Day 15: Fuzzy Matching

#SQL30 Day 15: Fuzzy Matching

10
Comments
3 min read
#SQL30 Day 14: UFO Sightings

#SQL30 Day 14: UFO Sightings

6
Comments
2 min read
#SQL30 Day 13: Permutations

#SQL30 Day 13: Permutations

8
Comments
2 min read
That's how I came back in time

That's how I came back in time

2
Comments
2 min read
#SQL30 Day 7: Grouping Sets

#SQL30 Day 7: Grouping Sets

6
Comments 1
3 min read
#SQL30 Day 9: Longest Span

#SQL30 Day 9: Longest Span

9
Comments
3 min read
#SQL30 Day 4: Video Game Sales

#SQL30 Day 4: Video Game Sales

7
Comments 1
3 min read
SQL In The Real World: Setting Expectations For Your First Job

SQL In The Real World: Setting Expectations For Your First Job

14
Comments
4 min read
My SQL5.5: Reasons for being World’s Most Popular Opensource Database

My SQL5.5: Reasons for being World’s Most Popular Opensource Database

4
Comments
2 min read
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

5
Comments
2 min read
#SQL30 Day 5: Hierarchies

#SQL30 Day 5: Hierarchies

5
Comments 1
3 min read
Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

3
Comments
2 min read
JOINs on JOINs on JOINs

JOINs on JOINs on JOINs

14
Comments
3 min read
When SQL & Serverless aren't the right choices

When SQL & Serverless aren't the right choices

38
Comments
3 min read
How to Install MySQL on Mac

How to Install MySQL on Mac

6
Comments
2 min read
dbForge Transaction Log – A New Tool Made by Devart

dbForge Transaction Log – A New Tool Made by Devart

3
Comments
2 min read
How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

8
Comments 8
1 min read
Query to get Primary Key & Foreign Key columns

Query to get Primary Key & Foreign Key columns

4
Comments
1 min read
MySQL- Indexing Basics

MySQL- Indexing Basics

7
Comments
1 min read
Todo List App Using Flask and SQL-Alchemy

Todo List App Using Flask and SQL-Alchemy

7
Comments
1 min read
Database Views and How to Use Them in a Rails Based Application?

Database Views and How to Use Them in a Rails Based Application?

5
Comments
8 min read
Conhecendo o Azure Data Studio

Conhecendo o Azure Data Studio

2
Comments
2 min read
Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

Ways to talk about code (to people who don't code) #01: CSS, SQL, JavaScript

10
Comments
4 min read
Sumar y restar cantidades con SQL en WordPress

Sumar y restar cantidades con SQL en WordPress

7
Comments
3 min read
How to Get the First or Last Value in a Group Using Group By in SQL

How to Get the First or Last Value in a Group Using Group By in SQL

5
Comments
11 min read
Analyzing Meetup Data With SQL And Tableau - A Free Webinar

Analyzing Meetup Data With SQL And Tableau - A Free Webinar

9
Comments
1 min read
JOIN Semiotics and MassiveJS v6

JOIN Semiotics and MassiveJS v6

12
Comments
7 min read
Native Android Database

Native Android Database

4
Comments
1 min read
Using Python to Scrape the Meet-Up API

Using Python to Scrape the Meet-Up API

58
Comments
5 min read
Improving Community Support for Liquibase

Improving Community Support for Liquibase

12
Comments
1 min read
Tips for Writing an ETL Console Application in C# .NET Core

Tips for Writing an ETL Console Application in C# .NET Core

8
Comments
5 min read
loading...