Learn about SQL joins using Excel

Why do we join tables in SQL? Tables that logically represent information are the foundation of relational databases. The ancient rules of database normalization remind us to arrange database tables to reduce redundancy and increase flexibility. An adequately...

Super Bowl Squares Template

elink.io | See Original The Superbowl is almost here. If you are tasked with creating blocks for a pool, there's still time to pull out your ruler, draw up a grid, and wrangle a bunch of friends into writing their names in the squares. Or, spare yourself some time...

How to Return Multiple Matches in one Cell Using a lookup?

VLOOKUP is great for looking up a value and returning another corresponding value. But what happens when the first match just isn't enough. I've been tasked with finding a way to put return not just the first but the second, and third match. At first, I tried to...

How to Delete every other Row in Excel

Have you ever needed to delete every other row in Excel? You are not alone.   There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...
How to Load Stock Information in Excel? It’s Easier Than You Think

How to Load Stock Information in Excel? It’s Easier Than You Think

There are plenty of websites that display stock tickers, technical information, and other important stock Information. Even though several websites do a fantastic job, sometimes you want to analyze them in your own little spreadsheet. Getting Stock Market Data into Excel the Old fashioned way Unless you are waiting for quotes in the next day's...

read more
Insert Multiple Rows into SQL table Using Excel as a Template

Insert Multiple Rows into SQL table Using Excel as a Template

I hope you followed the previous tutorial where we checked Created some brand new database tables using Excel as a template. Let's populate these tables with meaningful data. Okay, it might not be the most meaningful dataset since I just made this data up using Mockaroo.com. (Incredible site for creating sample data on the fly.) For this...

read more
How Do You Learn Computer Programming Quickly?

How Do You Learn Computer Programming Quickly?

If you don’t have a job as a programmer and want to learn fast, focus on active learning with lots of practice. Here is the path I recommend you take to fast-track the process: 1) Start with targeted, interactive lessons — short sessions of introductory and passive learning. 2) Passion projects — spend the bulk of your emphasis on longer sessions of challenging, passion-driven side projects.
3) Aim for things that you like to do or that will make your daily obligations easier. 4) Bring along a mentor or pay a freelancer to guide you. They will provide feedback and help you throw out lousy coding habits. Supplement with other sources to fill in the gaps. 5) Keep repeating steps 1 through 4 while applying for entry-level programming jobs.
6) Enroll in a short, targeted, software development path.

read more
Create Tables

Create Tables

We will create some brand new tables in SQL Management Studio using Excel as a template in this tutorial. The sample data is a fictitious list of Experts and their areas of specialty. Below is a quick Description of our tables and a short sampling of each. This tutorial focuses only on the creation of the tables. We will populate the tables in...

read more
Updating Table Data, Excel VS SQL

Updating Table Data, Excel VS SQL

Change is part of life and our data is extremely susceptible to these changes. Can Microsoft Excel Keep up with all of the changes to your data? Maybe it's time to use SQL to update your data. Let’s discuss updating data in an effective way. Up until now, many of the tutorials had examples where returns from using SQL over Excel were marginal....

read more
Getting Started with SQL Databases (an Excel User’s Perspective)

Getting Started with SQL Databases (an Excel User’s Perspective)

Most of my readers are heavy Excel users. Today we will transition our strong Excel foundation into learning another complementary tool, SQL Databases. Here are a few components that are fundamental to Databases and SQL. Tables - Other concepts could come first, however, a Table is a familiar starting place for an audience of Excel users. Let’s...

read more
Excel Pros should learn SQL to pull their own data.

Excel Pros should learn SQL to pull their own data.

Let's discuss why Excel Users should learn SQL to pull their own data. First, we will answer the basic question, What is SQL? SQL stands for Structured Query language. It is used to manage structured information in database tables. Structured data is formatted for meaningful data retrieved to make informed business decisions. SQL allows an...

read more
Share This