Hprc banner tamu.png

From TAMU High Performance Research Computing
Jump to: navigation, search

Contents

Introduction to Databases

This course overs 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, and tool sqliteman with graphical user interface to operate on SQLite databases.


Time and Place

Location: Student Computing Center (SCC) 4.102B (on first floor) registration required

Date: Wednesday, April 26, 2017

Time: 3:00 p.m. - 5:00 p.m.

Agenda

  • Introduction to Sqlite
  • Commands to Create and Access Sqlite Database
  • SQL Statement: SELECT, INSERT, DELETE, and UPDATE
  • Backup and Restore Sqlite Databases
  • Import and Export Sqlite Databases
  • Perl and Python Program to Access Sqlite
  • Transactions
  • Sqliteman: Graphical User Interface for Sqlite

Course material:

Personal tools
Namespaces
    Notice: Undefined index: namespace_urls in /var/www/mediawiki119/skins_local/Vector.php on line 354 Warning: Invalid argument supplied for foreach() in /var/www/mediawiki119/skins_local/Vector.php on line 354

Notice: Undefined index: variant_urls in /var/www/mediawiki119/skins_local/Vector.php on line 365 Warning: Invalid argument supplied for foreach() in /var/www/mediawiki119/skins_local/Vector.php on line 365

Variants
Views
    Notice: Undefined index: view_urls in /var/www/mediawiki119/skins_local/Vector.php on line 387 Warning: Invalid argument supplied for foreach() in /var/www/mediawiki119/skins_local/Vector.php on line 387
Actions
Important Info
User Guides
Helpful Pages
Tools