SQL EXCEPT

SQL Except Set Operation

What is the SQL EXCEPT set operation? The SQL EXCEPT set operation is another set operation like the UNION or INTERSECT operations. This operation, however, returns all rows from the first query except those rows that appears in the second query. Think of this as subtraction but for sets. Visually, the SQL EXCEPT set operation […]

SQL INTERSECT, Set operations

SQL INTERSECT Set Operation

What is the SQL INTERSECT set operation The SQL INTERSECT set operation returns the distinct rows from two or more queries that appear in each query’s results. Unlike the SQL UNION set operation that returns all rows from both queries, the SQL INTERSECT operation only returns the rows that appear in both queries. Visualized with […]

Six Business Lessons Learned from College Athletics

This post by Brewster Knowlton originally appeared on LinkedIn. I was fortunate enough to play college lacrosse at one of the top division three programs in the country – Western New England University.  Four years of fall ball, freezing mid-January practices, welts, bruises, triumph and defeat taught me more than I could have ever realized.   For […]

CMOs can use data

Five Ways CMOs Can Use Data

Data and analytics is exploding. Whether you call it big data, business intelligence, or analytics, it is clear that the use of data is going to be critical to any company’s success. Especially in the bank and credit union industry, data and analytics is a relatively new concept. Sure, data has been used in the […]

SQL Union Set Operation

SQL Set Operations: UNION

What is the SQL UNION set operation? The SQL UNION set operation combines the results of two separate queries into a single result that contains all rows from both queries. Visualized by a Venn diagram, the UNION set operation looks like: Notice that every section of the circles (representing the results of separate queries) is […]

SQL FULL OUTER JOIN

SQL Table Joins – FULL OUTER JOIN

What is a FULL OUTER JOIN? The FULL OUTER JOIN is the last of the join methods. This join method returns rows from both the first table and the second table regardless of whether or not a match exists. Visualized using a Venn diagram, the FULL OUTER JOIN looks like this: As an example, we […]

table joins, sql join

SQL Table Joins – RIGHT OUTER JOIN

What is the RIGHT OUTER JOIN The RIGHT OUTER JOIN is nearly identical to the LEFT OUTER JOIN. The only difference between the two types of OUTER JOINs is the order in which SQL evaluates them. The LEFT OUTER JOIN returns all rows from the first table and the rows that match from second table. […]

5 Reasons to Invest in Data and Analytics in 2016

It’s no secret that the amount of data in the world is growing at a tremendous rate. Some anticipate that the world’s data volume will grow 40% per year and expand to fifty times its current volume by 2020. Think about your own organization: how much data did you have ten years ago? Five years […]

Table Joins – SQL LEFT OUTER JOIN

What is a LEFT OUTER JOIN? Like the INNER JOIN, a LEFT OUTER JOIN allows you to connect multiple tables in the same query. However, the LEFT OUTER JOIN returns all rows from the left table (first table listed) where the joining key matches a row in the second table listed. This is represented by […]

SQL INNER JOIN

Learning Table Joins – SQL INNER JOIN

What is the SQL INNER JOIN? A SQL INNER JOIN is a technique that allows you to retrieve data from multiple tables by connecting them with a joining key. An INNER JOIN can be thought of as the intersection of two tables based on some joining key. Typically, ID columns like SalesPersonID or BusinessEntityID in […]