Database programming for intermediates
What you'll learn
- DBMS’s function to keep safety and accuracy (Keywords: Transaction, rollback, lock, etc.)
- How to create table, and mechanism to keep reliability (Keywords: DDL, constraint, referential integrity, etc.)
- How to enhance performance, safety, convenience (Keywords: Index, view, sequence, backup, etc.)
- Procedure to design table based on requirement (Keywords: Conceptual design, logical design, physical design, normalization, etc.)
Requirements
- Nothing
Description
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 knowledge
and design skill
This course’s table contents is as follows
1 Course Introduction
1.1 Self introduction
1.2 Target and goal
1.3 Contents overview
1.4 Contents detail
2 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 database
3.1.2 3 types of command
3.1.3 What is DCL ?
3.2 Create table
3.2.1 Basics of table creation
3.2.2 Setting of default value
3.2.3 DROP TABLE statement
3.2.4 ALTER TABLE statement
3.3 Constraint
3.3.1 Prepare for human error
3.3.2 3 basic constraints
3.3.3 Primary key constraint
3.4 Foreign key and referential integrity
3.5.1 Referential integrity break
3.5.2 Root cause of referential integrity break
3.5.3 Foreign key constraint
3.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 demerit
4.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 forward
5 Database design
5.1 Database design process
5.1.1 Database design process overview
5.1.2 Table design process
5.2 Requirement of household account management system
5.2.1 Hearing item of requirement phase
5.2.2 Concrete example of requirement
5.2.3 Important point of requirement
5.3 Conceptual design
5.3.1 Conceptual design process
5.3.2 Entity-Relationship diagram
5.3.3 Rule to make ER diagram
5.3.4 Process to list up all entities
5.4 Logical design
5.4.1 Logical design process
5.4.2 Break up many-to-many relationship into one-to-many
5.4.3 Arrange attribute of entity
5.4.4 Normalization
5.5 Normalization process
5.5.1 Normalization level
5.5.2 Unnormalized form
5.5.3 Transform to first normalized form
5.5.4 Functional dependency
5.5.5 Transform to second normalized form
5.5.6 Transform to third normalized form
5.5.7 Tips to normalize table
5.6 Physical design
5.6.1 Physical design process
5.6.2 Household account management system's physical design
5.7 Make use of normalized data
5.7.1 Start using household account management system
5.7.2 Engineer's mission
5.8 Chapter summary
Finally, thank you for enrolling this course. Let's start learning database design fundamentals!
Who this course is for:
- 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
Instructor
Career Background
- Active engineer with over 10 years of experience in the IT industry
- Extensive experience in software development and project management across various project scales
Areas of Expertise
- Full-stack development (Frontend: TypeScript, Angular; Backend: Java, Spring Boot)
- Cloud computing and DevOps (primarily AWS)
- Information security (authentication, authorization, secure communication)
Achievements as a Udemy Instructor
- Over 30,000 total students enrolled
- Multiple bestselling courses in full-stack development, AWS technologies, DevOps practices, and security implementation
- Numerous courses with top ratings
Message to Students
I combine practical knowledge gained from industry experience with the latest trends to provide you with immediately applicable skills. By balancing theory and practice, I am fully committed to supporting your career growth.
---
経歴
- IT業界で10年以上のキャリアを持つ現役エンジニア
- 多様な規模のプロジェクトにおけるソフトウェア開発とマネジメント経験
専門分野
- フルスタック開発(フロントエンド:TypeScript, Angular 、バックエンド:Java, Spring Boot)
- クラウドコンピューティングとDevOps(主にAWS)
- 情報セキュリティ(認証認可、セキュアな通信)
Udemy講師としての実績
- 累計受講者数30,000名以上
- フルスタック開発、AWS関連技術、DevOps実践、セキュリティ実装に関する複数のベストセラーコース
- 最高評価を獲得したコース多数
受講生の皆様へ
実務で培った知識と最新トレンドを融合し、即戦力となるスキルを提供します。 理論と実践のバランスを大切に、皆様のキャリアアップを全力でサポートします。