SQLite Databases With Python

SQLite Databases With Python - Full Course

Рет қаралды 661,063

Күн бұрын

In this course you’ll learn the basics of using SQLite3 with Python. SQLite is an easy-to-use database engine included with Python.
You’ll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more. For this course you should already have a basic knowledge of Python programming, but you don’t need to know anything at all about databases or SQLite.
💻Code: github.com/flatplanet/Intro-T...
🎥Course created by Codemy.com. Check out their KZfaq channel: / codemycom
⭐️Course Contents ⭐️
⌨️ (0:00:00) What Is A Database
⌨️ (0:03:39) Install Python
⌨️ (0:07:07) Install Git Bash Terminal
⌨️ (0:11:52) Connect to Database in Python
⌨️ (0:17:39) Create A Table
⌨️ (0:28:13) Insert One Record Into Table
⌨️ (0:31:25) Insert Many Records Into Table
⌨️ (0:34:41) Query and Fetchall
⌨️ (0:37:02) Format Your Results
⌨️ (0:44:39) Primary Key
⌨️ (0:47:51) Use The Where Clause
⌨️ (0:51:17) Update Records
⌨️ (0:56:42) Delete Records
⌨️ (0:58:27) Order Results
⌨️ (1:01:37) And/Or
⌨️ (1:04:57) Limiting Results
⌨️ (1:07:27) Delete (Drop) A Table And Backups
⌨️ (1:09:14) Unit 18 Our App - Show All Function
⌨️ (1:14:16) Unit 19 Our App - Add A Record Function
⌨️ (1:17:51) Unit 20 Our App - Delete a Record Function
⌨️ (1:21:23) Unit 21 Our App - Add Many Records Function
⌨️ (1:24:57) Unit 22 Our App - Where Clause Function
--
Learn to code for free and get a developer job: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news
And subscribe so you don't miss any tutorials: kzfaq.info_cent...

Пікірлер: 536

@redfordwilson5042 4 жыл бұрын

I didn't know Walter White was also skilled in programming. Cool!

@hellelo.5840 4 жыл бұрын

I am the danger, Walter said while talking to his wife about hacking

@zl7289 3 жыл бұрын

This comment deserves more likes! 😂

@ShaileshKumar-fk8cu 3 жыл бұрын

Hahahahahahahaha

@ayushjadaun4964 3 жыл бұрын

Maybe he is planning to hack Pentagon. This time

@CavanLeeSears 3 жыл бұрын

You'll notice that almost every skilled programmer is a bald be-speckled goatie (stubble too) wearing guy. Including myself. :)

@byleexs1991 Жыл бұрын

Cursors in sqlite3 python are objects that act as a pointer to the results of a query. They enable you to fetch, add, modify or delete data from a database. The cursor can also be used to traverse through the rows of a query result.

@Ricocase 4 жыл бұрын

He already created a time outline of specific concepts in the video = instant upvote! Down-to-earth explanations > boss move!

@tymothylim6550 3 жыл бұрын

Thank you John for this video! I watched the whole thing and it was really a well-planned lesson! This really helps me grasp the basics for sqlite3!

@tzwacdastag8223 4 жыл бұрын

⭐️Course Contents ⭐️ ⌨️ (0:00:00) What Is A Database ⌨️ (0:03:39) Install Python ⌨️ (0:07:07) Install Git Bash Terminal ⌨️ (0:11:52) Connect to Database in Python ⌨️ (0:17:39) Create A Table ⌨️ (0:28:13) Insert One Record Into Table ⌨️ (0:31:25) Insert Many Records Into Table ⌨️ (0:34:41) Query and Fetchall ⌨️ (0:37:02) Format Your Results ⌨️ (0:44:39) Primary Key ⌨️ (0:47:51) Use The Where Clause ⌨️ (0:51:17) Update Records ⌨️ (0:56:42) Delete Records ⌨️ (0:58:27) Order Results ⌨️ (1:01:37) And/Or ⌨️ (1:04:57) Limiting Results ⌨️ (1:07:27) Delete (Drop) A Table And Backups ⌨️ (1:09:14) Unit 18 Our App - Show All Function ⌨️ (1:14:16) Unit 19 Our App - Add A Record Function ⌨️ (1:17:51) Unit 20 Our App - Delete a Record Function ⌨️ (1:21:23) Unit 21 Our App - Add Many Records Function ⌨️ (1:24:57) Unit 22 Our App - Where Clause Function

@ferax4598 2 жыл бұрын

nice job copying the description

@espressoshot21 4 жыл бұрын

Thank you for this super helpful video! Keep up the awesome work. I've been really enjoying your courses on KZfaq. You're such an awesome instructor!

