LEADER 05318nam 2200697Ia 450 001 9910809242003321 005 20200520144314.0 010 $a0-470-48665-1 010 $a0-470-40363-2 035 $a(CKB)1000000000550984 035 $a(EBL)380427 035 $a(OCoLC)608623280 035 $a(SSID)ssj0000076553 035 $a(PQKBManifestationID)11125886 035 $a(PQKBTitleCode)TC0000076553 035 $a(PQKBWorkID)10007730 035 $a(PQKB)11222047 035 $a(JP-MeL)3000029976 035 $a(Au-PeEL)EBL380427 035 $a(CaPaEBR)ebr10257635 035 $a(CaONFJC)MIL320331 035 $a(CaSebORM)9780470224656 035 $a(MiAaPQ)EBC380427 035 $a(EXLCZ)991000000000550984 100 $a20080130d2008 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aMicrosoft SQL Server 2008 for dummies$b[electronic resource] /$fby Mike Chapple 205 $a1st edition 210 $aHoboken, NJ $cWiley$d2008 215 $a1 online resource (410 p.) 225 1 $a--For dummies 300 $aIncludes index. 311 $a0-470-22465-7 327 $aMicrosoft 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 327 $aManaging 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 327 $aControlling 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 327 $aPart 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 327 $aPart 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 327 $aMonitoring Your Server with Performance Studio 330 $aIf 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 410 0$a--For dummies. 606 $aSQL (Computer program language) 606 $aDatabase management 606 $aClient/server computing 615 0$aSQL (Computer program language) 615 0$aDatabase management. 615 0$aClient/server computing. 676 $a005.7585 686 $a54.53$2bcl 700 $aChapple$b Mike$0889333 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910809242003321 996 $aMicrosoft SQL Server 2008 for dummies$94081644 997 $aUNINA