SQL | R | Python | Access

SQL

Topic Title Output
Advanced Queries Aggregated Join [txt]
Advanced Queries Basic Join [txt]
Advanced Queries Detailed Join [txt]
Advanced Queries Filtered Join [txt]
Advanced Queries Multi-table Join [txt]
Advanced Queries Nesting Queries [txt]
Aggregation COUNT [txt]
Aggregation SUM [txt]
Basic Queries DISTINCT [txt]
Basic Queries GROUP BY [txt]
Basic Queries ORDER BY [txt]
Basic Queries SELECT [txt] [txt]
Basic Queries Simple WHERE [txt]
Basic Queries WHERE [txt] [txt] [txt]
Database Control Adding Records [txt]
Database Control Creating Tables [txt]
Database Control Importing Data [txt] [txt] [txt]
Database Control Missing Data [txt]
Database Control Updating Records [txt]
Database Structure Redundancy [txt] [txt] [txt]
Database Structure Split Cells [txt] [txt]
dplyr Databases Copy to Database [txt]
dplyr Link to Databases [txt]
QAQC Data entry validation in Excel
Tidy Data Clean Up Untidy Data
Tidy Data Improving Messy Data

[back to top]

R

Topic Title Output
Basic Data Management Review [txt] [txt]
Basic Vector Review [txt]
Capstone Cocili Data Exploration [png] [png]
Capstone Length of Floods [txt]
Combining Basics Shrub Volume Carbon [txt]
Data Analysis Code Shuffle [jpeg]
Data Frames Database CSV [txt]
Data Frames Shrub Volume Data Frame [txt]
Debugging Debug the Code [txt]
dplyr Collect from Databases [txt]
dplyr Databases Copy to Database [txt] [txt]
dplyr Databases Link and Query
dplyr Databases Manipulate Query [txt]
dplyr Databases NEON Mammals [jpeg] [txt] [jpeg] [jpeg]
dplyr Databases Source and Query [txt]
dplyr Fix the Code [txt]
dplyr Link to Databases [txt] [txt]
dplyr Agregando volúmenes de arbustos
dplyr Shrub Volume Aggregation [txt]
dplyr Shrub Volume Data Basics [txt]
dplyr Shrub Volume Join [txt]
Expressions & Variables Basic Expressions
Expressions & Variables Basic Expressions [txt]
Expressions & Variables Basic Variables
Expressions & Variables Basic Variables [txt]
Expressions & Variables Modify the Code
Expressions & Variables Modify the Code [txt]
Expressions & Variables More Variables
Expressions & Variables More Variables [txt]
Expressions & Variables Variable Names
Expressions & Variables Variable Names
Expressions & Variables Variable Reassignment
Expressions & Variables Variable Reassignment [txt]
Functions Built-in Functions [txt]
Functions Combining Functions [txt]
Functions Default Arguments [txt]
Functions for Loop [txt] [txt]
Functions Portal Species Time-Series [png] [png]
Functions String Data [txt]
Functions Use and Modify [txt]
Functions Writing Functions 2 [txt]
Functions Writing Functions [txt]
Functions Writing Tidyverse Functions [txt] [png] [png]
Good Style Format the Code [jpeg]
Graphing Acacia and Ants [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Acacia and Ants Data Manipulation [txt] [jpeg] [jpeg] [txt] [jpeg]
Graphing Acacia and Ants Histograms [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Adult vs Newborn Size [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Graphing Data From Multiple Tables [jpeg]
Graphing Mammal Body Size Distribution [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Mass vs Metabolism [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Sexual Dimorphism Data Manipulation [jpeg] [jpeg] [jpeg] [jpeg]
Graphing Sexual Dimorphism Exploration [jpeg] [jpeg] [jpeg] [jpeg] [jpeg]
Higher Order Functions Species Area Relationship [txt]
Knitr Reproducible Breeding Bird Survey Analysis [html]
Loops Basic For Loops [txt]
Loops Basic Index [txt]
Loops Basic Vector [txt]
Loops Crown Volume Calculation [txt] [txt] [txt]
Loops Improve Your Code [txt]
Loops Multi-file Analysis [png] [png] [png] [png] [png] [png] [png] [png] [png] [png] [txt]
Loops Multiple Files [txt]
Loops Size Estimates By Name Apply [txt] [png]
Loops Size Estimates By Name Loop [txt]
Loops Size Estimates Vectorized [txt]
Loops Size Estimates With Maximum [txt]
Loops Species Name Capitalization with Apply [txt]
Loops stringr [txt]
Loops Tree Growth [txt] [png] [png] [png]
Loops Use and Modify with Apply [txt] [txt]
Loops Use and Modify with Loops [txt] [txt] [txt]
Loops Vectorized Genus Extraction [txt]
Making Choices Basic If Statements [txt]
Making Choices Choice Operators [txt]
Making Choices Choices with Functions [txt]
Making Choices Complete the Code [txt]
Making Choices DNA or RNA [txt]
Making Choices DNA or RNA Iteration [txt]
Making Choices If Statements In Functions [txt]
Making Choices Load or Download File [txt]
Making Choices Simple If Statement [txt]
Making Choices Size Estimates by Name [txt]
Making Choices Unit Conversion Challenge [txt]
Modules dplyr
NEON Canopy Height from Space [png] [png] [png] [png] [txt] [png] [png] [png] [png]
NEON Cropping NEON Data [txt] [png] [png]
NEON Harvard Forest Soils Analysis [png] [png] [txt] [txt] [png] [png]
NEON NEON Database [jpeg] [jpeg] [jpeg]
NEON NEON Raster [jpeg]
NEON Phenology from Space [png] [txt]
dplyr Portal Data Aggregation [txt]
dplyr Portal Data Challenge [txt]
dplyr Portal Data dplyr Review [txt]
dplyr Portal Data Joins [txt]
dplyr Portal Data Manipulation [txt]
dplyr Portal Data Manipulation Pipes [txt]
dplyr Portal Data Review [txt] [png] [png] [png]
Putting It All Together Size-biased Extinction [txt] [txt] [png]
R-SQL Automate Query [txt]
R-SQL Connect and Query [txt]
R-SQL Data Stream [txt]
R-SQL Export to Database [txt]
Regular Expressions Find the Rodents [txt]
Loops Climate Space Iteration [png] [png] [png] [png] [png] [png] [png]
Reproduction Climate Space Rewrite [png] [png] [png]
Reproduction Climate Space [png] [png] [png] [png] [png] [png] [png] [png] [png] [png] [png] [png] [png]
Reproduction Dinosaur Size Distribution [png]
Reproduction Megafaunal Extinction [txt] [png] [png] [png]
Scientific Mammal Body Size [txt]
Scientific Mammal Body Size by Continent [txt]
Scientific Tree Biomass Challenge [txt] [jpg]
Spatial Data Species Occurrences Elevation Histogram [png] [png] [png]
Spatial Data Species Occurrences Map [txt] [png]
SQL Practice Basic Queries Review [txt] [txt] [txt]
Statistics Adult vs Newborn Size Regression [txt] [jpeg] [jpeg]
Statistics Mammal Body Size T-test [txt]
Statistics Shrub Volume ANOVA [txt]
Strings Function with Choices [txt]
Strings Long Strings [txt]
Strings Print Strings [txt]
Strings Split Strings [txt]
Strings stringr Functions [txt]
Strings Strings and Math [txt]
Strings Strings from Data [txt]
Tests Test the Code [txt]
Tidyr Tree Biomass [txt]
Vectors Basic Vectors
Vectors Basic Vectors [txt]
Vectors Bird Banding
Vectors Bird Banding [txt]
Vectors Bird Banding Multiple Vectors
Vectors Bird Banding Multiple Vectors [txt]
Vectors Nulls in Vectors
Vectors Nulls in Vectors [txt]
Vectors Shrub Volume Vectors
Vectors Shrub Volume Vectors [txt]
Version Control Add and Revert Comment
Version Control Basic Adding a Remote
Version Control Basic Commit Multiple Files
Version Control Basic Create Project Repository
Version Control Basic First Solo Commit
Version Control Basic Project Proposal
Version Control Basic Pulling and Pushing
Version Control Basic Pushing Changes
Version Control Basic Second Solo Commit
Version Control Basic Set Up Git
Version Control Fix and Commit
Version Control Git Setup
Version Control Merge Conflict
Version Control Pull and Move
Version Control Revert
dplyr Building data frames from vectors [txt]
dplyr Extracting vectors from data frames [txt]

[back to top]

Python

Python exercises were used in previous iterations of the course at Utah State University, but are no longer under active development.

Topic Title Output
Basic Data Management Review
Basic List Review
Combining Basics Shrub Volume [txt]
Data Analysis Code Shuffle
Debugging Fix the Code 1
Dictionaries Species Composition 2
Expressions & Variables Basic Expressions [txt]
Expressions & Variables Basic Variables [txt]
Expressions & Variables Modify the Code 1 [txt]
Expressions & Variables More Variables [txt]
Expressions & Variables Variable Reassignment
For Loops Exponential Growth 1
For Loops Repeat Strings
For Loops While
Functions Built-in Functions [txt]
Functions for Loop
Functions GC Content 2 [txt]
Functions Nested Functions
Functions Use and Modify [txt]
Functions Writing Functions [txt]
Graphing Adult vs Newborn Size 1 [png] [png] [png]
Graphing Mammal Body Size 3 [png]
Graphing Mass vs Metabolism [png] [png]
Higher Order Functions DNA
Higher Order Functions Species Area Relationship 1
Inheritance Platypus 4
Libraries Species Area Relationship 2
List Comprehensions Platypus 5
Lists Bird Banding 1 [txt]
Lists Bird Banding 2
Lists Bird Banding 3
Lists DNA Complement 1
Lists DNA or RNA 2
Lists Loop
Lists Nested Lists 1
Lists Nested Lists 2
Lists Ultimate Question 2
Loops Improve Your Code [txt]
Loops Shrub Dimensions 1 [txt]
Loops Shrub Dimensions 2
Loops Shrub Dimensions 3
Making Choices Choice Operators [txt]
Making Choices DNA or RNA 1 [txt]
Making Choices GC Content 3
Making Choices Modify the Code 2 [txt]
Making Choices Unit Conversion Challenge
Modules math Functions [txt]
Object Oriented Programming Platypus 1
Object Oriented Programming Platypus 2
Object Oriented Programming Platypus 3
Problem Decomposition Exponential Growth 2
Regular Expressions List the Rodents 1
Regular Expressions List the Rodents 2
Scientific DNA Complement 2
Scientific Mammal Body Size 1 [txt]
Scientific Mammal Body Size 2 [txt]
Scientific Shrub Volume 2 [txt]
Scientific Size-biased Extinction 1
Scientific Size-biased Extinction 2
Scientific Tree Biomass
Sets Species Composition 1
Shell Bird Counts 1
Shell Bird Counts 2
Shell Executable Programs
Shell Finding Things
Shell Getting Started
Shell Pipes and Filters
Shell Server
Statistics Adult vs Newborn Size 2 [txt] [png]
Statistics Mammal Body Size 4 [txt]
Statistics Shrub Volume 3 [txt]
Strings GC Content 1 [txt]
Strings Long Strings [txt]
Strings Print Strings [txt]
Strings Split Strings [txt]
Strings string Functions [txt]
Strings string Methods [txt]
Strings Strings and Math
Strings Ultimate Question 1
Tests Fix the Code 2
Tests Refactor
Version Control Add and Revert Comment
Version Control Fix the Code
Version Control Merge Conflict
Version Control Predict Richness
Version Control Pull and Move
Version Control Revert
Version Control Richness Merge Conflict
Version Control Richness Revert
Version Control Set Up Git

[back to top]

Access

Access exercises were used in previous iterations of the course at Utah State University, but are no longer under active development.

Topic Title Output
Advanced Queries Joins 1
Advanced Queries Joins 2
Advanced Queries Joins 3
Advanced Queries Joins 4
Advanced Queries Nested Queries
Aggregation Count
Aggregation Sum
Basic Queries Filtering
Basic Queries Grouping 1
Basic Queries Grouping 2
Basic Queries Selecting
Basic Queries Sorting
Database Control Creating Tables
Database Control Importing Tables
Database Structure Redundancy
Database Structure Split Cells
Database Tools Forms 1
Database Tools Forms 2
Database Tools Forms 3
Database Tools Reports

[back to top]