Most popular reads

2-Day Intermediate SQL & Database Management Bootcamp ($300)

Organized By
General Assembly
Sat
Dec 15
12:00 PM - 05:00 PM
Coding/Programming
Data Science
Networking
Description

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.

Schedule

DAY 1: Saturday, December 15 @ 10 am – 5 pm CST

DAY 2: Sunday, December 16 @ 10 am – 5 pm CST

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

Location of Event

444 N Wabash Avenue, 5th Floor
Chicago, IL, 60611
444 N Wabash Avenue, 5th Floor
Chicago, IL, 60611

Chicago startup guides

LOCAL GUIDE
Best Companies to Work for in Chicago
LOCAL GUIDE
Best Software Engineer Jobs in Chicago
LOCAL GUIDE
Coolest Offices in Chicago Tech
LOCAL GUIDE
Best Sales Jobs in Chicago
LOCAL GUIDE
Best Perks at Chicago Tech Companies
LOCAL GUIDE
Your Guide to Healthtech in Chicago
LOCAL GUIDE
Best Data Science & Data Analyst Jobs in Chicago
LOCAL GUIDE
Best Marketing Jobs in Chicago