SQL Tutorial exercises.

Contents:

Relational databases. Introduction.

SQL. Browse.

Using SQL to extract information from tables

Using relational and Boolean operations to create a more complex predicates

The use of special operators under

Generalization of data using aggregate functions

Formation prompting

Acquiring multiple tables as well as a

Combining the table with

Insert one query inside another

The correlation subqueries

Use operator EXISTS

Using Operators ANY, ALL, and SOME

Using the UNION clause

Entering, deletion and modification of the values \u200b\u200bof the field

Using Subqueries with teams modification

Creating Tables

Limit values \u200b\u200bof your data

Maintain the integrity of your data

Representation. Introduction.

Changing values \u200b\u200busing representations

Who can do what in the database?

Global Aspects SQL

How SQL data stored in an orderly manner

Using SQL with other languages \u200b\u200b(embedded SQL)

Apps