Beginning SQL Queries: From Novice to ProfessionalClare Churcher’s Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.
|
Contents
CHAPTER | 3 |
CHAPTER | 5 |
CHAPTER | 8 |
CHAPTER | 11 |
Relational Database Overview 1 | 16 |
Simple Queries on One Table | 17 |
A First Look at Joins | 41 |
Other Types of Joins | 54 |
Set Operations | 107 |
Overview of Basic Set Operations | 108 |
Intersection | 117 |
Difference | 123 |
Summary | 132 |
Aggregate Operations | 133 |
Efficiency Considerations | 153 |
How to Approach a Query | 169 |
Other editions - View all
Common terms and phrases
Access answer apply approach attribute average Cartesian product Chapter clause club coach columns combine complex condition consider copy COUNT create database describes division duplicates e.TourID entered entered tournament Entry table equivalent example EXISTS expression field Find Members FirstName foreign key Gender give GROUP Handicap implementations INNER JOIN intersection involving Junior keyword LastName look m.FirstName m.LastName m.MemberID manager means Member table MemberID membership MemberType names nested query Null Open tournaments operations outer join particular possible primary key problem query question records refer relational algebra relational calculus relationships represent result retrieve rows SELECT SELECT MemberID select operation shown in Listing shows simple single sort specify SQL statement subset of rows table in Figure TourID tournament 25 understand union usually write