SQLite Databases | Python Programming: (Build App and API )

SQLite 是一个提供关系数据库管理系统的软件库。SQLite 中的 lite 意味着在设置、数据库管理和所需资源方面的轻量级。SQLite 不需要服务器来运行。

由于无服务器架构，您无需在使用前“安装”SQLite。没有需要配置、启动和停止的服务器进程。SQLite 对表使用动态类型。这意味着您可以在任何列中存储任何值，而不管数据类型如何。

SQLite 是自包含的，这意味着它需要来自操作系统或外部库的最少支持。这使得 SQLite 可以在任何环境中使用，尤其是在 iPhone、Android 手机、游戏机、手持媒体播放器等嵌入式设备中。

SQLite 能够创建运行速度非常快的内存数据库。

SQLite 数据库与访问数据库的应用程序集成在一起。应用程序与 SQLite 数据库交互，直接从存储在磁盘上的数据库文件读取和写入。

Python 是一种动态的现代面向对象编程语言，易于学习，可用于做很多大大小小的事情。Python 是所谓的高级语言。这意味着它是一种比计算机更接近人类的语言。由于其灵活性，它也被称为通用编程语言。

Python 是一种流行且通用的编程语言。它可用于 Web 开发（服务器端）创建 Web 应用程序、软件开发、数学、系统脚本、数据科学、数据可视化。Python 可以与软件一起使用来创建工作流。Python 可以连接到数据库系统。它还可以读取和修改文件。Python 可用于处理大数据和执行复杂的数学运算。Python 可用于快速原型设计，或用于生产就绪的软件开发。

Python 适用于不同的平台（Windows、Mac、Linux、Raspberry Pi 等）。 Python 具有类似于英语的简单语法。Python 的语法允许开发人员用比其他一些编程语言更少的行数来编写程序。Python 在解释器系统上运行，这意味着代码可以在编写后立即执行。这意味着原型制作可以非常快。可以以过程方式、面向对象方式或函数方式处理 Python。

在这个实践课程中，我们将使用 SQLite 和 Python 从 scrtach 构建一个数据库驱动的应用程序和一个 API。

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 94 lectures (9h 34m) | Size: 1.96 GB
Learn SQLite | Python : Build a database driven app and API with Python and SQLite

What you’ll learn:
Build an app with Python and SQLIte
Build an API from scratch
Create and activate a virtual environment
Create database and table
Create application Graphical User Interface -GUI
Connect Python application GUI to SQLite Database
Perform CRUD Operations from app GUI
Query and fetch data from a database table
Sort data returned from a database
SQLite Operators
Add new records into a table
Python Variables and Conditional Statements
Python Functions and Loops
Python Dictionary and Lists

Requirements
A Computer with internet connection is required.

Description
SQLite is a software library that provides a relational database management system. The lite in SQLite means light weight in terms of setup, database administration, and required resource. SQLite does NOT require a server to run.

Because of the serverless architecture, you don’t need to “install” SQLite before using it. There is no server process that needs to be configured, started, and stopped. SQLite uses dynamic types for tables. It means you can store any value in any column, regardless of the data type.

SQLite is self-contained means it requires minimal support from the operating system or external library. This makes SQLite usable in any environments especially in embedded devices like iPhones, Android phones, game consoles, handheld media players, etc.

SQLite is capable of creating in-memory databases which are very fast to work with.

SQLite database is integrated with the application that accesses the database. The applications interact with the SQLite database read and write directly from the database files stored on disk.

Python is a dynamic modern object -oriented programming language that is easy to learn and can be used to do a lot of things both big and small. Python is what is referred to as a high level language. That means it is a language that is closer to humans than computer. It is also known as a general purpose programming language due to it’s flexibility.

Python is a popular and versatile programming language. It can be used for web development (server-side) to create web applications , software development, mathematics, system scripting, data science, data visualization. Python can be used alongside software to create workflows. Python can connect to database systems. It can also read and modify files. Python can be used to handle big data and perform complex mathematics. Python can be used for rapid prototyping, or for production-ready software development.

Python works on different platforms (Windows, Mac, Linux, Raspberry Pi, etc).Python has a simple syntax similar to the English language. Python has syntax that allows developers to write programs with fewer lines than some other programming languages. Python runs on an interpreter system, meaning that code can be executed as soon as it is written. This means that prototyping can be very quick. Python can be treated in a procedural way, an object-oriented way or a functional way.

In this practical hands on course we will build a database driven application and an API from scrtach with SQLite and Python.

Who this course is for
Beginners to SQLIte Databases
Beginners to Python
Beginners to API Development