Discover Classes. Earn 10% Rewards.

2-Day Intermediate SQL & Database Management Bootcamp

  • All levels
  • 18 and older
  • $300
  • Earn 10% Rewards
  • Price Lock
  • 444 N Wabash Ave, Chicago, IL
  • 14 hours over 2 sessions

Get More Information

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

  • $300
  • 14 hours over 2 sessions
  • 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 sql class:

This workshop will enable analysts to advance their SQL skills to retrieve and manipulate data from multiple sources with precision, integrate SQL queries with reporting tools to create automated reports and visualizations, and database management principles/best practices.

Takeaways
Database architecture and creation
Database management functions CREATE, INSERT, UPDATE, DROP, DELETE
NULL values and working with bad data
Complex JOINs with multiple tables and conditional JOINs
Common Table Expressions (CTE) and subqueries
Aggregation and GROUP BY combined with HAVING
Stored procedures and reporting tool integrations
Preparation
Understanding of SQL fundamentals including the use of the following command line functions
SELECT queries that include FROM, WHERE, ORDER BY, LIMIT
Basic understanding of table JOINs and UNIONs
Familiarity with using GROUP BY and HAVING in SELECT queries
General understanding of accessing remote/cloud databases and stored data formats
Laptop, Mac or Windows, with a minimum of 8G (16G preferred) available memory and 200 MB available to download applications
Preload pgAdmin
Instructor will walk you through how to download PostgreSQL
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)

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

Read more about General Assembly

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago 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.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

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