This section explains the use of structured query language, often called SQL or SQL. SQL is not in the traditional sense a programming language, but a data usage language for defining and processing a relational database. It is, however possible by embedding SQL into a scripting language such as Java or C to make it a fully operable programming language. SQL was first developed by IBM in 1978 by EF Cod, and adopted by NC the American National Standards Institute in 1986. Many changes have occurred over the years and the latest upgrade was released in 2011. SQL is an easy fix to database problems.
It has been thoroughly tested, stable, transaction based and most important, SQL is a standard well known and understood thoroughly documented. SQL is a text oriented and user and user friendly. being developed long before a graphical user interface or GUI is were popularized. Today most DBMS is employee SQL as a as a GUI. It is important to note that most professional programmers prefer native SQL statements, but we'll take an easier route and choose the GUI. We'll use SQL with Microsoft Access.
A lot knowledge of SQL is not a requirement for our purpose. A thorough understanding of this data language is required to become an effective MS Access developer. SQL statements are divided into categories. One data Definition Language, or DDL statements are used for creating tables relationships. For example, the CREATE TABLE student class to data manipulation When which are DML statements are used for querying and updating data. For example, insert into course values, and the infamous select from where statement, select student number, comma student name from student where city equals Washington.
Three, data control language, or dcl statements are used to grant or revoke permissions to users and groups. For example, Grant, revoke, deny. Different DBMS products implement SQL in different ways. Whether it is a GUI or programming language version, minor syntactical adjustments may be necessary. The MS Access workbench we use follow a well known QB query by example variant