Skip to Content

Changes for page SQL Query

Last modified by Danniar Firdausy on 2024/09/18 20:00
From version 9.5
edited by Danniar Firdausy
on 2024/09/11 10:32
Change comment: There is no comment for this version
To version 8.1
edited by Erik Bakker
on 2023/01/23 10:06
Change comment: There is no comment for this version

Summary

Details

Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.dfirdausy
1 +XWiki.ebakker
Content
... ... @@ -74,23 +74,23 @@
74 74  
75 75  {{warning}}You should be careful when deleting records in a table! Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted!{{/warning}}
76 76  
77 -== 4. Key takeaways ==
77 +== 4. Assignment ==
78 78  
79 +See if you can find any database implementation within the projects you can access. This assignment can be completed with the help of the (Academy) project that you have created/used in the previous assignment.
80 +
81 +== 5. Key takeaways ==
82 +
79 79  * These examples cover the basics of the SQL language
80 80  * The SQL language has its form of CRUD operations
81 81  * You can dynamically fill the values of the SQL properties with the help of SpEL expressions
82 82  * Other types of databases might require other queries
83 83  
84 -== 5. Suggested additional readings ==
88 +If you are interested in this topic and want more information, please read the help text provided by eMagiz and read more information on the following link:
85 85  
86 -If you are interested in this topic and want more information on it, please read the help text provided by eMagiz and see the following links:
90 +* [[SQL Explained>>https://www.w3schools.com/sql/default.Asp||target="blank"]]
87 87  
88 -* [[eMagiz Store (Menu)>>doc:Main.eMagiz Store.Accelerators.WebHome||target="blank"]]
89 -** [[Accelerators (Navigation)>>doc:Main.eMagiz Store.Accelerators.WebHome||target="blank"]]
90 -*** [[Database Connectivity (Explanation)>>doc:Main.eMagiz Store.Accelerators.Database Connectivity.WebHome||target="blank"]]
91 -* [[Expert Level (Menu)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.WebHome||target="blank"]]
92 -** [[Solution Architecture (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Solution Architecture.WebHome||target="blank"]]
93 -*** [[H2 Database for other applications (Explanation)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Solution Architecture.expert-solution-architecture-h2-database-for-other-applications||target="blank"]]
94 -* [[SQL Query (Search Results)>>url:https://docs.emagiz.com/bin/view/Main/Search?sort=score&sortOrder=desc&highlight=true&facet=true&r=1&f_space_facet=0%2FMain.&l_space_facet=10&f_type=DOCUMENT&f_locale=en&f_locale=&f_locale=en&text=%22sql+query%22||target="blank"]]
95 -* [[SQL Explained (External)>>https://www.w3schools.com/sql/default.Asp||target="blank"]]
92 +== 7. Silent demonstration video ==
93 +
94 +As this is more of theoretical microlearning, there is no video accompanying the microlearning.
95 +
96 96  )))((({{toc/}}))){{/container}}{{/container}}