19 Mar 2024 Jill Thornhill SQL Aggregate Functions Cheat Sheet A quick reference guide to using SQL aggregate functions. This SQL Aggregate Functions Cheat Sheet is designed to be your companion whenever you’re using SQL for data analysis. Aggregating data is essential for any meaningful data analysis. SQL provides a set of functions that allow you to include totals, averages, and counts in your reports and to extract the minimum and maximum value of any column of data. Read more 13 Feb 2024 Jill Thornhill Integrating SQL with Python for Data Analysis Integrating SQL with Python isn’t difficult. The two tools work together to combine the information-processing power of relational databases with the flexibility of a programming language. In this article, I will discuss the benefits of data analysis using SQL and Python, with real-world coding examples. Why do most of the best data analysis tools on the market – such as Tableau and Power BI – include both SQL and Python in their toolboxes? Read more 10 Jan 2024 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. Read more 7 Nov 2023 Jill Thornhill Why Every Database Administrator Needs SQL What is a database administrator? What do they do? Why do they need to know SQL, and what do they use it for? In this article, I'll answer these questions. As technology advances, more and more data is available to help organizations make informed decisions. You can't stay competitive – or provide good service to your customers – without the right information. Database administrators are responsible for making sure the right data is stored safely, that it's easily accessible to those who need it, and that it’s protected from malicious attacks. Read more 5 Oct 2023 Jill Thornhill BigQuery Window Functions Explained Keeping up with data analysis trends gives your organization – and your CV – the cutting edge. In this article, we'll look at BigQuery window functions and how you can use them to gain deeper insights into your data. Google's BigQuery, launched in 2010, is gaining traction as a popular choice with organizations needing to analyze large quantities of information quickly and to compare their own data against statistical data in the public domain. Read more 15 Aug 2023 Jill Thornhill Data-Driven Career Choices: Database Student Choosing a career is one of the most important decisions you'll ever make. A data-driven career is one of the best ways to secure your future; today's trend is to store and make use of more and more data in every field. In this article, I'll look at some of the choices available. We're living in an era where the quality and quantity of data is expanding exponentially. In almost any career you choose, you'll need to leverage data to make effective decisions. Read more 6 Jul 2023 Jill Thornhill Google BigQuery SQL Syntax: A Comprehensive Guide What is Google BigQuery? What can it do for your organization? Is BigQuery SQL a valuable skill? Where can you learn it, and where can you get some practice? Very few organizations today are not computerized. Many processes now make use of the IoT (Internet of Things), where all kinds of devices are networked and continually feed real time data into computer systems. The result is a vast amount of data available for decision-making. Read more 27 Jun 2023 Jill Thornhill How to Learn T-SQL Querying T-SQL is the dialect of SQL used by Microsoft SQL Server databases. Find out the best way to learn T-SQL querying with interactive online courses. In today's data-driven world, increasing your database knowledge is always a good choice. Microsoft SQL Server is one of the most popular databases nowadays. Knowing T-SQL – the query language of SQL Server databases –is often recommended as a worthwhile skill for careers in IT, business, or research fields. Read more 11 May 2023 Jill Thornhill Why Is Data a Valuable Resource for Your Business? How do you build an effective data resource and make it work for you? In this article, I'll look at why data is so important to any organization and how to make the most of your data resources. Bad decisions are almost always based on incorrect or incomplete facts. Good decisions keep your organization competitive. In a nutshell, that’s why data is such an important business resource. Ever since the dawn of civilization, our ancestors have known the value of information. Read more 20 Apr 2023 Jill Thornhill CTE vs. Subquery in SQL: What’s the Difference? What are Common Table Expressions (CTEs)? Are they the same as subqueries? When would you need to use CTEs? This article looks at the similarities and differences between CTE vs subquery. When I introduce a student to Common Table Expressions, their first reaction is “That’s just a subquery! Why do I need to learn that?”. Let’s answer this question by looking at what you can do with an SQL subquery and what extra advantages there are in using a CTE. Read more «« « 1 2 » »»