Name: A Practical Introduction to SQL
Brand: General Assembly
Rating: 5 (1 reviews)

Get More Information

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

$150
over 4 sessions

Description

What you'll learn in this sql class:

This workshop will take absolute beginners through the basics of SQL to an ability to write queries with confidence.

SQL provides powerful but reasonably simple tools and concepts for analysis and processing of data. We’ll cover the use of queries to combine data from a variety of tables, as well as for analysis and workflow tasks.

Takeaways

Session I: Basics of database setup and single table queries

Basics of setting up a database, loading data into it, and exporting results out
Basics of running simple queries
Running a variety of queries against a single table, to filter, transform, reorder, group, and analyze data
Debugging procedures

Session II: Using JOIN to combine data from two tables into a single table

Conceptual underpinnings of JOIN
Use of simple joins to combine tables
More advanced usage of joins, filtering, grouping, and transforming results of joins
Strategies for using joins to perform more complex analytic and workflow tasks

Session III: Using subqueries to bring data and analyses into a query

Use of simple subqueries in query expressions
Strategies for using simple subqueries
Use of correlated subqueries

Session IV: Using the table combination "toolbox" to perform complex analyses and tasks

Strategies for using joins and subqueries to perform complex tasks
Basics of query optimization (indexing)

Prerequisites & Preparation:

Basic technical aptitude and orientation to computers, and curiosity to learn new tools. Willingness to learn about a text-based / principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.

We will be pausing to let students run and write queries of their own, so students should bring laptops with an installed SQL implementation (MySQL, Postgres, SQL Server; Access is strongly discouraged). Instructions for installing MySQL will be distributed prior to 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)

(4.3-star rating across 2,637 reviews)

A Practical Introduction to SQL

Reviewed by Jason Stokar on 5/20/2014

After one class it seems totally worth the cost!

See reviews for other classes at General Assembly

Hide Reviews

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

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...

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