Asia Pacific University Library catalogue

Includes index.

Chapter 1 SQL Server 2005 Overview and Installation -- Why SQL Server 2005? -- Evolution of SQL Server -- Hardware Requirements -- CPU -- Memory -- Hard Disk Space -- Operating System Requirements -- The Example -- Installation -- A Standard Installation -- Preparing to Install -- Security -- Services Accounts -- Looking at the Authentication Mode -- The sa Login -- Chapter 2 SQL Server Management Studio -- A Quick Overview of SSMS -- Examining SSMS's Options -- Environment Node -- Source Control Node -- Text Editor Node -- Query Execution Node -- Query Results Node -- Query Editor -- Surface Area Configuration Tool -- Chapter 3 Database Design and Creation -- Defining a Database -- Databases Within SQL Server -- Master -- Tempdb -- Model -- Msdb -- AdventureWorks/AdventureWorksDW -- Choosing the Database System Type -- OLTP -- OLAP -- Example System Choice -- Gathering the Data -- Determining the Information to Store in the Database -- Financial Products -- Customers -- Customer Addresses -- Shares -- Transactions -- External and Ignored Information -- Building Relationships -- Using Keys -- Creating Relationships -- More on Foreign Keys -- Normalization -- Each Entity Should Have a Unique Identifier -- Only Store Information That Directly Relates to That Entity -- Avoid Repeating Values or Columns -- Normalization Forms -- Denormalization -- Creating the Sample Database -- Creating a Database in SQL Server Management Studio -- Dropping the Database in SQL Server Management Studio -- Creating a Database in a Query Pane -- Chapter 4 Security -- Logins -- Server Logins and Database Users -- Roles -- Fixed Server Roles -- Database Roles -- Application Roles -- Schemas -- Before You Can Proceed with Your Solution -- Chapter 5 Defining Tables -- What Is a Table? -- Defining a Table: SQL Server Management Studio -- Different Table Data Types -- Different Program Data Types -- Columns Are More Than Simple Data Repositories -- Default Values -- Generating IDENTITY Values -- The Use of NULL Values -- Why Define a Column to Allow NULL? -- Image and Large Text Storage in SQL Server -- Creating a Table in SQL Server Management Studio -- Defining a Table Through the Query Editor -- Defining a Table: Using a Template -- Creating and Altering a Template -- The ALTER TABLE Command -- Defining the Remaining Tables -- Setting a Primary Key -- Creating a Relationship -- Check Existing Data on Creation -- Enforce Foreign Key Constraints -- Delete Rule/Update Rule -- Using the ALTER TABLE SQL Statement -- Chapter 6 Creating Indexes and Database Diagramming -- What Is an Index? -- Types of Indexes -- Uniqueness -- Determining What Makes a Good Index -- Using Low-Maintenance Columns -- Primary and Foreign Keys -- Finding Specific Records -- Using Covering Indexes -- Looking for a Range of Information -- Keeping the Data in Order -- Determining What Makes a Bad Index -- Using Unsuitable Columns -- Choosing Unsuitable Data -- Including Too Many Columns -- Including Too Few Records in the Table -- Reviewing Your Indexes for Performance -- Creating an Index -- Creating an Index with the Table Designer -- Indexes and Statistics -- The CREATE INDEX Syntax -- Creating an Index in Query Editor: Template -- Creating an Index in Query Editor: SQL Code -- Dropping an Index -- Altering an Index in Query Editor -- Diagramming the Database -- Database Diagramming Basics -- The SQL Server Database Diagram Tool -- The Default Database Diagram -- The Database Diagram Toolbar -- Chapter 7 Database Backups, Recovery, and Maintenance -- Transaction Logs -- Backup Strategies -- When Problems May Occur -- Taking a Database Offline -- Backing the Data Up -- Backing Up the Database Using T-SQL -- Transaction Log Backup Using T-SQL -- Restoring a Database -- Restoring Using SQL Server Management Studio -- Restoring Using T-SQL -- Detaching and Attaching a Database -- Detaching and Attaching Using SQL Server Management Studio -- Detaching and Attaching Using T-SQL -- Producing SQL Script for the Database -- Maintaining Your Database -- Creating a Database Maintenance Plan -- Chapter 8 Working with the Data -- The T-SQL INSERT Command Syntax -- INSERT SQL Command -- Default Values -- Using NULL Values -- DBCC CHECKIDENT -- Column Constraints -- ADD CONSTRAINT -- Dealing with Several Records at Once -- Inserting Several Records in a Query Batch -- Retrieving Data -- Using SQL Server Management Studio to Retrieve Data -- The SELECT Statement -- Naming the Columns -- The First Searches -- Varying the Output Display -- Limiting the Search: The Use of WHERE -- SET ROWCOUNT n -- TOP n -- TOP n PERCENT -- String Functions -- Order! Order! -- The LIKE Operator -- Creating Data: SELECT INTO -- Who Can Add, Delete, and Select Data -- Securables -- Updating Data -- The UPDATE Command -- Updating Data Within Query Editor -- Transactions -- BEGIN TRAN -- COMMIT TRAN -- ROLLBACK TRAN -- Locking Data -- Updating Data: Using Transactions -- Nested Transactions -- Deleting Data -- DELETE Syntax -- Using the DELETE Statement -- Truncating a Table -- Dropping a Table -- Chapter 9 Building a View -- What Is a View? -- Using Views for Security -- Encrypting View Definitions -- Creating a View: SQL Server Management Studio -- Creating a View Using a View -- CREATE VIEW Syntax -- Creating a View: A Query Editor pane -- Creating a View: SCHEMABINDING -- Indexing a View -- Chapter 10 Stored Procedures -- What Is a Stored Procedure? -- CREATE PROCEDURE Syntax -- Returing a Set of Records -- Creating a Stored Procedure: Management Studio -- Different Methods of Executing -- No EXEC -- With EXEC -- Using RETURN -- Controlling the Flow -- IF...ELSE -- BEGIN...END -- WHILE...BREAK Statement -- CASE Statement -- Bringing It All Together -- Chapter 11 T-SQL Essentials -- Using More Than One Table -- Variables -- Temporary Tables -- Aggregations -- COUNT/COUNT_BIG -- SUM -- MAX/MIN -- AVG -- GROUP BY -- HAVING -- Distinct Values -- Functions -- Date and Time -- String -- System Functions -- RAISERROR -- Error Handling -- @@ERROR -- TRY...CATCH -- Chapter 12 Advanced T-SQL -- Subqueries -- IN -- EXISTS -- The APPLY Operator -- CROSS APPLY -- OUTER APPLY -- Common Table Expressions -- Recursive CTE -- Pivoting Data -- PIVOT -- UNPIVOT -- Ranking Functions -- ROW_NUMBER -- RANK -- DENSE_RANK -- NTILE -- Using the MAX Data Type -- Image LOB -- Chapter 13 Triggers -- What Is a Trigger? -- The DML Trigger -- CREATE TRIGGER Syntax for DML triggers -- Why Not Use a Constraint? -- Deleted and Inserted Logical Tables -- Creating a DML FOR Trigger -- Checking Specific Columns -- Using UPDATE() -- Using COLUMNS_UPDATED() -- DDL Triggers -- DDL_DATABASE_LEVEL_EVENTS -- Dropping a DDL trigger -- EVENTDATA() -- Chapter 14 SQL Server 2005 Reporting Services -- What Is Reporting Services? -- Reporting Services Architecture from 5000 Feet -- Reporting Services Architecture: A Closer Look -- The Application Layer -- The Server Layer -- The Data Layer -- Building Your First Report Using Report Wizard -- Building a Report from Scratch -- Data-Related Elements -- Report Items -- Reports Structure.