Summary and Highlights: Creating Tables and Loading Data总结与要点：建表与加载数据

Congratulations! You have completed this lesson. At this point, you know that:
恭喜！您已完成本课程。此时，您已经知道：

• DDL (Data Definition Language) statements, such as CREATE, ALTER, and DROP, are used for defining, modifying, and deleting objects in a database, like tables and their attributes.
  DDL（数据定义语言）语句，如 CREATE、ALTER 和 DROP，用于定义、修改和删除数据库中的对象，例如表及其属性。
• When creating tables, key considerations involve selecting a schema, defining columns with names, datatypes, and optional values like primary key constraints, and referencing an Entity Relationship Diagram (ERD).
  创建表时，关键考虑因素包括选择模式、定义具有名称、数据类型和可选值（如主键约束）的列，并参考实体关系图（ERD）。
• Methods for creating tables include using visual interfaces like the Db2 on Cloud console, SQL statements, and administrative APIs.
  创建表的方法包括使用可视化界面，如云上的 Db2 控制台、SQL 语句和管理 API。
• Post-creation actions may include generating SQL code, modifying table structure, exploring dependencies, and dropping the table if necessary.
  创建后的操作可能包括生成 SQL 代码、修改表结构、探索依赖关系，并在必要时删除表。
• Data manipulation involves DML (Data Manipulation Language) statements for working with data within tables, such as inserting, updating, deleting, or querying records.
  数据操作涉及使用 DML（数据操作语言）语句在表中处理数据，例如插入、更新、删除或查询记录。
• Data movement tasks include populating databases initially, adding or appending data, making copies for development tests or disaster recovery, and ensuring scalability.
  数据迁移任务包括初始填充数据库、添加或追加数据、为开发测试或灾难恢复制作副本，并确保可扩展性。
• Utilities like BACKUP and RESTORE are used to create and recover copies of entire databases, including tables, views, constraints, and their data.
  BACKUP 和 RESTORE 等工具用于创建和恢复整个数据库的副本，包括表、视图、约束及其数据。
• The IMPORT utility facilitates inserting data into tables from different formats like DEL/CSV, ASC, and IXF, while the EXPORT utility saves table data into various formats like CSV.
  IMPORT 实用程序用于从 DEL/CSV、ASC 和 IXF 等不同格式将数据插入表中，而 EXPORT 实用程序则将表数据保存为 CSV 等多种格式。
• LOAD utilities enable high-performance insertion of large volumes of data into specified tables, offering quicker and more efficient data loading compared to multiple INSERT statements.
  LOAD 实用程序能够将大量数据高效地插入指定表中，与多个 INSERT 语句相比，提供更快、更高效的数据加载。
• Loading data can be done from various sources, including delimited text files and Cloud Object Storage, and can be managed through user-friendly interfaces like the Load Data utility in the Db2 Web Console.
  数据加载可以从多种来源进行，包括分隔文本文件和云对象存储，并且可以通过用户友好的界面（如 Db2 Web 控制台中的加载数据实用程序）进行管理。