MPO and the Smith Master Student Association (SMSA) have partnered to offer an Intermediate SQL Workshop with instructor 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 users 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
This workshop is subject to cancellation due to low registration.
The workshop recording will be emailed within a week.
