本課程將探討設計資料庫應用的相關技術,範圍將包含:
1.資料庫表格的設計:探討與實作表格的正規化
2.資料庫引擎的操作:以MS SqlServer為主, 過程也會介紹SQLite, Access,mySQL等常用的資料庫; 基本DBA操作將在此探討:
2.1 索引優化的管理
2.2 空間的管理
2.3 權限管理
2.4 效能優化的監控
3.SQL Command的探討:除了SQL Command的操作, 也透過Access, Excel VBA比較不同工具的差異
4.Cloud DB的介紹:探討與實作Hadoop的運作, 以MS HDinsight為主
5.前端工具的介紹: 幾種檢索工具與常用資料庫class的設計, 幾個常用的主題亦將在此探討
5.1 SQL Injection的防護
5.2 SQL Command的效能調校
《 課程簡介 -- English 》
This course will explore related technologies for design database applications.The scope will include:
1.Design of database tables: Discussion and implementation of formalization of tables
2.Database engine operation: MS SqlServer is the main process, and the commonly used databases such as SQLite, Access, mySQL will also be introduced. Basic DBA operations will be discussed here:
2.1 Index Optimization Management
2.2 Space management
2.3 Rights Management
2.4 Performance Optimization Monitoring
3. Discussion of SQL Command: In addition to the operation of SQL Command, the differences between different tools are also compared through Access and Excel VBA.
4.Introduction to Cloud DB: Explore and implement the operation of Hadoop, mainly based on MS HDinsight
5. Introduction of front-end tools: design of several retrieval tools and common database classes, several common topics will also be discussed here
5.1 SQL injection protection
5.2 SQL Command Performance Tuning
|