From the course: SQL for Finance Professionals

Unlock the full course today

Join today to access over 24,900 courses taught by industry experts.

Setting up sample data and files

Setting up sample data and files - SQL Tutorial

From the course: SQL for Finance Professionals

Start my 1-month free trial Buy for my team

Setting up sample data and files

“

- [Instructor] Let's take what we've just learned about SQL and create our very first query. But before we do that, we have to set up our SQL environment to begin querying the database exercise files provided in this course. The software we'll be working with is called DB Browser, which is an open source tool used to work with database files through a spreadsheet-like interface and SQL commands. You've already seen me use it in the past few videos. Specifically the flavor of SQL it uses is called SQLite. To get started with DB Browser, simply go to sqlitebrowser.org/dl and download the version that is compatible with your operating system. Once that application is installed on your machine, you can open the database files that you've downloaded from this course by navigating to the open database button at the top left and selecting the files wherever you've saved them in your file system. With the files from this course, they will be downloaded in a ZIP file called…

Contents