SQLite Databases With Python - Full Course

Channel:
United States freeCodeCamp.org
Subscribers:
10,700,000
Published on ● Video Link: https://www.youtube.com/watch?v=byHcYRpMgI4


Duration: 1:29:37
582,153 views
14,207

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



Other Videos By freeCodeCamp.org


2020-06-02Python for Data Science - Course for Beginners (Learn Python, Pandas, NumPy, Matplotlib)
2020-05-30Deep Learning with PyTorch Live Course - Working with Images & Logistic Regression (Part 2 of 6)
2020-05-28Git and GitHub for Beginners - Crash Course
2020-05-27Project Euler Challenges 13-17 - Coding Challenges with Florin
2020-05-26Android Development for Beginners - Full Course
2020-05-23Deep Learning with PyTorch Live Course - Tensors, Gradient Descent & Linear Regression (Part 1 of 6)
2020-05-21Web Application Ethical Hacking - Penetration Testing Course for Beginners
2020-05-19Spring Boot and Angular Tutorial - Build a Reddit Clone (Coding Project)
2020-05-14Code Tetris: JavaScript Tutorial for Beginners
2020-05-13Project Euler Challenges 5–12 - Coding Challenges with Florin
2020-05-12SQLite Databases With Python - Full Course
2020-05-07Matplotlib Crash Course
2020-05-05Learn the Svelte JavaScript Framework - Full Course
2020-05-03Project Euler Challenges 1–4 - Coding Challenges with Florin
2020-05-02The Oracle Foundations Associate Cloud Certification (PASS THE EXAM) – Full Course
2020-05-01May 2020 Summit - freeCodeCamp.org
2020-04-30PyTorch for Deep Learning - Full Course / Tutorial
2020-04-28Yii2 PHP Framework - Full Course (Build a YouTube Clone)
2020-04-26Build a Brain Computer App with React Native (Part 8) - Live Coding with Jesse
2020-04-23How to Create a Custom WordPress Theme - Full Course
2020-04-21Introduction to Programming and Computer Science - Full Course


Tags:
sqlite
sqlite3
python
python database
sql database
sql
sqlite database