Table of Contents

Table of Contents

Preface

Author Contact Information

Chapter 1 – Starting Microsoft SQL Server 2014 (pp. 1-26)

Chapter 2 – Beginning SQL Commands in SQL Server (pp. 27-66)

Chapter 3 – Creating, Populating, Altering and Deleting Tables (pp. 67-94)

Chapter 4 – Joins (pp. 95-120)

Chapter 5 – Functions (pp. 121-176)

Chapter 6 – Query Development and Derived Structures (pp. 177-208)

Chapter 7 – Set Operations (pp. 209-244)

Chapter 8 – Joins versus Subqueries (pp. 245-260)

Chapter 9 – Aggregation and GROUP BY (pp. 261-282)

Chapter 10 – Correlated Subqueries (pp. 283-308)

Chapter 11 – Indexes and Constraints on Tables (pp. 309-340)

Appendix 1. – The Student_Course Database and Other Tables Used in This Book (pp. 341-344)

Appendix 2. – Script Used to Create Student_Course Database (pp. 345-354)

Glossary of Terms

Glossary of Important Commands and Functions

Index

---

Additional Information

The book can be used in undergraduate degree programs in Computer Science and Management Information Systems (in Database courses) in University and College. It can also be used by the working professional who needs to learn SQL.