|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-12c-cloud-advanced-sql-hands-on/
课程评论：没有评论
课程名称：Oracle 12 Cloud: 高级SQL/PLSQL实践 课程概述：Oracle SQL 是任何Oracle专业人士所需的重要技能。在本课程中，我们将深入探讨在Oracle Database 12c环境中使用SQL编码的高级方面。课程内容包括与数据库并发事务相关的关键主题、Oracle特定的模式对象（如索引和PL/SQL过程、函数与包）以及表分区等。 课程内容包括但不限于： - 设置Oracle Database 12c环境 - 编写子查询和内联视图 - 创建表索引以提升查询性能 - 使用Oracle数据字典 - 数据库事务管理 - 创建序列和触发器 - 表分区的好处，使用列表、范围和哈希分区 掌握Oracle SQL和PL/SQL相关技能、性能调优、数据库管理、数据建模以及理解Oracle架构，能够有效管理和优化数据库。 学习重点： 1. SQL熟练度：编写复杂查询、连接、子查询和集合操作；熟悉常见函数（聚合、字符串、日期/时间等）；理解SQL标准和最佳实践。 2. 数据库管理：创建、修改和管理数据库、表、索引和模式；用户和角色管理，包括权限和安全性；使用pg_dump和pg_restore进行备份和恢复。 3. 性能调优：使用EXPLAIN和ANALYZE分析查询性能；索引优化及理解索引策略；优化查询以提升性能并减少资源消耗。 4. PL/pgSQL编程：编写和维护存储过程、函数和触发器；在PL/pgSQL中的错误处理和控制结构；在数据库内实现复杂的业务逻辑。 5. 数据建模：设计和规范化数据库模式；理解关系数据库概念和实体关系建模；实现约束（主键、外键、唯一等）。 本课程旨在帮助学员提升Oracle SQL的专业技能，确保学员能够在实际工作中有效应用这些知识。
Oracle SQL is a necessary skill for any Oracle professional. In this course we overs advanced aspects of coding using SQL in an Oracle Database 12c environment.The following key topics can help you develop your Oracle SQL expertise, including database concurrency transactions, Oracle-specific schema objects such as indexes and PL/SQL procedures, functions and packages, and table partitioning.Setting up the Oracle Database 12c environment Writing subqueries and inline views Creating table indexes to boost query performance Using the Oracle Data Dictionary Database transactions Creating sequences and triggers Table partitioning benefits Using LIST, RANGE, and HASH partitionsOracle SQL is a necessary skill for any Oracle professional, alongside expertise in PL/SQL, performance tuning, database administration, data modeling, and understanding of Oracle architecture. Mastery of these skills ensures effective database management and optimization.SQL ProficiencyWriting complex queries, joins, subqueries, and set operations.Familiarity with common functions (aggregate, string, date/time, etc.).Understanding of SQL standards and best practices.Database AdministrationCreating, modifying, and managing databases, tables, indexes, and schemas.User and role management, including permissions and security.Backup and restore procedures using pg_dump and pg_restore.Performance TuningAnalyzing query performance using EXPLAIN and ANALYZE.Index optimization and understanding indexing strategies.Optimizing queries for better performance and reduced resource usage.PL/pgSQL ProgrammingWriting and maintaining stored procedures, functions, and triggers.Error handling and control structures in PL/pgSQL.Implementing complex business logic within the database.Data ModelingDesigning and normalizing database schemas.Understanding relational database concepts and entity-relationship modeling.Implementing constraints (primary key, foreign key, unique, etc.).
