|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/building-bulk-sql-queries-with-excel-sql-oracle-toad/
课程评论：没有评论
课程名称：《使用Excel、SQL、Oracle和TOAD构建大批量SQL查询》 课程概述： SQL是一种特定领域的编程语言，用于管理关系数据库管理系统中的数据或在关系数据流管理系统中进行流处理。SQL代表结构化查询语言。通过SQL，用户可以访问和操纵数据库。自1986年起，SQL成为美国国家标准协会（ANSI）的标准，1987年成为国际标准化组织（ISO）的标准。 SQL的主要功能包括： - 执行数据库查询 - 从数据库中检索数据 - 向数据库插入记录 - 更新数据库中的记录 - 删除数据库中的记录 - 创建新数据库 - 在数据库中创建新表 - 创建存储过程 - 创建视图 - 为表、过程和视图设置权限 尽管SQL是ANSI/ISO标准，但不同版本的SQL语言存在。因此，虽然它们都支持主要命令（如SELECT、UPDATE、DELETE、INSERT、WHERE），但在具体实现上可能存在差异。此外，大多数SQL数据库程序也有自己的专有扩展。 查询是从一个或多个数据库表请求数据或信息的过程。这些数据可以通过SQL产生的结果返回，也可以作为图形、图表或复杂结果（例如，数据挖掘工具中的趋势分析）来生成。 在本课程中，您将学习如何使用SQL和Excel构建大批量的SQL查询。
SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. SQL stands for Structured Query Language. SQL lets you access and manipulate databases.SQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987 What Can SQL do? SQL can execute queries against a databaseSQL can retrieve data from a databaseSQL can insert records in a databaseSQL can update records in a databaseSQL can delete records from a databaseSQL can create new databasesSQL can create new tables in a databaseSQL can create stored procedures in a databaseSQL can create views in a databaseSQL can set permissions on tables, procedures, and viewsSQL is a Standard - Although SQL is an ANSI/ISO standard, there are different versions of the SQL language.However, to be compliant with the ANSI standard, they all support at least the major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar manner.Note: Most of the SQL database programs also have their own proprietary extensions in addition to the SQL standard!A query is a request for data or information from a database table or combination of tables. This data may be generated as results returned by Structured Query Language (SQL) or as pictorials, graphs or complex results, e.g., trend analyses from data-mining tools. In this course you will learn how to use SQL and Excel to build bulk SQL queries.
