Microsoft SQL Server 2008 for dummies [[electronic resource] /] / by Mike Chapple

• Autore: Chapple Mike
• Pubblicazione: Hoboken, NJ, : Wiley, 2008
• Edizione: 1st edition
• Descrizione fisica: 1 online resource (410 p.)
• Disciplina: 005.7585
• Soggetto topico: SQL (Computer program language); Database management; Client/server computing
• Classificazione: 54.53
• Note generali: Includes index.
• Nota di contenuto: Microsoft SQL Server 2008; Table of Contents; Introduction; Part I Welcome to SQL Server 2008; Chapter 1 Introducing SQL Server 2008; Starting Off on the Right Foot; Understanding the Basic Components of SQL Server; Implementing Databases with SQL Server 2008; What's New in SQL Server 2008; Chapter 2 Building Your SQL Server; Installing SQL Server 2008; Upgrading an Existing SQL Server Installation; Configuring Database Mail; Using SQL Server's Built-In Databases; Chapter 3 Working with SQL Server Tools; Using SQL Server Configuration Manager ; Managing Your Server with SQL Server Management StudioWorking from the Command Line; Part II Building SQL Server 2008 Databases; Chapter 4 Planning Your Database; Introducing Database Design Concepts; Understanding the Elements of a Database; Organizing a Database; Diagramming Your Database; Staying Fit and Trim with Normalization; Choosing Data Types for Your Tables; Working with NULL Values; Chapter 5 Creating Databases and Tables; Creating a Database; Specifying Files and Filegroups; Creating a Table; Chapter 6 Imposing Constraints and Relationships; Introducing Constraints ; Controlling Database Contents Using ConstraintsEnforcing Database Integrity; Part III Retrieving Data from Databases; Chapter 7 Constructing Simple Database Queries; Retrieving Data with SELECT Statements; Organizing Query Results; Chapter 8 Joins and Other Advanced Queries; Joining Data from Multiple Tables; Taking SELECT to the Next Level; Using Database Views; Chapter 9 Turning Data into Information with SQL Server Reporting Services; Setting up SQL Server Reporting Services; Creating an SSRS Report with Report Builder; Working with Deployed (Published) Reports ; Part IV Inserting and Manipulating Your DataChapter 10 Inserting, Updating, and Deleting Data; Inserting Small Quantities of Data; Modifying and Deleting Data; Importing Large Quantities of Data; Working with SQL Server Integration Services; Chapter 11 Saving Time with Functions, Stored Procedures, and Triggers; Reusing Logic with Functions; Leveraging SQL Server's built-in functions; Creating Your Own Functions; Reusing SQL Code with Stored Procedures; Updating Data Automatically with Triggers; Modifying and Deleting Functions, Stored Procedures, and Triggers ; Part V SQL Server AdministrationChapter 12 Keeping Your SQL Server Running Smoothly; Indexing Data to Improve Query Performance; Improving Performance with Partitions; Updating Database Statistics; Managing File Sizes; Checking Database Integrity; Governing Resource Consumption; Chapter 13 Automating SQL Server 2008 Administration; Scheduling Tasks with SQL Server Agent; Implementing Database Maintenance Plans; Alerting Administrators about Database Events; Chapter 14 Troubleshooting SQL Server 2008 Problems; Understanding the Inner Workings of SQL Server Queries; Reviewing Log Records ; Monitoring Your Server with Performance Studio
• Sommario/riassunto: If you're a database administrator, you know Microsoft SQL Server 2008 is revolutionizing database development. Get up to speed on SQL Server 2008, impress your boss, and improve your company's data management - read Microsoft SQL Server 2008 For Dummies! SQL Server 2008 lets you build powerful databases and create database queries that give your organization the information it needs to excel. Microsoft SQL Server 2008 For Dummies helps you build the skills you need to set up, administer, and troubleshoot SQL Server 2008. You'll be able to:Develop and main
• Titolo autorizzato: Microsoft SQL Server 2008 for dummies
• ISBN: 0-470-48665-1; 0-470-40363-2
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Lingua di pubblicazione: Inglese
• Record Nr.: 9910782223503321
• Lo trovi qui: Univ. Federico II
• Serie: --For dummies.