※ 引述《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