SQLite in Python || Python Tutorial || Learn Python Programming

Are you a Python programmer who loves Data? This is your lucky video! Hit play as we dive into the world of SQLite in Python. We'll cover connecting & creating databases, cursors, different ways to execute queries, the secrets of dodging SQL Injection Attacks, and more! So buckle up, grab your coding gear, and let's get this party started!

Find our programming playlists here:

Subscribe to Socratica + bell for notifications:

⧓⧓⧓⧓⧓
We recommend:
How to Be a Great Student

Python Cookbook, 3rd edition

⧓⧓⧓⧓⧓
Join this channel to get access to perks:

Support Socratica on Patreon:

Written & Produced by Michael Harrison
Edited by Megi Shuke and Michael Harrison

#pythontutorial #sqlite #coding

[cyndicorinne]

This is a great introduction to the use of for SQLite and Python. As always, the deadpan humor is much appreciated. 💜

[AhmadAlMutawa_abunoor]

I can not convey how much I am glad to see your videos coming back.
I use SQLite extensively with C#. But I am glad to see that I can extend my usage to python as well.

Please, please, please, make more videos like this, and with more frequency 🙏🙏

[djl]

{
"title":"SQLite in Python",
"chapters":{
"start" : "00:00:00",
"What is SQLite" : "00:00:34",
"Create DB" : "00:01:20",
"Create Table" : "00:02:27",
"Insert data" : "00:03:13",
"Commit the connection" : "00:04:42",
"Data Types" : "00:05:07",
"execute & exececutemany" : "00:05:50",
"executescript" : "00:06:01",
"Cursor iteration" : "00:07:12",
"? placeholder" : "00:07:39",
"Summary" : "00:08:42",
"end" : "00:10:10"
}
}

[thatotherguy]

This could not have come at a better time...my boss just asked me to speed up our dashboards and start managing our own data instead of relying on the technology team. Awesome video as always.

[KaizerKilborn]

I started learning SQL yesterday, and am using it in Python. This video has arrived with precise timing. Would expect nothing less from Socratica. Thank you for making this video!

[darius_defiant]

I love the way this is narrated SO much. It's the perfect amount of efficient, to-the-point teaching and humour. It keeps me engaged and interesting through otherwise relatively dry subject matter

[metinunlu_]

I don't remember enjoying a cs related education video this much, absolutely loved it! Thank you.

[alvarocafe]

This channel just keeps getting better! Cheers!

[neurite]

Appreciate you have included the topic of SQL injection in this short video.

[rhysdavies]

I'm new to Python and SQL and this helped me overcome my first hurdle - also made me giggle too, which is very much a plus - Great stuff!!

[paulw]

This is wonderful, the comedic take is sublime.

[binsitt]

I LOVE that style, learning is a breeze here!

[df]

I would really love a MongoDb video just like this. 🙏🏽

[FlyingTurtleLP]

Oh how much I love these videos :D ... Amazing style and so entertaining!

[Dettol]

Love the video style, production and clear content, thank you!

[pochta]

Great, great, great to see and hear you back ! Thank you ! So cool that you have immediately involved ChatGPT (who haven't ?). Eager to see more and more of your brilliant videos !

[kingofcastlechaos]

I need to write a Python script that detects I am watching your videos, and then reminds me to NOT be drinking or chewing while watching, or I may be cleaning up my desktop yet again. LOVE the humor!

[JorgeEscobarMX]

Omg! ❤ it's been so long. I'm just happy to have a new SQL video on socratica

[ozzman]

I've been using SQLite3 for years in python to import and export Excel files. I love the versatility. It makes anything I can put into Excel, easy to handle for generating formatted colorized output in a terminal of a bastion server. Also love the fact that I still learned a couple new concepts from this video. Great job.

[absmustang]

Another fine video full of memorable info. Thanks!