Sql Database Essay

779 Words4 Pages
SQL Database Charles W. Golden Dr. Tom Swanson ITM440 SLP 3 September 27, 2010 Introduction This chapter is dedicated to SQL, which is regarded as a Structured Query Language, whose purpose is to manage data and relational database management systems (RDBMS), and was first founded on a relational algebra protocol. One of the important aspects that this tutorial was trying to get the user to understand is that SQL is used to insert data, query, and update and delete data. SQL is also uses data sets know as schema, which is used to define the tables the fields, relationships, views, indexes, packages, procedures, functions, queues, and other elements. If you explore the schema further you will learn that schemas are usually located as a data dictionary. Even though the term schema is defined in text database language, it can also be utilized to describe a graphical depiction of the database structure. The SQL language is usually divided into several language parameters; these are listed as Clauses, which are used to control constituent components of statements and queries. The remaining SQL parameters are Expressions, Predicates, Queries, and Statements Desktop vs. Servers In general desktop databases are inexpensive, they regarded as a simple solution when compared to more complex applications. They are identified by there capability to run small application directly from their desktop or personal computer. One of the most widely known desktop products is Microsoft, but other application can be utilized as well i.e., FoxPro, Paradox, and Filmmaker Pro to name a few. One of the prominent reasons to choose desktop over server applications is cost. Desktop databases are also more user friendly when compared to the more complex server databases, desktop database generally offer the user an easy to use graphical user interface. Many of
Open Document