|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/creating-and-querying-databases-with-nosql-and-sql/
课程评论：没有评论
课程名称：使用NoSQL和SQL创建和查询数据库 课程概述：随着数据的增长，NoSQL（非SQL或不仅仅是SQL）数据库越来越受到关注，因为它们能够在超大规模上存储非关系数据，并解决常规数据库无法处理的问题。这些数据库在大数据操作中广泛应用，其主要优势在于有效处理大数据集以及应对现代应用所需的可扩展性和灵活性。NoSQL数据库有不同的种类，广泛应用于社交媒体（如Facebook）、搜索引擎（如Google）以及健康、航空、教育等多个领域。 在本课程中，我们将使用Couch DB NoSQL数据库。您将学习如何创建数据库、加载数据并进行查询，掌握使用JavaScript进行查询的技巧，包括处理嵌套数据和创建视图。此外，您还将学习如何使用JavaScript的Map和Reduce函数在没有SQL的情况下查询数据库，以及使用键值对插入数据到数据库中。课程中，我们会强调数据库的安全性和完整性，面对日益增长的数据量，保证数据的正确性尤为重要。 基于结构化查询语言（SQL）的知识是与关系数据库管理系统（如Microsoft SQL Server、Oracle、PostgreSQL、MySQL等）进行交互的标准语言。本课程还将讲解SQL的基础知识和Transact-SQL（T-SQL），因为两者在某些指令上是相同的。您将学习如何创建数据库和数据表，插入数据以及查询数据库表中的数据。 通过本课程，您将获得有关NoSQL和SQL数据库的基本理解和实践技能，为以后的数据管理和分析打下坚实的基础。
NoSQL (Non-SQL or Not-only-SQL) databases are increasing in popularity due to the growth of data as they can store non-relational data on a super large scale, and can solve problems regular databases can't handle. They are widely used in Big data operations. Their main advantage is the ability to handle large data sets effectively as well as scalability and flexibility issues for modern applications. There are different categories of NoSQL databases and they are used in social media such as with Facebook and search like Google and in other types of sectors like Health, Aviation, Education and other areas.In this course we will Use the Couch DB NoSQL database. We will create a database, load data and query a database. Learn techniques such as querying with JavaScript, working with nested data, and creating views. You will learn how to query a database without SQL by using JavaScript Map and Reduce functions Using the couch DB database you will learn how to insert data into the database using Key -Value pairs where every data key will have a corresponding value. Security and integrity of a database is very important . The volume of data available is huge and increasing daily. Structured Query Language -SQL (pronounced as sequel) is the standard language used to communicate and interact with data stored in relational management database systems like Microsoft SQL Server Oracle, PostgreSQL, MySQL etc.Different database management systems have their own proprietary version of the SQL language but they all conform to using some commands in SQL the same way. Microsoft SQL Server's version of SQL is known as Transact-SQL (T-SQL). In this course you will learn the basics of the SQL language and Transact-SQL since both use certain commands in the same way. We will learn to create a database, table and how to insert data into a database table as well as querying it.
