Muutke küpsiste eelistusi

Mastering Microsoft SQL Server 2005 Express ed [Multiple-component retail product]

3.56/5 (11 hinnangut Goodreads-ist)
,
  • Formaat: Multiple-component retail product, 600 pages, kõrgus x laius: 226x193 mm, kaal: 900 g, Illustrations, Contains 1 CD-ROM
  • Ilmumisaeg: 01-Apr-2006
  • Kirjastus: Sybex Inc.,U.S.
  • ISBN-10: 0782144020
  • ISBN-13: 9780782144024
Teised raamatud teemal:
Mastering Microsoft SQL Server 2005 Express edSuurem pilt
  • Formaat: Multiple-component retail product, 600 pages, kõrgus x laius: 226x193 mm, kaal: 900 g, Illustrations, Contains 1 CD-ROM
  • Ilmumisaeg: 01-Apr-2006
  • Kirjastus: Sybex Inc.,U.S.
  • ISBN-10: 0782144020
  • ISBN-13: 9780782144024
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780782144024.html
Märksõnad:
A Comprehensive Guide to Microsoft's New Express Edition of its Bestselling Database Server

Microsoft's SQL Server 2005 Express Edition is the perfect fit if you're a small business owner, trainer, or student who doesn't need all the bells and whistles of the full version of SQL Server 2005. In this comprehensive guide written by two SQL Server experts, you'll find step-by-step explanations and simplified management tools for

using SQL Server Express in smaller-scale but still mission-critical situations. With a focus on practical tasks, the book thoroughly

covers both database administration and development, smoothly moving you from beginner to advanced subjects.

Coverage Includes
* Understanding basic database concepts
* Getting to know database types: file server, client server, relational and more
* Learning Structured Query Language (SQL) and SQL Server's Transact-SQL
* Creating efficient and useful databases
* Writing queries and stored procedures to explore your data
* Automating the administration of your databases
* Developing database applications with Visual Basic(r) Express
* Using SQL Server Management Studio Express
* Sharing data between multiple servers
* Monitoring and optimizing SQL Server Express

Featured on CD
CD includes Microsoft(r) SQL Server Express and Visual Basic(r) Express!

Leverage the Experience of Experts through Real-World Examples

Increase Your Own Productivity with an Entire Chapter on Troubleshootng

Discover Practical Solutions to a Database Administrator's Needs