@WillNicholson Жыл бұрын

Thanks John, this was really helpful. Just want to note something I got hung up on; if you delete the last row in a table, that rowid will be REUSED when you add a new item to the table UNLESS you use the AUTOINCREMENT keyword. In other words, if the last rowid is 6, and you delete it (and all of that person's data)... then the last rowid is 5. But, if you add a new item, the new person's data will be added to a row that ALSO has the rowid of 6. This can cause issues when referencing data by rowid later on.

@vhoover3609 4 жыл бұрын

Hint: the print function accepts multiple arguments where each one is separated by a space when printed. I.e. print( item[0], item[1]) will print Jon Elders to the screen.

@dimjim2365 Жыл бұрын

Wow, just wow. This is one superb course for beginners like myself. I followed the whole instructions and created an employees db. I reached a little far trying to incorporate nulls and blobs which caused me probs at the end. Ha. Had to drop back to the text and email demos but everything worked the first time after I corrected my typos. Ha. Thank you for a marvelous tutorial!

@shivangivishwasrao1983 2 жыл бұрын

Simply loved how crisp and to the point this course was. Thank you so much!

@pleabargain 3 жыл бұрын

I worked through all of the code examples. Thank you! I have learned a lot!

@ABMA79 3 жыл бұрын

amazing course and productive. Thanks for the wonderful lesson. I have learned so many things in one hour from you. Expecting more amazing stuff like this in the future Thanks a lot

@myriamt6340 2 жыл бұрын

WALTER WHITE teaching me SQLITE, what a time to be alive :D

@Surferdudeoh 3 жыл бұрын

Thanks a lot for this, seriously you are an incredible teacher.

@shrishailgharat1964 4 жыл бұрын

John hope you are eating well and are healthy. Really loved the course. Thanks for the video and keeping it simple and short.

@larslover6559 Жыл бұрын

Thank you so much John for the lesson! Your calm natural way of teaching is great!

@boa2145 2 жыл бұрын

Hi John, I watched all clips. Thx for your full course "Sqlite databases with Python". Well done!!!

@dragonarch0 4 жыл бұрын

Me thinking about learning python KZfaq : I see you wanna learn python,here you go

@aspodermousstoplight100 4 жыл бұрын

Dragonarch youtube just knows man

@theboiyoulove5124 4 жыл бұрын

bruh i recommend you to learn python before watching this video

@euphoric-therapeuticmusic5374 3 жыл бұрын

Neuralink in action

@franklecky6570 Жыл бұрын

Really easy to understand course. Some very useful bits in there. Thanks John!

@louisyang185 3 жыл бұрын

this is sooooo useful. thank you so much. you're an incredible teacher!

@sabilislam7629 3 жыл бұрын

You Rock I roll... Seriously, This guy's videos are most helpful in the entire KZfaq!

@junioradi6554 3 жыл бұрын

Super and simple course which permits to understand the use of database into an application written using Python. Thank you sir

@darthvoda 2 жыл бұрын

Very good introductory course! Thank you for sharing, the energy end enthusiasm is contagious! Looking forward to learn slqite more in depth, but at a first glance I didn't found an advanced course on codemy..

@FlowGrapher 4 жыл бұрын

Just started a new project in React-Native this SQLite course will help a lot for mobile dev. Thanks 🙏

@uucea 4 жыл бұрын

This is the type of channel that will mold the next Bill Gates Few of us watching will create something revolutionary

@marcus.the.younger 3 жыл бұрын

hopefully :)

@davidt01 2 жыл бұрын

Not sure if we want another one of him though.

@cloudtechhills 2 жыл бұрын

I appreciate your work on this tutorial. Thanks mate!

@MahdeenSky 4 жыл бұрын

this is very easy to understand, good job, very few sqlite3 tutorials actually show the syntax of the sql knowledge and doesn't assume we learned the sql language beforehand, and this is one of them. Fantastic!

@MahdeenSky 4 жыл бұрын

may i ask how do i move on from this tutorial into more functional sql?

@atomiccow1906 Жыл бұрын

@@MahdeenSky howd it go

@miltondias6617 Жыл бұрын

Very simple and straight forward. Congrats!

@draganmilinov7495 3 жыл бұрын

Thank you very much on this video! It helped me. I'm beginner in programming. Python is my first programming language.

@pipedreamsnetwerk5110 Жыл бұрын

This was awesome. I was trying to figure out sqlite3. Thanks!!!

@souzafelix Жыл бұрын

Didn't know Walter white was so good at teaching sqlite! Great video!

@srinjoyghosh7273 2 жыл бұрын

