Chapter 7: Advanced SQL Usage

Chapter 7 - Advanced SQL Usage
byGareth Downes-Powellet al.
Wrox Press 2003

Overview

Author: Bruno Mairlot

• Advanced SQL

• Grouping

• Database Optimization

In this chapter we will look more deeply at what what makes SQL a really useful language for retrieving information.

Retrieving information is done with the SELECT keyword. We will analyze the syntax of SELECT and see how to retrieve information from multiple tables with the JOIN keyword. We will then look at how to order the retrieved information directly from the SQL server. Finally we will look at how to limit the result of a query.

The second part of this chapter will be dedicated to optimization. You will learn how to optimize your SELECT query with indexes.