|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/simplified-approach-to-dbms/
课程评论：没有评论
课程名称：简化的数据库管理系统方法：完整包 概述：数据库是当今所有主要应用程序的基础！无论是基于互联网的、金融、社交、行政还是内部网应用，没有数据库，它们统统只是空名。Oracle和Microsoft SQL Server已经成为领先的商业系统，而MySQL和PostgreSQL则在开源领域引领潮流。尽管数据库管理系统（DBMS）之间存在显著差异，但它们具有共同的模型、设计范式和结构化查询语言（SQL）。本课程的主要目标是涵盖这些内容。 适合人群：本课程适合以下学习者： - 该领域的初学者 - 准备大学考试的学生 - 准备面试的求职者 - 希望在短时间内快速成为数据库专家的软件专业人士 课程内容： - DBMS基础知识 - DBMS与基于文件系统的比较 - DBMS的三级架构 - 不同的DBMS模型-关系型、层次型、网络数据模型及其数据操作 - 理解主键、外键、超键、候选键及人工键 - 设计实体关系（ER）模型 - 实体、实体集合、强弱实体、完全依赖和部分依赖的概念 - 将ER模型转换为表 - 从零学习范式化 - 函数依赖、完全函数依赖、传递依赖和多值依赖的概念 - 事务管理 - 完整的SQL：创建表、插入、更新和删除数据、修改表结构、表连接（笛卡尔积、内连接、外连接和自连接）、在SQL中对数据进行分组 通过本课程，学习者将掌握数据库管理系统的基本概念和实际应用技能，为他们的职业发展奠定坚实的基础。
Databases are the spine of all major applications today! Whether internet-based, financial, social, administrative or intranet applications, without databases they all are namesake! Oracle, Microsoft SQL Server, have emerged as leading commercial systems whereas MySQL, PostgreSQL have led the open-source. While DBMSs differ profoundly, they resemble a common set of models, design paradigms and a Structured Query Language (SQL). With this course, our main intention is to cover these details.Who is the course for?This course is designed for learners who are:beginners in this fieldwant to prepare for University examinationswant to prepare for placement interviewssoftware professionals who want to quick start there carrier as a Database expertin a short time span.What topics will this course cover?Basics of DBMSsComparison of DBMS with File Based SystemThree Level Architecture of DBMSDifferent models of DBMS- Relational, Hierarchical, Network Data models with Data operations on them.Understanding Primary, Foreign Key, Super Key, Candidate key and Artificial keyDesigning ER ModelConcept of Entity, Entity Set, Strong and weak entity, Total and Partial DependenceConversion of ER Model to TablesLearn Normalization from scratch.Concept of Functional Dependence, Fully Functional Dependence, Transitive Dependence and Multi Value DependenceTransaction ManagementFull SQL: Creation of TablesInsertion, Updation and Deletion of DataAlter TableJoining of TablesCartesian Product, Inner Join, Outer Join and Self JoinGrouping of Data in SQL
