|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sqlite-for-beginners/
课程评论：没有评论
课程名称：SQLite入门 课程概述：本课程为您提供SQLite的简要概述，并介绍SQLite的独特功能，使其成为最广泛部署的SQL数据库引擎之一。SQLite是一个软件库，提供关系数据库管理系统，其“lite”之意在于在设置、数据库管理和所需资源方面的轻量级特性。SQLite不需要服务器来运行，因而您无需在使用前“安装”它，无需配置、启动和停止服务器进程。SQLite为表格使用动态类型，意味着您可以在任何列中存储任何值，无论数据类型如何。SQLite的自给自足特性要求操作系统或外部库的支持最小，使其在嵌入式设备（如iPhone、Android手机、游戏机、手持媒体播放器等）中可用。 本课程将涵盖以下内容： - 数据库概念 - 下载和安装SQLite - 了解SQLite Studio - 连接样本数据库到SQLite - 如何连接SQLite数据库 - 一些基本的SQLite命令 - 常用的sqlite3命令 - SQLite Dump命令 - sqlite3工具简介 - SQLite SELECT语句 - 查询表中所有列的数据 - 查询特定列的数据 - 使用ORDER BY子句排序数据 - 使用DISTINCT子句移除重复记录 - 使用WHERE子句过滤数据 - 识别NULL值 - SQLite数据类型 - SQLite约束 - SQLite创建表语句 - SQLite插入数据语句 - SQLite更新数据语句 - SQLite删除数据语句 - SQLite删除表语句 - BETWEEN运算符 - IN运算符 - LIMIT子句 - LIKE运算符 - GLOB运算符 - 子查询 - 在WHERE子句中构建子查询 - 使用IN运算符在WHERE子句中构建子查询 - 在FROM子句中构建子查询 - SQLite表连接 - LEFT连接 - INNER连接 - CROSS连接 - SELF连接 - 别名 - SQLite聚合函数 - SQLite聚合函数介绍 - AVG函数 - COUNT函数 - SUM函数 - MAX函数 - MIN函数 - GROUP_CONCAT函数 - GROUP BY子句 - HAVING子句 通过本课程，您将掌握SQLite的基本概念和操作，为进一步的数据库学习打下坚实基础。
This course gives you a brief overview of SQLite and the SQLite's distinctive features that make SQLite one of the most widely deployed SQL database engine.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.What You will learn includes:Database Concepts Download and Install SQLiteWhat is SQLite Studio Attaching Sample Database to SQLiteHow to connect to SQLite DatabaseSome Basic SQLite CommandsSome commonly used sqlite3 commandsSQLite Dump commandWhat is sqlite3 toolSQLite SELECT statementQuerying data from all columns in a tableQuerying data from specific columns in a tableSorting data using ORDER BY clauseRemoving duplicate records using DISTINCT clauseFiltering data with WHERE clauseIdentifying NULL valuesSQLite Data TypesSQLite ConstraintsSQLite Create Table Statement SQLite INSERT INTO Table StatementSQLite UPDATE StatementSQLite DELETE StatementSQLite DROP Table StatementSQLite BETWEEN OperatorSQLite IN OperatorSQLite LIMIT clauseSQLite LIKE operatorSQLite GLOB OperatorSQLite SubqueryBuilding a subquery in a WHERE clauseBuilding a subquery in a WHERE clause using IN operatorBuilding a subquery in FROM clauseSQLITE Table JoinsSQLite LEFT JoinSQLite INNER JoinSQLite CROSS JoinSQLite SELF JoinSQLite ALiasesSQLite Aggregate FunctionsIntroduction to SQLite Aggregate FunctionsSQLite AVG FunctionSQLite COUNT FunctionSQLIte SUM FunctionSQLite MAX FunctionSQLite MIN FunctionSQLite GROUP_ CONCAT FunctionSQLite GROUP BY ClauseSQLite HAVING Clause
