DEV Community

Cover image for Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!
Nathan S.R.
Nathan S.R.

Posted on • Updated on

Learn SQL Quickly & Join Data Easily, With This Simple Method & Get into 11 New Professions !!!!

In this post, I am going to describe a very simple & powerful method, to join data from multiple spreadsheets, using just plain english like statements ( also called SQL ) and avoid complex vlookup & hlookup functions of spreadsheets !

This method can also be considered as an easier alternative to lookup functions of spreadsheet programs ( i.e. hlookup & vlookup functions, used to retrieve specific data from a table based on a lookup value )

Let us get started ( Video & Its Transcript, Download Link, Quick SQL Cheatsheets, Professions that commonly use SQL, Follows ) :

Step 1:

Save your spreadsheets as CSV type files

Step 2:

Download this free, wonderful, portable & easy software, just once:

Step 3:

Start / Open the sqlitebrowser program, downloaded in Step 2

Step 4:

Click the "New Database" option from its File Menu and name it as you like and then Save. Cancel the "Edit table definition" dialog box that pops up, immediately after.

Step 5:

Now, Choose the File Menu -> Import -> Table from CSV file... option and get your CSV files, imported into the database, one by one. Here, in the next step, i will be using the department & employee csv sample files, available from the download link in step 8 below. So, please import them as well.

Step 6:

Click the "Execute SQL" button on the top and copy / edit, if required / paste the following query and press the play button, over there:

e. job_role,
FROM employee e
JOIN department d ON e.department_id = d.department_id;
Enter fullscreen mode Exit fullscreen mode

This query says “show me the full name, role, and department name, where the department_id matches in both tables”.

Here, the letters e and d are called aliases and are used for two reasons : 1. To prevent the long typing of table names, each time 2. To refer to the location of column names, specifically

We can name these aliases, in any way, we like.

Step 7:

Select all the result data, copy & paste it back to a new spreadsheet. Adjust font colors, if the data is not visible.

That's all.

Step 8:

For learning & practicing more useful queries, i will give the download link below, containing quick cheatsheets & sample sqlite database ( i.e. .db file ) & also csv files, to learn the wonderful SQL language, very fast. As usual, it is only the practice, that generates confidence in us and not just the mere theoretical reading of it.

Download Link :

High Quality PDF Versions of the below Cheatsheets are also included in the download link above.



Here are some of the professions that commonly use SQL:

  1. Database Administrators (DBAs):

    Manage and maintain databases, ensuring their performance, security, and integrity.
    Use SQL to create, modify, and delete database objects, implement backups and recovery plans, and troubleshoot issues.

  2. Data Analysts:

    Gather, organize, and analyze large datasets to extract meaningful insights.
    Use SQL to query and manipulate data, create reports and visualizations, and identify trends and patterns.

  3. Data Scientists:

    Use advanced statistical and machine learning techniques to solve complex problems and make predictions.
    Rely on SQL to access and process data from various sources, often in conjunction with other programming languages like Python or R.

  4. Software Developers:

    Build applications that interact with databases, whether for web applications, desktop software, or mobile apps.
    Use SQL to write code that stores, retrieves, and updates data within the applications.

  5. Business Analysts:

    Gather and analyze data to support business decision-making and process improvement.
    Use SQL to query and manipulate data from business systems, generate reports, and identify areas for optimization.

  6. Data Engineers:

    Design, build, and maintain data pipelines and infrastructure for data storage and processing.
    Use SQL to create and manage databases, optimize queries, and ensure data quality and consistency.

  7. Business Intelligence (BI) Analysts:

    Develop and maintain BI dashboards and reports to provide insights into business performance.
    Use SQL to create queries and data visualizations that track key metrics and trends.

  8. Marketing Analysts:

    Analyze customer data to understand behavior, preferences, and campaign effectiveness.
    Use SQL to segment customers, track campaign performance, and measure ROI.

  9. Web Developers:

    Develop web applications that interact with databases to store and retrieve user data, content, and other information.
    Use SQL to create and manage databases, write queries to fetch and display data, and handle user interactions.

  10. System Administrators:

    Manage and maintain computer systems, including databases and database servers.
    Use SQL to perform tasks such as creating and managing user accounts, configuring database settings, and troubleshooting issues.

  11. Researchers:

    Conduct research that involves collecting and analyzing large amounts of data.
    Use SQL to query and manipulate data from various sources, such as scientific databases, surveys, and experiments.

Share this post / video with your Friends and Contacts, so that they can benefit from it too.

Also Press Like, Comment, Share and Subscribe to my Channel.

Thanks for viewing and have a nice day.

Top comments (0)