عنوان

Mastering Microsoft SQL server 2005 Express edition /

0782143806

9780782143805

b773833

Mastering Microsoft SQL server 2005 Express edition /

[Book]

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

Indianapolis, Ind. :

Wiley,

2006.

xxviii, 1028 pages :

illustrations ;

24 cm

Includes index.

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

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)

Gunderloy, Mike.

Jorden, Joseph L.

Tschanz, David W.

20201203060938.0

[Book]

Y