Overview

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!

Skills

Reviews