DS10 Code-Alongs

About Code-Alongs

Code-alongs are guided, interactive sessions where you'll code alongside an instructor to reinforce concepts and practice hands-on skills. These sessions help you apply what you've learned in a structured environment with real-time guidance.

For Sprint 10, we have two code-alongs that will help you master SQL queries - from basic operations to more complex multi-table queries.

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.

Ideal Code-Along Preparation Checklist:

  • Did you review the core competencies before coming to class?
  • Did you watch the guided projects before coming to class?
  • Did you take the checks for understanding before coming to class?
  • Did you finish your module projects before coming to class?

Code-Along Sessions

Code-Along 1

Basic SQL Queries

Practice creating basic SQL queries to access and analyze data in a database.

What Will You Need To Attend the Code-Along?

Starter Link Solution Link

Code-Along 2

Multi-table SQL Queries

Learn advanced SQL techniques for working with multiple tables and complex queries.

What Will You Need To Attend the Code-Along?

Starter Link Solution Link

References

Helpful Resources for SQL Queries

The "Chinook" SQLite Database Order of execution for SQL statements PostgreSQL Documentation: SQL Commands PostgreSQL Tutorial