Dive into a comprehensive video course on using SQLite databases with Python, designed for those with basic Python knowledge but no prior database experience. Learn to create databases and tables, add and manipulate data, generate reports, and execute specific queries. Master essential concepts like connecting to databases, creating tables, inserting records, using primary keys, implementing WHERE clauses, updating and deleting records, ordering results, and more. Follow along as the instructor builds a practical application, demonstrating how to implement various database functions. By the end of this 1-2 hour tutorial, gain the skills to effectively work with SQLite3 in your Python projects.
Overview
Syllabus
) What Is A Database.
) Install Python.
) Install Git Bash Terminal.
) Connect to Database in Python.
) Create A Table.
) Insert One Record Into Table.
) Insert Many Records Into Table.
) Query and Fetchall.
) Format Your Results.
) Primary Key.
) Use The Where Clause.
) Update Records.
) Delete Records.
) Order Results.
) And/Or.
) Limiting Results.
) Delete (Drop) A Table And Backups.
) Unit 18 Our App - Show All Function.
) Unit 19 Our App - Add A Record Function.
) Unit 20 Our App - Delete a Record Function.
) Unit 21 Our App - Add Many Records Function.
) Unit 22 Our App - Where Clause Function.
Taught by
freeCodeCamp.org
Related Courses
-
110+ Exercises - Python + SQL (sqlite3) - SQLite Databases
-
Learn PostgreSQL Tutorial - Full Course for Beginners
5.0 -
Using Databases in Python Course (How To)
-
Django Project – Code a CRM App Tutorial
-
Databases with Python: MySQL, SQLite & MongoDB with Python
-
Databases and SQL for Data Science with Python
2.0
Related articles
Reviews
4.5 rating, based on 2 Class Central reviews
-
Youssef Elia GhattasI recently completed an SQLite course, and I am thoroughly impressed with the experience! The course was well-structured, starting from the basics and gradually moving into more advanced topics. The instructor was knowledgeable and explained the con… -
The content is very helpfull as I'm a beginner. The teacher is cool and very clear. May be, it would be nice if the content can talk about over functions like index or trigger.
