Introduction to Databases

Overview

Time: Friday, February 23, 1:30pm - 4:30pm

Location: SCC 102.B

This course covers SQLite, the most widely used relational database. Topics include: command line tools to manage SQLite databases and files (CSV and TXT files), Structured Query Language (SQL) to manage relational database, Python and R programming with SQLite.

Course Materials

  • Introduction to Databases Handout: (Spring 2018) PDF
  • Introduction to Databases Course Files: (Spring 2018) ZIP
  • Introduction to Databases: (Fall 2017) PDF
  • Introduction to Databases Handout: (Fall 2017) PDF
  • Introduction to Databases: (Spring 2017) PDF

Agenda

This course focuses, among others, on the following topics:

Introduction to Databases

  • Notebook, Sample Database and SQLite
  • Table and Data Types
  • SELECT: Select Data from Databases
  • INSERT: Insert Data into Database
  • UPDATE: Update Data in Databases
  • DELETE: Delete Data in Databases
  • Transactions
  • SQLite on Command Line
  • Python and RProgramming with SQLite

Note: During the class sessions many aspects of the material will be illustrated live via a login to Titan. Attendees are welcome to follow these parts with their own laptops. They will need to configure their laptops to use the TAMULink wireless network. Relevant details on this can be found at: http://tamulink.tamu.edu/