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.



Dreamweaver MX PHP Web Development
Dreamweaver Mx: Advanced Php Web Development
ISBN: 1904151191
EAN: 2147483647
Year: 2001
Pages: 88

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net