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 ...