This lesson is in the early stages of development (Alpha version)

Introduction to SQL


Drastic increase in data in the real world led to building an organized way of data called relational databases. To draw insights from these databases, one should be able to retrieve this huge data efficiently and this can be done using SQL language. This workshop is designed to introduce you to the concept of SQL and how it is useful in database management. It includes basics of SQL, explanation of data retrieval and manipulation using SQL queries along with concepts of Operators and Joins using hands-on examples.

We will be using W3School’s SQL editor for implementing the SQL queries on predefined databases present in the editor. W3Shcool’s SQL editor is a open source online editor and is available for everyone for free of cost.

Workshop goals


Pre-requisites

STOP: before starting this workshop, please attend the following Digital Scholarship Lab workshop(s) before completing this one:

OR make sure you’re comfortable with the following concepts (study suggestions in parentheses)

Workshop Content

Section Overview Time Estimate
Setup download and setup required software. Download data files/other required set up files 0:10 min
Introduction to SQL Introduction To SQL 0:5 min
Basic Queries Build understanding on important keywords of SQL 0:20 min
Operators Understanding the concepts of Operators using SQL 0:20 min
Joins Understanding the concepts of JOINS and data manipulation using Joins in SQL 0:20 min

Survey

Thank you for attending this workshop or reading through the workshop material! If you could take 3-5 min to respond to our survey, we can continue to improve this workshop. We appreciate any and all feedback!

Next Up…

Check out these workshops after you’ve completed this one:

  1. SQL Advanced