Skip to Content

Changes for page Database connectivity

Last modified by Erik Bakker on 2024/09/24 16:20
From version 61.1
edited by Erik Bakker
on 2024/09/24 16:20
Change comment: There is no comment for this version
To version 32.1
edited by Erik Bakker
on 2022/05/03 13:16
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Database connectivity
1 +Solution Architecture
Default language
... ... @@ -1,1 +1,1 @@
1 -sw
1 +en
Content
... ... @@ -1,8 +1,6 @@
1 -{{velocity}}
2 -#set ($discard = $xwiki.ssx.use('Main.Extensions.ContainerSizingCoursePage.WebHome'))
3 -{{/velocity}}
1 +In this course, we will zoom in on various architectural aspects of the platform. We will zoom in on the choices to be made in Capture when choosing the correct system for the job. We will take a look at the various platform components that are important in eMagiz. We will expand our knowledge of Design Architecture. We learn how to update our memory settings for on-premise installations. Also, we will take a look at what the H2 database is and why it is in every entry (or should be). Last but not least we will take a look at the importance of topic storage. As you can see quite a mixed bag of topics. This should broaden your knowledge of the architectural sides of the platform.
4 4  
5 -{{container}}{{container layoutStyle="columns"}}(((In this course, we will focus on databases and how to properly connect to them with the help of the eMagiz platform. This course is introductory in nature. It focuses on the connection between the platform and databases. In other classes, we will expand on this knowledge.)))((({{html}}<div class="strip__attribute" style="text-align:center"><table><tr><td><img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/></td></tr><tr><td><div class="strip__attribute-label">20-30 minutes</div></td></tr></table></div>{{/html}}))){{/container}}{{/container}}
3 +* **Total time:** between 45 and 60 minutes
6 6  
7 7  
8 8  (% style="border-color:#10137e" %)
... ... @@ -13,51 +13,46 @@
13 13   <main class="master">
14 14   <ul class="strip-container">
15 15   <li class="strip">
16 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-available-options" target="_blank" class="strip__link">
17 - <div class="strip__attribute__new__stack">
18 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
19 - </div>
20 - <label for="" class="strip__label">
21 - <span>226</span>
22 - Available Options
14 + <a href="../../docs/microlearning/intermediate-solution-architecture-system-vs-multi-tenant-system" class="strip__link">
15 + <label for="" class="strip__label">
16 + <span>204</span>
17 + System vs Multi-tenant system
23 23   </label>
24 24   <div class="strip__attribute">
25 25   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
26 - <div class="strip__attribute-label">4 minutes</div>
21 + <div class="strip__attribute-label">5 minutes</div>
27 27   </div>
28 28   <div class="strip__attribute">
29 29   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
30 30   <div class="strip__attribute-label">Developer</div>
31 31   </div>
27 + <div class="strip__attribute">
28 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
29 + <div class="strip__attribute-label">Architect</div>
30 + </div>
32 32   </a>
33 33   </li>
34 - <li class="strip">
35 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-driver" target="_blank" class="strip__link">
36 - <div class="strip__attribute__new__stack">
37 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
38 - </div>
39 - <label for="" class="strip__label">
40 - <span>226</span>
41 - Driver
33 + <li class="strip">
34 + <a href="../../docs/microlearning/intermediate-solution-architecture-explaining-platform-components" class="strip__link">
35 + <label for="" class="strip__label">
36 + <span>204</span>
37 + Explaining Platform Components
42 42   </label>
43 43   <div class="strip__attribute">
44 44   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
45 - <div class="strip__attribute-label">4 minutes</div>
41 + <div class="strip__attribute-label">9 minutes</div>
46 46   </div>
47 47   <div class="strip__attribute">
48 48   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
49 - <div class="strip__attribute-label">Developer</div>
45 + <div class="strip__attribute-label">All</div>
50 50   </div>
51 51   </a>
52 52   </li>
53 - <li class="strip">
54 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-sql-query" target="_blank" class="strip__link">
55 - <div class="strip__attribute__new__stack">
56 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
57 - </div>
58 - <label for="" class="strip__label">
59 - <span>226</span>
60 - SQL Query
49 + <li class="strip">
50 + <a href="../../docs/microlearning/intermediate-solution-architecture-understanding-design-architecture" class="strip__link">
51 + <label for="" class="strip__label">
52 + <span>204</span>
53 + Understanding Design Architecture
61 61   </label>
62 62   <div class="strip__attribute">
63 63   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
... ... @@ -65,37 +65,31 @@
65 65   </div>
66 66   <div class="strip__attribute">
67 67   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
68 - <div class="strip__attribute-label">Developer</div>
61 + <div class="strip__attribute-label">All</div>
69 69   </div>
70 70   </a>
71 71   </li>
72 72   <li class="strip">
73 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-update-database-after-retrieval" target="_blank" class="strip__link">
74 - <div class="strip__attribute__new__stack">
75 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
76 - </div>
77 - <label for="" class="strip__label">
78 - <span>226</span>
79 - Update database after retrieval
66 + <a href="../../docs/microlearning/intermediate-solution-architecture-edit-memory-on-premise-runtime-windows" class="strip__link">
67 + <label for="" class="strip__label">
68 + <span>204</span>
69 + Edit memory for on-premise runtime (Windows)
80 80   </label>
81 81   <div class="strip__attribute">
82 82   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
83 - <div class="strip__attribute-label">4 minutes</div>
73 + <div class="strip__attribute-label">6 minutes</div>
84 84   </div>
85 85   <div class="strip__attribute">
86 86   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
87 - <div class="strip__attribute-label">Developer</div>
77 + <div class="strip__attribute-label">All</div>
88 88   </div>
89 89   </a>
90 90   </li>
91 91   <li class="strip">
92 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-configuration" target="_blank" class="strip__link">
93 - <div class="strip__attribute__new__stack">
94 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-reading32.svg"/>
95 - </div>
96 - <label for="" class="strip__label">
97 - <span>226</span>
98 - Connectivity Configuration Example
82 + <a href="../../docs/microlearning/intermediate-solution-architecture-function-of-h2-database" class="strip__link">
83 + <label for="" class="strip__label">
84 + <span>204</span>
85 + H2 Database, Function
99 99   </label>
100 100   <div class="strip__attribute">
101 101   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
... ... @@ -103,30 +103,31 @@
103 103   </div>
104 104   <div class="strip__attribute">
105 105   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
106 - <div class="strip__attribute-label">Developer</div>
93 + <div class="strip__attribute-label">All</div>
107 107   </div>
108 108   </a>
109 109   </li>
110 110   <li class="strip">
111 - <a href="/bin/view/Main/eMagiz%20Academy/Microlearnings/Intermediate%20Level/Database%20connectivity/intermediate-database-connectivity-database-operations" target="_blank" class="strip__link">
112 - <div class="strip__attribute__new__stack">
113 - <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-exercises32.svg"/>
114 - </div>
115 - <label for="" class="strip__label">
116 - <span>226</span>
117 - Database operations
98 + <a href="../../docs/microlearning/intermediate-solution-architecture-topic-storage" class="strip__link">
99 + <label for="" class="strip__label">
100 + <span>204</span>
101 + Topic Storage
118 118   </label>
119 119   <div class="strip__attribute">
120 120   <img class="strip__attribute-icon strip__attribute-icon--duration" src="/bin/download/Main/Images/General/WebHome/icon-duration32.svg"/>
121 - <div class="strip__attribute-label">6 minutes</div>
105 + <div class="strip__attribute-label">5 minutes</div>
122 122   </div>
123 123   <div class="strip__attribute">
124 124   <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
125 125   <div class="strip__attribute-label">Developer</div>
126 126   </div>
111 + <div class="strip__attribute">
112 + <img class="strip__attribute-icon strip__attribute-icon--roles" src="/bin/download/Main/Images/General/WebHome/icon-roles32.svg"/>
113 + <div class="strip__attribute-label">Architect</div>
114 + </div>
127 127   </a>
128 128   </li>
129 - </ul>
117 + </ul>
130 130   </main>
131 131   </div>
132 132  </div>