Edu First Computer and Learning Intitutes

 Nội dung

 Thời lượng

 Phần I - Thiết kế CSDL Quan hệ

 24 giờ

• Define a Database Management System (DBMS)
• Identify the different DBMS users, Describe the need for a database system
• Define the architecture of DBMS as External level, Conceptual level, Internal level
• Identify the functional components of a DBMS and need of database planning
• Identify the stages in the Database Development Life Cycle (DDLC)
• Identify the effects of poor database planning and design
• Describe the types of data models, Create an entity-relationship model
• List the types of relationships between entities
• Define a Relational Database Management System (RDBMS)
• Describe the operators that work on relations
• Map an E/R Diagram to Tables in relation to the following: Regular entities, Attributes,
• Relationships, Weak entities, Sub and super types
• Identify keys, Define Specialization and Generalization
• Describe the Top-down and Bottom-up approach
• Describe data redundancy, Describe the first, second, and third normal forms
• Describe the Boyce-Codd Normal Form (BCNF), Need for de-normalization

 Phần II- Triển khai Cơ Sở Dữ Liệu trên MS SQL Server 2005

 72 giờ

• Query data
• Query data from multiple tables
• Manage databases and tables
• Manage data in tables
• Implement indexes, views, and full-text search
• Implement stored procedures and functions
• Implement triggers and transactions
• Implement managed code
• Implement HTTP endpoints
• Implement services for message-based communication
• Install and configure SQL Server 2005
• Manage and secure a database
• Backup and restore data
• Monitor, optimize, and troubleshoot performance
• Maintain high availability
• Implement replication
• Import and export data