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
- To get familiarize with the concepts and keywords of SQL
- To build a basic understanding of various features in SQL
- To execute Database manipulation queries using SQL
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)
- Relational Databases (resource 1)
- Entity-Relationship Models (resource 2)
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: