Price:
$200 8 seats
Start Date:

Sat, Oct 13, 10:00am - 4:00pm

Next start dates (2)

Location:
Downtown, Washington, D.C.
1133 15th St NW 8th Fl
Btwn L & M Streets NW
Washington, District of Columbia 20005
(Map)
Share:
Important:
A computer will not be provided.
Class Level: All levels
Age Requirements: 18 and older
Average Class Size: 20
Teacher: Matt Brems

What you'll learn in this sql class:

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence.

Note:
45 minutes to an hour will be allocated for lunch at 12:30pm. You have the option to pack a lunch, help yourself to our peanut butter and jelly station, or find something in the vicinity.

Takeaways
  • Background on SQL
  • Basic SELECT-FROM-WHERE statements
  • LIMIT clauses
  • Math operations and constant expressions in SELECT statements
  • Booleans and complex conditions in the WHERE clause
  • Pattern matching in the WHERE clause
  • NULL values
  • JOIN operations
  • Grouping and aggregations
  • HAVING clauses
  • ORDER BY clauses
  • Subqueries
Prereqs & Preparation
A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.

Prior to class:
  • Watch the Introduction to SQL video. Please reach out to Coursehorse for the link.
  • Download Sqlectron.
    - Students using Windows should download the Sqlectron-Setup-1.15.0.exe file.
    - Students using a Mac should downloads the Sqlectron-1.15.0.dmg file. 
    -- Mac users may need to allow installation of non-app-store programs in their System Preferences
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.

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 (3)
Start Date Time Teacher # Sessions Price
10:00am - 4:00pm Matt Brems 1 $200
10:00am - 4:00pm Josh Yazman 1 $200
10:00am - 4:00pm Josh Yazman 1 $200

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 2000 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers

Get quick answers from CourseHorse and past students.

Reviews of Classes at General Assembly

(1651 Reviews)
loading...

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

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