Data Analysis: Moving From Excel to SQL

Carousel glenn carstens peters 203007
ABOUT THIS EVENT
Event Category

Business & Technology

Event Overview

About This Class


Are you using Excel for analysis? Spreadsheets are useful for analyzing and visualizing data, but become cumbersome and unwieldy with large datasets.


Relational databases address many of Excel's limitations by simplify repetitive tasks and enabling analysis over much larger datasets. The only catch is that you need to know SQL to fully harness the power of these technologies.


This class will introduce students to the world of databases and analysis in SQL. Students will be shown how to setup a SQL environment on their laptops, so that they can practice writing queries on a real dataset. After this class, students will understand the fundamentals of SQL syntax, and be able to write queries using MySQL Workbench (one of the world's most popular database design tools).


Takeaways



  • Install MySQL Server and Workbench enabling students to write SQL queries directly from their laptops

  • Learn introductory database concepts and data structures

  • Understand the fundamentals of SQL, including how to filter, aggregate and summarize large datasets

  • Gain enough SQL foundation to begin analysis beyond simple spreadsheets


Prereqs & Preparation



By signing up for this class, you agree to General Assembly's Privacy Policy and Terms of Service. If for any reason you need to cancel or change your registration please contact Dabble directly at hello@dabble.co


About the Instructor



Alex Castrounis Photo

Alex CastrounisFounder and President,
InnoArchiTech


Alex Castrounis is a product and data science leader, technologist, mentor, educator, speaker, and writer. He has held leadership roles in data science, software (architecture and engineering), and product (vision, strategy, design, and management).


Alex spent ten years as a race strategist, data scientist, vehicle dynamicist, and software engineer for IndyCar racing teams. He was a race strategist for over 100 races, including six Indianapolis 500s.


Alex also founded InnoArchiTech, and writes for the InnoArchiTech blog at www.innoarchitech.com. Topics covered are related to Alex's interests and expertise, which are data science, artificial intelligence, machine learning, big data, IoT, product, and scalable software.


Minimum age

All ages welcome

Cancellation Policy
Location

There are currently no upcoming dates scheduled for this Dabble. Log in to an account message the host or add to your bucket list to be automatically notified when new dates are posted.

No upcoming dates. Add to your bucket list to be notified or message host.

BRING IT BACK

MORE ABOUT YOUR HOST

General Assembly is a pioneer in education and career transformation, specializing in today’s most in-demand skills. The leading source for training, staffing, and career transitions, we foster a flourishing community of professionals pursuing careers they love.

More Events From General Assembly Chicago

SIMILAR EXPERIENCES

BROWSE ALL EVENTS