DATA SCIENCE SKILLS: Gentle Introduction to sqlite3. Python, SQLite and Databases

You can create your FREE account and get started with any of their 60+ free lessons to sharpen your data skills

Tutorial starts at 02:14
SQLite & Pandas 12:30

How to use python, SQLite and sqlite3. Python makes handling databases straightforward.

WANT TO LEARN PYTHON? Try my courses:
How to Learn Data Science for Free. My YouTube video:

👌 SUBSCRIBE to ME!👌

[manishsingh]

Yours is a highly underrated channel amongst the computer science related channels on YouTube. Great video as always. ❤

[ebarbere]

It's spooky how timely some of your videos are. After sitting on an online Python course for a year, I have only this weekend started with the SQLite section. Happy to see the practices reinforced here with some great features I was wondering about (using with Pandas), but hadn't learned yet. Thank you for all of your content.

[carstenpedersen]

Perfect timing for this video. Started looking at sqlite last week, then deceided it was to advanced for me, and just wanted to save my data as json/dict/csv file.. A buddy of mine convinced me to go back to sql, so will try that, and with your video i just got a good introduction to it. :)

[saurabhrai]

Thank You! ❤️❤️
Amazing Video, been waiting for this.

[tylernelson]

Thank you so much, just what I was looking for, very well designed - cheers!

[creativecore]

this is exactly what I was lookiing for. Thank you Python Programmer !

[VKjkd]

Love Sqllite and sqllite studio is a massive time saver.

[Raymanujan]

A gentle introduction by an English gentleman.

[bitpilot]

You don't have to delete the database. You already added the condition: CREATE TABLE IF NOT EXISTS books - this ensures that the books table is created only when it doesn't already exists.

[helaolange]

My favorite SQLite command.
.mode csv

[helaolange]

I'll always wanted this videos to be in OOP style

[songokussjcz]

Hi, what about relations? If I have two tables. In first Books(id, title, authorId, price), the second Authors(authorId, firstName, secondName). Do I need to use JOIN in SQL command or is there a more pythonic way?

[saurabhrai]

Make a video on Machine Learning using WSL2 platform. (On Windows 10)

[kizitobukenya]

A comb. of Python and sqlite3 offers the modern environment for interactive data management

[djingo-blip]

Hey -
what colour theme are you using for vccode?

[Punkt_Materialny]

14:29 - 'DataFrame' object has no attribute 'append'

[pawlowski]

Could you highlight some real world use cases for this? If I understand correctly, this can't be used to create a persistent database. For example load data walk away come back next week and the dad is still there. If you can't do that? What's the use of this? Thanks much

[gedtoon]

Some of the code is cropped off on the right hand side. Is it available as a download?

[hannibalbra]

The only question that i dont understand is how to insert to many data in such ways.. It is not comfy to enter massive data with command like that

[armmass]

Hi
I miss some of your videos because i did not recognize it is yours
will be better if you put your photo in video thumbnail to recognize it