MICROSOFT SQL SERVER 2005 PROGRAMMING
ABOUT SQL SERVER 2005 PROGRAMMING FOR DUMMIES FOOLISH ASSUMPTIONS CONVENTIONS USED IN THIS BOOK WHAT YOU DON’T HAVE TO READ HOW THIS BOOK IS ORGANIZED PART I: GET STARTED USING THE SQL SERVER DEVELOPMENT ENVIRONMENT PART II: RETRIEVING DATA USING TRANSACT-SQL PART III: CREATING DATABASES AND DATABASE OBJECTS WITH TRANSACT-SQL PART IV: PROGRAMMING SQL SERVER SECURITY PART V: BEYOND TRANSACT-SQL PROGRAMMING PART VI: THE PART OF TENS ICONS USED IN THIS BOOK WHERE TO GO FROM HERE DECIDING WHICH VERSION OF SQL SERVER 2005 TO USE GATHERING AND MANIPULATING DATA ENFORCING BUSINESS RULES FOR YOUR DATABASE ENSURING SQL SERVER SECURITY WHEN TRANSACT-SQL ISN’T ENOUGH GETTING TO KNOW THE DATABASE ENGINE DISCOVERING DATABASE OBJECTS INTRODUCING SQL SERVER DATA TYPES GETTING FAMILIAR WITH SQL SERVER NAMING RULES TALKING TRANSACT-SQL EXPLORING SQL SERVER MANAGEMENT STUDIO LAUNCHING SQL SERVER MANAGEMENT STUDIO DISCOVERING WHAT TYPES OF QUERIES YOU CAN CREATE CREATING A SIMPLE QUERY WITH THE CODE EDITOR WORKING WITH TEMPLATES CREATING A QUERY WITH THE QUERY DESIGNER EVALUATING THE EXECUTION PLAN OF A QUERY USING THE SQLCMD UTILITY GETTING TO KNOW THE SQL SERVER CONFIGURATION MANAGER USING OTHER SQL SERVER PROGRAMMING TOOLS VISUAL STUDIO 2005 THE BUSINESS INTELLIGENCE DEVELOPMENT STUDIO ACCESSING SQL SERVER BOOKS ONLINE (BOL) INSTALLING THE SQL SERVER SAMPLE DATABASES ADVENTUREWORKS NORTHWIND AND PUBS EXPLORING YOUR DATABASE’S OBJECTS INTRODUCING THE SELECT STATEMENT USING THE FROM CLAUSE THE WHERE CLAUSE USING COMPARISON OPERATORS COMBINING COMPARISON OPERATORS WITH AND, OR, OR NOT USING OTHER KEYWORDS WITH THE WHERE CLAUSE THE ORDER BY CLAUSE THE GROUP BY CLAUSE UNDERSTANDING THE NEED FOR JOINS CREATING AN INNER JOIN USING ALIASES FOR TABLE NAMES CREATING AN INNER JOIN WITH SQL SERVER MANAGEMENT STUDIO JOINING MORE THAN TWO TABLES CREATING AN OUTER JOIN CREATING A CROSS JOIN USING SUBQUERIES EXAMINING THE EXISTS KEYWORD USING THE CAST AND CONVERT FUNCTIONS WORKING WITH COMMON TABLE EXPRESSIONS COPYING A DATABASE ADDING DATA USING INSERT WRITING A BASIC INSERT STATEMENT INSERTING DATA FROM ANOTHER TABLE INSERTING DATA INTO A TABLE WITH AN IDENTITY COLUMN REMOVING DATA USING DELETE CHANGING DATA USING UPDATE TRANSACTIONAL CONTROL EXAMINING THE KEY PHASES TO DESIGNING A DATABASE DEFINITION REQUIREMENTS EVALUATION DESIGN IMPLEMENTATION DOCUMENTATION AND TESTING DELIVERY MAINTENANCE NORMALIZING DATA FIRST NORMAL FORM SECOND NORMAL FORM THIRD NORMAL FORM DESIGNING RELATIONSHIPS CREATING DATABASES ALTERING DATABASES DROPPING DATABASES CHOOSING A NAMING SCHEME FOR TABLES AND COLUMNS CHOOSING DATA TYPES FOR COLUMNS EXACT NUMERIC DATA TYPES APPROXIMATE NUMERIC DATA TYPES DATE- AND TIME-RELATED DATA TYPES NON-UNICODE CHARACTER DATA TYPES UNICODE CHARACTER DATA TYPES BINARY DATA TYPES MISCELLANEOUS DATA TYPES THE CREATE TABLE STATEMENT CREATING RELATIONSHIPS USING TRANSACT-SQL CREATING TABLES USING SQL SERVER MANAGEMENT STUDIO CREATING THE DATABASE CREATING THE TABLES THE ALTER TABLE STATEMENT UNDERSTANDING THE TYPES OF CONSTRAINTS CREATING NOT NULL CONSTRAINTS CREATING DEFAULT CONSTRAINTS CREATING UNIQUE CONSTRAINTS CREATING CHECK CONSTRAINTS REMOVING CONSTRAINTS USING ADVANCED CONSTRAINTS WHAT IS A VIEW? UNDERSTANDING THE NEED FOR VIEWS CREATING A VIEW USING VIEWS FOR SECURITY UPDATING THROUGH VIEWS GETTING TO KNOW STORED PROCEDURES WHY USE STORED PROCEDURES? CREATING A STORED PROCEDURE USING ALTER TO CHANGE A STORED PROCEDURE USING PARAMETERS WITH STORED PROCEDURES USING EVENTS THAT EXECUTE TRIGGERS UNDERSTANDING WHERE AND WHEN TO USE TRIGGERS USING AFTER TRIGGERS USING INSTEAD OF TRIGGERS USING DDL TRIGGERS DEBUGGING TRIGGERS WHAT IS A TRANSACT-SQL FUNCTION? CREATING USER-DEFINED FUNCTIONS ALTERING AND DROPPING FUNCTIONS USING SYSTEM FUNCTIONS GETTING A HANDLE ON WHY YOU MIGHT NEED INDEXES CONSIDERING THE TYPES OF INDEXES CREATING AN INDEX ALTERING AN INDEX DROPPING AN INDEX ERROR HANDLING IN TRANSACT-SQL USING THE @@ERROR FUNCTION USING RAISERROR USING TRY CATCH NESTING TRY CATCH STATEMENTS INTRODUCING SQL SERVER 2005 SECURITY UNDERSTANDING LOGINS AND USERS ADDING LOGINS UNDERSTANDING SCHEMAS AND USERS USING SCHEMAS ADDING USERS ASSIGNING PERMISSIONS ON DATABASE OBJECTS USING ROLES USING APPLICATION ROLES USING SECURITY FUNCTIONS INTRODUCING ENCRYPTION WORKING WITH ASYMMETRIC AND SYMMETRIC ENCRYPTION USING CERTIFICATES ENCRYPTING DATA XML IN SQL SERVER 2005 USING TYPED AND UNTYPED XML QUERYING XML DATA DML ON XML DATA EXPOSING RELATIONAL DATA AS XML INTRODUCING THE CLR UNDERSTANDING CLR PERMISSIONS CONFIGURING SQL SERVER FOR THE CLR CREATING AN ASSEMBLY USING SERVER EXPLORER USING THE VISUAL DESIGNERS USING SOLUTION EXPLORER CREATING A PROJECT GETTING STARTED WITH SQL-SMO DISCOVERING THE SQL-SMO OBJECT MODEL CREATING A SQL-SMO PROGRAM LISTEN TO YOUR CLIENTS’ NEEDS DOCUMENT THE PROJECT BUDGET ENOUGH TIME FOR THE PROJECT THINK ABOUT LONG-TERM NEEDS THINK CAREFULLY ABOUT RELATIONS IN THE DATABASE HANDLE MANY-TO-MANY RELATIONSHIPS APPROPRIATELY THINK ABOUT PERFORMANCE DESIGN AND TEST ON DEVELOPMENT HARDWARE TEST YOUR APPLICATION CAREFULLY THINK ABOUT WHICH EDITION OF SQL SERVER TO USE THINK ABOUT THE HARDWARE YOU NEED BOOKS ONLINE THE PUBLIC NEWSGROUPS THE PUBLIC FORA THE SQL SERVER 2005 WEB SITE THE SQL SERVER DEVELOPER CENTER THE SQL SERVER 2005 TECHCENTER THE BUSINESS INTELLIGENCE SITE THE INTEGRATION SERVICES DEVELOPER CENTER THE REPORTING SERVICES WEB SITE CHANNEL 9 OTHER WEB SITES