Advertisement

Introducing SQL Server

  • Authors
  • Mike McQuillan

Table of contents

  1. Front Matter
    Pages i-xxiii
  2. Mike McQuillan
    Pages 1-5
  3. Mike McQuillan
    Pages 7-32
  4. Mike McQuillan
    Pages 33-51
  5. Mike McQuillan
    Pages 53-69
  6. Mike McQuillan
    Pages 71-95
  7. Mike McQuillan
    Pages 97-106
  8. Mike McQuillan
    Pages 107-128
  9. Mike McQuillan
    Pages 129-141
  10. Mike McQuillan
    Pages 143-162
  11. Mike McQuillan
    Pages 163-176
  12. Mike McQuillan
    Pages 177-192
  13. Mike McQuillan
    Pages 193-222
  14. Mike McQuillan
    Pages 223-234
  15. Mike McQuillan
    Pages 235-263
  16. Mike McQuillan
    Pages 265-281
  17. Mike McQuillan
    Pages 283-304
  18. Mike McQuillan
    Pages 305-318
  19. Mike McQuillan
    Pages 319-335
  20. Mike McQuillan
    Pages 337-348
  21. Mike McQuillan
    Pages 349-368
  22. Mike McQuillan
    Pages 369-371
  23. Mike McQuillan
    Pages 373-375
  24. Mike McQuillan
    Pages 377-380
  25. Mike McQuillan
    Pages 381-381
  26. Back Matter
    Pages 383-388

About this book

Introduction

Introducing SQL Server is a fast and easy introduction to SQL Server and the world of relational databases. You’ll learn how databases work and how to use the T-SQL language by practicing on one of the most widely-used and powerful database engines in the corporate world: Microsoft SQL Server.

Do you quake at the sight of a SELECT statement? Start to shiver when people start talking about tables and rows? Fear not, Introducing SQL Server is here to rescue you. The book focuses on the knowledge and skills needed to begin your journey toward becoming a solid and competent SQL Server professional and database programmer. You’ll learn the core concepts of SQL Server, from installing the software to executing and profiling queries.

Introducing SQL Server is aimed at SQL Server newcomers as well as at those wanting to improve their database skills. You’ll put a comprehensive database together as you work through the book. You will create tables and learn to use constraints; create reusable functions and stored procedures; and even learn how indexes work and what they bring in terms of increased performance. Introducing SQL Server shows you that databases don’t need to be difficult.

• Teaches you how to build a SQL Server database from scratch
• Takes a tutorial-based approach, with each chapter building on the last
• Covers what you need to know for common SQL Server development tasks


Bibliographic information

Industry Sectors
Pharma
Chemical Manufacturing
Biotechnology
Finance, Business & Banking
Electronics
IT & Software
Telecommunications
Consumer Packaged Goods
Energy, Utilities & Environment
Engineering