SQL Bootcamp

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

SQL provides powerful but reasonably simple tools for data analysis and handling. This Bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence — and start using the tool immediately.

We strongly recommend that participants sign up at least 48 hours before the Bootcamp start time to ensure sufficient time for pre-work and set-up.

Takeaways

• Understand SQL vocabulary such as tables, schema, functions and JOINS.
• Understand the differences between different data management systems for SQL databases.
• Create basic SQL queries by applying Boolean logic, sorting functions, and commenting.
• Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT].
• Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data.

Preparation

• This Bootcamp is for beginners.
• This course will occur completely online using Zoom and Slack
• You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection
• Pre-work and course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches
• Students will be asked to register to Mode Analytics before your course begins (directions to do so will be emailed to all students)
• Each individual course participant must have purchased a ticket