LibGuides: Research Data: Working with Data

R

R is a free piece of software used for statistical analysis and data visualization.

You can download R from the R Project website. RStudio is a popular development environment for working with R. You can also install these using BCIT's AppsAnywhere service.

Videos

Learn R programming by Dr. David Wilkins (1h 29m)
Learning R by Barton Poulson (2h 51m)
Data Wrangling in R by Mike Chapple (2h 51m)
R for Data Science: Lunchtime Lessons by Mark Niemann-Ross (16h+)

Ebooks

R for Data Science by Garrett Grolemund and Hadley Wickham
R for Everyone: Advanced Analytics and Graphics, 2nd Edition by Jared P. Lander
R in Action, Second Edition by Robert I. Kabacoff
Learning R by Richard Cotton
R For Dummies by Joris Meys and Andrie de Vries

Print book

Advanced R by Hadley Wickham (QA 276.45 R3 W53 2015)
An Introduction to Statistical Learning: with Applications in R by Gareth James, Daniela Witten, Trevor Hastie, and Robert Tibshirani (QA 276 I585 2013)
R in a nutshell by Joseph Adler (QA 276.45 R3 A3 2010)

Other Resources (not provided by BCIT)

GIS

Videos

Real-World GIS by Jason VanHorn (2h 43m)
ArcGIS Pro Essential Training by Gordon Luckett (3h 17m)

Ebooks

GIS Fundamentals by Stephen Wise
Learning ArcGIS Pro 2 by Tripp Corbin

Print Books

GIS Fundamentals by Stephen Wise (G 70.212 W58 2014)
Mastering ArcGIS by Maribeth Hughett Price (G 70.212 P75 2014)

Git

Videos

Git from Scratch by Morten Rand-Hendriksen (19m 41s)
Programming Foundations: Version Control with Git by Christina Truong (1h 20m)
Learning Git and GitHub by Ray Villalobos (1h 52m)
Git Essential Training: The Basics by Kevin Skoglund (2h 55m)

Ebooks

Pro Git by Scott Chacon and Ben Straub
Git Pocket Guide: A Working Introduction by Richard E. Silverman
Git Essentials: Create, Merge, And Distribute Code With Git by Ferdinando Santacroce
Learn Git in a Month of Lunches by Rick Umali

Other Resources

Ry's Git Tutorial by Ryan Hodson

Python

Python is a programming language frequently used for working with data and automating research.

You can download Python from the official website. You can also use a distribution such as Anaconda, which is recommended by many people using Python for data science and research. Both of these are also available through BCIT's AppsAnywhere service.

Videos

Python Quick Start by Lavanya Vijayan (1h 36m)
Python for Non-Programmers by Nick Walter (1h 55m)
Learning Python by Joe Marini (3h 10m)
Python Essential Training by Ryan Mitchell (4h 17m)

Ebooks

Python Crash Course, 2nd Edition by Eric Matthes
Head First Python, 2nd Edition by Paul Barry
Automate the Boring Stuff with Python by Al Sweigart
Learn Python the Hard Way: A Very Simple Introduction to the Terrifyingly Beautiful World of Computers and Code, Third Edition, Video-Enhanced Edition by Zed A. Shaw
Learning Python, 5th Edition by Mark Lutz

Print books

Building Python Programs by Stuart Reges (QA 76.73 P98 R445 2019)
Python scripting for ArcGIS by Paul A. Zandbergen (G 70.212 Z36 2013)
Learn Python 3 the Hard Way: A Very Simple Introduction to the Terrifyingly Beautiful World of Computers and Code by Zed A. Shaw (QA 76.73 P98 S53 2017)

Other Resources (not provided by BCIT)

Plotting and Programming in Python (Software Carpentries)

SQL

Videos

Quick Start Guide to SQL by Deepa Maddala (1h 18m)
SQL for Non-Programmers by Julianne Thouin (1h 30m)
SQL Essential Training by Bill Weinman (3h 0m)

Ebooks

SQL Cookbook by Anthony Molinaro and Robert de Graaf
Sams Teach Yourself SQL in 10 Minutes a Day by Ben Forta
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data with SQL by Walter Shields
Learning SQL: Generate, Manipulate, and Retrieve Data by Alan Beaulieu
Head First SQL by Lynn Beighley

Print Books

Sams teach yourself SQL in 10 minutes (4th edition) by Ben Forta (QA 76.73 S67 F67 2013)
SQL: A Beginner's Guide by Andrew J. Oppel (QA 76.73 S67 S54 2016)

AutoCAD

AutoCAD is a Computer-Aided Design (CAD) and drafting program made by Autodesk that is frequently used by architects, engineers, and other professionals.

AutoCAD is available through BCIT's AppsAnywhere service, however those wanting to use the software must first create an Autodesk account and confirm their eligibility with Autodesk’s verification service. For more information check BCIT's Knowledge Base.

Videos

Learning AutoCAD by Shaun Bryant (2h 19m)
AutoCAD 2023 Essential Training by Shaun Bryant (9h 48m)

Ebooks

Mastering AutoCAD 2019 and AutoCAD LT 2019 by George Omura and Brian C. Benton
AutoCAD For Dummies (19th Edition) by Ralph Grabowski
Beginning AutoCAD® 2020 - Exercise Workbook by Cheryl R. Shrock and Steve Heather
Practical Autodesk AutoCAD 2021 and AutoCAD LT 2021 by Yasser Shoukry, Jaiprakash Pandey
AutoCAD 2021 Beginning and Intermediate by Munir M. Hamad

Print Books

AutoCAD for Dummies (17th Edition) by Bill Fane (T 385 F36 2016)
Technical Drawing 101 with AutoCAD 2021: A Multidisciplinary Guide to Drafting Theory and Practice by Douglas Smith, Antonio Ramirez, and Ashleigh Fuller (T 353 S495 2020)
AutoCAD 2022: Essentials (Reserves: T 386 A97 A83 2021)
Introduction to AutoCAD 2020: A Modern Perspective by Paul Richard (Reserves: T 385 R53 2020)

Other Resources (not provided by BCIT)

Excel

Microsoft Excel is a spreadsheet program that can be used for data visualization and analytics.

Excel is available to download by itself or as part of Office365 through BCIT's AppsAnywhere service. You can find more information on activating it on BCIT's Knowledge Base.

Videos