Title: A brief introduction to SQLIte
Duration: 16:36 min.
Summary: The SQLite database is the tiniest database used on Linux, applications and portable devices. This video presents an introduction to this database by means of an explanatory demonstration of how to connect to the Linux, via a SSH client called Putty and how to create a database file from the bash console of an Ubuntu Linux distribution. After the database file was created, the video shows how to send simple queries to retrieve the data that is stored. Also, some details of the command-line tool use to interact with the SQLite database are presented during the video, such as how to connect, finalize commands, create a table and set formating options. The video ends showing an example where more than one user connects to the same database file and work with the data that is stored on a table.
Technologies : SQLite, SSH, Linux.
Examples: How to log in on Linux via a SSH client, create a database on SQLite and send some queries to return information about the databases and tables via the command line interface.
Keywords: SQL, SQLite, SSH, Linux.