Hanbit - This is MySQL
Chapter000_Introduction
001_Introduction
Chapter001_Introduce_DBMS_and_MySQL
001
Chapter002_Install_MySQL
001
002
003_for_Linux
004_for_Linux
Chapter003_Run_MySQL_entire_process
001_Introduce
002_Create_db_table
003_Insert_data_into_table_Use_data_using_SQL_query
004_Other_My_SQL_components_Index_View_Stored_procedure
005_Other_My_SQL_components_Trigger_Backup
006_Connect_MySQL_to_application
Chapter004_Database_modeling
001_Concept
002_Forward_Reverse
Chapter005_Use_MySQL_utility_MySQL_workbench
001_Basics
002_Manage_external_MySQL_server_Create_permissions
Chapter006_SQL_basic
001_Basics
002_Where_Wildcard_Sub_query_Order_by_Distinct_Limit
003_Group_by_Having_Rollup
004_Insert_Auto_increment_Ignore_On_duplicate_key
Chapter007_SQL_advanced
001_Number_Char_Time_data_type_Variable
002_MySQL_built_in_functions_If_Ifnull_Nullif_Case_Ascii_Char
003_Large_data
004_Join
005_Outer_join
006_SQL_programming
Opentutorials - Database modeling
Chapter001
001_Introduction
Chapter002
001_Entire_process_of_data_modeling
Chapter003
001_Understand_your_project
002_Create_plan_document
Chapter004_Conceptual_data_modeling
001_Introduction
002_Structure_of_concepts_for_RDB
003_Components_of_ERD
004_Define_entity
005_Define_attribute
006_Define_identifier
007_Define_relationship_between_entities
008_Cardinality
009_Optionality
010_Complete_ERD
011_ERD_helper
Chapter005_Logical_data_modeling
001_Introduction
002_Create_table_and_column
003_1to1_relationship_using_key
004_1toN_relationship_using_key
005_NtoN_relationship_using_key
006_NtoN_relationship_using_key
Chapter006_Normalization
001_Introduction
002_First_normal_form_Atomic_columns
003_Second_normal_form_No_partial_dependencies
004_Third_normal_form_No_transitive_dependencies
Chapter007_Physical_data_modeling
001_Introduction
002_Intro_to_denormalization
003_Manipulate_column_to_reduce_join
004_Manipulate_column_to_reduce_computation
005_Split_table
006_Denormalization_for_relationship
Opentutorials - JOINs
001_Introduction
002_Split_table
003_JOIN_exercise_preparation
004_LEFT_OUTER_JOIN
005_INNER_JOIN
006_FULL_OUTER_JOIN