|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-engineerdba-mysql-mongodb-sqlite/
课程评论：没有评论
课程名称：数据库工程师/数据库管理员 - (MySQL, MongoDB, SQLite) 课程概述： 本课程将带您深入了解世界上最受欢迎的开源数据库——MySQL。您将学习如何使用MySQL，并在实践中掌握有用的技能。通过学习MySQL，您还将对关系数据库有更全面的理解。课程中，您将学习结构化查询语言（SQL），并通过大量的实际操作建立数据库，填充数据并对数据进行查询。 除了MySQL，本课程还涵盖MongoDB，这是一个面向文档的数据库管理系统（DBMS），其数据模型由类似JSON的对象组成，而不是传统的关系数据库表。MongoDB不支持联接和事务，但有二级索引、表达性的查询语言、文档级原子写入和完全文本一致性读取的特性。MongoDB使用动态模式，允许在定义文档结构（即字段或其值类型）之前创建集合，并可以通过添加新字段或删除现有字段来改变文档结构。 此外，课程还介绍SQLite，是一个提供关系数据库管理系统的轻量级软件库。SQLite不需要服务器即可运行，简化了安装和管理过程。使用SQLite，您无需安装任何服务器进程，也不需要进行配置。SQLite使用动态类型的表格，意味着可以在任何列中存储任何值，而不受数据类型的限制。SQLite是自包含的，仅需最少的操作系统或外部库支持，使其适用于各种环境，尤其是在嵌入式设备中，如iPhone、安卓手机、游戏机等。它还可以创建内存数据库，具有极高的速度，并与访问数据库的应用程序直接集成。 通过本课程，您将获得关于MySQL、MongoDB和SQLite这三种数据库的广泛而深入的理解，并掌握建筑和管理现代数据库所需的技能。
The MySQL is the world's most popular open source database.This course will teach you a lot to start using this incredibly popular MySQL database and gain useful skills in the process. In learning about MySQL you will also gain an understanding of relational databases in general. Furthermore, you will harness that power by learning SQL and using it to build databases, populate them with data and query that data through extensive hands-on practices.MongoDB is a document-oriented DBMS, with JSON-like objects comprising the data model, rather than RDBMS tables. MongoDB does not support joins nor transactions. However, it features secondary indexes, an expressive query language,atomic writes on a per-document level, and fully-consistent reads. MongoDB uses JSON, a binary object format similar to, but more expressive than JSON..MongoDB uses dynamic schema. We can create collections without defining the structure,i.e. the fields or the types of their values, of the documents. You can change the structure of documents simply by adding new fields or deleting existing ones. Documents in a collection need unique set of fields.MongoDB database stores its data in collections not in tables The collections are the rough equivalent of RDBMS tables. A collection holds one or more documents, which corresponds to a record or a row in a relational database table, and each document has one or more fields, which corresponds to a column in a relational database table.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.
