Skip to Content

Changes for page SQL Query

Last modified by Danniar Firdausy on 2024/09/18 20:00
From version 9.4
edited by Danniar Firdausy
on 2024/09/11 10:31
Change comment: There is no comment for this version
To version 9.6
edited by Danniar Firdausy
on 2024/09/18 19:59
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -1,5 +1,5 @@
1 1  {{container}}{{container layoutStyle="columns"}}(((
2 -In this microlearning, we will learn the basics of SQL queries. With the help of this information, you can start writing the correct queries to retrieve and write data from and to a database.
2 +In this microlearning, we will explore the fundamentals of SQL queries. By understanding these concepts, you will be equipped to write basic queries to retrieve and modify data in a database.
3 3  
4 4  Should you have any questions, please get in touch with [[academy@emagiz.com>>mailto:academy@emagiz.com]].
5 5  
... ... @@ -76,10 +76,11 @@
76 76  
77 77  == 4. Key takeaways ==
78 78  
79 -* These examples cover the basics of the SQL language
80 -* The SQL language has its form of CRUD operations
81 -* You can dynamically fill the values of the SQL properties with the help of SpEL expressions
82 -* Other types of databases might require other queries
79 +* These examples cover the basic SQL operations: INSERT (Create), SELECT (Read), UPDATE (Update), and DELETE (Delete).
80 +* SQL queries allow you to perform essential CRUD operations to manage data in a database.
81 +* You can use dynamic values in SQL queries through SpEL expressions, making your queries more adaptable and flexible.
82 +* While SQL is commonly used, other databases may require different query languages or syntax for similar operations.
83 +* Always ensure conditions (like WHERE clauses) are applied to avoid unintentional modifications or deletions of data.
83 83  
84 84  == 5. Suggested additional readings ==
85 85  
... ... @@ -88,9 +88,9 @@
88 88  * [[eMagiz Store (Menu)>>doc:Main.eMagiz Store.Accelerators.WebHome||target="blank"]]
89 89  ** [[Accelerators (Navigation)>>doc:Main.eMagiz Store.Accelerators.WebHome||target="blank"]]
90 90  *** [[Database Connectivity (Explanation)>>doc:Main.eMagiz Store.Accelerators.Database Connectivity.WebHome||target="blank"]]
91 -* [[Intermediate Level (Menu)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.WebHome||target="blank"]]
92 -** [[Solution Architecture (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Solution Architecture.WebHome||target="blank"]]
93 -*** [[H2 Database, Function (Explanation)>>doc:Main.eMagiz Academy.Microlearnings.Intermediate Level.Solution Architecture.intermediate-solution-architecture-function-of-h2-database||target="blank"]]
92 +* [[Expert Level (Menu)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.WebHome||target="blank"]]
93 +** [[Solution Architecture (Navigation)>>doc:Main.eMagiz Academy.Microlearnings.Expert Level.Solution Architecture.WebHome||target="blank"]]
94 +*** [[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 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 95  * [[SQL Explained (External)>>https://www.w3schools.com/sql/default.Asp||target="blank"]]
96 96  )))((({{toc/}}))){{/container}}{{/container}}