Microsoft SQL Server 2005 Express

ISBN-10: 0672327414

ISBN-13: 9780672327414

Edition: 2006

Authors: Alison Balter

List price: $34.99
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

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.
eBooks Starting from $27.99
Buy eBooks
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Customers also bought
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

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
×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×