Warriors B2G1 Free
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Book News | May 11, 2015

    Chris Hedges: IMG Powell’s Q&A: Chris Hedges



    Describe your latest book. Wages of Rebellion looks at the nature of rebellion, those who do it, why they do it, and the price they pay for being a... Continue »
    1. $18.89 Sale Hardcover add to wish list

      Wages of Rebellion

      Chris Hedges 9781568589664

    spacer

This item may be
out of stock.

Click on the button below to search for this title in other formats.


Check for Availability
Add to Wishlist

Creating SQL Server 2005 Applications with Visual Studio

Creating SQL Server 2005 Applications with Visual Studio Cover

 

Synopses & Reviews

Publisher Comments:

 

This text provides an overview of database design and implementation topics using Microsoft SQL Server 2005, with an emphasis on database application development using Visual Studio .NET. 

Table of Contents

Table of Contents

 

1.  Introduction to Databases

Overview of Databases. The Database Development LIfe Cycle. Entity Relationship Modeling. Using an ER Model to Define Relational Database Tables.

 

2.  Creating SQL Server Databases

Database System Architectures. SQL Server 2005 DBMSsand Client Applications. SQL Server Database Objects. Creating and Managing Databases. Creating Database Tables. Deleting Database Tables. Modifying Existing Database Tables.

 

3.  Creating SQL Queries to View Database Data

Sample Databases. Using SQL Queries to Retrieve Database Data. Using Arithmetic Operations in Queries. Using In-Line Functions in Queries.Using Aggregate Functions in Queries. Formatting Query Output. Retrieving Data From Multiple Tables. Creating Nester Queries. Database Views. Performing Set Operations in Queries.

 

4.  SQL Action Queries and T-SQL Scripts

Inserting, Updating, and Deleting Database Data. Database Transactions and Locking/Blocking. T-SQL Programming. Stores Procedures. User-defined Functions. Triggers.

 

5.  Introduction to Visual Basic and the Visual Basic Integrated Development Environment

.Net Framework. Using the VB Integrates Development Environment (IDE). VB Programming Fundamentals. Controlling Program Flow. User-Defined Procedures.

 

6.  Creating VB .NET Database Applications

Accessing Data in .Net. Creating and Managing Data Access Components in the VB IDE. Common Database Interfaces. Working with Data-Bound Controls. Using Program Commands to Manipulate Data. Creating a Form Combining Data-Bound Controls and Program Commands. Retrieving Data Synchronously.

 

7.  Creating Database Reports

Common Database Report Layouts. Creating A Single-Table Tabular Report. Creating a Report That Displays Data From Multiple Tables. Creating a Master-Details Report with Multiple Master-Detail Relationships. Adding Summary and Formula Fields to a Report. Creating a Report That Accepts an Input Parameter.

 

8.  Creating Web-based Database Applications Using ASP.NET

Introduction to the World Wide Web. Web Addressing Concepts. HyperText Markup Language. Introduction to ASP.NET.Creating Web Database Forms.

 

9.  Using XML in Database Applications

Introduction to XML. Creating SQL Server Queries to Retrieve XML-Formatted Data. Extensivke Stylesheet Language Transformation (XSLTs). Creating and Processing XML Documents Using Data Sets. Using .NET Program Commands to Create XML Files and Add XML Elements. Sharing XML Data Using XML Web Services.

 

10.  SQL Server Database Administration 

SQL Server Database Management Tools. Database Indexing. Security and User Authentication. Backup and Recovery. Deploying Database Applications.

 

Appendix A:  Configuring a client/server SQL Server application development environment 

Appendix B:  Configuring a SQL Express development environment

 

Product Details

ISBN:
9780131463554
Publisher:
Prentice Hall
Subject:
Programming Languages - SQL
Author:
Morrison, Joline
Author:
Morrison, Charles M.
Author:
Morrison, Michael
Subject:
Database management
Subject:
Client-server computing
Copyright:
Edition Description:
Trade paper
Publication Date:
August 2006
Binding:
Paperback
Grade Level:
College/higher education:
Language:
English
Illustrations:
Y
Pages:
573
Dimensions:
9.92x8.06x.85 in. 2.31 lbs.

Related Subjects

Computers and Internet » Database » SQL

Creating SQL Server 2005 Applications with Visual Studio
0 stars - 0 reviews
$ In Stock
Product details 573 pages Prentice Hall - English 9780131463554 Reviews:
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.