SQL Filtering 101

sql filtering basics, sql filter by date, sql filter function, sql filter keyword, sql filter clause, filter sql, sql where, sql filter by date range, postgresql filter

Sometimes, SQL queries return lots of data you don’t need. In this article, we’ll look at a simple example of filtering SQL queries to reduce the complexity of your data. The key to learning how to filter data in SQL is understanding the very basics of Boolean algebra. That’s just a fancy term mathematicians use to describe expressions involving logical values (true/false) and their associated operators (and, or, not, etc.). Don’t be discouraged by this jargon; filtering is just common

Continue Reading

Learn SQL over the summer

Think summer is reserved for flying to warm places and hanging out at the beach? Sure! But it’s also a great time to learn new skills that you haven’t had time for. If you recently graduated from high school and want to get a head start on computer programming for college, learning SQL over the summer is a great opportunity. You have nothing to lose and everything to gain—SQL is actually really easy to learn, especially with so much free

Continue Reading

Why Data Visualization Is Important: Two Perspectives

Have you ever wondered how you can deal with an overwhelming amount of data? How do you use it? How do you understand what it’s saying? And last but not least, how do you present your data to the world such that everyone understands your point? In this article, we’ll explore these questions to understand the importance of data visualization. Where are the data? When I want someone to understand my perspective, I try to visualize it precisely so I

Continue Reading

New Vertabelo Academy Course: Learn R with Introduction to R

Unlock the potential of data! With this course, you’ll learn about data analytics, data science, statistical analysis, and functions in the R programming language. This course is perfect for people who have no prior knowledge of computer science or R programming. With Introduction to R, you’ll learn to work in the R programming language as you enter the promising world of data science.     Why R is so famous According to the TIOBE programming community index, which ranks the popularity

Continue Reading

How It Works

Brush up on your data science and SQL skills with Vertabelo Academy’s interactive courses. Why Vertabelo Academy? You get instant access to lessons that teach various concepts of SQL, data science, and programming in R (soon also in Python!). Our courses are appropriate for people who have no prior knowledge of computer science or programming. The only requirement is a web browser. No need to install databases, download example tables, or spend time inventing exercises for yourself. Each course comes with

Continue Reading

Understanding Data: Mining Vs. Visualization

Here’s a reality check: Big Data has hit us like a speeding truck on the highway of business intelligence. In today’s digital age, we’re generating data about ourselves that were once considered private, and we’re doing it willingly! From what we eat and wear to where we are at all times, nearly everything is now public knowledge. The data generated is a potential diamond mine for everyone in business, from one-person companies to Fortune 500 A-Listers alike, all thanks to

Continue Reading

GET ACCESS TO EXPERT SQL CONTENT!