|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-sqlite-from-scratch-create-sql-queries/
课程评论：没有评论
课程名称：从零开始学习SQLite：创建SQL查询 课程概述：SQLite是一个内嵌式库，实施自包含、无服务器、零配置的事务性SQL数据库引擎。SQLite的代码属于公有领域，因此可以自由用于任何目的，无论是商业的还是私人使用。SQLite是全球使用最广泛的数据库，应用场景数不胜数，包括多个高知名度的项目。与大多数其他SQL数据库不同，SQLite没有单独的服务器进程，而是直接读取和写入普通的磁盘文件。完整的SQL数据库，包括多个表、索引、触发器和视图，都包含在单个磁盘文件中。SQLite的数据库文件格式是跨平台的，您可以自由地在32位和64位系统之间或在大端和小端架构之间复制数据库。SQLite在每次发布前都会经过严格测试，因而享有很高的可靠性。SQLite的大部分源代码专注于测试和验证，自动化测试套件运行了数百万个测试案例，涉及数亿条个体SQL语句，达成100%的分支测试覆盖率。SQLite能够优雅地响应内存分配失败和磁盘I/O错误。 在本课程中，您将学习如何： - 设置SQLite数据库服务器 - 恢复示例数据库 - 查询数据库 - 创建查询 - 创建数据库表 - 向数据库中插入数据 - 更新数据库中的数据 - 删除数据库中的数据 - 过滤和排序数据 此课程适合希望深入了解SQLite及其操作的学习者，通过实践操作，您将能够熟练使用SQLite数据库。
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is the most widely deployed database in the world with more applications than we can count, including several high-profile projects.SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.SQLite is very carefully tested prior to every release and has a reputation for being very reliable. Most of the SQLite source code is devoted purely to testing and verification. An automated test suite runs millions and millions of test cases involving hundreds of millions of individual SQL statements and achieves 100% branch test coverage. SQLite responds gracefully to memory allocation failures and disk I/O errors. In this course you will learn how to:Setup an SQLite Database ServerHow to restore a sample databaseHow to query databaseHow to create queriesHow to create database tablesHow to insert data into databaseHow to update data in databaseHow to delete data in databaseHow to filter and sort data
