![]() Aside from its ability to easily connect to a SQLite database file, as well as other SQL engines, DbVisualizer is also used here because it contains a visually appealing and easy-to-use query editor with syntax highlighting. Downloading DbVisualizerĭbVisualizer is a popular tool for connecting to multiple SQL engines and databases, including SQLite. If you wish to create an empty SQLite database yourself, see the Creating An Empty Database (Optional) section in this document. The student_records_filled.db file is a complete version of the database that is populated with the contents of the comma-separated value (CSV) files in the data/raw subfolder. This file is an empty (i.e., contains no data tables) SQLite database. The insert_data.sql in the same subfolder provides SQL code for inserting data into rows in the different tables.įor the exercise in the live session we use the students_records.db file in the data/databases subfolder. The student_records.sql file in the code subfolder contains the SQL code for creating a new database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |