Flylib.com
Beginning Transact-SQL With SQL Server 2000 and 2005
Beginning Transact-SQL With SQL Server 2000 and 2005
ISBN: 076457955X
EAN: 2147483647
Year: 2006
Pages: 131
Authors:
Paul Turley
BUY ON AMAZON
Table of Contents
Back Cover
Beginning Transact-SQL with SQL Server 2000 and 2005
Foreword
Chapter 1: Introducing Transact-SQL and Data Management Systems
Transact-Structured Query Language
SQL Server as a Relational Database Management System
SQL Server and Other Products
Summary
Chapter 2: SQL Server Fundamentals
Who Uses SQL Server?
SQL Server Editions and Features
Semantics
Normalization Rules
Applying Normalization Rules
ClientServer Processes
The Mechanics of Query Processing
The Adventure Works Cycles Database
Summary
Chapter 3: Tools for Accessing SQL Server
Tools for SQL Server 2000
Tools for SQL Server 2005
Summary
Exercises
Chapter 4: Introducing Transact-SQL Language
The Nature of SQL
Where to Begin
Data Manipulation Language (DML)
Data Definition Language
Data Control Language
Summary
Exercises
Chapter 5: Data Retrieval
The SELECT Statement
Summary
Exercises
Chapter 6: SQL Functions
The Anatomy of a Function
Aggregate Functions
Configuration Variables
Conversion Functions
Summary
Exercises
Chapter 7: Aggregation and Grouping
Using Aggregate Functions
Understanding Statistical Functions
Grouping Data
Summary
Exercises
Chapter 8: Multi-Table Queries
Understanding Subqueries and Joins
Summary
Exercises
Chapter 9: Data Transactions
Introducing Transactions
Let s Do CRUD with Data
Explicit Transactions
Summary
Exercises
Chapter 10: Advanced Queries and Scripting
Subqueries
Cursors
Summary
Exercises
Chapter 11: Full-Text Index Queries
Microsoft Search Ser vice
Managing and Populating Catalogs
Summary
Chapter 12: Creating and Managing Database Objects
Data Definition Language
Securing Database Objects
Summary
Exercise
Chapter 13: Transact-SQL Programming Objects
Views
Stored Procedures
User-Defined Functions
Transaction Management
Summary
Exercises
Chapter 14: Transact-SQL in Applications and Reporting
Application Programming Models
Selecting a Model
SQL Server Reporting Services
Summary
Appendix A: Command Syntax Reference
Transact-SQL Commands, Clauses, and Predicates
Appendix B: System Variables and Functions Reference
Appendix C: System Stored Procedure Reference
Appendix D: Information Schema Views Reference
Appendix E: Answers to Exercises
Chapter 4 Exercises
Chapter 5 Exercises
Chapter 6 Exercises
Chapter 7 Exercises
Chapter 8 Exercises
Chapter 9 Exercises
Chapter 10 Exercises
Chapter 12 Exercises
Chapter 13 Exercises
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
List of Figures
List of Tables
List of Try It Outs
Beginning Transact-SQL With SQL Server 2000 and 2005
ISBN: 076457955X
EAN: 2147483647
Year: 2006
Pages: 131
Authors:
Paul Turley
BUY ON AMAZON
Metrics and Models in Software Quality Engineering (2nd Edition)
Total Quality Management
The Prototyping Approach
Defect Removal Effectiveness
Halsteads Software Science
Establishing the Alignment Principle
The CISSP and CAP Prep Guide: Platinum Edition
Legal, Regulations, Compliance, and Investigations
Continuous Monitoring Process
Appendix C The Information System Security Architecture Professional (ISSAP) Certification
Appendix D The Information System Security Engineering Professional (ISSEP) Certification
Appendix F Security Control Catalog
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Parts of a Computer System
Branching and Looping
String Operations
Appendix D 80x86 Instructions (by Mnemonic)
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 15. Zoom Right In on Your Neighborhood
Hack 23. Explore David Rumseys Historical Maps
Hack 63. Build Your Own Car Navigation System with GpsDrive
Hack 87. Build a Spatially Indexed Data Store
Hack 98. Give Your Great-Great-Grandfather a GPS
InDesign Type: Professional Typography with Adobe InDesign CS2
End Marks
Footnotes
Right-Aligned Type
Up Next
Setting Tabs
The Lean Six Sigma Pocket Toolbook. A Quick Reference Guide to Nearly 100 Tools for Improving Process Quality, Speed, and Complexity
Using DMAIC to Improve Speed, Quality, and Cost
Working with Ideas
Descriptive Statistics and Data Displays
Reducing Lead Time and Non-Value-Add Cost
Selecting and Testing Solutions
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies