Sql Queries

Michał Wasiluk

A Guide to PostGIS: Basic Geospatial Data Query Examples

Geospatial data is becoming increasingly important in many fields, from urban planning to environmental science. In this article, we’ll demonstrate basic PostgreSQL PostGIS queries for working with this type of data. Geospatial data, which contains information about locations on Earth, requires specialized tools for effective use. PostGIS is a powerful PostgreSQL extension that turns a Postgres database into a full-featured Geographic Information System (GIS). With PostGIS, you can store geographic objects, run spatial queries, and perform advanced analyses directly in SQL.

Jakub Romanowski

How to Find SQL Databases for Practice

Learning SQL is important for anyone working with data, but finding a SQL database for practice can be a challenge. In this guide, you'll find easy SQL queries (and some rather more complex) to help you get started using the databases from our new SQL Databases for Practice course. SQL can be fun and practical when you get to try out real queries on a real database. If you are a beginner this guide will help you get started with some simple SQL queries using the databases from our SQL Databases for Practice course.

Jeffrey Edison

Data Analyst's Guide to SQL Indexing: Fix Slow Queries

Does your SQL query response time leave something to be desired? Or maybe you don't know if your queries could be faster. In this article, we’ll explain how SQL indexing can help. Diving into SQL is like unlocking a superpower. It's all about mastering the art of querying your database effectively so you can retrieve the information you need quickly and easily. But what happens when you ask a question that's complex enough to slow response time from seconds to minutes – or even longer?

Jill Thornhill

Data Export: From SQL Query to Spreadsheet

How do you export data from an SQL database to Excel or another spreadsheet? In this article, I’ll look at various methods and share a few tips for when things go wrong. SQL is the most widely used method of extracting data from a database. However, it’s not the only gadget in an analyst’s toolbox. Once the information is extracted, you’ll often want to import it into a spreadsheet – maybe to do further analysis or just to make it look pretty so you can present it to management.

Maria Durkin

SQL and Power BI: Transforming Data into Insights

The need for powerful tools that enable efficient data analysis and visualization has never been greater. Enter SQL and Power BI, a potent duo that enables businesses to maximize the value of their data assets. First, let’s explain what SQL and Power BI are; then we’ll discuss how and why they make such a great pair. SQL, or Structured Query Language, allows you to communicate with databases, making it the foundation of data management.

Maria Durkin

Where to Practice SQL

Are you looking to boost your data management or analytical abilities? Then you need to know how and where to practice SQL, the worldwide language for managing and running relational databases. Of course, knowing where to practice SQL can be a challenge – there are so many options! In this article, we’ll walk you through the best digital platforms for enhancing your SQL skills. SQL, or Structured Query Language, is the universal language for managing and operating relational databases.

Nicole Darnley

How to Create Your Own Database to Practice SQL

Welcome to the step-by-step guide to creating your own SQL database from scratch, designed with beginners in mind. This guide not only helps you set up your database but also introduces you to essential SQL practice exercises to get you started on your learning journey. Follow along to gain SQL hands-on practice and foster a deeper understanding of SQL functionalities. Set a solid foundation for more advanced SQL training!

Valentyn Kucherenko

An SQL Basics Primer for Non-IT Professionals

You don’t need to be an IT professional to understand SQL. Our quick primer of SQL basics is perfect for beginners without any computer science or programming background. If you’ve ever tried to learn a new software program, you know it takes more than just a few minutes. But it doesn’t mean you can’t learn it! The same is true if you want to learn SQL and databases. Even if you don’t have an IT background, you can do it.

Tihomir Babic

20 Basic SQL Query Examples for Beginners

These 20 basic queries are a must in a starter pack for every SQL beginner. These examples will get you going on your journey to mastering SQL. You’ve set your mind on learning SQL, googled ‘basic sql query examples’ or something similar, and here you are staring at this article. Now what? All learning starts with the basics, so let’s start with the most basic question: What Is SQL?

Jakub Romanowski

The Best Way to Learn SQL: A Complete Guide for Beginners

If you've ever wondered about the best way to learn SQL, you're in the right place. Whether you're a complete beginner or an experienced professional looking to upskill, this comprehensive guide will show you the way. In today's data-driven world, you can think of data as a treasure chest full of gold. And SQL (Structured Query Language) is your personal key to unlocking it. SQL is a potent tool that allows you to communicate with databases, enabling you to extract, shape, and make sense of data.

Alexandre Bruffa

How SQL Skills Can Boost Your Resume

You may wonder: does having SQL skills matter? In what areas could I use my SQL skills? In this article, I will explain how having SQL skills can boost your resume and add momentum to your professional career. We are living in the Big Data era. Every time we go online, we provide the websites we visit with a lot of information. If we voluntarily give our data by creating an account, filling out a form, or making a purchase, we give them even more information.

Ignacio L. Bisso

SQL Window Functions By Explanation

In our previous post, we explained how SQL window functions work by example. We started with some very simple, basic functions. Let's extend it by explaining subclauses in window functions. SQL window functions are a great way to compute results from a set of rows rather than a single row. As you know from our first article, the "window" in window function refers to the set of rows. We showed you some examples of simple window functions like RANK and LEAD.