The Resource Microsoft SQL Server 2005 programming for dummies, Andrew Watt, (electronic resource)

Microsoft SQL Server 2005 programming for dummies, Andrew Watt, (electronic resource)

Label
Microsoft SQL Server 2005 programming for dummies
Title
Microsoft SQL Server 2005 programming for dummies
Statement of responsibility
Andrew Watt
Creator
Subject
Genre
Language
  • eng
  • eng
Summary
Create and modify databases and keep them secureGet up to speed on using T-SQL to store and manipulate dataSQL Server 2005 improves an already great database management system. This book shows you how to put it to work in a hurry. You'll find out how to use the SQL Server Management Studio and the SQLCMD utility to write T-SQL code, retrieve data from single or multiple SQL Server tables, add data using the INSERT statement, and much more.* Create queries to retrieve data*Ensure SQL Server security*Use Visual Studio(r) 2005 with SQL Server*<b
Member of
Cataloging source
MiAaPQ
http://library.link/vocab/creatorDate
1953-
http://library.link/vocab/creatorName
Watt, Andrew
Dewey number
005.7585
Illustrations
illustrations
Index
index present
Language note
English
LC call number
QA76.9.C55
LC item number
W388 2007
Literary form
non fiction
Nature of contents
dictionaries
Series statement
--For dummies
http://library.link/vocab/subjectName
  • Client/server computing
  • Database management
Label
Microsoft SQL Server 2005 programming for dummies, Andrew Watt, (electronic resource)
Instantiates
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
  • cr
Content category
text
Content type code
  • txt
Contents
  • Microsoft SQL Server 2005 Programming For Dummies; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About SQL Server 2005 Programming For Dummies; Foolish Assumptions; Conventions Used in This Book; 2; What You Don't Have to Read; How This Book Is Organized; 3; 4; Icons Used in This Book; Where to Go from Here; 5; 6; Part I: Get Started Using the SQL Server 2005 Development Environment; Chapter 1: The Joy of SQL Server 2005 Programming; Deciding Which Version of SQL Server 2005 to Use; Gathering and Manipulating Data
  • Enforcing Business Rules for Your DatabaseEnsuring SQL Server Security; When Transact-SQL Isn't Enough; Chapter 2: Understanding Database Fundamentals; Getting to Know the Database Engine; Discovering Database Objects; Introducing SQL Server Data Types; Getting Familiar with SQL Server Naming Rules; Talking Transact-SQL; Chapter 3: Getting to Know the SQL Server Toolset; Exploring SQL Server Management Studio; Using the SQLCMD Utility; Getting to Know the SQL Server Configuration Manager; Using Other SQL Server Programming Tools; Accessing SQL Server Books Online (BOL)
  • Installing the SQL Server Sample DatabasesPart II: Retrieving Data Using Transact-SQL; Chapter 4: Retrieving Data Using the SELECT Statement; Exploring Your Database's Objects; Introducing the SELECT Statement; Using the FROM Clause; The WHERE Clause; The ORDER BY Clause; The GROUP BY Clause; Chapter 5: Creating Joins; Understanding the Need for Joins; Creating an Inner Join; Creating an Outer Join; Creating a Cross Join; Chapter 6: Creating Advanced Queries; Using Subqueries; Examining the EXISTS Keyword; Using the CAST and CONVERT Functions; Working with Common Table Expressions
  • Chapter 7: Manipulating DataCopying a Database; Adding Data Using INSERT; Removing Data Using DELETE; Changing Data Using UPDATE; Transactional Control; Part III: Creating Databases and Database Objects with Transact-SQL; Chapter 8: Designing, Creating, and Altering Database Objects; Examining the Key Phases to Designing a Database; Normalizing Data; Designing Relationships; Creating Databases; Altering Databases; Dropping Databases; Chapter 9: Designing, Creating, and Changing Tables; Choosing a Naming Scheme for Tables and Columns; Choosing Data Types for Columns; The CREATE TABLE statement
  • Creating Relationships Using Transact-SQLCreating Tables Using SQL Server Management Studio; The ALTER TABLE Statement; Chapter 10: Applying Constraints; Understanding the Types of Constraints; Creating NOT NULL Constraints; Creating DEFAULT Constraints; Creating UNIQUE Constraints; Creating CHECK Constraints; Removing Constraints; Using Advanced Constraints; Chapter 11: Creating Views; What Is a View?; Understanding the Need for Views; Creating a View; Using Views for Security; Updating through Views; Indexing a View; Chapter 12: Using Stored Procedures; Getting to Know Stored Procedures
  • Why Use Stored Procedures?
