SQLite Databases With Python - Full Course

Veröffentlicht am: 12 Mai 2020
auf dem Kanal: freeCodeCamp.org

779,906

17k

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

🎥Course created by Codemy.com. Check out their YouTube channel: / codemycom

❤️ Try interactive Python courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Python (Made possible by a grant from our friends at Scrimba)

⭐️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_cent...

Auf dieser Seite können Sie das Online-Video SQLite Databases With Python - Full Course mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer freeCodeCamp.org 12 Mai 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 779,906 Mal angesehen und es wurde von 17 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!