I saw his TKinter playlist too. Amazing teacher !

@OnDoitConnaitre 3 жыл бұрын

This Course is really easy to follow and super useful for people who want to start using SQLite, but I wanted to understand 'JOIN' concept which is not explained neither mentioned here, so i guess I will look for some more content.

@aidynskullz4139 4 жыл бұрын

What kind of witch sorcery is this channel? As soon as I need to learn something for a project, a new course is released on the topic. This is insane and might be the tenth time it's happening. Keep up the good work!!!

@freecodecamp 4 жыл бұрын

When deciding what course to post, our first thought is always "What does Aidyn Skullz need to learn right now?" 😀

@aidynskullz4139 4 жыл бұрын

@@freecodecamp haha LOL. Thanks for replying though XD.

@euphoric-therapeuticmusic5374 3 жыл бұрын

@@freecodecamp so you guys have everything ready? why not post all of them.

@johannesperez9548 2 жыл бұрын

Thanks John! Super useful! I learned a lot!!!

@brianburch8062 3 жыл бұрын

Ah, thank you. This video cleared up a lot of things I was confused about.

@026maheshkumars7 Жыл бұрын

I have finished this course...I have enjoyed every second in this course and i have learned lot of details... thankyou very much..

@Lennardish 3 жыл бұрын

Hello John, Your course is MOST helpful. Thanks a lot. Cristal clear :)))

@franciscofurey4878 2 жыл бұрын

Amazing course! such a big teacher and explanation method!

@noir371 2 жыл бұрын

Really appreciate everything this channel does!

@anzhelazenaishvili7380 4 жыл бұрын

Hello ,I am starting to learn Data science,so I am beginer and this course it's very good for beginers,thank you very much!!!

@EpicGamer-ux1tu Жыл бұрын

Great video mate, I learned SQL and sqlite3 from you, thanks

@whatisleansixsigmabydr.sal4884 3 жыл бұрын

You did such a great job. I loved it.

@captainpenny2122 11 ай бұрын

Thank you so much for this videos, it was well planned and really helped me!!!

@aniruddhakulkarni700 3 жыл бұрын

Thank you for this Walter!

@techsutra4917 Жыл бұрын

thanks alot that was such an awesome video to learn basics about sql lite with python

@dexternepo 3 жыл бұрын

At 37:21 he mispronounces tuple as "toople" and then corrects himself after immediately remembering the correct pronunciation. As a non-native speaker of English from India, this brings a smile to my face. Because this is exactly what we do at times. When we learn English from textbooks, we have our pronunciation for some words, and then after watching native speakers pronounce it differently we try to remember the correct pronunciation. But still end up pronuncing it the way we first learned it in spite of knowing the correct way. The word that immediately comes to my mind that I personally mispronounce is "environment".

@MrMoKhalaf 4 ай бұрын

🤣🤣🤣

@selikiekone9975 3 жыл бұрын

You are a champion if you have any python course I will go for it. Thank you for your bright knowledge.

@gabrielade775 2 жыл бұрын

Great hands on course, thank you John

@xxl0o Жыл бұрын

Great course! Thanks a lot!

@conermos 3 жыл бұрын

Thanks so much. This video was very informative and was very well-structured

@marwanrabi5450 Жыл бұрын

What a CrashCourse man!! AWESOME!!

@ariansoltani6079 11 ай бұрын

Thank you for publishing this video and teaching smoothly .....very practical and useful 👌

@utkarshrastogi8791 4 жыл бұрын

Massive respect for these guys

@sambidao88 Жыл бұрын

Thank you! The author made me understand to use Python that do CRUD a database incredibly

@JuanThomasAlvarez 2 жыл бұрын

It would be good to show readonly vs read+write connections to the sqlite3 database file, which comes in handy if you're creating a flask web app which will be used by multiple individuals at once.

@federicobau8651 4 жыл бұрын

Ohh man...it feels so great when understand everything!! I like how you teach really smooth and understandable. Soon I will gotta buy some of your courses

@Meta910 3 жыл бұрын

AMAZING....#just got re-candled again😊

@francescoroccocrisafi6617 4 жыл бұрын

Great tutorial! Thank you for sharing it

@argjendsejfullai8541 3 жыл бұрын

you know i might pass my exam because of you sir , you earn my respect :D

@nickeax 4 жыл бұрын

Thanks for the brilliant guide.

@auusiebatman 2 жыл бұрын

Loved this video, thank you.

@gamesandstuff7724 2 жыл бұрын

Many thanks, great video!

@tehreemqasim2204 2 жыл бұрын

Excellent tutorial. Many thanks for the great videos.

