Browsing Tag
sql
93 posts
Final association query solution
By rethinking and redefining the equi-joins, we are able to simplify the join syntax. A direct and obvious…
HackerRank SQL preparation; Revising the Select Query II(MySQL)
Problem Statement: Query the NAME field for American cities in the CITY table with populations larger than 120,000.…
The difficulty of SQL stems from relational algebra
In the field of structured data computing, SQL is still the most widely used working language, not only…
Why You Should Use a Database
Now, the point I want to drive home with this is that, storing a database, storing a collection…
Migrating SQL Server to Azure SQL Database with SQL Server Management Studio (SSMS)
Introduction Databases from an on-premises SQL Server instance can be moved to an Azure SQL Database (offline) using…
ORM vs No ORM: Which to Choose?
ORM (Object-Relational Mapping) Choose to use an ORM, like Sequelize, Django ORM, Hibernate, or Entity Framework if: You…
SQL vs NoSQL: Which to Choose?
SQL Choose SQL databases, like MySQL, PostgreSQL, and SQLite, if: Your data is structured and relational. You need…
Functions in SQL
Functions are very similar to procedures in databases. In this article, I will try to break down functions…
Is SQL a declarative language
When learning SQL, we often hear the saying that SQL is a declarative language. You just need to…
🏁🐘Winning Race Conditions With PostgreSQL
Race conditions suck! They can be extremely difficult to debug, and often only occur naturally in production at…
