SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

books >> sql server 2005 books >> Microsoft SQL Server 2005: Database Essentials ...

Microsoft SQL Server 2005: Database Essentials


Feb 02, 2007

Step by Step Tutorial for New Database Programmers


Review by SQL-Server-Performance.com

Microsoft SQL Server 2005: Database Essentials
By Solid Quality Learning
306 pages. Microsoft Press. $39.99.

Find out more about this book, or purchase it, from Amazon.com.



To deliver data from a database to users via an application you need the following:

  • A database system.
  • A database.
  • A data model.
  • Knowledge in the programming language of the database.
  • Knowledge in the programming language of the client application.
  • Time.

Typically, all but the last item are present. So you need to be proficient in the first five points on the list or be able to acquire that knowledge in a very timely manner. Otherwise, you could find yourself having to dedicate more time than you care to.

Many voluminous books have been written on each of the points above. In some of them, the foreword and the introduction alone are nearly as long as this book, which including the index has about 300 pages. In this limited space, the authors of Microsoft SQL Server 2005: Database Essentials try to communicate the basic knowledge that a database developer must have. In other words, you should take the title of the book literally.

Table of Contents:

  • Introduction to Database Development with Microsoft SQL Server 2005
  • Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment
  • Reviewing Microsoft SQL Server 2005 Management Tools
  • Gathering and Understanding Business Requirements before Creating Database Objects
  • Designing a Database to Solve Business Needs
  • Reading Microsoft SQL Server 2005 Data from Client Applications
  • Selecting the Data you Need
  • Creating Views to Encapsulate Queries
  • Retrieving Data Using Programmable Objects
  • Inserting Data in Microsoft SQL Server 2005
  • Deleting Data from Microsoft SQL Server 2005
  • Updating Data from Microsoft SQL Server 2005

Database Essentials is a good at explaining in 300 pages the stuff other authors take many more pages to do. And it lives up to its claim that nothing but the mere basics should be explained. Chances are it will suit your needs.


        








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved