SQLite Databases With Python – Full Course




[ad_1]

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: https://github.com/flatplanet/Intro-To-TKinter-Youtube-Course

🎥Course created by Codemy.com. Check out their YouTube channel: https://www.youtube.com/c/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: https://www.freecodecamp.org

Read hundreds of articles on programming: https://freecodecamp.org/news

And subscribe so you don’t miss any tutorials: https://youtube.com/subscription_center?add_user=freecodecamp

Source


[ad_2]

Comment List

  • freeCodeCamp.org
    December 18, 2020

    Hey everyone, creator of the video here. If you enjoyed this free course, check out my website Codemy.com and consider subscribing to my Youtube channel for tons more coding content!
    ✅ Subscribe To My YouTube Channel: http://bit.ly/2IGzvOR
    ▶️ Check Out My Website: https://Codemy.com

  • freeCodeCamp.org
    December 18, 2020

    Programmable chemical amphetamin isotopes is a new format developed by the real Walter White. His latest working computer ml some of his best results, "the Heisenberg code" they even have developed a cpu chip that does the drugs it creates allows it run on 0.volts and perform 30% better Programmable chemical amphetamin isotopes . This new format by Walter White is really some of his best work results, "the Heisenberg code" they even have developed a cpu chip that does the drugs it creates allows it run on 0.volts and performance to increase 30%

  • freeCodeCamp.org
    December 18, 2020

    HELP! I'm on Step Connect Database to Python 1:12:40

    When I type python database.py it says Permission denied.

  • freeCodeCamp.org
    December 18, 2020

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

  • freeCodeCamp.org
    December 18, 2020

    1:26:18 Please anyone explain why there is a comma after email in that tuple?

  • freeCodeCamp.org
    December 18, 2020

    This is SQL course 😂

  • freeCodeCamp.org
    December 18, 2020
  • freeCodeCamp.org
    December 18, 2020

    The dislikes are from the flat earthers.

  • freeCodeCamp.org
    December 18, 2020

    Didn't know Windows 7 still existed.. 😀

  • freeCodeCamp.org
    December 18, 2020

    he seems not very good at explanations! I do not understand all what he says and he skips things that makes it more confusing……well, he may be a good programmer, who knows, but not all people can be good teachers even they try to!

  • freeCodeCamp.org
    December 18, 2020

    Is sublime text completely free?

  • freeCodeCamp.org
    December 18, 2020

    I'd give your video one additional like for each 'Boom', if only I could. That really makes me fill like I'm a computer overlord, easily manipulating the conservative machine.

  • freeCodeCamp.org
    December 18, 2020

    If you are given a sqlite3 database. How do you analyse/scan this database to know how many tables are in there and how many columns and rows are in each table? Thanks for anyone who helps.

  • freeCodeCamp.org
    December 18, 2020

    "DROP TABLE" wasn't even highlighted red like other commands, because it is no biggy 😂

  • freeCodeCamp.org
    December 18, 2020

    Note: 53:12

  • freeCodeCamp.org
    December 18, 2020

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

  • freeCodeCamp.org
    December 18, 2020

    anyone know why my git bash doesn't want to show anything? my visual studio code outputs perfectly but for some reason git bash won't.

  • freeCodeCamp.org
    December 18, 2020

    Thanks for this video

  • freeCodeCamp.org
    December 18, 2020

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

  • freeCodeCamp.org
    December 18, 2020

    Thanks Mr White

  • freeCodeCamp.org
    December 18, 2020

    John the tech HULK:)

  • freeCodeCamp.org
    December 18, 2020

    I have learnt SO much from Codemy, and freecodecamp!!! Thank you guys a lot!

  • freeCodeCamp.org
    December 18, 2020

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

  • freeCodeCamp.org
    December 18, 2020

    Update records

  • freeCodeCamp.org
    December 18, 2020

    the executemany is giving me binding error

  • freeCodeCamp.org
    December 18, 2020

    Thank you for this Walter!

  • freeCodeCamp.org
    December 18, 2020

    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".

  • freeCodeCamp.org
    December 18, 2020

    at 1:26:15
    took me half a day to understand that little "quirk" of comma in "(email,)"
    and found out that it is also possible to write "[email]" as both cases returns an iterable.

  • freeCodeCamp.org
    December 18, 2020

    Is there any other part of the course??
    ps: This one was really cool I did follow till the very end.

Write a comment