The fun and easy way(r) to build powerful databases
See how to administer, troubleshoot, and report like a pro in SQL Server
Are you ready to unleash the power hidden within your organization's data to meet business objectives? This book will help you build the skills that SQL Server database administrators must have to succeed. You'll find out how to develop and maintain a SQL Server system, design databases, manipulate data, and much more.
Discover how to:
* Build your first SQL Server databases
* Insert, manipulate, and retrieve data
* Keep your database server running smoothly
* Protect data from prying eyes
* Improve performance with database snapshots
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Höhe: 23.1 cm
Breite: 18.5 cm
Dicke: 1.7 cm
Gewicht
ISBN-13
978-0-470-22465-6 (9780470224656)
Schweitzer Klassifikation
Mike Chapple, MCDBA, CISA, CISSP, is an IT professional at the University of Notre Dame, where he teaches a computer applications course. He is a coauthor of the CISSP Study Guide.
Autor*in
The Brand Institute, Miami, FL
Part I: Welcome to SQL Server 2008.
Chapter 1: Introducing SQL Server 2008.
Chapter 2: The Wacky World of Databases.
Chapter 3: Building Your SQL Server.
Chapter 4: Working with Management Studio.
Part II: Building Databases.
Chapter 5: Planning Your Database.
Chapter 6: Creating Databases and Tables.
Chapter 7: The Keys to Relationship Management.
Part III: Retrieving Data from Databases.
Chapter 8: Simple Database Queries.
Chapter 9: The Power of Marriage: Joining Tables Together.
Chapter 10: Working With Database Views.
Chapter 11: SQL Server Analysis Services.
Part IV: Working With Your Data.
Chapter 12: Inserting Data into Your Database.
Chapter 13: Stored Procedures and User Functions.
Chapter 14: Triggers.
Chapter 15: Migrating from Access.
Part V: SQL Server Administration.
Chapter 16: Keeping Your Server Running Smoothly.
Chapter 17: Automating Administration.
Chapter 18: Replication.
