|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sqlite-for-beginners-learn-sql-from-scratch/
课程评论：没有评论
**Coursera 课程总结：SQLite 入门 - 从零开始学习 SQL** 本课程是学习 SQLite 的终极指南，旨在帮助您掌握这款功能强大、简洁高效的无服务器数据库系统。SQLite 因其小巧、快速、可靠的特性，在浏览器、嵌入式系统和移动设备领域备受欢迎。 **SQLite 的独特优势：** * **起源与设计：** 由 D. Richard Hipp 于 2000 年为导弹驱逐舰设计，无需安装数据库管理系统或数据库管理员即可运行。 * **多项优势：** * **动态类型（Manifest typing）：** 数据类型是值的属性，而非列的属性，增加了灵活性。 * **可读性强的源代码：** 注释和解释清晰，易于理解。 * **零配置：** 无需多次安装或复杂设置。 * **无服务器：** 直接从数据库文件运行，无需独立服务器。 * **可变长度记录：** 仅占用存储信息所需的磁盘空间，开销极小。 * **单一数据库文件：** 所有数据存储在一个普通磁盘文件中，易于管理和迁移。 * **稳定的跨平台数据库文件：** 在一个平台上创建的数据库文件可在不同架构的机器上使用。 * **SQL 语言扩展：** 提供如 EXPLAIN 关键字和动态类型等增强功能。 * **公共领域：** 免费使用和修改。 **课程内容概览：** 本课程将从基础知识出发，详细讲解 SQLite 的方方面面，帮助您不仅了解其概念和工作原理，更能熟练掌握所有必要的功能和关键词，成为一名专业的 SQLite 用户。 **学习重点：** * SQLite 的安装与配置。 * 基本 SQL 命令的学习和实践。 * 深入理解和应用约束（constraints）、连接（joins）和子查询（subqueries）。 * 复杂命令的使用，数据和表的操纵。 * 生成报表。 完成本课程后，您将全面掌握 SQLite 的使用，并能自信地进行数据管理和分析。
The ULTIMATE course for learning SQLite from scratch is finally here! Boost your database skills with this one of a kind severless database system. SQLite is a unique database for embedded systems and is currently the most popular database on the market for browsers, embedded systems and even mobile phones. Easily summed up in three words, SQL is small, fast and reliable. SQLite was designed by D. Richard Hipp in 2000 for an aboard guided missile destroyers that needed the program to be operated without installing a database management system or requiring a database administrator. It comes with numerous benefits over traditional relational database systems such as: Manifest typing - SQL uses Manifest typing instead of static typing, which makes datatypes a property of the value itself, and not of the column in which the value is stored. Readable source code - Codes in SQLite are commented and explained extremely well making the language quite readable. Zero-Configuration - SQLite does not need to be installed multiple times and neither does it require any setup. Serverless - SQL runs directly from the database files, without requiring a dedicated server. Variable-length records - SQLite uses only the amount of disk space needed to store the information in a row, with very little overheads. Single Database File - SQLite runs on a single ordinary disk file and does not need multiple files. It can also read all the files from the database it runs on. Stable Cross-Platform Database File - A database file written on one machine can be copied to and used on a different machine with a different architecture. SQL language extensions - It offers multiple enhancements to the SQL language that are not found in other database engines such as EXPLAIN keywords and Manifest typing language. Public domain - SQLite is in the public domain, which means it is free of cost to use and manipulate as one sees fit. This tutorial is the perfect resource to learn SQLite. We will breakdown the database from start to end to help you not only learn what it is and how it works, but instead master all the functions and keywords you need to become a professional. The course will give you a detailed introduction and will help you progress from installing the system to learning the different important commands that are required to work with the database. You will also learn about constraints, joins and subqueries with detailed examples. At the end of this course, you will not only be familiar with SQLite but also how you can install it, work complex commands, generate a report and even manipulate data and tables. Enroll now to get started with this amazing ‘lite' serverless database engine!