Reduce Complexity and Build Simple Data-Driven Applications
Introduction xxi
Part 1 Introducing SQL Server Express
1(62)
Introduction to SQL Server Express
3(8)
Why SQL Server Express?
3(1)
Administering SQL Server Express
4(5)
Opening Management Studio
4(2)
Creating a Login
6(1)
Using the Configuration Manager
7(2)
Viewing Current Activity
9(1)
New and Improved
9(1)
Summary
10(1)
Overview of Database Concepts
11(18)
Databases
11(3)
File-Server and Client-Server Databases
12(1)
Relational Databases
13(1)
OLTP and OLAP Databases
13(1)
Transaction Logs
14(1)
Tables
14(6)
Records, Fields, and Values
14(1)
Rows and Columns
15(1)
Null Values
15(1)
Field Properties
16(1)
Keys and Relationships
16(3)
Indexes and Constraints
19(1)
Rules and Defaults
19(1)
SQL
20(3)
Locking
23(1)
Views
24(1)
Stored Procedures
24(2)
Triggers
25(1)
Transactions
25(1)
System Stored Procedures
26(1)
Ownership and Security
26(1)
Replication
27(1)
Summary
28(1)
Overview of SQL Server Express
29(14)
Programs Installed with SQL Server Express
29(9)
Books Online
29(1)
SQL Server Configuration Manager
30(4)
The sqlcmd Tool
34(4)
Application Programming Interfaces
38(1)
XML and SQL Server Express
39(1)
SQL Server Express Storage Concepts
39(2)
Pages
40(1)
Extents
41(1)
Summary
41(2)
Database Design and Normalization
43(20)
What Is Normalization?
43(6)
Entity Integrity
43(3)
Domain Integrity
46(1)
Referential Integrity
47(2)
User-Defined Integrity
49(1)
First Normal Form
49(3)
Defining First Normal Form
50(1)
Identifying a Primary Key
51(1)
Second Normal Form
52(2)
Foreign Keys and Relations
53(1)
Third Normal Form
54(1)
Boyce-Codd Normal Form
55(2)
Advanced Normalization
57(1)
Fourth Normal Form
57(1)
Fifth Normal Form
58(1)
Denormalization
58(2)
Making the Trade-offs
59(1)
Declarative Referential Integrity
60(1)
Cascading Referential Integrity
61(1)
Summary
61(2)
Part 2 Transact-SQL
63(120)
Transact-SQL Overview and Basics
65(36)
What Is Transact-SQL?
65(8)
ANSI SQL
65(1)
SQL Dialects
66(1)
SQL Configuration Options
66(7)
T-SQL Syntax and Conventions
73(3)
Reading Syntax Diagrams
73(1)
Valid Identifiers
74(1)
Referring to Objects
75(1)
Reserved Words
76(1)
Datatypes
76(5)
Integers
76(1)
Text
77(1)
Decimal
78(1)
Money
78(1)
Floating Point
78(1)
Date
78(1)
Binary Data
79(1)
Special-Purpose Native Datatypes
79(1)
Synonyms for Datatypes
80(1)
Operators
81(2)
Available Operators
81(1)
Operator Precedence and Grouping
82(1)
Wildcards
83(1)
Variables
83(3)
System Global Variables
83(3)
Local Variables
86(1)
Functions
86(8)
Generating GUIDs
88(1)
String Functions
89(1)
Date and Time Functions
90(1)
Mathematical Functions
91(1)
System and Metadata Functions
92(1)
User-Defined Functions
92(2)
Using Command-Line Utilities
94(5)
Using osql
95(2)
Using sqlcmd
97(2)
Summary
99(2)
Select Queries
101(30)
Using Select
101(6)
Limiting the Columns
102(1)
Limiting Records with the Where Clause
103(3)
Using Wildcards
106(1)
Using Join
107(5)
The Inner Join
107(2)
The Outer Join
109(2)
Multiple Joins
111(1)
Bringing Order to the Results
112(15)
Using Order By
112(1)
Using Group By and Having
113(5)
Using Rollup
118(2)
Using Cube and Grouping
120(2)
Using Top
122(4)
Using Over
126(1)
Linked Server Queries
127(2)
Summary
129(2)
Action Queries
131(20)
What Are Action Queries?
131(1)
Delete Queries
132(3)
Syntax of Delete
132(1)
Examples of Delete
132(2)
Limitations of Delete
134(1)
Syntax of Truncate Table
134(1)
Limitations of Truncate Table
135(1)
Example of Truncate Table
135(1)
Update Queries
135(7)
Syntax of Update
136(1)
Limitations of Update
137(1)
Examples of Update
137(5)
Insert Queries
142(7)
Syntax of Insert
142(2)
Limitations of Insert
144(1)
Examples of Insert
145(1)
Syntax of Select Into
146(1)
Limitations of Select Into
147(1)
Examples of Select Into
148(1)
Summary
149(2)
Topics in Advanced Transact-SQL
151(32)
Transactions
151(6)
The ACID Properties
152(1)
Using Transactions
153(4)
Transaction Tips
157(1)
Rowset Functions
157(9)
Openquery
158(1)
Openrowset
158(1)
Opendatasource
159(1)
Openxml
159(7)
Cursors
166(8)
Declare Cursor
166(2)
Open and @@Cursor_Rows
168(1)
Fetch and @@Fetch_Status
169(2)
Close
171(1)
Deallocate
172(1)
A Cursor Example
172(2)
Using the System Tables and Information Schema Views
174(5)
What's in the System Tables?
175(2)
Sample System Table Queries
177(1)
Information Schema Views
178(1)
Optimizer Hints
179(3)
Table Hints
180(1)
Join Hints
181(1)
Query Hints
181(1)
View Hints
182(1)
Summary
182(1)
Part 3 Digging into SQL Server Express
183(156)
Using Management Studio Express
185(30)
Introduction to Microsoft SQL Server Management Studio Express
185(2)
The Main Windows
187(24)
The Object Explorer Window
187(24)
Template Explorer
211(1)
External Tools
212(1)
Summary
213(2)
Databases
215(20)
Database Basics
215(2)
Planning for Capacity
217(1)
Creating Databases
218(6)
Creating Databases with Management Studio
218(3)
Creating Databases with T-SQL
221(3)
Modifying Databases
224(9)
Setting Database Options
225(4)
Changing Database Size
229(4)
Summary
233(2)
Tables
235(28)
Planning Tables
235(5)
Partitioning Tables
240(1)
Creating Tables
240(5)
Restricting the Data
245(16)
Enforcing Domain Integrity
245(4)
Enforcing Entity Integrity
249(4)
Enforcing Referential Integrity
253(8)
Summary
261(2)
Indexing
263(10)
Index Architecture
263(7)
Understanding Heaps
263(2)
Understanding Clustered Indexes
265(2)
Understanding Nonclustered Indexes
267(3)
Creating Indexes
270(2)
Summary
272(1)
Views
273(26)
Using Views to Partition Tables
273(5)
Creating a View
274(4)
Modifying a View
278(1)
Using Aliases in a View
279(2)
Organizing the Result Set
281(2)
Using Views to Join Tables
283(4)
Joining Multiple Tables in a View
285(2)
Modifying Data through a View
287(4)
Enhancing Views with Inline User-Defined Functions
291(1)
Using Information Schema Views
292(3)
Using Catalog Views
295(2)
Summary
297(2)
Stored Procedures
299(16)
Understanding Stored Procedures
299(10)
Basic Stored Procedures
300(2)
Using Input Parameters
302(2)
Using Output Parameters
304(2)
Optimizing Stored Procedures
306(1)
Securing Your Stored Procedures
307(2)
Using System and Extended Stored Procedures
309(4)
Using System Stored Procedures
309(3)
Using Extended Stored Procedures
312(1)
Summary
313(2)
Using Triggers
315(24)
Understanding Triggers
315(16)
Working with Insert Triggers
316(4)
Working with Delete Triggers
320(2)
Working with Update Triggers
322(7)
Working with Instead of Triggers
329(2)
Advanced Considerations
331(7)
Combining Trigger Types
331(1)
Reporting Errors with Raiserror()
332(2)
Recursive Triggers
334(2)
Using DDL Triggers
336(2)
Summary
338(1)
Part 4 Administering SQL Server Express
339(56)
Basic Administrative Tasks
341(34)
Backing Up Your Data
341(18)
How Backups Work
342(1)
SQL Server Express Creating a Backup Device
343(1)
Performing a Full Backup
344(2)
Performing Differential Backups
346(2)
Performing Transaction Log Backups
348(3)
Performing Filegroup Backups
351(5)
Backing Up to Multiple Devices
356(3)
Restoring Databases
359(7)
Standard Restores
359(3)
Point-in-Time Restores
362(3)
Piecemeal Restores
365(1)
Devising a Backup Strategy
366(3)
Full Backups Only
366(1)
Full with Differential Backups
367(1)
Full with Transaction Log Backups
368(1)
Full, Differential, and Transaction Log Backups
368(1)
Filegroup Backups
369(1)
Maintaining Indexes
369(4)
Understanding DM_DB_Index_Physical_Stats
370(2)
Reorganizing Indexes
372(1)
Summary
373(2)
Security and SQL Server Express
375(20)
Is Security for You?
375(1)
Understanding Security Modes
376(2)
Windows NT/2000 Authentication Mode
376(1)
Mixed Mode
376(1)
Setting the Authentication Mode
377(1)
SQL Server Express Logins
378(3)
Windows Logins
378(3)
Fixed Server Roles
381(2)
Creating Database User Accounts
383(1)
Understanding Permissions
384(3)
Statement Permissions
385(1)
Object Permissions
386(1)
Database Roles
387(4)
Fixed Database Roles
388(1)
Custom Database Roles
388(2)
Application Roles
390(1)
Permission States
391(1)
Creating a Security Plan
392(1)
Summary
393(2)
Part 5 Developing Applications with SQL Server Express
395(74)
Working with Visual Basic Express
397(20)
Feeling at Home with VB Express
397(1)
Creating a VB Express Application
398(13)
Creating a Project
398(4)
Connecting to a SQL Server Express Database
402(5)
Designing a Data Access Form
407(4)
Deploying a Project
411(4)
Publishing a Project to CD-ROM
411(4)
Summary
415(2)
Accessing Data Using ADO.NET
417(28)
ADO.NET Namespaces and Classes
417(2)
Understanding DataSets
418(1)
Understanding the SQLClientData Provider
419(1)
Understanding SQL Types
419(1)
Making and Managing Connections
419(3)
Building Connection Strings
420(2)
Handling Connection Pooling
422(1)
Using the SqlCommand Object
422(4)
Executing a Query
422(2)
Using Parameters
424(1)
Retrieving a Single Value
425(1)
Using the SqlDataReader Object
426(4)
Opening a SqlDataReader
426(1)
Retrieving Data
427(3)
Using the DataSet and SqlDataAdapter Objects
430(14)
Setting Up the SqlDataAdapter
430(2)
Filling the DataSet
432(3)
Modifying the DataSet
435(6)
Updating the Database
441(1)
A User Interface Example
442(2)
Summary
444(1)
Automating SQL Server Express Using SMO and RMO
445(24)
What Is SMO?
445(1)
The SMO Object Model
446(13)
The Major SMO Objects
446(2)
The Server Object
448(4)
The Configuration Object
452(1)
The Database Object
453(1)
The DatabaseOptions Object
454(1)
The StoredProcedure Object
455(2)
The Table Object
457(1)
The Column Object
458(1)
Sample SMO Code
459(6)
Creating and Connecting a Server Object
460(1)
Creating a Database
461(1)
Changing a Configuration Option
461(1)
Creating a Table
462(1)
Dropping a Table
463(1)
Creating and Executing a Stored Procedure
463(2)
Using RMO
465(2)
Summary
467(2)
Part 6 Advanced SQL Server Express Administration
469(70)
Locking
471(18)
Why Locking?
471(2)
Lost Updates
471(1)
Uncommitted Dependencies
472(1)
Inconsistent Analysis
472(1)
Phantom Reads
472(1)
Optimistic and Pessimistic Concurrency
472(1)
Isolation Levels
473(1)
Locking Mechanics
474(3)
Locking Granularity
474(1)
Locking Modes
475(1)
Lock Escalation
476(1)
Dynamic Locking
477(1)
Viewing Current Locks
477(5)
Using sp_lock
477(2)
Using Management Studio
479(3)
Deadlocks
482(2)
Customizing Locking Behavior
484(2)
Setting the Lock Timeout
484(1)
Setting the Transaction Isolation Level
484(2)
Locking Hints
486(1)
Application Locks
486(2)
sp_getapplock
487(1)
sp_releaseapplock
488(1)
Summary
488(1)
Monitoring and Optimizing SQL Server Express
489(12)
Using Performance Monitor
489(5)
Using Management Studio's Query Editor
494(2)
Tips and Techniques
496(1)
Setting a Measurement Baseline
496(1)
Data Archiving and Trend Tracking
497(1)
Optimization Techniques
497(1)
Queries and Stored Procedures
497(1)
Tempdb
498(1)
Query Governor
498(1)
Setting Trace Flags
498(1)
Summary
499(2)
Replication
501(10)
Understanding Replication
501(8)
The Publisher/Subscriber Metaphor
502(1)
Replication Types
503(3)
Replication Agents
506(1)
Replication Models
507(2)
Summary
509(2)
Service Broker
511(18)
Understanding Service Broker
511(1)
T-SQL DDL and DML
512(2)
Messaging
514(4)
Conversations
514(1)
Asynchronous Queued Transactional Messaging
515(1)
Activation
516(2)
Service Broker Programming
518(5)
Creating a Service Broker Application
518(3)
Creating a Queue-Reading Stored Procedure
521(2)
Administering Service Broker
523(4)
Managing Applications and Queues
523(2)
Service Broker Security
525(1)
System Configuration Options
525(1)
Service Broker Catalog Views
526(1)
Summary
527(2)
Troubleshooting
529(10)
General Troubleshooting
529(2)
Troubleshooting Setup
531(1)
Troubleshooting Databases
532(3)
Using DBCC
532(2)
Repairing Shutdown Databases
534(1)
Troubleshooting Backup and Restores
535(1)
Troubleshooting Client Connectivity
536(1)
Summary
537(2)
Appendix A Transact-SQL Reference
539(8)
Creating a Database
539(1)
Cursor Statements
540(1)
Database Options
541(1)
Deleting Records
542(1)
Inserting Records
542(1)
Retrieving Records
543(1)
Rowsets
543(1)
Transactions
544(1)
Updating Records
544(1)
User-Defined Functions
545(2)
Index 547


Mike Gunderloy has been developing software for over 25 years, during which time he has gained expertise across a wide variety of Microsoft technologies. His books include Mastering SQL Server 2005; Mastering Visual C#(r); ADO and ADO.NET Programming; and Coder to Developer. Susan Sales Harkins is the bestselling author of several database books, including Mastering Dreamweaver(r) MX Databases. She was formerly an editor-in-chief at The Cobb Group.