1 Introduction

This book was written over the course of a STAT 400 class at California Polytechnic State University, San Luis Obispo. For each section, we walk through the processes using SAS, Julia, R, and Python. These programming languages are common in statistics and among Cal Poly statistics students.

This book demostrates how to connect to, upload data to, and read data from a Microsoft Server database. While the code provided in this book is specific to Microsoft SQL, the lessens can likely be extended to any database, with a few google-able differences.

Table of Contents

  1. Background
  2. Machine Setup
  3. Connecting to a Database
  4. Creating and Writing to Tables
  5. Querying a Database
  6. Using APIs
  7. Integrating this Material into a Statistics Course