- 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
About the Authors
Dr. Sikha Bagui is an Assistant Professor in the Computer Science Department at the University of West Florida in Pensacola. She and Richard Walsh Earp have teamed up to write "Learning SQL: A Step-By-Step Guide using Oracle" and "Learning SQL: A Step-By-Step Guide using Access" for Addison-Wesley, and "Conceptual Database Design Using ER Diagrams" for CRC Press. Dr. Bagui and Richard Earp have also collaborated on several articles for academic journals in their field, and have designed an introductory database course.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.