عنوان

Mastering Microsoft SQL server 2005 Express edition /

(Number (ISBN

0782143806

(Number (ISBN

9780782143805

Number

b773833

Title Proper

Mastering Microsoft SQL server 2005 Express edition /

General Material Designation

[Book]

First Statement of Responsibility

Mike Gunderloy, Joseph L. Jorden, David W. Tschanz.

Place of Publication, Distribution, etc.

Indianapolis, Ind. :

Name of Publisher, Distributor, etc.

Wiley,

Date of Publication, Distribution, etc.

2006.

Specific Material Designation and Extent of Item

xxviii, 1028 pages :

Other Physical Details

illustrations ;

Dimensions

24 cm

Text of Note

Includes index.

Text of Note

PART 1: INTRODUCING SQL SERVER: Introduction to SQL server 2005 -- Overview of database concepts -- Overview of SQL server -- Database design and normalization -- PART 2: TRANSACT-SQL: Transact-SQL overview and basics -- SELECT queries -- Action queries -- Topics in advanced Transact-SQL -- PART 3: DIGGING INTO SQL SERVER: Using SQL server management studio -- Databases -- Tables -- Indexing -- Views -- Stored procedures -- Using triggers -- PART 4: ADMINISTERING SQL SERVER: Basic administrative tasks -- Automating administration -- Security and SQL server 2005 -- PART 5: DEVELOPMENT WITH SQL SERVER: Integrating SQL server with Microsoft .NET -- ADO.NET and SQL server -- SMO AND RMO programming -- Integration services -- PART 6: ADVANCED TOPICS: Locking -- Monitoring and optimizing SQL server 2005 -- Replication -- Analysis services -- Notification services -- Reporting services -- Service broker -- Troubleshooting -- Appendix: Transact-SQL Reference.

0

Text of Note

Whether you're a systems administrator, database application developer, or IT consultant, you'll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005's enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.

SQL server.

SQL server.

Client/server computing.

Database management.

SQL (Computer program language)

Client/server computing.

Database management.

SQL (Computer program language)

Number

Edition

Class number

Book number

Gunderloy, Mike.

Jorden, Joseph L.

Tschanz, David W.

Date of Transaction

20201203060938.0

Electronic name

[Book]

Y