General Programing Resources
SQL
Course Notes
- Introduction to Databases
- Basic Queries
- Aggregation
- Joins
- Tidy Data
- Data Entry in Excel
- Nested Queries
Extra Notes
- Database Control - SQLite Manager
- Database Control - Queries
- Database Structure
- Database Resources
- Exporting from OpenOffice
- SQL for Access Users
Database Structure Image Files
- Basic Structure
- Cross-tabulated Table
- Crosstab Restructured
- Multiple Values
- No Duplicate Rows
- No Redundant Information
- One Column per Type
- One Value per Cell
- Order Doesn’t Matter
- Redundant Table
- Redundant Table Restructure
R
- Introduction
- Data Structures
dplyrggplot- Functions
forloops- Other Data Structures
- Conditionals
- Problem Decomposition (R-script)
- Spatial Data
- Version Control
- Working with Databases
- Low-level Database Management Libraries
tidyr- Project Structure
- Debugging
knitr- R Cheat Sheet
- Projects
Python
Python materials were used in previous iterations of the course at Utah State University, but are no longer under active development. Most of the material is presented as IPython notebooks. The main links will take you to a nicely formatted text version of the notebook displayed in the browser. You can also download the raw notebook to interact with it on your computer by changing the code and seeing what happens.
Course Notes
- Expressions, Types, Variables, and Errors
- Expressions (notebook)
- Types (notebook)
- Integer Division (notebook)
- Variables and Assignment (notebook)
- Using Functions (notebook)
- Writing Functions (notebook)
- Strings (notebook)
- Lists: loops, methods, and nested lists
- For loops (notebook)
- While loops (notebook)
- Importing delimited text files (notebook | raw)
- Web data
- Exporting data from Python (notebook | raw)
- Numpy (notebook | raw)
- Graphing (notebook | raw) | Graphing Alternate
- Statistics (notebook)
- Interacting with Databases from Python (notebook)
- List comprehensions (notebook)
- Debugger
- Testing
- Style
- Program Design (notebook)
- Common points of confusion in Python (notebook)
- Python & R (notebook | raw)
- Rpy2 (notebook)
Extra Notes
- Aliasing (notebook)
- Beautiful Soup (notebook)
- Biopython
- Errors (notebook)
- First Class Functions
- For Loops Indexing
- Making Choices
- Modules
- Multi-way ANOVA (notebook)
- Object Oriented Programming (notebook)
- Object Oriented Programming Example (notebook)
- Packaging
pandas(notebook)- Program Design
- Python Resources
- Rainfall Example (notebook)
- Regular Expressions
- Requests (notebook)
- Running Blast
- Shell in Python
- SQL in Python | Alternate SQL in Python
- Statistics in Scipy
- Style Guide
- Testing (notebook)
- Using Help
Access
Access materials were used in previous iterations of the course at Utah State University, but are no longer under active development.