13 Dec 2024 Ekre Ceannmor SQL Quiz Want to quickly check your SQL skills? Take this short quiz and get immediate results, together with advice on your future learning path! Want to quickly check your SQL skills? Our SQL Quiz is tailored just for you! It's a great way to verify your current knowledge and identify areas for improvement. If you want a more thorough test for your skills – including advanced topics like reports, window functions and much more – check out our free SQL Skill Assessment. Read more 28 Nov 2024 Ekre Ceannmor SQL Queries for Google Sheets Power up your data analysis skills by utilizing SQL queries for Google Sheets! This comprehensive guide will demonstrate how to use the QUERY function to combine the power of SQL with the accessibility of Google Sheets! Looking to make data analysis in Google Sheets faster and more powerful? The QUERY function lets you filter, sort, and analyze data just like you would in SQL – without leaving your spreadsheet! In this article, we will break down everything you need to get started using SQL queries for Google sheets. Read more 26 Nov 2024 Ekre Ceannmor How to Start Coding SQL in VS Code Looking to enhance your SQL development? Our guide covers everything you need to get started with SQL in Visual Studio Code, the world's most popular IDE. Discover setup tips, extensions, database connections, and more to streamline your SQL coding experience. Visual Studio Code (VS Code) is currently the world’s most popular integrated development environment (IDE). It supports a variety of programming languages, and its massive community creates a lot of different extensions that help streamline your work or unlock even more potential within the IDE. Read more 29 Oct 2024 Ekre Ceannmor SQL Project for Beginners: AdventureWorks Sales Dashboard Building an SQL project on your own is a great way to sharpen your skills and gain practical experience. This SQL project example for beginners will show you how to create a sales dashboard with SQL and the AdventureWorks sample database. If you're an SQL beginner who wants to take their skills beyond simple query exercises, it’s a good idea to tackle an SQL data analysis project. Not only will it challenge you to apply what you've learned, it will also give you a deeper understanding of how SQL works in real-world scenarios. Read more 15 Oct 2024 Ekre Ceannmor 19 Aggregate Function Exercises Solve these 19 SQL aggregate function exercises and sharpen your SQL skills! Practice using aggregate functions with GROUP BY, HAVING, subqueries, and more. Includes a solution and detailed explanation for each exercise. Aggregate functions are an important part of SQL. They allow you to calculate different statistics and generate reports that you would not have been able to with single-row operations like filtering. It’s important to practice aggregate functions often, as they are a crucial part of your SQL skill set. 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