|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-loader/
课程评论：没有评论
**课程名称：22个示例学SQL Loader** **课程概述：** SQL Loader是Oracle数据库的强大实用工具，用于将大量数据高效且灵活地加载到Oracle数据库中。本课程将通过21多个实例，深入讲解SQL Loader的功能和使用方法。学员将学习如何从固定宽度文件、分隔符数据以及多种其他数据格式加载数据，还能掌握选择性加载、数据转换、直接路径加载、加载大型对象和集合以及性能优化等关键技能。 **核心学习内容：** * 理解SQL Loader的功能 * 加载固定宽度文件数据 * 加载分隔符数据 * 加载多种其他数据格式 * 选择性加载数据 * 在加载过程中转换数据 * 实现直接路径加载 * 加载大型对象 (LOBs) * 加载对象和集合 * 掌握性能优化技巧
SQL Loader is an Oracle Utility that's been around almost as long as the Oracle database itself. It is an efficient and flexible tool that you can use to load large amounts of data into an Oracle database. In simple terms, SQL Loader reads the data from flat files and inserts the data into one or more database tables. If you would like to learn about SQL Loader, you have landed in the right course!!! This course explains the concepts using 21+ Examples, what else can you expect? Students will be learning the below skills: Understand the functionality of SQL LoaderLoad data from Fixed Width files, Delimited Data and many other data format types.Selectively loading the dataTransforming the data during LoadDirect Path LoadsLoading Large objectsLoading Objects and CollectionsPerformance tips...
