youngminpark2559 / db Goto Github PK

<h2>Hanbit - This is MySQL</h2>
Chapter000_Introduction<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter000_Introduction/001_Introduction/main.html">001_Introduction</a><br/>
Chapter001_Introduce_DBMS_and_MySQL<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter001_Introduce_DBMS_and_MySQL/001/main.html">001</a><br/>
Chapter002_Install_MySQL<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter002_Install_MySQL/001/main.html">001</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter002_Install_MySQL/002/main.html">002</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter002_Install_MySQL/003_for_Linux/main.html">003_for_Linux</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter002_Install_MySQL/004_for_Linux/main.html">004_for_Linux</a><br/>
Chapter003_Run_MySQL_entire_process<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/001_Introduce/main.html">001_Introduce</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/002_Create_db_table/main.html">002_Create_db_table</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/003_Insert_data_into_table_Use_data_using_SQL_query/main.html">003_Insert_data_into_table_Use_data_using_SQL_query</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/004_Other_My_SQL_components_Index_View_Stored_procedure/main.html">004_Other_My_SQL_components_Index_View_Stored_procedure</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/005_Other_My_SQL_components_Trigger_Backup/main.html">005_Other_My_SQL_components_Trigger_Backup</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter003_Run_MySQL_entire_process/006_Connect_MySQL_to_application/main.html">006_Connect_MySQL_to_application</a><br/>
Chapter004_Database_modeling<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter004_Database_modeling/001_Concept/main.html">001_Concept</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter004_Database_modeling/002_Forward_Reverse/main.html">002_Forward_Reverse</a><br/>
Chapter005_Use_MySQL_utility_MySQL_workbench<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter005_Use_MySQL_utility_MySQL_workbench/001_Basics/main.html">001_Basics</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter005_Use_MySQL_utility_MySQL_workbench/002_Manage_external_MySQL_server_Create_permissions/main.html">002_Manage_external_MySQL_server_Create_permissions</a><br/>
Chapter006_SQL_basic<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter006_SQL_basic/001_Basics/main.html">001_Basics</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter006_SQL_basic/002_Where_Wildcard_Sub_query_Order_by_Distinct_Limit/main.html">002_Where_Wildcard_Sub_query_Order_by_Distinct_Limit</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter006_SQL_basic/003_Group_by_Having_Rollup/main.html">003_Group_by_Having_Rollup</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter006_SQL_basic/004_Insert_Auto_increment_Ignore_On_duplicate_key/main.html">004_Insert_Auto_increment_Ignore_On_duplicate_key</a><br/>
Chapter007_SQL_advanced<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/001_Number_Char_Time_data_type_Variable/main.html">001_Number_Char_Time_data_type_Variable</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/002_MySQL_built_in_functions_If_Ifnull_Nullif_Case_Ascii_Char/main.html">002_MySQL_built_in_functions_If_Ifnull_Nullif_Case_Ascii_Char</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/003_Large_data/main.html">003_Large_data</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/004_Join/main.html">004_Join</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/005_Outer_join/main.html">005_Outer_join</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Hanbit_This_is_MySQL/Chapter007_SQL_advanced/006_SQL_programming/main.html">006_SQL_programming</a><br/>

<h2>Opentutorials - Database modeling</h2>
Chapter001<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter001/001_Introduction/main.html">001_Introduction</a><br/>
Chapter002<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter002/001_Entire_process_of_data_modeling/main.html">001_Entire_process_of_data_modeling</a><br/>
Chapter003<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter003/001_Understand_your_project/main.html">001_Understand_your_project</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter003/002_Create_plan_document/main.html">002_Create_plan_document</a><br/>
Chapter004_Conceptual_data_modeling<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/001_Introduction/main.html">001_Introduction</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/002_Structure_of_concepts_for_RDB/main.html">002_Structure_of_concepts_for_RDB</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/003_Components_of_ERD/main.html">003_Components_of_ERD</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/004_Define_entity/main.html">004_Define_entity</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/005_Define_attribute/main.html">005_Define_attribute</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/006_Define_identifier/main.html">006_Define_identifier</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/007_Define_relationship_between_entities/main.html">007_Define_relationship_between_entities</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/008_Cardinality/main.html">008_Cardinality</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/009_Optionality/main.html">009_Optionality</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/010_Complete_ERD/main.html">010_Complete_ERD</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter004_Conceptual_data_modeling/011_ERD_helper/main.html">011_ERD_helper</a><br/>
Chapter005_Logical_data_modeling<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/001_Introduction/main.html">001_Introduction</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/002_Create_table_and_column/main.html">002_Create_table_and_column</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/003_1to1_relationship_using_key/main.html">003_1to1_relationship_using_key</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/004_1toN_relationship_using_key/main.html">004_1toN_relationship_using_key</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/005_NtoN_relationship_using_key/main.html">005_NtoN_relationship_using_key</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter005_Logical_data_modeling/006_NtoN_relationship_using_key/main.html">006_NtoN_relationship_using_key</a><br/>
Chapter006_Normalization<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter006_Normalization/001_Introduction/main.html">001_Introduction</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter006_Normalization/002_First_normal_form_Atomic_columns/main.html">002_First_normal_form_Atomic_columns</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter006_Normalization/003_Second_normal_form_No_partial_dependencies/main.html">003_Second_normal_form_No_partial_dependencies</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter006_Normalization/004_Third_normal_form_No_transitive_dependencies/main.html">004_Third_normal_form_No_transitive_dependencies</a><br/>
Chapter007_Physical_data_modeling<br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/001_Introduction/main.html">001_Introduction</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/002_Intro_to_denormalization/main.html">002_Intro_to_denormalization</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/003_Manipulate_column_to_reduce_join/main.html">003_Manipulate_column_to_reduce_join</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/004_Manipulate_column_to_reduce_computation/main.html">004_Manipulate_column_to_reduce_computation</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/005_Split_table/main.html">005_Split_table</a><br/>
&nbsp&nbsp<a href="https://youngminpark2559.github.io/db/Opentutorials.org_Database_modeling/Chapter007_Physical_data_modeling/006_Denormalization_for_relationship/main.html">006_Denormalization_for_relationship</a><br/>

<h2>Opentutorials - JOINs</h2>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/001_Introduction/main.html">001_Introduction</a><br/>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/002_Split_table/main.html">002_Split_table</a><br/>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/003_JOIN_exercise_preparation/main.html">003_JOIN_exercise_preparation</a><br/>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/004_LEFT_OUTER_JOIN/main.html">004_LEFT_OUTER_JOIN</a><br/>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/005_INNER_JOIN/main.html">005_INNER_JOIN</a><br/>
<a href="https://youngminpark2559.github.io/db/Opentutorials.org_JOIN/006_FULL_OUTER_JOIN/main.html">006_FULL_OUTER_JOIN</a><br/>