You are here

Introduction to SQL (2 Sessions)

Overview

Where

Practical Programming
49W 33rd Street, 3rd Fl.
New York, NY
United States

When

Tuesday, November 7, 2017 - 7:15pm to Tuesday, November 14, 2017 - 8:45pm

Details

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, youll know how to write SQL and work with databases to solve business problems and produce management reports.

This workshop meets two times:
Nov 7th - 7.15pm - Start day
Nov 14th - 7.15pm
Price for two sessions is $75
Follow the link to register: https://www.eventbrite.com/e/introduction-to-sql-2-sessions-tickets-39010825429

You will learn:
What databases are and why they are important
The different flavors of databases
Connecting to your works 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. Alexs 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.