|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-programming-for-intermediates/
课程评论：没有评论
课程名称：中级数据库编程 课程概述： 本课程旨在提升已经具备基础SQL技能的IT工程师的数据库管理系统（DBMS）知识，特别是在事务、数据定义语言（DDL）、性能和设计方面。课程特别适合希望了解高级功能以增强系统性能和安全性的工程师。 课程目标： - 理解高级DBMS知识及其应用。 - 能够基于高级DBMS知识和设计技能，设计和开发简单的Web应用程序。 课程内容： 1. 课程介绍 - 自我介绍 - 目标与课程目的 - 内容概述 - 内容详细介绍 2. 事务 - 问题概述：挂起与中断 - 详细问题与解决方案，涵盖原子性、提交与回滚等多个方面 - 章节总结 3. 创建数据表 - SQL语句及其角色 - 数据表创建的基本知识、默认值设置以及表的修改和删除语句 - 约束条件的准备与设计，包括主键和外键约束 - 章节总结 4. 附加功能 - 性能增强、便利性增强和安全性增强，包括索引、视图和备份等内容 - 章节总结 5. 数据库设计 - 数据库设计过程概述，包括表设计、需求分析以及概念设计 - 逻辑设计与规范化过程 - 物理设计及其应用 感谢您报名本课程，让我们一起开始学习数据库设计的基础知识吧！
This course's target and goal is as follows■ Target● IT engineer already have basic SQL skill related to data manipulation,and want to get more knowledge on DBMS itself (such as transaction, DDL, performance, design)● IT engineer want to know advanced function to enhance performance and safety■ Goal● Understand advanced DBMS knowledge, and how to use it● Be able to design and develop simple Web app based on advanced DBMS knowledgeand design skillThis course's table contents is as follows1 Course Introduction1.1 Self introduction1.2 Target and goal1.3 Contents overview1.4 Contents detail2 Transaction 2.1 Issue overview - suspension and interruption - 2.2 Suspension issue detail and solution 2.2.1 Issue detail - suspension - 2.2.2 Solution overview - atomicity - 2.2.3 Solution detail - commit and rollback - 2.2.4 Supplementary explanation1 - how to use transaction - 2.2.5 Supplementary explanation2 - how to release auto commit mode - 2.3 Interruption issue detail and solution 2.3.1 Issue detail - interruption - 2.3.2 Solution overview - isolation - 2.3.3 Solution detail - lock - 2.3.4 Supplementary explanation1 - isolation level - 2.3.5 Supplementary explanation2 - dead lock - 2.4 Chapter summary 3 Create table 3.1 SQL statement 3.1.1 2 Roles to use database3.1.2 3 types of command3.1.3 What is DCL ?3.2 Create table 3.2.1 Basics of table creation3.2.2 Setting of default value3.2.3 DROP TABLE statement3.2.4 ALTER TABLE statement3.3 Constraint 3.3.1 Prepare for human error3.3.2 3 basic constraints3.3.3 Primary key constraint3.4 Foreign key and referential integrity 3.5.1 Referential integrity break3.5.2 Root cause of referential integrity break3.5.3 Foreign key constraint3.5 Chapter summary 4 Additional functions 4.1 Performance enhancement 4.1.1 Issue detail - Low performance - 4.1.2 Solution overview - Index - 4.1.3 Solution detail - How to use index - 4.2 Convenience enhancement 4.2.1 Issue detail - Complex SQL statement - 4.2.2 Solution overview - View - 4.2.3 Solution detail - How to use view - 4.2.4 View's demerit4.3 Safety enhancement 4.3.1 Issue detail - Data elimination - 4.3.2 Solution overview - Back up - 4.3.3 Solution detail - Offline back up and Online back up - 4.3.4 Roll forward5 Database design 5.1 Database design process 5.1.1 Database design process overview5.1.2 Table design process5.2 Requirement of household account management system 5.2.1 Hearing item of requirement phase5.2.2 Concrete example of requirement5.2.3 Important point of requirement5.3 Conceptual design 5.3.1 Conceptual design process5.3.2 Entity-Relationship diagram5.3.3 Rule to make ER diagram5.3.4 Process to list up all entities5.4 Logical design 5.4.1 Logical design process5.4.2 Break up many-to-many relationship into one-to-many5.4.3 Arrange attribute of entity5.4.4 Normalization5.5 Normalization process 5.5.1 Normalization level5.5.2 Unnormalized form5.5.3 Transform to first normalized form5.5.4 Functional dependency5.5.5 Transform to second normalized form5.5.6 Transform to third normalized form5.5.7 Tips to normalize table5.6 Physical design 5.6.1 Physical design process5.6.2 Household account management system's physical design5.7 Make use of normalized data 5.7.1 Start using household account management system5.7.2 Engineer's mission5.8 Chapter summary Finally, thank you for enrolling this course. Let's start learning database design fundamentals!
