Difference between revisions of "Main Page"

From database24
Jump to navigation Jump to search
(Introduction)
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
== General ==
+
Databases are used as backend infrastructure component almost everywhere. There are different [[:Category:Technology|technologies]] to access data from databases and different spots in [[:Category:Architecture|architectures]], where you find databases in applications.
* [[Naming Conventions|Naming Conventions]]
 
  
== SQL ==
+
There are also [[:Category:Conventions|conventions]] you may want to obey, [[:Category:Patterns|patterns]] you may want to use and special constructs in [[:Category:SQL|SQL]] you might never heard of.
* [[Well Formed SQL Statements|Well Formed SQL Statements]]
 
  
== Microsoft Access ==
+
Amongst the multitude of databases out there, you might already know [[:Category:Microsoft Access|Microsoft Access]], [[:Category:Microsoft SQL Server|Microsoft SQL Server]] and [[:Category:Oracle|Oracle]].
Technically speaking "Microsoft Access" is a front end for the "Jet Database Engine". For the sake of simplicity and as many people do not know the difference, the database will henceforth be called "Microsoft Access" too.
 
  
=== Coding ===
+
Databases are usually queried with [[:Category:SQL|SQL statements]], but you also might have come across some code in [[:Category:VBA|VBA]], which makes use of different [[:Category:Technology|technologies]].
* [[Microsoft Access VBA Coding Conventions|VBA Coding Conventions]]
 
* [[Microsoft Access VBA Code Snippets|VBA Code Snippets]]
 
* [[Microsoft Access Code Management|Code Management]]
 
 
 
=== Architecture ===
 
* [[Microsoft Access Front End|Front End]]
 
* Back End
 

Latest revision as of 16:49, 5 February 2016

Databases are used as backend infrastructure component almost everywhere. There are different technologies to access data from databases and different spots in architectures, where you find databases in applications.

There are also conventions you may want to obey, patterns you may want to use and special constructs in SQL you might never heard of.

Amongst the multitude of databases out there, you might already know Microsoft Access, Microsoft SQL Server and Oracle.

Databases are usually queried with SQL statements, but you also might have come across some code in VBA, which makes use of different technologies.