Discover Classes. Earn Rewards.
Data Analysis: Moving from Excel to SQL is unfortunately unavailable

Thankfully we have 3 other SQL Server Classes for you to choose from. Check our top choices below or see all classes for more options.

Data Analysis: Moving from Excel to SQL

at General Assembly - The Loop

(2501)
Course Details
Price:
$60
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
The Loop, Downtown/Loop
150 N Wacker Ste # 2600
At W Randolph St
Chicago, Illinois 60606
(Map)
Share:
Important:
A computer will not be provided.
Purchase Options
Save to WishList

9 people saved this class

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

Flexible Reschedule Policy: This provider has flexible, free rescheduling for any-in person workshop. Please see the cancellation policy for more details

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 (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

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 600 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,486)

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.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

3 Top Choices

Microsoft SQL Server 2012/14/16 Reporting Services

This class is temporarily being offered remotely.

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course introduces the SSRS architecture, the report manager, the basics of databases and database queries, and the report builder role. In this course you will learn to:  Plan for, install, configure and customize SQL Server 2012 Reporting Services Retrieve data with SELECT queries Generate reports from the Report Wizard and from scratch...

Monday Apr 27th, 9am - 4pm

  (5 sessions)
$2,925

5 sessions

Querying Microsoft SQL Server 2012/14/16

This class is temporarily being offered remotely.

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are seeking to prove their skills and knowledge in writing queries.  Certification exams are administered by third party testing companies such as Pearson Vue or Prometric. Our courses prepare you for the certification exam, which...

Monday May 11th, 9am - 4pm

  (5 sessions)
$2,925

5 sessions

MySQL Workbench: Data Modeling & Development

This class is temporarily being offered remotely.

at Certstaffix Training - Near North Side 500 N Michigan Ave Ste 600, Chicago, Illinois 60611

This course explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to...

Monday May 18th, 9am - 4pm

  (4 sessions)
$2,280

4 sessions

Loading...