top of page
Home

SQL in ACCT 605

SQL - CLASS 2.png
SQL - CLASS 1.png
SQL - Class 3.png

Database Structure

Executions

Exporting to a CSV

SQLite lets us set up tables and views that can help us start organizing data. This makes it easier to see the structure at a glance without the extra code without using DB Browser. 

We can use SQL queries in DB Browser to pull what data we need, like customer numbers with sale summaries. This can be faster than viewing sheets to find the same information. 

We can also export data from the query results straight to a CSV file with a couple of clicks. Data can then be uploaded to Excel and Tableau for further analysis and visuals. 

bottom of page