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

Sikha Bagui and Richard Earp
Department of Computer Science, University of West Florida, AL, USA

Series: Computer Science, Technology and Applications
BISAC: COM014000

Clear

$205.00

Volume 10

Issue 1

Volume 2

Volume 3

Special issue: Resilience in breaking the cycle of children’s environmental health disparities
Edited by I Leslie Rubin, Robert J Geller, Abby Mutic, Benjamin A Gitterman, Nathan Mutic, Wayne Garfinkel, Claire D Coles, Kurt Martinuzzi, and Joav Merrick

eBook

Digitally watermarked, DRM-free.
Immediate eBook download after purchase.

Product price
Additional options total:
Order total:

Quantity:

Browse Wishlist
Browse Wishlist

Details

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)

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

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.

You have not viewed any product yet.