Intermediate Structured Query Language (SQL) Workshop

The MPO and the Smith Master Student Association (SMSA) have partnered to offer an Intermediate SQL Workshop led by Ravi Pandey. This workshop is only open to current Smith School students, and seats are limited.

Do you have a basic knowledge of SQL and want to deep dive with complicated SQL queries. This Intermediate SQL workshop is for you!

In this three-hour workshop, you will learn various techniques to get insights from your data using SQL. You will gain all the necessary skills to start writing SQL queries to excel in your classes and career.  

Takeaways

• Learn fundamental of SQL – Structured Query Language 

• Learn to create your first database and populate tables

• Retrieve complex data using – SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY 

• Learn the magic of aggregate functions

• Learn about Joins and Sub Queries

Prerequisite & Preparation

• This class requires a computer and a strong internet connection.

• Windows user will need Microsoft Windows 8/10. MAC users will need Mac OS 10+

• We will go through the installation guide in the workshop.

• Please install MYSQL Server and Workbench before the start of the workshop.

• Link : https://dev.mysql.com/downloads/ 

Course Content

• SELECT Statements

• WHERE vs HAVING

• GROUP BY

• Order BY 

• Joins and Subqueries

• Window functions for Advance queries

• Aggregate functions

Register Here!

Please Note:

• Registration for this workshop will close at 3pm on February 11th. The Zoom link will be emailed to registrants shortly after.
• This workshop is subject to cancellation due to low registration.
• The recording of this workshop will be emailed to registrants within one week.