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

Continue Reading

High Performance Statistical Queries: Linear Dependencies Between Continuous Variables

In my previous articles, I dealt with analyses of only a single variable. Now it is time to check whether two variables of interest are independent or somehow related. For example, a person’s height positively correlates with shoe size. Taller people have larger shoe sizes, and shorter people have smaller shoe sizes. You can find this and many more examples of positive associations at: http://examples.yourdictionary.com/positive-correlation-examples.html. A negative association is also possible. For example, an increase in the speed at which

Continue Reading

So You Want to Be a Data Scientist?

A career in data science is hot right now. What is a data scientist, and how can you become one? Very few of us said “I want to grow up to be a data scientist” when we were kids. But now, in the age of Big Data and economic uncertainty, a career in data science is looking mighty attractive. If you like the idea of working with information and earning a good paycheck, read on. If you’re interested in cutting-edge

Continue Reading

What Is Vertabelo’s SQL Cheat Sheet?

Everyone, from rookie programmers to SQL ninjas, needs a bit of help now and again. Enter Vertabelo’s SQL Cheat Sheet! Working with databases is hard. There’s a lot of data to manage, which can be daunting. But the main challenge many database users face is the SQL commands themselves. It’s all right when you’re using the same familiar ones day after day, but what about the commands you dust off once or twice a year? Or what if you’re just

Continue Reading

The 5 Highest Paying SQL and Database Jobs

IT provides a wide and growing job market, offering many excellent opportunities in both career development and earning potential. Today we’ll take a look at several very interesting SQL/Database-related jobs. Every year, many in the work force set their sights and aim for new and better jobs. When it comes to jobs, “better” means different things to different people, but earning potential is almost always a top priority. Enter the growing field of IT, in which new challenges wait around

Continue Reading

Four Reasons Aspiring Data Scientists Must Learn SQL

Isn’t data science way too advanced for simple SQL? Nope! SQL can help you build a foundation for your data science career. Let’s see how. Data science is hot right now. What if you could predict the next market crash? Or contain the spread of Ebola? Or accurately predict a health crisis months or even years before it happens? Data scientists are working hard on these kinds of projects, and they are earning healthy salaries in the process. No wonder

Continue Reading

GET ACCESS TO EXPERT SQL CONTENT!