Dimensions
unknown
Extent
1 online resource (434 p.)
Form of item
online
Isbn
9780470128596
Media category
computer
Media type code
  • c
Specific material designation
remote
System control number
  • (CKB)1000000000354705
  • (EBL)287371
  • (OCoLC)124094389
  • (SSID)ssj0000202579
  • (PQKBManifestationID)12056374
  • (PQKBTitleCode)TC0000202579
  • (PQKBWorkID)10255106
  • (PQKB)10117223
  • (MiAaPQ)EBC287371
  • (EXLCZ)991000000000354705
Label
Microsoft SQL Server 2005 programming for dummies, Andrew Watt, (electronic resource)
Publication
Note
Includes index
Carrier category
online resource
Carrier category code
  • cr
Content category
text
Content type code
  • txt
Contents
  • Microsoft SQL Server 2005 Programming For Dummies; About the Author; Dedication; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About SQL Server 2005 Programming For Dummies; Foolish Assumptions; Conventions Used in This Book; 2; What You Don't Have to Read; How This Book Is Organized; 3; 4; Icons Used in This Book; Where to Go from Here; 5; 6; Part I: Get Started Using the SQL Server 2005 Development Environment; Chapter 1: The Joy of SQL Server 2005 Programming; Deciding Which Version of SQL Server 2005 to Use; Gathering and Manipulating Data
  • Enforcing Business Rules for Your DatabaseEnsuring SQL Server Security; When Transact-SQL Isn't Enough; Chapter 2: Understanding Database Fundamentals; Getting to Know the Database Engine; Discovering Database Objects; Introducing SQL Server Data Types; Getting Familiar with SQL Server Naming Rules; Talking Transact-SQL; Chapter 3: Getting to Know the SQL Server Toolset; Exploring SQL Server Management Studio; Using the SQLCMD Utility; Getting to Know the SQL Server Configuration Manager; Using Other SQL Server Programming Tools; Accessing SQL Server Books Online (BOL)
  • Installing the SQL Server Sample DatabasesPart II: Retrieving Data Using Transact-SQL; Chapter 4: Retrieving Data Using the SELECT Statement; Exploring Your Database's Objects; Introducing the SELECT Statement; Using the FROM Clause; The WHERE Clause; The ORDER BY Clause; The GROUP BY Clause; Chapter 5: Creating Joins; Understanding the Need for Joins; Creating an Inner Join; Creating an Outer Join; Creating a Cross Join; Chapter 6: Creating Advanced Queries; Using Subqueries; Examining the EXISTS Keyword; Using the CAST and CONVERT Functions; Working with Common Table Expressions
  • Chapter 7: Manipulating DataCopying a Database; Adding Data Using INSERT; Removing Data Using DELETE; Changing Data Using UPDATE; Transactional Control; Part III: Creating Databases and Database Objects with Transact-SQL; Chapter 8: Designing, Creating, and Altering Database Objects; Examining the Key Phases to Designing a Database; Normalizing Data; Designing Relationships; Creating Databases; Altering Databases; Dropping Databases; Chapter 9: Designing, Creating, and Changing Tables; Choosing a Naming Scheme for Tables and Columns; Choosing Data Types for Columns; The CREATE TABLE statement
  • Creating Relationships Using Transact-SQLCreating Tables Using SQL Server Management Studio; The ALTER TABLE Statement; Chapter 10: Applying Constraints; Understanding the Types of Constraints; Creating NOT NULL Constraints; Creating DEFAULT Constraints; Creating UNIQUE Constraints; Creating CHECK Constraints; Removing Constraints; Using Advanced Constraints; Chapter 11: Creating Views; What Is a View?; Understanding the Need for Views; Creating a View; Using Views for Security; Updating through Views; Indexing a View; Chapter 12: Using Stored Procedures; Getting to Know Stored Procedures
  • Why Use Stored Procedures?
