Introduction to SQL
Structured Query Language SQL
SQL (Structured Query Language) is a query language for relational databases. The roots of SQL go back to SQUARE, a more mathematical oriented language and SEQUEL, a predecessor of SQL from the seventies. There exist different standards (ISO and ANSI) of SQL, but the most common one is SQL-92. The latest standard SQL-99 (or SQL3) even includes XML. In the following Units we will give a simple overview of the most important SQL functions.
- You understand the basic SQL concepts and are able to explain the use of SQL in the areas of data definition, data manipulation, and data control.
- You are able to use SQL to create, modify, and delete tables.
- You can express simple and complex queries with the help of SQL and know how SQL queries are used in nesting or in combinations. You are also able to correctly apply arithmetic operators and set operators within SQL queries.
- You master SQL to add, modify, and delete data tuples.
Data Control (DCL)