Database programming for intermediates

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