@walternyc 3 жыл бұрын

Thanks. This is an excellent reference video.

@rahulgovindkumar3105 2 жыл бұрын

Thank you for this super helpful video!

@sanjayraj1700 2 жыл бұрын

Thank you John. It was really helpful :)

@i_am_dumb1070 4 ай бұрын

Really easy to follow along course loved the simple explanation thankyou

@Lucaischz 4 жыл бұрын

As far as I know, docstrings aren't the same as triple quote strings. Docstrings are indeed expressed on tripple quote strings, but it means something more specific, which is the on code documentation for classes and functions, actually working as source code comments, but the syntax accepts this particular case because it's industry standard. Edit: also, as far as I know, SQL is case INSENSITIVE, actually, but it's good practice to capitalize reserved words to distinguish it from context defined elements (names, parameters, etc).

@pepijnkrijnsen4 3 жыл бұрын

Six months later but you're absolutely right

@nickjakes8663 2 жыл бұрын

Absolutely fantastic! Thank you

@medimarsh2376 3 жыл бұрын

in spite of all unfair comments, I have to say perfect video. Thanks!!!

@jimcallahan448 2 жыл бұрын

Made sense to me, but that was because I already knew SQL and the SQLite command line. Might be easier to demonstrate SQLite command line and then ask what if we want to do this as part of a larger Python program? At the SQLite command line one can immediately demonstrate the newly created table with: SELECT customers *; If a student asks, why not do everything in SQL? Ask the student, "What if you want to graph the data?" SQL doesn't have matplotlib or even the tools to produce a formatted report. So, Python and SQL (SQLite) make a good team.

@johndoe-rq4gf 3 жыл бұрын

Hi! just a remark: contrary to what you say in the first part, SublimeText is free for evaluation but if you do read the little popup window (or the website) you have to buy a license for continuous usage, it's not a donation, it's a license.

@mr.dineshlee 4 жыл бұрын

Very Easy to Understand this one...🙏🏻

@MullahJeelan Жыл бұрын

You are amazing and you are way of teaching is brilliant and time saving

@vasileantoniupop5476 Жыл бұрын

First helpful tutorial on this topic

@theBATfamiliar 4 жыл бұрын

Thank you guys for sharing

@ilyastrojnov7627 3 жыл бұрын

Thx for video! I think that best way for use database functions is optional args connection, we just create one connection and use it in all functions

@hanasheto1520 2 жыл бұрын

Well done! Thank you so much

@inan5255 5 ай бұрын

thank you for upload this video, very educational.

@tridevjha255 Жыл бұрын

Really helpful Video Made the bridge of knowledge which I needed from a long time One more time thank you

@otabekjunashaliev 2 жыл бұрын

super helpful and understandable, Thanks a lot

@user-hb2ih2hb9g 8 ай бұрын

Thank you for this great course...

@muhamedqasim5390 3 жыл бұрын

this is very cool ,man!

@marcelus4614 5 ай бұрын

Exellent. Thanks !!

@usmantariq5615 2 жыл бұрын

Excellent dude.. Very good course for beginners.

@oqant0424 3 жыл бұрын

truely commendable...thanks a bunch

@prasadnirmal6426 3 жыл бұрын

wow! you are good teacher! it's amazing

@robertopulido9557 3 жыл бұрын

thank you, you make so much easier, i know there it is more ways to do it but i just get confused thank you

@a_b_c_wan_2_33 2 жыл бұрын

This video is incredible.

@waqarfk 4 жыл бұрын

Awesome content Guyz....🔥

@trollgaminaboneol1844 2 жыл бұрын

Just PERFECT!

@TURKISTONIM2 2 жыл бұрын

The best video course i will enrol on 👍👍👍👍👍👍

@jagadeeshkumar7724 Жыл бұрын

He is enjoying himself.. he doesn't want the output to be displayed... What a gamer!!!!!

@Langeta-kun 5 ай бұрын

this was amazing! granted Im a comp sci student and I finished sql and python. But i had no idea what I was doing! This was smooooth(I still had issues btw but I guess that is just SQL)

@ebrahimgholami9277 8 ай бұрын

Thank you John!

@zainabbasmerchant9650 3 жыл бұрын

Better than my college professor thanks a lot ✌

@wwqwqwwsa322 2 жыл бұрын

Thanks so much for all videos

@etlammerker2325 2 жыл бұрын

wow, what a great tutorial!!!

@OlivierSuire 3 жыл бұрын

17:44 it seems to me that databases really start making sense when they are comprised of MULTIPLE tables. I wish you would have touched this subject. Other than that : fantastic video ; it really helped.