Discover Classes. Earn Rewards.

Data Analysis: Moving from Excel to SQL

at General Assembly - Near North Side

(2205)
Course Details
Price:
$40 8 seats
Start Date:

Thu, Oct 10, 6:00pm - 8:00pm

Next start dates (1)

Location:
Near North Side, Downtown/Loop
444 N Wabash Ave 5th Fl
Btwn E Illinois & E Hubbard Streets
Illinois City, Illinois 60611
(Map)
Share:
Important:
A computer will not be provided.
Purchase Options
No Booking Fees Book Now Save to WishList

7 people saved this class

Give as a Gift
Description
Class Level: Intermediate
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Bianca Mounce

What you'll learn in this sql server 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 PGAdmin (one of the world's most popular database design tools).

Takeaways
  • Install PGAdmin 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 PGA Admin
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.

Still have questions? Ask the community.

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.

Map

Google Map

General Assembly

All classes at this location

Start Dates (2)
Start Date Time Teacher # Sessions Price
6:00pm - 8:00pm Bianca Mounce 1 $40
6:00pm - 8:00pm Bianca Mounce 1 $40

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 400 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Reviews of Classes at General Assembly (2,190)

Similar Classes

School: General Assembly

General Assembly

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.

What began as a co-working space in...

Read more about General Assembly

CourseHorse Approved

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

Ready to take this class?
BOOK NOW
Taking this class for work? Get exclusive perks & discounts for free.
Loading...