|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-advanced-sql-for-oracle-databases/
课程评论：没有评论
**课程名称：** 学习 Oracle 数据库的高级 SQL **课程概述：** 本课程旨在教授学员使用 Oracle 数据库设计和编写复杂查询的高级 SQL 技能。学员将学会如何设计、编写和测试最高效的查询以解决特定的业务问题。Oracle 数据库是目前世界上应用最广泛的数据库系统之一。 在本课程中，学员可以选择使用 Toad 或 SQL Developer 连接至 Oracle 数据库，课程将指导学员完成数据库连接的设置。这门高级 Oracle SQL 课程涵盖了更复杂 SQL 语句的设计以及相应的实现策略，包括 SET 操作符和分析函数等主题。此外，课程还将介绍视图（Views）的概念，因为视图对于隐藏查询的复杂性以及作为安全机制都非常有用。 **目标学员：** 本课程适合所有具备基本 SQL 知识，能够编写和理解简单 SQL 查询的人员。对关系型数据库管理系统（RDBMS）有基本了解将是一项优势。 **学习内容：** * 如何创建视图 * 如何检查表的结构 * 如何使用 Flashback 回滚数据 * 如何使用分析函数 * 如何使用 SET 操作符查询数据 * 如何设置数据库环境 * 如何连接到数据库 * 如何编写高级 SQL 查询
Learn the advanced SQL skills necessary to design and code complex queries against Oracle databases. Design, code and test the most efficient query to solve a given business problem. Oracle databases are one of the most widely used database systems in the world.In this course you will have a choice of either using Toad or SQL developer to connect to the oracle database. The course will show you how to setup connection to the database. This advanced Oracle SQL course covers the design of more complex SQL statements and the strategies available for implementing them, it covers topics like SET operators and Analytic functions. It also introduces you to views because these are useful for hiding the complexity of queries and also can act as a security mechanismWho is This Course For?This course is designed for anyone who has some basic SQL knowledge and can write and understand simple SQL Queries. Also knowing the basics of relational database management systems (RDBMS) would be an advantage.What You Will Learn:How to Create ViewsHow to check the structure of a tableHow to use Flashback to Rollback DataHow to use Analytic FunctionsHow to use SET operators to query dataHow to set database environmentHow to connect to the databaseHow to write advanced SQL queries
