Free Online Courses for Software Developers - MrBool
× Please, log in to give us a feedback. Click here to login
×

You must be logged to download. Click here to login

×

MrBool is totally free and you can help us to help the Developers Community around the world

Yes, I'd like to help the MrBool and the Developers Community before download

No, I'd like to download without make the donation

×

MrBool is totally free and you can help us to help the Developers Community around the world

Yes, I'd like to help the MrBool and the Developers Community before download

No, I'd like to download without make the donation

Introduction to Graphical User Interfaces Tools for SQLite | SQL courses

In this video we will see a tool called SQLite Manager, which is a free add-on for the Firefox Web Browser.

OBS: download the application please visit www.mrbool.com/player

Title: Introduction to Graphical User Interfaces Tools for SQLite

Duration: 16:50  min.

Summary: There are many tools that can be used to administer a SQLite database file. This video presents a brief introduction to two graphical user interfaces tools that can be used to administer a SQLite database file on the Ubuntu Linux: the SQLite Database Browser and the SQLite Manager. The first tool, SQLite Database,  is an open source tool used to perform few tasks, such as create, alter and drop tables, triggers, views and indexes and send SQL commands through a GUI interface. Furthermore, the video show a tool called SQLite Manager, which is a free add-on for the Firefox Web Browser. The SQLite Manager contains all the options of the SQLite Database Browser and more, allowing the DBA to control better the database file. This tool have options to change the main settings of the database and also to manage the files by attaching, copying, compressing and other operations. Also, SQLite Manager have a interface that helps the user find the rows that are needed, avoiding the construction of complex SELECT statements. However, if the user wants he can execute any SQL commands that a SQLite database accepts directly on the SQLite Manager.

Technologies : SQLite, SSH, Linux

Examples: How to create a table in a SQLite datbase file, add records and export the database structure and data to a text file that contains SQL commands.

Keywords: SQL, SQLite, SSH, Linux.



Mauro Pichiliani has the Master of Science degree on collaborative systems by the Aeronatics Institute of Technology (ITA) in Brazil. He is a specialist on database technologies with more than 8 years of experience on the industry...

What did you think of this post?
Services
[Close]
To have full access to this post (or download the associated files) you must have MrBool Credits.

  See the prices for this post in Mr.Bool Credits System below:

Individually – in this case the price for this post is US$ 2,00 (Buy it now)
in this case you will buy only this video by paying the full price with no discount.

Package of 10 credits - in this case the price for this post is US$ 1,00
This subscription is ideal if you want to download few videos. In this plan you will receive a discount of 50% in each video. Subscribe for this package!

Package of 50 credits – in this case the price for this post is US$ 0,33
This subscription is ideal if you want to download several videos. In this plan you will receive a discount of 83% in each video. Subscribe for this package!


> More info about MrBool Credits
[Close]
You must be logged to download.

Click here to login