SQL for NFL Data Analysis

Explore sql server management studio to run queries and view results, with hands-on practice writing select statements, using top, and exploring game and play tables.

Learn to filter NFL data with where, like, and, or, and in, then order results by week and season year using order by, across game, fantasy data, and play tables.

Explore additional sql queries on nfl fantasy data, filtering by defense and season, counting players above a drafting point threshold, and ranking DK Metcalf's games against the 40 niners.

Group by enables you to summarize fantasy data by player, season, and team, including playoffs, using sum, averages, variances, and counts with regular season filters.

Explore using aggregate functions to analyze NFL data by name, season, and team, computing sum, count, min, max, average, standard deviation, and variance while handling zeros and data type conversion.

Use the having clause after group by to filter aggregated data, such as average DraftKings points above 20, and rank running backs by yards per carry with 50+ attempts.

Explore how to join nfl data across players, teams, games, and drives using inner, left, right, full outer, and cross joins on common fields and table aliases to avoid ambiguity.

Create temp tables with select into, using the pound sign to store 100 combinations. Rename fields for uniqueness, then use insert into to add data and drop tables when done.

Use subqueries to pull in fantasy points PPR projection from season projections and temp tables, aligning running back and wide receiver data to compare top combos for 2023.

Discover how to simplify complex queries with common table expressions (ctes) to build projection data from top combos, compare projection and actual points, and order results by their differences.

Apply the rank function over partition by position to rank players by the sum of fantasy points, grouping by name, position, and team, and filter with having to remove zeros.

Use the coalesce function to replace null draft rounds with 99 for undrafted players, enabling correct ordering and data joins for NFL player data without altering the underlying table.

Compute each team's pass versus run play percentages from the previous season by joining play with game data, then save results to a regular season team stats table.

Pull 2023 NFL player data from the fantasy data table to compute passing, rushing, and receiving totals, touchdowns, fantasy points, games played, and team history by player.

Compute rookie projections by draft round using average fantasy points from fantasy data, joined with player data to capture draft round, rookie year, and regular-season filters.

Combine four data tables to build a unified NFL player dataset, computing age and average fantasy points per game while including rookies through left joins and coalesce for undrafted rounds.

Adjust NFL season projections by importing a CSV into the NFL data analysis database, linking player IDs, and saving the updated projections with proper data type handling.