Relational_Mario_Database

Learn Relational Databases by Building a Mario Database


CONTENT

1. Start the Terminal
2. Login
3. View Databases
4. Create first_database
5. View first_database
6. Create second_database
7. View Databases
8. Connect to second_database
9. View second_database Tables
10. Create first_table
11. View second_database Tables
12. Create second_table
13. View second_database Tables
14. View second_table Details
15. Create first_column
16. View second_table Details
17. Add id Column
18. View second_table Details
19. Add age Column
20. View second_table Details
21. Drop age Column
22. View second_table Details
23. Drop first_column Column
24. Add name Column
25. View second_table Details
26. Rename name Column
27. View second_table Details
28. Insert Samus Row
29. View second_table Data
30. Insert Mario Row
31. View second_table Data
32. Insert Luigi Row
33. View second_table Data
34. Delete Luigi Row
35. View second_table Data
36. Delete Mario Row
37. Delete Samus Row
38. View second_table Data
39. View second_table Details
40. Drop username Column
41. Drop id Column
42. View second_database Tables
43. Drop second_table
44. Drop first_table
45. View Databases
46. Rename first_database
47. View Databases
48. Connect to mario_database
49. Drop second_database
50. View Databases
51. Display mario_database Tables
52. Create characters Table
53. Add character_id column
54. View characters Details
55. Add name Column
56. Add homeland Column
57. Add favorite_color Column
58. View characters Details
59. Insert Mario Row
60. View characters Data
61. Insert Luigi Row
62. View characters Data
63. Insert Peach Row
64. Add Toadstool and Bowser Rows
65. Add Daisy and Yoshi Rows
66. View characters Data
67. Update Daisy's favorite_color
68. View characters Data
69. Update Toadstool's name
70. View characters Data
71. Update Mario's name
72. View characters Data
73. Update Toad's favorite_color
74. Update Bowser's favorite_color
75. Update Bowser's homeland
76. View characters Data
77. View Sorted characters Data
78. Add name Primary Key
79. View characters Details
80. Drop name Primary Key
81. View characters Details
82. Add character_id Primary Key
83. View characters Details
84. Create more_info Table
85. View mario_database Tables
86. View characters Details
87. Create more_info_id Column
88. Create more_info Primary Key
89. View mario_database Tables
90. Add birthday Column
91. Add height Column
92. Add weight Columns
93. View more_info Details
94. Add character_id Foreign Key
95. View more_info Details
96. Add UNIQUE
97. Add NOT NULL
98. View more_info Details
99. Select character_id
100. Select character_id and name
101. Add more_info for Mario
102. View more_info Data
103. Select character_id and name
104. Add more_info for Luigi
105. View more_info Data
106. Select character_id and name
107. Add more_info for Peach
108. Select Toad's character_id and name
109. Add more_info for Toad
110. View more_info Data
111. Select Bowser's Row
112. Add more_info for Bowser
113. Select Daisy's Row
114. Add more_info for Daisy
115. View more_info Data
116. Select Yoshi's character_id and name
117. Add more_info for Yoshi
118. View all more_info Data
119. Rename height Column
120. Rename weight Column
121. View all more_info Data
122. Create sounds Table
123. View mario_database Tables
124. Add filename Column
125. Add sounds Foreign Key
126. View sounds Details
127. View characters Data
128. Insert its-a-me.wav
129. Insert yippee.wav
130. Insert ha-ha.wav
131. Insert oh-yeah.wav
132. Insert Sounds for Peach
133. Insert Two More Sounds
134. View sounds Data
135. Create actions Table
136. Add action Column
137. Insert run
138. Insert jump
139. Insert duck
140. View actions Data
141. Create Junction Table
142. Add character_id Column
143. Add character_id as Foreign Key
144. View character_actions Details
145. Add action_id Column
146. Add action_id as Foreign Key
147. View character_actions Details
148. Create Composite Primary Key
149. View character_actions Details
150. Insert Yoshi Actions
151. View character_actions Data
152. Insert Daisy Actions
153. Insert Bowser Actions
154. Insert Toad Actions
155. Insert Peach Actions
156. Insert Luigi Actions
157. Insert Mario Actions
158. View character_actions Data
159. Display Tables
160. View characters Data
161. View more_info Data
162. Full Join characters on more_info
163. Full Join characters on sounds
164. Join character_actions with characters and actions