Articles Cookbook
30 Aug 2024
LearnSQL.com Team

New Monthly SQL Practice for September 2024!

Ready for our new SQL challenge? This time, the tasks are slightly more difficult. In this course, you will assist MoMA’s management by analyzing data using standard SQL functions to answer questions and solve problems. Welcome to the September SQL Practice course! In our September 2024 SQL Practice, you will work with the database at the Museum of Modern Art (MoMA) in New York City. MoMA’s management has hired you, an SQL specialist, to bring a fresh perspective to the museum.
Read more
29 Aug 2024
Ekre Ceannmor

How to Export Data from PostgreSQL into a CSV File

Do you need to quickly send data to a client or share a report for further analysis? A CSV file is a great sharing option! Let’s take a look at how you can use this format to export data from a PostgreSQL database. In this article, we will first review what the CSV file format is and why it’s handy when exporting your PostgreSQL database. Then we will export some example data from a real database using psql on the command line and pgAdmin, a free and open-source interface for PostgreSQL databases.
Read more
27 Aug 2024
Jakub Romanowski

Top YouTube Channels Every Data Analyst Should Follow

If you're a data analyst or looking to become one, YouTube is a great resource to help you learn and grow. In this article, I’ll share the top YouTube channels every data analyst should follow. These recommendations will give you the knowledge you need to succeed in data analysis. YouTube is a great place to start learning data analysis, and I’m here to help you get the most out of it.
Read more
22 Aug 2024
Michał Wasiluk

An Introduction to Spatial Databases and Geospatial Data

Discover how spatial databases and geospatial data enhance spatial queries, support GIS integrations, and enable advanced data analysis. Spatial databases are specialized database systems designed to store, manage, and query geospatial data efficiently. These databases provide support for spatial data types and spatial indexing, allowing for complex spatial queries and analysis. Geospatial data, stored within these databases, represents information about the physical world tied to specific locations on Earth.
Read more
20 Aug 2024
Jakub Romanowski

Data Analyst Salaries: Benchmarks for 2025

The demand for data analysts is going crazy as businesses are relying more and more on data to make decisions. In this post, I’ll walk you through what you can expect for salary at different stages of a data analyst career so you can decide if this is the path for you. If you’re considering a data analyst career you’re in the right place at the right time. Companies are more data hungry than ever and by 2025 this demand will be even crazier.
Read more
15 Aug 2024
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.
Read more
13 Aug 2024
Alexandre Bruffa

Integrating SQL with Looker for Data Analysis

You may have heard the term “data-driven”. All big companies nowadays have a data-driven approach; it simply means they make strategic decisions based on data analysis and interpretation. To streamline the process and stay competitive, companies rely heavily on data analysis and Business Intelligence (BI) tools. One of the most famous powerful BI platforms is Looker. Now owned by Google, Looker is well known for its data exploration, visualization, and reporting capabilities.
Read more
11 Aug 2024
Martyna Sławińska

SQL Practice for Beginners: AdventureWorks Exercises

Hone your SQL skills with hands-on exercises using the AdventureWorks sample database. Practice essential SQL features using real-world scenarios. Practicing SQL is important if you want to get better at using it. This article has 20 beginner-friendly exercises using the AdventureWorks sample database from Microsoft. This database is designed to show how SQL Server works. It represents a fictitious bicycle manufacturing company called AdventureWorks Cycles and includes five schemas: HumanResources, Person, Production, Purchasing, and Sales.
Read more
6 Aug 2024
Jakub Romanowski

How to Overcome the Challenges of Becoming a Data Analyst

Want to become a data analyst but not sure how to do it? No worries, I'm here to help. In this guide, I'll show you the most common challenges to starting a data analysis career. I’ll also tell you about simple steps you can take to overcome these roadblocks. A career as a data analyst can be both exciting and a bit scary. The potential to uncover insights from data and make a real impact is thrilling, but there are many skills to master and a lot to learn.
Read more
1 Aug 2024
Jakub Romanowski

Course of the Month: GROUP BY Extensions in PostgreSQL

Do you work with data? Want to be able to create better and more sophisticated SQL reports? Then check out our interactive GROUP BY Extensions in PostgreSQL course. In August 2024, you can complete this online PostgreSQL course for FREE! How can you get this free SQL course in August 2024? Create a free LearnSQL.com account or log in if you already have one. Start the course.
Read more