Learning SQL on SQL Server 2005
by Richard Walsh Earp, Sikha Saha Bagui
Learning SQL on SQL Server 2005
- Dedication
- A Note Regarding Supplemental Files
- Preface
- 1. Starting Microsoft SQL Server 2005
- Starting Microsoft SQL Server 2005 and SQL Server 2005’s Management Studio
- Creating a Database in Microsoft SQL Server 2005
- The Query Editor
- Creating Tables Using the Load Script
- Viewing Table Definitions
- Modifying Table Definitions
- Viewing Table Data
- Deleting a Table
- Deleting a Database
- Entering a SQL Query or Statement
- Parsing a Query
- Executing a Query
- Saving a Query
- Displaying the Results
- Stopping Execution of a Long Query
- Printing the Query and Results
- Customizing SQL Server 2005
- Summary
- Review Questions
- Exercises
- 2. Beginning SQL Commands in SQL Server
- Displaying Data with the SELECT Statement
- Displaying or SELECTing Rows or Tuples from a Table
- The COUNT Function
- The ROWCOUNT Function
- Using Aliases
- Synonyms
- Adding Comments to SQL Statements
- Some Conventions for Writing SQL Statements
- A Few Notes About SQL Server 2005 Syntax
- Summary
- Review Questions
- Exercises
- 3. Creating, Populating, Altering, and Deleting Tables
- Data Types in SQL Server 2005
- Creating a Table
- Inserting Values into a Table
- The UPDATE Command
- The ALTER TABLE Command
- The DELETE Command
- Deleting a Table
- Summary
- Review Questions
- Exercises
- References
- 4. Joins
- 5. Functions
- 6. Query Development and Derived Structures
- 7. Set Operations
- Introducing Set Operations
- The UNION Operation
- The UNION ALL Operation
- Handling UNION and UNION ALL Situations with an Unequal Number of Columns
- The IN and NOT..IN Predicates
- The Difference Operation
- The Union and the Join
- A UNION Used to Implement a Full Outer Join
- Summary
- Review Questions
- Exercises
- Optional Exercise
- 8. Joins Versus Subqueries
- 9. Aggregation and GROUP BY
- 10. Correlated Subqueries
- 11. Indexes and Constraints on Tables
- A. The Student Database and Other Tables Used in This Book
- B. Script Used to Create the Student_course Database
- Glossary of Terms
- Important Commands and Functions
- Index
- About the Authors
- Colophon
- Copyright
Learning SQL on SQL Server 2005
Sikha Saha Bagui
Richard Walsh Earp
Beijing • Cambridge • Farnham • Köln • Sebastopol • Tokyo
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.