SQL

Synopsis of SQL

This practical guide offers a quick and easy approach to learning how to work with SQL, the universal standard language for data processing. It explains how to execute queries, apply filters, perform searches, sort data, and perform joins between queries. It also addresses data manipulation, adding new information, updating and deleting existing data, as well as defining database structures. The process of creating complex elements such as triggers, functions, and stored procedures is described, using the SQL-derived languages Transact-SQL and PL/SQL. The book is aimed at computer users, from web designers to office automation users who operate with applications such as Access, to programmers and database administrators.