SQL Server 2014: A Step by Step Guide to Learning SQL



Series: Computer Science, Technology and Applications
BISAC: COM014000

Written for readers who have little or no previous experience with databases, SQL, or Microsoft SQL Server database software, this book provides a systematic approach to learning SQL (Structured Query Language) using SQL Server database software. It starts with simple SQL concepts, and progresses to more complex query development. Each chapter is written in a step-by-step manner and has examples that can be executed using SQL Server. Using the sample database, readers can experience hands-on SQL programming in SQL Server. This text also presents exercises at the end of the chapters to help readers gain proficiency in SQL.

(Imprint: Nova)

Table of Contents

Table of Contents


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


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.

Publish with Nova Science Publishers

We publish over 800 titles annually by leading researchers from around the world. Submit a Book Proposal Now!