| layout | root | permalink | boxId |
|---|---|---|---|
lesson |
. |
index.html |
kweltidiq4bv1m9ow12prsuo9x2espsd |
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.
{% comment %} briefly list workshop goals below - should be the same as the objectives from each workshop section (also repeated in the workshop overview) {% endcomment %}
- 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: > * [Introduction to SQL](https://uic-library.github.io/SQL-Intro/) > > __OR__ make sure you're comfortable with the following concepts (study suggestions in parentheses) > > * SQL ([resource 1]()) > {: .prereq}
| 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|
{% comment %}
{% include box_player.html id=page.boxId %} {% endcomment %}
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!