With a wide range of applications and increasing demand, SQL is one of the most popular skills that recruiters are looking for. Level up your understanding of SQL, to use advanced features of SQL to retrieve meaningful data efficiently and draw insightful conclusions. This workshop is designed to increase your understanding of SQL and introduce you to advanced topics in SQL like Functions, Aggregations, Statements, GroupBy and Window Functions with 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 Advanced concepts and keywords of SQL
- To build advance understanding of various features in 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)
- SQL (resource 1)
Workshop Content
| Section | Overview | Time Estimate |
|---|---|---|
| Setup | download and setup required software. Download data files/other required set up files | 0:10 min |
| Selection Queries | Review of basic SQL queries and introduction to advanced queries and keywords | 0:15 min |
| Aggregate Function | Introduction to Aggregate Functions | 0:10 min |
| Conditional Functions | Introduction to Conditional Functions | 0:15 min |
| Window Function | Introduction to Window Functions | 0:10 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!