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
Participation
During the training, attendees are expected to log in to an HPRC cluster using their own computer and complete the instructor-led examples and exercises.
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