Microsoft SQL Server 2005 Express

Name: Microsoft SQL Server 2005 Express
Price: 17.25 USD
Availability: InStock
ISBN: 9780672327414

ISBN-10: 0672327414

ISBN-13: 9780672327414

Edition: 2006

Authors: Alison Balter

List price: $34.99

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $17.25

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Written with clarity and a down-to-earth approach,Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize SQL Server stored procedures, functions, and triggers using T-SQL, VB.NET, and C#. Finally, you will learn how to output SQL Server data to reports, and the Internet.

Book details

List price: $34.99
Copyright year: 2006
Publisher: Pearson Education
Publication date: 6/16/2006
Binding: Mixed Media
Pages: 456
Size: 6.75" wide x 8.75" long x 1.00" tall
Weight: 1.584
Language: English



Introduction



Introduction to SQL Server



Basic Relational Database Design


Database Basics


System Versus User Objects


Table Basics


Relational Database Design Concepts


View Basics


Stored Procedure Basics


User-Defined Function Basics


Trigger Basics


SQL Server Stored Procedures Versus Transact-SQL Statements Stored on Local Computers


Summary


Q&A


Workshop


Activities



SQL Server Basics


Versions of SQL Server 2005 Available


Installing SQL Server Express


Getting Started with the SQL Server Management Studio Express


Summary


Q&A


Workshop


Activities



Getting to Know the SQL Server Management Studio


Microsoft SQL Server Management Studio Express


Creating a SQL Server Database


Summary


Q&A


Workshop


Activities



Working with Tables, Views, and Stored Procedures



SQL Server Tables


Creating SQL Server Tables


Working with Constraints


Identity Columns


Working with Computed Columns


Working with User-Defined Data Types


Adding and Modifying Indexes


Summary


Q&A


Workshop


Activities



Working with Table Relationships


An Introduction to Relationships


Working with Database Diagrams


Working with Table Relationships


How to Designate Table and Column Specifications


How to Add a Relationship Name and Description


How to Determine when Foreign Key Relationships Constrain the Data Entered in a Column


Designating Insert and Update Specifications


Summary


Q&A


Workshop


Activities



Getting to Know the SELECT Statement


Introducing T-SQL


Working with the SELECT Statement


Adding on the FROM Clause


Including the WHERE Clause


Using the ORDER BY Clause


Adding the DISTINCT Keyword


Working with the FOR XML Clause


Creating Top Values Queries


Summary


Q&A


Workshop


Activities



Building SQL Statements Based on Multiple Tables


Working with Joint Types


Working with the GROUP BY Clause


Including Aggregate Functions in Your SQL Statements


Taking Advantage of the HAVING Clause


Summary


Q&A


Workshop


Activities



Modifying Data with Action Queries


Modifying Data with Action Queries


Summary


Q&A


Workshop


Activities



Getting to Know the T-SQL Functions


Working with Numeric Functions


Taking Advantage of String Functions


Exploring the Date/Time Functions


Working with Nulls


Summary


Q&A


Workshop


Activities



Working with SQL Server Views


An Introduction to Views


Using T-SQL to Create or Modify a View


Summary


Q&A


Workshop


Activities



Creating Complex Views


Creating Views Based on Data in Multiple Tables


Views and Subqueries


Views and Outer Joins


Views and Top Values


Sorting View Results


Views and Functions


Views and Built-in Functions


Using Views to Secure Data


Modifying Data in a View


Modifying Views


Renaming Views


Deleting Views


Indexed Views


Optimizing the Views That You Build


Summary


Q&A


Workshop


Activities



Using T-SQL to Design SQL Server Stored Procedures


The Basics of Working with Stored Procedures


Declaring and Working with Variables


Controlling the Flow


Summary


Q&A


Workshop


Activities



Important Stored Procedure Techniques


The SET NOCOUNT Statement


Using the @@ Functions


Working with Parameters


Modifying Data with Stored Procedures


Errors and Error Handling


Stored Procedures and Transactions


Summary


Q&A


Workshop


Activities



Stored Procedure Special Topics


Stored Procedures and Temporary Tables


Stored Procedures and Security


Building and Working with User-Defined Functions


Creating and Working with Triggers


Summary


Q&A


Workshop


Activities



ADO.NET and SQL Server


The History of Data Access


The Basics of ADO.NET


Building Queries That Modify Data


Summary


Q&A


Workshop


Activities



Using VB to Design SQL Server Stored Procedures


Executing a Simple Stored Procedure


Declaring and Working with Variables


Controlling Program Flow


Working with Parameters


Modifying Data with Stored Procedures


Summary


Q&A


Workshop


Activities



Visual Basic .NET Special Topics


Working with Temporary Tables


Including Error Handling in the Stored Procedures that You Build


Using Transactions to Protect Your Data


Summary


Q&A


Workshop


Activities



Using C# to Design SQL Server Stored Procedures


Executing a Simple Stored Procedure


Declaring and Working with Variables


Controlling Program Flow


Working with Parameters


Modifying Data with Stored Procedures


Summary


Q&A


Workshop


Activities



C# Special Topics


Working with Temporary Tables


Including Error Handling in the Stored Procedures That You Build


Using Transactions to Protect Your Data


Summary


Q&A


Workshop


Activities



Debugging the Stored Procedures That You Write


Harnessing the Power of the Immediate Window


Invoking the Debugger


Using Breakpoints to Troubleshoot


Stepping Through Code


Setting the Next Statement to Execute


Viewing the Call Stack


Working with the Locals Window


Working with Watch Expressions


Summary


Q&A


Workshop


Activities



Security and Administration



SQL Server Authentication


The Basics of Security


Types of Authentication Available


How to Create Logins


How to Create Roles


Summary


Q&A


Workshop


Activities



SQL Server Permissions Validation


The Types of Permissions Available


Getting to Know Table Permissions


Getting to Know View Permissions


Getting to Know Stored Procedure Permissions


Getting to Know Function Permissions


Implementing Column-Level Security


Summary


Q&A


Workshop


Activities



Configuring, Maintaining, and Tuning SQL Server


Selecting and Tuning Hardware


How to Configure and Tune SQL Server


How to Maintain Your Databases


How to Maintain Tables and Other Objects


Summary


Q&A


Workshop


Activities



Performance Monitoring


Executing Queries in SQL Server Management Studio Express


Displaying and Analyzing the Estimated Execution Plan for a Query


Adding Indexes to Enable Queries to Execute More Efficiently


Setting Query Options


Summary


Q&A


Workshop


Activities



Using the NorthWind Sample Database


What You Need to Know About Installing the Sample Database Files


Attaching to the NorthWind Sample Database File


Index