index.md

layout	title
page	Lecture Materials

SQL | R | Python | Access

General Programing Resources

• [Problem Decomposition]({{ site.baseurl }}/materials/problem-decomposition)
• [Git Collaboration]({{ site.baseurl }}/materials/git-collaboration-example)
• [Git in 30 minutes]({{ site.baseurl }}/materials/git-in-30-minutes)
• [Shell]({{ site.baseurl }}/materials/shell) | [Shell Alternate]({{ site.baseurl }}/materials/shell2)
• [State in IDEs]({{ site.baseurl }}/materials/state-in-IDEs)

SQL

Course Notes

• [Introduction to Databases]({{ site.baseurl }}/materials/databases-intro-sql)
• [Basic Queries]({{ site.baseurl }}/materials/sql-basic-queries)
• [Aggregation]({{ site.baseurl }}/materials/sql-aggregation)
• [Joins]({{ site.baseurl }}/materials/sql-joins)
• [Tidy Data]({{ site.baseurl }}/materials/tidy-data)
• [Data Entry in Excel]({{ site.baseurl }}/materials/data-entry)
• [Nested Queries]({{ site.baseurl }}/materials/sql-nested-queries)

Extra Notes

• [Database Control - SQLite Manager]({{ site.baseurl }}/materials/database-control-sql)
• [Database Control - Queries]({{ site.baseurl }}/materials/database-control-queries-sql)
• [Database Structure]({{ site.baseurl }}/materials/database-structure)
• [Database Resources]({{ site.baseurl }}/materials/database-resources)
• [Exporting from OpenOffice]({{ site.baseurl }}/materials/exporting-tables-and-queries-from-openoffice-base-to-csv)
• [SQL for Access Users]({{ site.baseurl }}/materials/sql-for-access-users)

Database Structure Image Files

