|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/querying-databases-with-sql-and-nosql-postgresql-mongodb/
课程评论：没有评论
课程名称：用SQL和NoSQL查询数据库：PostgreSQL与MongoDB 课程概述：数据库在构建应用程序中至关重要，它们存储使应用程序正常工作的数据。数据库查询是请求数据库数据以检索或操作数据的过程。高层次来看，查询就是一个问题。无论是与他人交流还是进行数据库查询，期望都是得到某种答案。数据库查询通常与创建（Create）、读取（Read）、更新（Update）和删除（Delete）等基本操作密切相关，它允许我们通过获取的响应信息执行逻辑操作。 数据库是一个有组织的结构化信息集合，通常以电子方式存储在计算机系统中，通常由数据库管理系统（DBMS）控制。数据与DBMS及相关应用程序的组合被称为数据库系统。当前最常用的数据库通常以表格的行和列的形式组织数据，以提高处理和查询的效率，从而实现数据的访问、管理、修改和控制。 大多数数据库使用结构化查询语言（SQL）来编写和查询数据。SQL是一种编程语言，几乎所有的关系型数据库都使用它来查询、操作和定义数据，并提供访问控制。SQL最初是在1970年代由IBM开发的，Oracle是其重要贡献者之一，形成了SQL ANSI标准。尽管SQL仍然被广泛使用，但新的编程语言正在逐渐出现。 关系型数据库在1980年代成为主流，数据以表格的形式组织，提供了访问结构化信息的高效且灵活的方式。与关系型数据库不同，NoSQL（非关系型数据库）允许存储和操作非结构化和半结构化数据。随着Web应用程序的普及和复杂化，NoSQL数据库逐渐流行。 PostgreSQL是一个强大的开源对象-关系型数据库系统，它使用并扩展了SQL语言，具有许多特性，能安全地存储和扩展复杂的数据工作负载。MongoDB是一个基于横向拓展架构的开源文档数据库，使用灵活的架构来存储数据。 此课程将带领学员深入了解如何利用SQL和NoSQL的特性进行数据库查询和管理。
Databases are crucial to building applications. They store data that make our applications work like they should. A database query is a request for a database's data so we can retrieve or manipulate it. At a very high level, a query is a question. When we talk about queries in relation to other people, we expect some sort of answer in return. This is no different for computers when we perform database queries.A database query is a similar action that is most closely associated with some sort of CRUD (create, read, update, delete) function. A database query is a request to access data from a database to manipulate it or retrieve it. This allows us to perform logic with the information we get in response to the query.A database is an organized collection of structured information, or data, typically stored electronically in a computer system. A database is usually controlled by a database management system (DBMS). Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database.Data within the most common types of databases in operation today is typically modeled in rows and columns in a series of tables to make processing and data querying efficient. The data can then be easily accessed, managed, modified, updated, controlled, and organized. Most databases use structured query language (SQL) for writing and querying dataSQL is a programming language used by nearly all relational databases to query, manipulate, and define data, and to provide access control. SQL was first developed at IBM in the 1970s with Oracle as a major contributor, which led to implementation of the SQL ANSI standard, SQL has spurred many extensions from companies such as IBM, Oracle, and Microsoft. Although SQL is still widely used today, new programming languages are beginning to appear.Relational databases became dominant in the 1980s. Items in a relational database are organized as a set of tables with columns and rows. Relational database technology provides the most efficient and flexible way to access structured information.A NoSQL, or nonrelational database, allows unstructured and semi structured data to be stored and manipulated (in contrast to a relational database, which defines how all data inserted into the database must be composed). NoSQL databases grew popular as web applications became more common and more complex.PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.MongoDB is an open-source document database built on a horizontal scale-out architecture that uses a flexible schema for storing data.SQL stands for Structured Query LanguageSQL lets you access and manipulate databases.
