Code-Alongs
What is a Code-Along?
Code-Alongs are live experiences taught by our instructors designed to prepare you for concepts found in the sprint challenges. They're your opportunity to work on complex job-ready problems in a live and engaging environment.
These sessions are 50 minutes in length and are offered seven days a week in the morning, afternoon, and evening. Because Code-Alongs delve deeper into a core competency, you will need to come to class prepared to have the best experience.
Ideal Code-Along Preparation Checklist
- Did you review the core competencies?
- Did you watch the guided projects?
- Did you finish your module projects?
Code-Along 1: Basic SQL Queries
This code-along focuses on creating basic SQL queries to access and analyze data in a database, reinforcing concepts from Module 1. You'll work through realistic examples of SELECT statements, filtering data, and performing basic aggregations that form the foundation of database analysis.
How to Prepare
- Review SQL basics and query structure concepts from Module 1
- Watch the guided project videos
- Complete your module projects before attending
- Have access to a SQL database environment (SQLite, PostgreSQL, or similar)
Code-Along 2: Multi-Table SQL Queries
This session builds on Modules 1 and 2's content, providing hands-on practice with advanced SQL techniques for working with multiple tables and complex queries. You'll work with real database examples to understand JOINs, subqueries, and analytical functions that are essential for data analysis workflows.
How to Prepare
- Review JOIN operations and multi-table concepts from Module 1
- Review SQL for analysis concepts from Module 2
- Watch the guided project videos
- Complete your module projects before attending
- Have familiarity with relational database concepts and table relationships
Prepare for Success
The best Code-Along experiences happen when you are ready before coming to class. Your instructors created a starting point and a solution for each of your Code-Alongs to ensure you have what you need to succeed.
Make sure to review the relevant module materials before attending the code-along. This will help you get the most out of the session and be better prepared to tackle the challenges.