BiteSizedChunks.comLearn one small thing at a time.

Course contentsShow

1Defining Data Science
2The Interdisciplinary Nature of Data Science
3The Role of a Data Scientist
4Data Science vs Data Analytics vs Business Intelligence
5The Evolution of Data Science
6Common Data Science Applications
7The Data Science Skill Stack
8Misconceptions About Data Science
9The Data Science Lifecycle Overview
10Problem Definition and Scoping
11Data Collection and Acquisition
12Data Cleaning and Preparation
13Exploratory Analysis and Modeling
14Model Evaluation and Validation
15Deployment, Monitoring, and Iteration
16Structured vs Unstructured Data
17Categorical Variables: Nominal and Ordinal
18Numerical Variables: Discrete and Continuous
19Temporal Data and Time Series
20Primary Data Sources: Databases and Data Warehouses
21APIs and Web Scraping
22File Formats: CSV, JSON, and Beyond
23Data Provenance and Metadata
24Data Quality Dimensions
25The Scientific Method in Data Science
26Reproducibility vs. Replicability
27Documentation Standards for Analysis
28Random Seeds and Deterministic Computation
29Code and Environment Management
30The Reproducibility Crisis and Solutions
31Ethical Principles in Data Science
32Data Privacy and Consent
33Transparency and Explainability
34Recognizing Boundaries of Competence
35Conflicts of Interest and Independence
36Responsible Data Sourcing and Use
37Professional Responsibility and Accountability

1Defining Data Science
2The Interdisciplinary Nature of Data Science
3The Role of a Data Scientist
4Data Science vs Data Analytics vs Business Intelligence
5The Evolution of Data Science
6Common Data Science Applications
7The Data Science Skill Stack
8Misconceptions About Data Science
9The Data Science Lifecycle Overview
10Problem Definition and Scoping
11Data Collection and Acquisition
12Data Cleaning and Preparation
13Exploratory Analysis and Modeling
14Model Evaluation and Validation
15Deployment, Monitoring, and Iteration
16Structured vs Unstructured Data
17Categorical Variables: Nominal and Ordinal
18Numerical Variables: Discrete and Continuous
19Temporal Data and Time Series
20Primary Data Sources: Databases and Data Warehouses
21APIs and Web Scraping
22File Formats: CSV, JSON, and Beyond
23Data Provenance and Metadata
24Data Quality Dimensions
25The Scientific Method in Data Science
26Reproducibility vs. Replicability
27Documentation Standards for Analysis
28Random Seeds and Deterministic Computation
29Code and Environment Management
30The Reproducibility Crisis and Solutions
31Ethical Principles in Data Science
32Data Privacy and Consent
33Transparency and Explainability
34Recognizing Boundaries of Competence
35Conflicts of Interest and Independence
36Responsible Data Sourcing and Use
37Professional Responsibility and Accountability

← Data Science

Lesson 1028 of 2,145·26. Advanced SQLPro lesson

PARTITION BY with LAG and LEAD

Apply LAG and LEAD within groups using PARTITION BY to reset row access at partition boundaries.

This lesson is for subscribers

You've completed the free preview. Subscribe to unlock every lesson in every course.

See pricing Back to course