Google Colab + SQLite

Tutorial on utilizing SQLite databases within Google Colab. The tutorial reviews how to create a SQLite database & table and how to run SQL queries on the table using either the pandas module or SQLite's cursor object. The notebook can be found in the "Google Colab Tutorials" folder within the below repo. GitHub Repo - https://github.com/ad17171717/YouTube-Tutorials/blob/main/Google%20Colab%20Tutorials/Google_Colab_%2B_SQLite.ipynb CONNECT: LinkedIn: https://www.linkedin.com/in/adrian-dolinay-frm-96a289106/ GitHub: https://github.com/ad17171717 X: https://twitter.com/DolinayG Odysee: https://odysee.com/@adriandolinay:0 Medium: https://medium.com/@adriandolinay PODCAST: Apple Podcasts: https://podcasts.apple.com/us/podcast/the-aspiring-stem-geek/id1765996824 Audible: https://www.audible.com/podcast/The-Aspiring-STEM-Geek/B0DC73S9SN?eac_link=ONLefHtKpP93&ref=web_search_eac_asin_1&eac_selected_type=asin&eac_selected=B0DC73S9SN&qid=ZLZCJYZ17Q&eac_id=145-9930582-4977616_ZLZCJYZ17Q&sr=1-1 iHeart Radio: https://iheart.com/podcast/202676097/ Spotify: https://open.spotify.com/show/60dPNJbDPaPw7ru8g5btxV?si=26e034e416f446d8 |-Video Chapters-| 0:00 - Intro 0:04 - Overview of SQLite 0:32 - SQLite in Google Colab 0:54 - Tutorial Overview 1:05 - Downloading Dataset with wget 1:29 - Unzipping Dataset 1:44 - Inspecting Dataset with head 2:03 - Importing Libraries 2:30 - Reading Dataset into Pandas DataFrame 3:17 - Creating SQLite Database 3:42 - Creating Table in SQLite Database 4:24 - Running SQL Queries with Pandas 5:21 - Querying Metadata for Table 5:24 - Retrieving Table Dimensions 5:36 - Calculating Average Power Consumption 5:50 - Identifying Null Values in Columns 6:09 - Closing SQLite Connection 6:13 - Working with SQLite Cursor Object 6:26 - Creating New SQLite Database 7:03 - Loading Data into SQLite Using CSV Reader 8:03 - Running Queries with Cursor Object 8:25 - Counting Households with High Power Usage 8:47 - Finding Times with Highest Power Usage 9:01 - Closing Connection 9:07 - Conclusion