Dimensions
unknown
Extent
1 online resource (434 p.)
Form of item
online
Isbn
9780470128596
Media category
computer
Media type code
  • c
Specific material designation
remote
System control number
  • (CKB)1000000000354705
  • (EBL)287371
  • (OCoLC)124094389
  • (SSID)ssj0000202579
  • (PQKBManifestationID)12056374
  • (PQKBTitleCode)TC0000202579
  • (PQKBWorkID)10255106
  • (PQKB)10117223
  • (MiAaPQ)EBC287371
  • (EXLCZ)991000000000354705

Library Locations

  • Albert D. Cohen Management LibraryBorrow it
    181 Freedman Crescent, Winnipeg, MB, R3T 5V4, CA
    49.807878 -97.129961
  • Architecture/Fine Arts LibraryBorrow it
    84 Curry Place, Winnipeg, MB, CA
    49.807716 -97.136226
  • Archives and Special CollectionsBorrow it
    25 Chancellors Circle (Elizabeth Dafoe Library), Room 330, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Bibliothèque Alfred-Monnin (Université de Saint-Boniface)Borrow it
    200, avenue de la Cathédrale, Local 2110, Winnipeg, MB, R2H 0H7, CA
    49.888861 -97.119735
  • Bill Larson Library (Grace Hospital)Borrow it
    300 Booth Drive, G-227, Winnipeg, MB, R3J 3M7, CA
    49.882400 -97.276436
  • Carolyn Sifton - Helene Fuld Library (St. Boniface General Hospital)Borrow it
    409 Tache Avenue, Winnipeg, MB, R2H 2A6, CA
    49.883388 -97.126050
  • Concordia Hospital LibraryBorrow it
    1095 Concordia Avenue, Winnipeg, MB, R2K 3S8, CA
    49.913252 -97.064683
  • Donald W. Craik Engineering LibraryBorrow it
    75B Chancellors Circle (Engineering Building E3), Room 361, Winnipeg, MB, R3T 2N2, CA
    49.809053 -97.133292
  • E.K. Williams Law LibraryBorrow it
    224 Dysart Road, Winnipeg, MB, R3T 5V4, CA
    49.811829 -97.131017
  • Eckhardt-Gramatté Music LibraryBorrow it
    136 Dafoe Road (Taché Arts Complex), Room 257, Winnipeg, MB, R3T 2N2, CA
    49.807964 -97.132222
  • Elizabeth Dafoe LibraryBorrow it
    25 Chancellors Circle, Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Fr. H. Drake Library (St. Paul's College)Borrow it
    70 Dysart Road, Winnipeg, MB, R3T 2M6, CA
    49.810605 -97.138184
  • J.W. Crane Memorial Library (Deer Lodge Centre)Borrow it
    2109 Portage Avenue, Winnipeg, MB, R3J 0L3, CA
    49.878000 -97.235520
  • Libraries Annex (not open to the public; please see web page for details)Borrow it
    25 Chancellors Circle (in the Elizabeth Dafoe Library), Winnipeg, MB, R3T 2N2, CA
    49.809961 -97.131878
  • Neil John Maclean Health Sciences LibraryBorrow it
    727 McDermot Avenue (Brodie Centre), 200 Level, Winnipeg, MB, R3E 3P5, CA
    49.903563 -97.160554
  • Sciences and Technology LibraryBorrow it
    186 Dysart Road, Winnipeg, MB, R3T 2M8, CA
    49.811526 -97.133257
  • Seven Oaks General Hospital LibraryBorrow it
    2300 McPhillips Street, Winnipeg, MB, R2V 3M3, CA
    49.955177 -97.148865
  • Sister St. Odilon Library (Misericordia Health Centre)Borrow it
    99 Cornish Avenue, Winnipeg, MB, R3C 1A2, CA
    49.879592 -97.160425
  • St. John's College LibraryBorrow it
    92 Dysart Road, Winnipeg, MB, R3T 2M5, CA
    49.811242 -97.137156
  • Victoria General Hospital LibraryBorrow it
    2340 Pembina Highway, Winnipeg, MB, R3T 2E8, CA
    49.806755 -97.152739
  • William R Newman Library (Agriculture)Borrow it
    66 Dafoe Road, Winnipeg, MB, R3T 2R3, CA
    49.806936 -97.135525
Processing Feedback ...