|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-database-12c-basic-sql-hand-on-step-by-step/
课程评论：没有评论
**课程名称：** Oracle Cloud: Oracle SQL 基础与实践 **课程概述：** 本课程为Oracle专业人士和有兴趣成为Oracle专家的初学者提供了SQL语言的基础知识。课程将重点介绍Oracle数据库12c环境下SQL语言的特性，包括： * **数据选择与过滤：** 学习如何从表中选择数据，并使用各种条件进行过滤。 * **数据操作与函数：** 掌握使用SUBSTR, UPPER, MIN, MAX, AVG, SUM等常用函数进行数据操作和转换。 * **多表数据合并：** 学习如何使用JOIN语句将来自两个或多个表的数据合并到单个查询中。 * **数据修改：** 了解DML（如DELETE, UPDATE）和DDL命令，用于修改和管理数据。 * **数据分组与聚合：** 使用聚合函数对数据进行分组和统计分析。 * **高级概念：** 涵盖约束（Constraints）和子查询（Subqueries）等进阶主题。 **适用人群：** 本课程特别适合没有任何SQL或Oracle经验的数据库开发新手。 **学习内容亮点：** * 使用免费的 Oracle SQL*Developer 开发环境。 * 掌握标准SQL的数据查询和操作。 * 熟练运用Oracle特有的SQL函数。 * 理解并实践多表联接。 * 学习创建、更新和删除数据的基本操作。 * 掌握数据分组、排序以及主键和约束的应用。
SQL language is an important skill for any Oracle professional and is the first step in suitable a true Oracle expert. As with any database platform, Oracle has its own take on the SQL language that builds on top of industry standards. In this course, I cover the basics required to code with SQL in an Oracle Database 12c environment. Learn how to select and filter data, and manipulate data using functions, including SUBSTR, UPPER, MIN, MAX, AVG, SUM, and more. Then find out how to combine data from two or more tables in a single statement with joins. Discover how to modify data with DML and DDL commands like DELETE and UPDATE, and group data with aggregate functions also include such as constraints and subqueries advance concepts. This training course is suitable for beginning database developers with no prior experience with SQL or Oracle. Following are including: Using Oracle SQL*Developer, the free development environment Selecting data from tables Filtering data Using functions to manipulate data Joining data from tables Creating tables Updating values Truncating data Grouping and ordering result sets Working with primary keys Checking constraints
