SQL server 2014 : a step by step guide to learning SQL / editors, Sikha Bagui and Richard Earp.

Format:

Book

Contributor:

Bagui, Sikha, 1964- editor.

Earp, Richard, 1940- editor.

Series:

Computer science, technology and applications.

Computer Science, Technology and Applications

Language:

English

Subjects (All):

SQL server.

SQL (Computer program language).

Physical Description:

1 online resource (380 p.)

Place of Publication:

New York, [New York] : Nova Science Publishers, Inc., 2015.

Language Note:

English

Summary:

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 rea

Contents:

""SQL SERVER 2014: A STEP BY STEP GUIDE TO LEARNING SQL""; ""SQL SERVER 2014: A STEP BY STEP GUIDE TO LEARNING SQL""; ""Library of Congress Cataloging-in-Publication Data""; ""Contents""; ""Preface""; ""Why This Book?""; ""SQL and SQL Server""; ""Audience and Coverage""; ""Author Contact Information""; ""Chapter 1: Starting Microsoft SQL Server 2014""; ""1.1. Starting Microsoft SQL Server 2014 and SQL""; ""Server Management Studio""; ""1.2. Creating a Database in Microsoft SQL Server 2014""; ""1.2.1. Objects in the Student_course Database""; ""1.2.2. Default System Databases""

""1.3. The Query Editor""""1.3.1. Opening the Query Editor by Right Clicking""; ""1.3.2. Opening the Query Editor Using the New Query Button""; ""1.3.3. Activating (or opening) the Database Using USE""; ""1.4. Creating Tables Using the Load Script""; ""1.5. Viewing Table Designs""; ""1.6. Modifying Table Designs""; ""1.6.1. Modifying Column Designs""; ""1.6.2. Modifying the Table Design Directly""; ""1.7. Viewing Table Data""; ""1.8. Deleting a Table""; ""1.9. Deleting a Database""; ""1.10. Typing a SQL Query or Statement""; ""1.11. Parsing a Query""; ""1.12. Executing a Query""

""1.12.1. Color Coding""""1.13. Saving a Query""; ""1.14. Displaying the Results""; ""1.14.1. Viewing Results in Grid Form""; ""1.14.2. Viewing Results in Text Form""; ""1.14.3. Saving Results to File""; ""1.15. Stopping Execution of a Long Query""; ""1.15.1. Viewing Error Messages""; ""1.16. Printing the Query and Results""; ""1.17. Copying the Query and Results""; ""1.18. Customizing SQL Server 2014""; ""1.18.1. The Environment Tab""; ""1.18.2. The Source Control Tab""; ""1.18.3. The Text Editor Tab""; ""1.18.4. The Query Execution Tab""; ""1.18.5. The Query Results Tab""

""1.18.6. The Designer Tab""""1.18.7. The SQL Server Always on tab""; ""1.18.8. The SQL Server Query Explorer Tab""; ""Summary""; ""Review Questions""; ""Exercises""; ""Chapter 2: Beginning SQL Commands in SQL Server""; ""2.1. Displaying Data with the SELECT Statement""; ""2.1.1. SELECT without the FROM""; ""2.2. Displaying or Selecting Columns from a Table""; ""2.2.1. Displaying or SELECTing One Column from a Table""; ""2.2.2. Displaying or SELECTing More than One Column from a table""; ""2.2.3. Displaying or SELECTing All Columns of a Table""; ""2.2.4. ORDER BY""

""2.2.4.1. ORDER BY and NULLs""""2.2.5. Ascending and Descending Order""; ""2.2.6. Ordering Within an Order""; ""2.3. Displaying or SELECTing Rows from a Table""; ""2.3.1. Filtering with WHERE""; ""2.3.2. The AND Operator""; ""2.3.3. The OR Operator""; ""2.3.4. The BETWEEN Operator""; ""2.3.5. Negating the BETWEEN Operator""; ""2.4. The COUNT Function""; ""2.4.1. IS NULL""; ""2.4.2. IS NOT NULL""; ""2.5. The ROWCOUNT function""; ""2.6. Using Aliases""; ""2.6.1. Column Aliases""; ""2.6.2. Table Aliases""; ""2.6.3. Table Aliases Used as Table Qualifiers""; ""2.7. Synonyms""

""2.8. Adding Comments to SQL Statements""

Notes:

Includes index.

Description based on print version record.

ISBN:

1-63463-554-X

OCLC:

903957175