|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/db2-sql-for-beginners/
课程评论：没有评论
课程名称：DB2 SQL初学者课程 概述： DB2是IBM推出的一系列数据库管理系统（DBMS）产品，适用于多种操作系统平台，广泛应用于各规模的组织。DB2提供一个数据平台，支持事务处理和分析操作，确保数据的持续可用性，从而高效运行事务工作流和分析。DB2数据库具备逻辑结构和物理结构，DBMS分别管理这两种结构。物理数据存储的管理不会影响对逻辑存储结构的访问。 DB2数据库通过数据定义语言（DDL）命令创建，包含表空间、行和列的表、视图、索引、存储过程及其他支持结构。一旦创建，数据库管理员（DBA）或开发人员可以利用DB2数据库及其基础结构进行数据的创建、读取、更新和删除，以满足组织的业务需求。 SQL是一种特定领域的编程语言，旨在管理关系数据库管理系统中的数据或在关系数据流管理系统中进行流处理。SQL代表结构化查询语言，它允许用户访问和操作数据库。SQL于1986年成为美国国家标准协会（ANSI）的标准，并于1987年成为国际标准化组织（ISO）的标准。 SQL的功能包括： - 执行针对数据库的查询 - 从数据库中检索数据 - 在数据库中插入记录 - 更新数据库中的记录 - 从数据库中删除记录 - 创建新数据库 - 在数据库中创建新表 - 创建存储过程 - 创建视图 - 设置表、过程和视图的权限 此课程为初学者提供了关于使用DB2和SQL进行数据库管理的基础知识，适合希望掌握数据库操作技能的学习者。
Db2 is a family of database management system (DBMS) products from IBM that serve several different operating system (OS) platforms. Used by organizations of all sizes, Db2 provides a data platform for both transactional and analytical operations, as well as continuous availability of data to keep transactional workflows and analytics operating efficiently.Db2 databases have logical structures and physical structures which the DBMS manages separately. The physical storage of data can be managed without affecting the access to logical storage structures. Db2 databases are created using Data Definition Language, or DDL, commands and are composed of tablespaces, tables with rows and columns, views, indexes, stored procedures and other supporting structures.Once created, a DBA or developer can use a Db2 database and its underlying structures to create, read, update and delete data to support an organization's business requirements.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 databasesSQL became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987What 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 views
