SQL Administration


What is SQL ?

SQL (Structured Query Language) standard interactive and programming language for getting information from and updating a database. Although SQL is both an ANSI and an ISO standard, many database products support SQL with proprietary extensions to the standard language. You can :

  •  Get to grips with the SELECT command and extract the data you are interested in, calculate sums and averages, filter and order data
  •  Summarise data with GROUP BY and then filter it with HAVING, join multiple tables together with inner and outer joins.
  •  Develop UNION queries and advanced joins together with subqueries.
  •  Update records and delete records as well as inserting records, allowing you to maintain data.
  •  Plus lots more ...