Comprehensive Detailed guide on how to use DB Browser for SQLite for database, table, and views creation and management. This is perfect for absolute beginners.
Blog posts referenced in the video
Blog post on how to use DB Browser for SQLite -
Blog post on Installing SQLite on Windows and Mac -
If you want a database to open and use with SQLite,
Download the Employees Database when you sign up to get access to my FREE technical resources - you will get access to this database as well as other databases.
Or get it from my github page Although, the FREE Tech resources page has a lot more database and resources than my github page.
---
Follow me on Youtube -
Follow me on Linkedin -
Follow me on Github -
Follow me on Twitter -
If you want to contact me, speak to me here -
Want me to create a similar technical content for your brand? Contact me here. -
Want to get updates every time I publish new content? Join my FREE Technical Newsletter -
Timestamps
00:00 - Introduction
00:41 - Install DB Browser for SQLite -
1:10 - Open DB Browser for SQlite
1:38 - How to Open a Database in DB Browser for SQLite
3:00 - How to Browse data in DB Browser for SQlite
4:00 - How to create a new database in DB Browser for SQLite
5:00 - How to create new data tables in a SQLite database using DB Browser for SQLite
8:00 - How to execute, run, and add SQL Queries to DB Browser for SQLite.
10:30 - How to Save SQL Queries in DB Browser for SQLite
12:00 - How to add data to SQLite database tables using DB Browser for SQLite (GUI)
14:25 - Filter data tables in DB Browser for SQLite
15:20 - How to add data to SQLite database tables using DB Browser for SQLite (Using SQL Queries)
16:30 - How to open and save projects in DB Browser for SQLite
17:50 - How to create and save views in DB Browser for SQLite
21:00 - Open Multiple Databases simultaneously in DB Browser for SQLite
24:00 - Everything Else you need to know about DB Browser for SQLite
27:40 - Connect with me and additional resources