SQL for NFL Data Analysis

سرفصل های دوره

Use SQL to answer your NFL play questions

1. Introduction to SQL and NFL Data

1. Introduction

2.1 Microsoft SQL Server Express.html

2.2 Microsoft SQL Server Management Studio.html

2. SQL Server Installation

3.1 NFL DB.zip

3. NFL Database Installation

4. Understanding the NFL Data Schema

2. Basic SQL for Data Retrieval

1. SELECT statements for retrieving data

2. Filtering and Ordering data with the WHERE and ORDER BY Commands

3. Additional Example Queries

4. Writing Queries.html

3. Aggregating NFL Data

1. Grouping results with GROUP BY

2. Using aggregate functions (SUM, AVG, MAX, MIN) for statistics

3. Writing Grouping Queries.html

4. Filtering aggregated data with HAVING

Files.zip

4. Joins and Relationships and building new datasets

1. Using JOIN operations to combine data from multiple tables

2. Creating Tables - Temp Tables and SELECT INTO

3. Sub Queries to Pull in Additional Information

4. Common table expressions (CTEs) for complex queries

Files.zip

5. Advanced SQL Techniques

1. Window functions for ranking and partitioning data

2. Handling missing or incomplete data

6. Creating Your Own Projection for a New Season

1. Pulling play data from the previous season

2. Pulling Player Data from the previous season

3. Dealing with Rookies in Projections

4. Combining our Projection Datasets

5. Adjusting our projections for the season and saving projections

Files.zip

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy