※ 引述《Fujirou (秀吉)》之铭言： : ※ 引述《fluteoner (NCU_CS)》之铭言： : : 我大概讲一下我们的主题 : : 1.DB环境概论、历史与发展 : : 2.Database Analysis, 包含ER model与 Enhanced ER model : : 3.Database Design, 就是第一第二第三正规化, Denormalization, RAID等等 : : 4.SQL语法, 我们教SQL Server2000 (只教一点点) : : 然後两学期就差不多结束了 : : 其他像是 : : Client/Server DB, Data warehouse, Distributed DB, Object-Orented DB, : : 等等进阶的领域都可以另外再开课，真是太可怕啦 : : 会问这个是因为我考到资工所，现在要作Data Warehouse相关的东西， : : 想知道资工比较着重在哪一部份，难道你们只有学SQL?? : 资工课程 : 课本是Database Management Systems 3e, by R. Ramakrishnan and J. Gehrke : 1. Overview of Database Systems : 2. ER Model : 3. Relational Model : 4. Relational Algebra (Relational Calculus skipped) : 5. SQL : 8. Overview of Storage and Indexing : 9. Storing Data: Disks and Files (RAID, Buffer Manager, Page formats,...) : 10. Tree-Structured Indexing (ISAM, B+ Tree) : 11. Hash-Based Indexing : 12. Overview of Query Evaluation : 13. External Sorting : 14. Evaluating Relational Operators : 16. Overview of Transaction Management (Strict 2PL, Deadlocks) : 17. Concurrency Control : 18. Crach Recovery (ARIES) : 有几章的後面会跳过，是哪几章我也忘了… : 这是一个学期的课 交大资工的资料库 课本 : Fundamentals of Database Systems 4th Edi. ,by Elmasri && Navathe 课程内容包括 : 1.Databases and Database Use 2.Database System Concepts and Architecture 3.Data Modeling Using the Entity-Relationship Model 4.Enhanced Entity-Relationship and UML Modeling 5.The Relational Data Model and Relational Database Constraints 6.The Relational Algebra and Relational Calculus(Calculus的部分没有教) 7.Relational Database Design by ER- and EER-to-Relational Mapping 8.SQL-99: Schema Definition,Basic Constraints and Queries 9.More SQL: Assertions,Views,and Programming Techniques 10.Functional Dependencies and Normalization for Relational Databases 13.Disk Storage,Basic File Structures, and Hashing 14.Indexing Structures for Files 17.Introduction to Transaction Processing Concepts and Theory 18.Concurrency Control Techniques 26.XML and Internet Database 27.Data Mining Concepts 28.Overview of Data Warehousing and OLAP -- 今天刚考完 囧 --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 140.113.93.86