Beginning SQL Server Express Database Applications

With Visual Basic Express and Visual Web Developer Express from Novice to Professional

By: Rick Dobson

Write A Review

Paperback | 16 December 2005

At a Glance

Paperback
620 Pages

Dimensions(cm)
22.86 x 17.15 x 3.18

Paperback

RRP $84.99

$83.75

or 4 interest-free payments of $20.94 with

Ships in 10 to 15 business days

SQL Server 2005 Express (SSE) (database component of
Microsoft's Express Suite of products) is free of charge,
inherits many (non-enterprise) features from SQL Server
2005, and comes complete with its own dedicated development
and administration tools. It is an ideal database for
developers and administrators to use in prototype/evaluation
projects, and also a powerful development platform in its
own right for low-budget database applications for non-
profit Web Sites, as well as small office/departmental
solutions and even eCommerce sites. This book provides all
of the installation, configuration, administration and
development techniques that you need to build these types of
application quickly and effectively. It focuses on solution
techniques that are easy to learn, fast to implement, and
transparent in the ways they address real-world problems.
The book includes two full example case studies showing how
to build a paypal-based eCommerce site and a Church
administration application.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Graphical & Digital Media Applications Web Graphics & Design Computer Programming & Software Development Database Programming Databases Database Software SQL Server & MS SQL Programming & Scripting Languages Software Engineering

About the Author	p. xiii
About the Technical Reviewer	p. xv
Acknowledgments	p. xvii
Introduction	p. xix
Working with SQL Server Express
Getting Started with SQL Server Express	p. 3
What Is SQL Server Express?	p. 3
Who Is SQL Server Express For?	p. 5
Hobbyists and Other Nonprofessional Developers	p. 6
Business Analysts	p. 6
Database Administrators and Operations Specialists	p. 7
Professional Developers in Need of a Free, Modern Database	p. 8
SQL Server Express vs. SQL Server 2005	p. 9
Similarities	p. 9
Differences	p. 10
SQL Server Express vs. MSDE	p. 11
Installing SQL Server Express	p. 12
Performing a System Check for SQL Server Express	p. 12
Registration, Feature, and Instance Name Screens	p. 13
Service Account and Authentication Mode Screens	p. 14
Collation, Error Reporting, and Ready to Install Screens	p. 15
Using SQL Server Express Query Tools	p. 16
Query Tools for SQL Server Express	p. 17
Configuring SQL Server Express to Start Automatically	p. 17
Configuring SQL Server Express for Network Access	p. 19
Configuring the Windows XP Firewall for SQL Server Express	p. 21
Connecting from the SSMS-Based Query Tool	p. 22
Connecting from Remote Down-Level Clients	p. 24
Installing Sample Databases	p. 24
Connecting to SQL Server Express from Visual Studio 2003	p. 25
Connecting to SQL Server Express from Access Projects	p. 27
Connecting to SQL Server Express from Access Linked Tables	p. 28
Summary	p. 31
Graphical and Command-Line Query Tools	p. 33
Using the SSMS-Based Query Tool	p. 33
Connecting to SQL Server Instances	p. 34
Using Database, Table, and View Designers	p. 41
Designing, Running, Saving, and Rerunning SQL Scripts	p. 51
Using the sqlcmd Utility	p. 60
Connecting to SQL Server Instances	p. 60
Running Statements from a File	p. 62
Saving Output to a File	p. 64
Dynamically Running and Batching sqlcmd Statements	p. 65
Summary	p. 71
Exploring, Creating, and Recovering Databases	p. 73
Overview of Databases	p. 73
Introducing Database Concepts	p. 74
Types of Databases	p. 75
Getting Meta Data About Databases	p. 75
Using sp_helpdb for Database Help	p. 76
Using System Catalog Views	p. 78
Searching for and Copying Databases with Windows Explorer	p. 83
Using CREATE DATABASE	p. 84
Just Naming the Database	p. 84
Designating Data Files in the ON Clause	p. 85
Using the LOG ON Clause	p. 87
Attaching and Detaching Databases	p. 88
Attaching Databases with CREATE DATABASE	p. 89
Copying Files, the Auto-Close Feature, and sp_detach_db	p. 95
Backing Up and Restoring Databases	p. 98
Overview of Database Recovery Models	p. 99
Choosing and Modifying a Database's Recovery Model	p. 101
Performing a Full Data Backup and Restore	p. 102
Performing Differential Backups and Restores	p. 103
Cleaning Up the Backup and Restore Scripts	p. 106
Summary	p. 106
Data Types, Tables, and Constraints	p. 107
Learning About Data Types	p. 107
Numbers and Dates	p. 108
Character and Binary Byte Streams	p. 114
Miscellaneous	p. 117
Creating Tables and Using Data Types	p. 121
Creating a Table with Columns	p. 121
Adding Data to Tables	p. 124
Managing Data Integrity with Basic Constraints and Column Properties	p. 128
Inserting Data for a Subset of Table Columns	p. 128
Not Allowing Null Values in a Column	p. 131
Designating Default Column Values	p. 132
Designating a Column as a Primary Key	p. 135
Managing Data Integrity with Sophisticated Constraints	p. 139
Using CHECK Constraints	p. 139
Using Multicolumn Constraints	p. 143
Using Foreign Key Constraints	p. 145
Summary	p. 154
Creating Queries from a Single Database Object	p. 155
Specifying Items to Select from a Data Source	p. 155
Specifying SELECT List Items	p. 156
Using the Current Database Context or a Different Database	p. 165
Specifying Queries from Another Server Instance	p. 168
Filtering, Grouping, and Aggregating	p. 175
Filtering for Exact and Approximate Character Matches	p. 175
Filtering for Values in a Range	p. 177
Grouping and Aggregating	p. 183
Summary	p. 189
Querying Multiple Database Objects and Manipulating Result Sets	p. 191
Joining Data Sources	p. 191
Inner Joins	p. 192
Outer Joins	p. 195
Cross Joins	p. 198
Self-Joins	p. 200
Joins for More Than Two Data Sources	p. 205
Using Subqueries	p. 208
Including a Subquery in a SELECT List	p. 208
Including a Subquery in a WHERE Clause	p. 211
Including a Correlated Subquery in a WHERE Clause	p. 214
Explicitly Ordering and Ranking Rows	p. 215
Controlling Row Order with the ORDER BY Clause	p. 215
Ranking Result Set Rows	p. 219
Manipulating Result Sets	p. 224
Saving a Result Set with the INTO Clause	p. 225
Appending Result Sets to One Another	p. 229
Reusing Queries with Common Table Expressions	p. 232
Converting Between Relational and Cross-Tabulated Tables	p. 239
Summary	p. 245
Leveraging Database Objects That Encapsulate T-SQL	p. 247
Creating and Using Views	p. 247
Performing Data Access with a View	p. 248
Performing Data Modification with a View	p. 252
Processing Meta Data with System Views	p. 256
Creating and Using User-Defined Functions	p. 259
Creating and Using FN User-Defined Functions	p. 260
Creating and Using IF User-Defined Functions	p. 263
Creating and Using Stored Procedures	p. 267
Returning Result Sets Without Parameters	p. 268
Returning Result Sets and Input Parameters	p. 271
Returning Scalar Values with Output Parameters	p. 278
Processing Return Status Values	p. 282
Performing Data Manipulation	p. 284
Creating and Using Triggers	p. 292
Learning to Reference Inserted and Deleted Tables	p. 293
Rolling Back in an AFTER Trigger	p. 295
Archiving Changes to a Table with Triggers	p. 297
Using an INSTEAD OF Trigger with a View	p. 302
Summary	p. 305
Managing SQL Server Express Security	p. 307
Overview of Security Concepts	p. 307
Exploring and Creating Principals	p. 308
Exploring Principals	p. 309
Creating Principals	p. 313
Assigning Permissions to Principals	p. 324
Overview of Securables and Permissions	p. 325
Assigning Permissions via the Fixed Server Roles	p. 327
Assigning Permissions via the Fixed Database Roles	p. 332
Granting, Denying, and Revoking Permissions	p. 339
Creating and Using Schemas	p. 348
Creating and Owning Schemas	p. 349
Creating Objects in Owned Schemas	p. 353
Creating Objects in Any Schema	p. 356
Using Encryption Keys and Certificates	p. 359
Encrypting Data	p. 360
Signing Data	p. 363
Summary	p. 368
Working with Visual Basic Express and Visual Web Developer Express
Introduction to Visual Basic Express and Windows Forms	p. 371
Starting, Saving, and Exploring a Solution	p. 371
Starting and Saving a New Solution's Project	p. 371
Adding Items to a Solution	p. 372
Exploring a Solution	p. 373
Using Visual Basic Data Types in VBE	p. 374
Data Types Are Objects	p. 374
Overview of Data Types	p. 375
Declaring Variables and Assigning Data Type Values	p. 379
Building and Testing a Windows Form Calculator	p. 385
Creating a New Startup Form	p. 385
Populating a Windows Form with Controls	p. 386
Adding Button Click Event Procedures to a Form	p. 387
Testing the Code Behind a Form	p. 389
Handling Exceptions	p. 390
A Form for Running Try...Catch Statements	p. 392
Using Try...Catch Statements Directly	p. 393
Invoking a Try...Catch Statement in a Function Procedure	p. 394
Dynamically Adapting to Runtime Errors	p. 395
Using the File System	p. 397
Design and Formatted Views of an Application Form	p. 397
Exploring Folders and Viewing Files	p. 399
Reading Fixed-Width Reports	p. 404
Summary	p. 408
Introduction to Visual Web Developer Express, Web Pages, and Web Forms	p. 409
ASP.NET Development Concepts	p. 409
Starting and Exploring ASP.NET Projects	p. 411
Starting an ASP.NET Project	p. 411
Exploring a New ASP.NET Project	p. 413
Creating Pages for an ASP.NET Project	p. 415
Changing a Page by Clicking a Button	p. 415
Returning a Formatted Date from a Calendar Control	p. 419
Programming a Message-for-the-Day Application	p. 424
Creating and Linking HTML Pages	p. 427
Interacting with Data	p. 429
Creating a Server-Based Website and Copying Files to It	p. 429
Saying Hello Dynamically to a Web Form User	p. 431
Populating an Application Variable and Reading from It	p. 435
Summary	p. 442
Programming ADO.NET	p. 445
Overview of ADO.NET	p. 445
ADO.NET Providers	p. 445
ADO.NET Architecture	p. 446
Programming Connection Objects	p. 447
Opening and Closing a Connection to a SQL Server Database	p. 448
Getting Help with Constructing a Connection String	p. 450
Connecting to SQL Server Express and Access Database Files	p. 451
Programming Command Objects	p. 454
Returning a Single Value with a Command Object	p. 455
Returning Forward-Only, Read-Only Rowsets	p. 462
Performing Data Definition and Database Maintenance	p. 471
Summary	p. 483
Programming DataAdapter and DataSet Objects	p. 485
Creating, Populating, and Using DataSet Objects	p. 486
Sorting and Filtering DataTables with DataViews	p. 493
Inserting, Updating, and Deleting Rows	p. 498
Bulk Loading Data from Excel	p. 509
Summary	p. 514
Using Visual Database and Form Design Tools	p. 515
Visual Database Tools in VBE	p. 515
Dialog Boxes for Creating Connections	p. 516
Exploring a SQL Server Express Database	p. 517
Adding Objects to a SQL Server Express Database	p. 519
Migrating and Revising an MSDE Database	p. 522
Adding a Stored Procedure	p. 525
Working with Data Sources and Windows Forms	p. 526
Creating a Data Source for the Data Sources Window	p. 527
Dragging Data Source Items to a Windows Form	p. 529
Modifying Control Behavior with Smart Tags	p. 532
Creating and Using Interactive Data Displays	p. 539
Visual Web Developer Visual Database Tools	p. 554
Making Database Connections	p. 554
Viewing Data and Modifying Databases	p. 558
Displaying Data on a Web Form Page with a GridView Control	p. 560
Performing Lookups on a Web Form Page	p. 564
Summary	p. 574
Index	p. 575
Table of Contents provided by Ingram. All Rights Reserved.

Beginning SQL Server Express Database Applications

With Visual Basic Express and Visual Web Developer Express from Novice to Professional

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Databases

Python All-in-One For Dummies

3rd Edition

SPSS Survival Manual

7th Edition - A step by step guide to data analysis using IBM SPSS

Storytelling with Data

A Data Visualization Guide for Business Professionals, 10th Anniversary Edition

Database Systems

A Practical Approach

Tools and Applications of Data Mining

Big Data Analytics

A Practical Guide

The Data Science and Psychology

Data Mining

Concepts, Techniques and Applications

Designing Semantic Knowledge Graphs

A Guide to Utilizing Semantic Web Technologies for Agile Data Management

The Data Warehouse Toolkit 3ed

The Definitive Guide to Dimensional Modeling

The Crypto Trader

How anyone can make money trading Bitcoin and other cryptocurrencies

Microsoft Excel 365 Bible

Bible

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Designing Data-Intensive Applications

Big Ideas Behind Reliable, Scalable, and Maintainable Systems

Hands-On Programming with R

Write Your Own Functions and Simulations

Mindf*ck

Inside Cambridge Analytica's Plot to Break the World

Social Research Methods

4th Edition

Data Analytics for Accounting ISE

3rd Edition

Microsoft 365 Access For Dummies

Access for Dummies

Microsoft Power BI For Dummies

For Dummies (Computer/Tech)

Don't Make Me Think, Revisited

A Common Sense Approach to Web Usability

Data Governance: The Definitive Guide

People, Processes, and Tools to Operationalize Data Trustworthiness

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Data Strategy

How to Use Data and Artificial Intelligence to Transform Your Business

This product is categorised by