Discover Classes. Earn Rewards.

Data Analysis: Moving from Excel to SQL

  • All levels
  • 18 and older
  • $45
  • 3858 Walnut St, Denver, CO
  • 2 hours

Get More Information

Fill out this form and the course provider will contact you with more information about this course.

  • $45
  • GA Denver @ Industry RiNo Station @ 3858 Walnut St, Denver, CO 80205
  • 2 hours
  • A computer will not be provided.

By submitting this form, I consent to CourseHorse providing the information in this form with the course provider which may contact me via email, phone or text.

Class Description

Description

What you'll learn in this data analyst training:

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


Preparation

  • Familiarity with spreadsheet analysis tools, or interest in databases and SQL
  • Installation of MySQL Community Server and MySQL WorkBench, and a sample database (installation assistance will be provided during the class)


School Notes:
For students enrolling in 12 week part time and immersive classes, it is not recommended that you book more than one class simultaneously.

Refund Policy

If you can't make it to a class/workshop, please email us at [email protected] at least 7 days before the scheduled event date. No refunds will be given after this timeframe.


In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at General Assembly (2,637)

Similar Classes

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

General Assembly

At General Assembly you get the tech skills, career advice and networking opportunities needed to be job ready for a career in coding or data or ux design, in as little as three months, with little or no previous experience.

Since 2011 General Assembly has graduated more than 40,000 students...

Read more about General Assembly

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Denver educator.

General Assembly

General Assembly

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...