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;