$120

Introduction to SQL

Event Information

Share this event

Date and Time

Location

Location

Practical Programming

115 West 30th Street

5th Floor, 501

New York, NY 10001

View Map

Event description

Description

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. The session will be highly interactive and engaging - questions are encouraged!

This workshop is for beginners. We will start with basic examples and gradually move toward more complex SQL queries. By the end of this workshop, you’ll know how to write SQL and work with databases to solve business problems and produce management reports.

Wednesday July 26th 6.00pm - 9.00pm

You will learn:

  • What databases are and why they are important

  • The different “flavors” of databases

  • Connecting to your work’s database

  • The four operations you can perform on data

  • The fundamental parts of a SQL query (eg. SELECT, FROM, WHERE)

  • Analytical queries: GROUP BY

  • Subqueries

  • Joins

Prerequisites & preparation:

  • Laptop

About the instructor

Alex Petralia specializes in data analytics, data ingestion and automated solutions. He works in business analytics at a premier algorithmic trading firm headquartered in NYC. Alex’s work has been featured in multiple newspapers such as The Boston Globe and the US News and World Report. Prior to his work in finance, Alex was a data engineer at an e-commerce startup and a financial analyst at a boutique economic consulting firm.

Share with friends

Date and Time

Location

Practical Programming

115 West 30th Street

5th Floor, 501

New York, NY 10001

View Map

Save This Event

Event Saved