Intermediate SQL Workshop

Smith Master Student Association & MPO

MPO and the Smith Master Student Association (SMSA) have partnered to offer an Intermediate SQL Workshop.

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<ul><li>Learn fundamental of SQL – Structured Query Language </li><li>Learn to create your first database and populate tables</li><li>Retrieve complex data using – SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY </li><li>Learn the magic of aggregate functions</li><li>Learn about Joins and Sub Queries</li></ul>Prerequisite &amp; Preparation<ul><li>This class requires a computer and a strong internet connection.</li><li>Windows users will need Microsoft Windows 8/10. MAC users will need Mac OS 10+</li><li>We will go through the installation guide in the workshop.</li><li>Please install MYSQL Server and Workbench before the start of the workshop.</li><li>Link : https://dev.mysql.com/downloads/ </li></ul>Course Content <ul><li>SELECT Statements</li><li>WHERE vs HAVING</li><li>GROUP BY</li><li>Order BY </li><li>Joins and Subqueries</li><li>Window functions for Advance queries</li><li>Aggregate functions </li></ul>This workshop is subject to cancellation due to low registration.The workshop recording will be emailed within a week.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Intermediate SQL Workshop

More events from Smith Master Student Association & MPO

Follow organizers to get events picked for you

Intermediate SQL Workshop

More events from Smith Master Student Association & MPO

Follow organizers to get events picked for you

You might also like...

Sign-In for personalized recommendations