|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-oracle-sql-building-database-applications/
课程评论：没有评论
课程名称：高级Oracle SQL：学习高级SQL技能 概述：Oracle SQL是标准SQL语言中最强大的版本之一。其高级功能使您能够构建可以存储在数据库中的复杂SQL语句或查询。Oracle SQL拥有众多强大功能和特性，使得解决复杂查询相关问题变得更加便捷。本课程将帮助您掌握知识和技能，自信地构建复杂查询，从而更快速地解决与数据库相关的问题。 本课程将教您如何利用Oracle SQL强大的内置函数快速提取复杂数据，以及如何使用原生SQL进行过程处理。每位开发人员都需要了解如何使用Oracle SQL从大型表中汇总和聚合数据，并利用“model”子句等强大特性使SQL充当过程语言。您将学习更快速、更优雅地检索Oracle数据的技巧。 本课程适合具备基础Oracle SQL和Oracle数据库知识的学习者。课程内容包括： - 创建已排序和限制数据的报告 - 执行数据操作语句（DML） - 控制特定对象的数据库访问 - 管理模式对象 - 使用数据字典视图管理对象 - 从表中检索行和列数据 - 控制对象和系统级别的权限 - 创建索引和约束；修改现有模式对象 - 编写包含查询的SELECT语句 - 从SQL语句创建业务报告 - 创建用于存储数据的表 - 运行数据操作语句（DML） - 创建聚合数据的报告 通过本课程的学习，您将能够更高效地掌握Oracle SQL的各种高级功能。
Oracle SQL is one of the world's most powerful version of the standard SQL language. The advanced capabilities of Oracle SQL will enable you to build advanced SQL statements or queries that can be stored on the database. Oracle SQL is packed with advanced functions and features that gives the language powerful capabilities. Using these powerful features makes it easier to solve complex query related issues.This course will give you the knowledge and understanding to confidently build complex queries to solve database related problems faster.This course will teach you working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing. Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language. This course will teach you how the techniques for retrieving Oracle data faster and more elegantly.This course is designed for those that have some basic knowledge of oracle SQL and Oracle Databases.Some of the topic covered in this course includes:• Create reports of sorted and restricted data.• Run data manipulation statements (DML).• Control database access to specific objects.• Manage schema objects.• Manage objects with data dictionary views.• Retrieve row and column data from tables.• Control privileges at the object and system level.• Create indexes and constraints; alter existing schema objects.• Write SELECT statements that include queries• Create Business reports from SQL Statements• Retrieve row and column data from tables• Create tables to store data• Run data manipulation statements (DML) • Create reports of aggregated data
