|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-rdbms-with-oracle/
课程评论：没有评论
课程名称：学习Oracle的关系数据库管理系统（RDBMS） 课程概述：本课程适合新毕业生及希望从事数据库开发职业的人士。数据库开发在当前就业市场上非常热门。尽管许多NoSQL数据库目前颇受欢迎，但NoSQL数据库并不能取代关系数据库管理系统（RDBMS）。本课程旨在帮助学员理解RDBMS的基本知识以及如何在Oracle中编写SQL查询。整个课程分为两个部分：RDBMS基础和SQL基础。 在RDBMS基础部分，课程详细讲解了RDBMS的概念、数据库的规范化以及EF Codd的规则，这些都是RDBMS系统的核心部分。此外，还涵盖了数据库管理系统的关键和数据完整性及约束等内容。 在SQL基础部分，课程内容包括各种连接类型、子查询、公共表表达式（CTE）查询，以及如何编写单表和多表连接的SQL查询，以及如何使用分组（Group by）条件编写查询。课程还包括数据字典的相关内容，以及如何在Oracle中使用数据字典。 通过本课程，您将通过Oracle学习RDBMS。课程设计配有优秀的实践测试和课后作业，以检测您的理解程度。该课程专为初学者设计，无需具备RDBMS的先前知识。
This course is good for new graduates and who are aspiring for Database development career. Database development is hot in a current Job Market. Although there are many NoSQL databases are currently popular, NoSQL DBs are not a replacement to RDBMS. This course is to understand the Basic knowledge on RDBMS and writing SQL queries in Oracle. This entire course can be broken into 2 parts one is RDBMS Fundamentals and next is SQL Fundamentals. Under DBMS Fundamentals, Concepts of RDBMS, Normalization in DB, EF Codd's' Rules which core part of RDBMS systems are well explained. This is well built to share the enough details on DBMS Keys along with Data Integrity and constraints. Under SQL Fundamentals, this course teaches what are the types of Joins, what are Sub Queries, CTE Queries, how to write a SQL with single, Multi Table joins and how to write a query with Group by clauses. Also included the part of Data dictionaries and how this can be used in Oracle. Throughout this course you will learn RDBMS through Oracle. This course is designed with excellent practice test and assignment at the end of the lesson to test your understandings. This is course is for beginners and no prior knowledge on RDBMS is needed.
