GitHub - caveofprogramming/mysql-course: SQL for MySQL from Beginner to Advanced Course

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 3 Commits
012_Exporting_Data.sql		012_Exporting_Data.sql
015_Some_Test_Data.sql		015_Some_Test_Data.sql
020_Solutions1.sql		020_Solutions1.sql
035_Solutions2.sql		035_Solutions2.sql
040_Health_Database.sql		040_Health_Database.sql
044_Solutions3.sql		044_Solutions3.sql
046_Foreign_Keys.sql		046_Foreign_Keys.sql
048_Joins_and_Cartesian_Products.sql		048_Joins_and_Cartesian_Products.sql
049_Inner_Joins.sql		049_Inner_Joins.sql
050_Left_and_Right_Outer_Joins.sql		050_Left_and_Right_Outer_Joins.sql
051_Joins_Between_Pairs_of_Tables.sql		051_Joins_Between_Pairs_of_Tables.sql
054_Many_to_Many.sql		054_Many_to_Many.sql
055_Joining_Tables_to_Themselves.sql		055_Joining_Tables_to_Themselves.sql
056_Restrict.sql		056_Restrict.sql
059_Online_Shop.sql		059_Online_Shop.sql
063_Adding_Columns.sql		063_Adding_Columns.sql
064_Adding_Foreign_keys.sql		064_Adding_Foreign_keys.sql
065_Adding_Indexes.sql		065_Adding_Indexes.sql
066_Indexing_Multiple_Columns.sql		066_Indexing_Multiple_Columns.sql
069_Views.sql		069_Views.sql
070_View_Algorithms.sql		070_View_Algorithms.sql
071_With_Check_Option.sql		071_With_Check_Option.sql
074_Using_Variables.sql		074_Using_Variables.sql
075_Setting_Variables_With_Selects.sql		075_Setting_Variables_With_Selects.sql
076_Select_Update_Example.sql		076_Select_Update_Example.sql
077_Fixing_Select_Update_With_Table_Locks.sql		077_Fixing_Select_Update_With_Table_Locks.sql
079_A_Simple_Transaction.sql		079_A_Simple_Transaction.sql
082_Demonstrating_Isolation_Levels_and_Row_Locking.sql		082_Demonstrating_Isolation_Levels_and_Row_Locking.sql
087_Select_for_Update.sql		087_Select_for_Update.sql
088_Lock_in_Share_Mode.sql		088_Lock_in_Share_Mode.sql
089_String_functions.sql		089_String_functions.sql
090_Date_Functions.sql		090_Date_Functions.sql
091_Control_Flow_Functions.sql		091_Control_Flow_Functions.sql
092_Casting.sql		092_Casting.sql
099_Hello_World.sql		099_Hello_World.sql
100_Setting_the_Definer.sql		100_Setting_the_Definer.sql
101_Procedure_Permission_Example.sql		101_Procedure_Permission_Example.sql
102_Procedure_Permissions.sql		102_Procedure_Permissions.sql
103_Passing_Parameters.sql		103_Passing_Parameters.sql
106_Out_Parameters.sql		106_Out_Parameters.sql
108_If.sql		108_If.sql
109_Local_Variables.sql		109_Local_Variables.sql
110_Account_Withdrawal.sql		110_Account_Withdrawal.sql
111_Transactional_Withdrawal.sql		111_Transactional_Withdrawal.sql
113_Error_Handlers.sql		113_Error_Handlers.sql
114_While_Loops.sql		114_While_Loops.sql
115_Labelled_Loops.sql		115_Labelled_Loops.sql
116_Generating_Random_Data.sql		116_Generating_Random_Data.sql
117_A_Data_Generating_Procedure.sql		117_A_Data_Generating_Procedure.sql
118_Cursors.sql		118_Cursors.sql
119_Fetching_Cursor_Data_With_Loops.sql		119_Fetching_Cursor_Data_With_Loops.sql
120_Case_Expression.sql		120_Case_Expression.sql
123_Solutions4.sql		123_Solutions4.sql
124_Introducing_Triggers.sql		124_Introducing_Triggers.sql
125_Triggers_and_Validation.sql		125_Triggers_and_Validation.sql
126_Triggers_and_Transactions.sql		126_Triggers_and_Transactions.sql
127_Triggers_Exercise.txt		127_Triggers_Exercise.txt
128_Solution5.sql		128_Solution5.sql
130_Defining_Functions.sql		130_Defining_Functions.sql
135_Art_Shop.sql		135_Art_Shop.sql
clean.sql		clean.sql
makefile		makefile
out.png		out.png