Learning SQL on SQL Server 2005

Dedication;
Preface;
Why This Book?;
SQL and SQL Server;
Audience and Coverage;
A Few Notes About SQL Server 2005 Installation;
Conventions Used in This Book;
Using Code Examples;
How to Contact Us;
Acknowledgments;
Chapter 1: Starting Microsoft SQL Server 2005;
1.1 Starting Microsoft SQL Server 2005 and SQL Server 2005’s Management Studio;
1.2 Creating a Database in Microsoft SQL Server 2005;
1.3 The Query Editor;
1.4 Creating Tables Using the Load Script;
1.5 Viewing Table Definitions;
1.6 Modifying Table Definitions;
1.7 Viewing Table Data;
1.8 Deleting a Table;
1.9 Deleting a Database;
1.10 Entering a SQL Query or Statement;
1.11 Parsing a Query;
1.12 Executing a Query;
1.13 Saving a Query;
1.14 Displaying the Results;
1.15 Stopping Execution of a Long Query;
1.16 Printing the Query and Results;
1.17 Customizing SQL Server 2005;
1.18 Summary;
1.19 Review Questions;
1.20 Exercises;
Chapter 2: Beginning SQL Commands in SQL Server;
2.1 Displaying Data with the SELECT Statement;
2.2 Displaying or SELECTing Rows or Tuples from a Table;
2.3 The COUNT Function;
2.4 The ROWCOUNT Function;
2.5 Using Aliases;
2.6 Synonyms;
2.7 Adding Comments to SQL Statements;
2.8 Some Conventions for Writing SQL Statements;
2.9 A Few Notes About SQL Server 2005 Syntax;
2.10 Summary;
2.11 Review Questions;
2.12 Exercises;
Chapter 3: Creating, Populating, Altering, and Deleting Tables;
3.1 Data Types in SQL Server 2005;
3.2 Creating a Table;
3.3 Inserting Values into a Table;
3.4 The UPDATE Command;
3.5 The ALTER TABLE Command;
3.6 The DELETE Command;
3.7 Deleting a Table;
3.8 Summary;
3.9 Review Questions;
3.10 Exercises;
3.11 References;
Chapter 4: Joins;
4.1 The JOIN;
4.2 The Cartesian Product;
4.3 Equi-Joins and Non-Equi-Joins;
4.4 Self Joins;
4.5 Using ORDER BY with a Join;
4.6 Joining More Than Two Tables;
4.7 The OUTER JOIN;
4.8 Summary;
4.9 Review Questions;
4.10 Exercises;
Chapter 5: Functions;
5.1 Aggregate Functions;
5.2 Row-Level Functions;
5.3 Other Functions;
5.4 String Functions;
5.5 CONVERSION Functions;
5.6 DATE Functions;
5.7 Summary;
5.8 Review Questions;
5.9 Exercises;
Chapter 6: Query Development and Derived Structures;
6.1 Query Development;
6.2 Parentheses in SQL Expressions;
6.3 Derived Structures;
6.4 Query Development with Derived Structures;
6.5 Summary;
6.6 Review Questions;
6.7 Exercises;
Chapter 7: Set Operations;
7.1 Introducing Set Operations;
7.2 The UNION Operation;
7.3 The UNION ALL Operation;
7.4 Handling UNION and UNION ALL Situations with an Unequal Number of Columns;
7.5 The IN and NOT..IN Predicates;
7.6 The Difference Operation;
7.7 The Union and the Join;
7.8 A UNION Used to Implement a Full Outer Join;
7.9 Summary;
7.10 Review Questions;
7.11 Exercises;
7.12 Optional Exercise;
Chapter 8: Joins Versus Subqueries;
8.1 Subquery with an IN Predicate;
8.2 The Subquery as a Join;
8.3 When the Join Cannot Be Turned into a Subquery;
8.4 More Examples Involving Joins and IN;
8.5 Using Subqueries with Operators;
8.6 Summary;
8.7 Review Questions;
8.8 Exercises;
Chapter 9: Aggregation and GROUP BY;
9.1 A SELECT in Modified BNF;
9.2 The GROUP BY Clause;
9.3 The HAVING Clause;
9.4 GROUP BY and HAVING: Aggregates of Aggregates;
9.5 Auditing in Subqueries;
9.6 Nulls Revisited;
9.7 Summary;
9.8 Review Questions;
9.9 Exercises;
Chapter 10: Correlated Subqueries;
10.1 Noncorrelated Subqueries;
10.2 Correlated Subqueries;
10.3 Existence Queries and Correlation;
10.4 SQL Universal and Existential Qualifiers;
10.5 Summary;
10.6 Review Questions;
10.7 Exercises;
Chapter 11: Indexes and Constraints on Tables;
11.1 The “Simple” CREATE TABLE;
11.2 Indexes;
11.3 Constraints;
11.4 Summary;
11.5 Review Questions;
11.6 Exercises;
The Student Database and Other Tables Used in This Book;
;
Script Used to Create the Student_course Database;
Glossary of Terms;
Important Commands and Functions;
Colophon;