Data Analysis: Moving From Excel to SQL
15

Wednesday, 15 November

7 9 pm HKT

GA Hong Kong, Garage 8F

8F, 33 Des Voeux Road Central
Hong Kong
$325 HKD
Regular Ticket
$325 HKD
Total

Questions? Read our FAQs

Data Analysis: Moving From Excel to SQL

Max Della Libera Photo


Senior Analytics Manager

15

Wednesday, 15 November

7 9 pm HKT

GA Hong Kong, Garage 8F

8F, 33 Des Voeux Road Central
Hong Kong
$325 HKD
Regular Ticket
$325 HKD
Total

Questions? Read our FAQs

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

About the Instructor

Max Della Libera Photo

Senior Analytics Manager

Max started his journey in data by building a private CrunchBase-like database for the leading VC firm in Denmark. He is passionate about bringing solutions and insights out of the data by merging his technical knowledge and business understanding. After having deployed the Business Intelligence platform across Asia for a major player in Telco, he is now leading the BI initiative for one of the fastest growing fintech start-up in Asia.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.