Data Analysis From Excel to SQL
Ability to move data from a spreadsheet to a SQL database, analyze it with SQL queries, and output results back to spreadsheet
Students can begin using SQL without entirely abandoning a trusted spreadsheet workflow
Write basic SQL queries replicating filtering, aggregation and summary functions performed by spreadsheet tools like autofilters and pivot tables
Gain enough SQL foundation to begin analysis beyond spreadsheets' abilities
ABOUT THIS CLASS
Are you using Excel for data analysis? Spreadsheets provide quick and intuitive tools for data analysis, but users can begin to find them cumbersone and unwieldy. SQL and databases can simplify repetitive tasks and enable much more involved analysis, but users may worry they must first master a complex database language to do anything.
We will introduce students to the use of SQL queries for data analysis, keeping the focus on analysis by using a graphic SQL program (MySQL workbench). We will learn enough query syntax to perform basic analysis and get students started on problems too unwieldy for spreadsheets.
PREREQS & PREPARATION
Familiarity with spreadsheet analysis tools, or interest in databases or SQL
Installation of MySQL Community Server and MySQL Workbench, and a sample database
ABOUT THE INSTRUCTOR(S)
Gordon Agress is self-taught on LAMP stack (mostly Python, but some PHP). He has worked in the President's Budget Office and on Wall Street, and has an MBA from the University of Chicago.
Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.
Learn More: Data Analysis From Excel to SQL