• [Basic Structure]({{ site.baseurl }}/materials/databases-basic-table-structure.png)
• [Cross-tabulated Table]({{ site.baseurl }}/materials/databases-crosstab-table.png)
• [Crosstab Restructured]({{ site.baseurl }}/materials/databases-crosstab-restructured.png)
• [Multiple Values]({{ site.baseurl }}/materials/database-struct-multiple-habitat-values.png)
• [No Duplicate Rows]({{ site.baseurl }}/materials/database-struct-no-dup-rows.png)
• [No Redundant Information]({{ site.baseurl }}/materials/database-struct-no-redundant-information.png)
• [One Column per Type]({{ site.baseurl }}/materials/database-struct-one-col-per-type.png)
• [One Value per Cell]({{ site.baseurl }}/materials/database-struct-one-val-per-cell.png)
• [Order Doesn't Matter]({{ site.baseurl }}/materials/database-struct-order-doesnt-matter.png)
• [Redundant Table]({{ site.baseurl }}/materials/databases-redundant-table.png)
• [Redundant Table Restructure]({{ site.baseurl }}/materials/databases-redundant-table-restructure.png)

R

• [Introduction]({{ site.baseurl }}/materials/r-intro)
• [Data Structures]({{ site.baseurl }}/materials/data-structures-R)
• [dplyr]({{ site.baseurl }}/materials/dplyr)
• [ggplot]({{ site.baseurl }}/materials/ggplot)
• [Functions]({{ site.baseurl }}/materials/functions-R)
• [for loops]({{ site.baseurl }}/materials/for-loops-R)
• [Other Data Structures]({{ site.baseurl }}/materials/other-data-structures-R)
• [Conditionals]({{ site.baseurl }}/materials/conditionals-R)
• [Problem Decomposition]({{ site.baseurl }}/materials/decomposition-R) ([R-script]({{ site.baseurl }}/materials/decomposition-example.R))
• [Spatial Data]({{ site.baseurl }}/materials/spatial-data-R)
• [Version Control]({{ site.baseurl }}/materials/version-control-R)
• [Working with Databases]({{ site.baseurl }}/materials/r-databases)
• [Low-level Database Management Libraries]({{ site.baseurl }}/materials/r-sql)
• [tidyr]({{ site.baseurl }}/materials/tidyr)
• [Project Structure]({{ site.baseurl }}/materials/project-structure)
• [Debugging]({{ site.baseurl }}/materials/debugging-R)
• [knitr]({{ site.baseurl }}/materials/knitr)
• [R Cheat Sheet]({{ site.baseurl }}/materials/Walkthrough-R)
• [Projects]({{ site.baseurl }}/materials/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]({{ site.baseurl }}/materials/expressions-types-variables-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]({{ site.baseurl }}/materials/lists-loops-methods-nesting.pdf)
• For loops (notebook)
• While loops (notebook)
• [Importing delimited text files]({{ site.baseurl }}/materials/importing-data-into-python) (notebook | raw)
• [Web data]({{ site.baseurl }}/materials/web-data)
• [Exporting data from Python]({{ site.baseurl }}/materials/exporting-data-from-python) (notebook | raw)
• [Numpy]({{ site.baseurl }}/materials/a-brief-introduction-to-numpy) (notebook | raw)
• [Graphing]({{ site.baseurl }}/materials/graphing) (notebook | raw) | [Graphing Alternate]({{ site.baseurl }}/materials/a-brief-introduction-to-matplotlib)
• Statistics (notebook)
• Interacting with Databases from Python (notebook)
• List comprehensions (notebook)
• [Debugger]({{ site.baseurl }}/materials/debugger)
• [Testing]({{ site.baseurl }}/materials/testing)
• [Style]({{ site.baseurl }}/materials/style)
• Program Design (notebook)
• Common points of confusion in Python (notebook)
• [Python & R]({{ site.baseurl }}/materials/R-and-python.pdf) (notebook | raw)
• Rpy2 (notebook)

Extra Notes

• Aliasing (notebook)
• Beautiful Soup (notebook)
• [Biopython]({{ site.baseurl }}/materials/biopython-data-types-and-methods)
• Errors (notebook)
• [First Class Functions]({{ site.baseurl }}/materials/first-class-functions)
• [For Loops Indexing]({{ site.baseurl }}/materials/for-loops-indexing)
• [Making Choices]({{ site.baseurl }}/materials/if-then-else)
• [Modules]({{ site.baseurl }}/materials/modules-using)
• Multi-way ANOVA (notebook)
• Object Oriented Programming (notebook)
• Object Oriented Programming Example (notebook)
• [Packaging]({{ site.baseurl }}/materials/packaging)
• pandas (notebook)
• [Program Design]({{ site.baseurl }}/materials/program-design)
• [Python Resources]({{ site.baseurl }}/materials/python-resources)
• Rainfall Example (notebook)
• [Regular Expressions]({{ site.baseurl }}/materials/regexp)
• Requests (notebook)
• [Running Blast]({{ site.baseurl }}/materials/running-blast-from-pythons)
• [Shell in Python]({{ site.baseurl }}/materials/shell-in-python)
• [SQL in Python]({{ site.baseurl }}/materials/sql-python) | [Alternate SQL in Python]({{ site.baseurl }}/materials/using-python-to-interface-with-databases)
• [Statistics in Scipy]({{ site.baseurl }}/materials/statistics-in-scipy)
• [Style Guide]({{ site.baseurl }}/materials/style-guide-Python)
• Testing (notebook)
• [Using Help]({{ site.baseurl }}/materials/using-help)

Access

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

• [Advanced Queries]({{ site.baseurl }}/materials/access-adv-queries)
• [Databases Week 2]({{ site.baseurl }}/materials/databases2)
• [Forms]({{ site.baseurl }}/materials/access-forms)
• [Linking Databases]({{ site.baseurl }}/materials/access-linking-databases)
• [Setting up an ODBC connection in Windows]({{ site.baseurl }}/materials/setting-up-an-odbc-connection-in-windows)
• [Reports]({{ site.baseurl }}/materials/access-reports)