Tag: sql query

SQL Aggregate Functions: Easy Tips for Newbies

Database development, Statements

SQL Aggregate Functions are functions that perform calculations and return a summarized...
Read More

How to Write Complex Queries in SQL

Database development, Statements

Typical queries in the SELECT * FROM table format are sometimes not enough. When the data for a query is not in one table, but in several,...
Read More

Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance

Database administration, Database development, Performance Tuning, Statements

What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
Read More

9 Best Practices for Writing SQL Queries

Database administration, Database development, MySQL, Oracle, Performance Tuning, PostgreSQL, SQL Server, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to...
Read More

SQL Reference Table: How to Create and Write Basic Queries

Database development, Statements, Tables

This article will focus on writing SQL queries against the database reference table with a fairly simple structure to understand and...
Read More

SQL Basic Commands: How to Write Simple Queries with Examples

Database development, Statements

This article explains writing simple SQL queries from the most basic ones and gradually improving the script to solve some mathematical and...
Read More

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

Database development, Performance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases....
Read More

The Easy Guide on How to Use Subqueries in SQL Server

Database development, Statements • One Comment

Do you use SQL subqueries or avoid using them? Let’s say the chief credit and collections officer asks you to list down the names of...
Read More
Close