Mensys Online Shop
| Category: | General - Books | By: | APress |
| More info: | www.apress.com | Author(s): | Robin Dewson |
| Pages: | 507 | Year of publication: | 2009 |
This book takes a developer, and even a DBA, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource. The book focuses on the features within the Express Edition & therefore will not confuse readers with coverage of features found only in the Development Edition.- Covers using the free Express Edition of SQL Server;- » Read more... | ![]() |
All prices are in Euro excl. VAT (19%, for books 6%) and excl. shipping.
E-mail or call us at +31 (0)23 548 20 20 for licences, upgrades and other questions.
This book takes a developer, and even a DBA, from knowing nothing about SQL Server 2008 Express Edition to being ready to design and build a fully functioning system that is secure, reliable, maintainable, and robust. The Express Edition of SQL Server is a free resource. The book focuses on the features within the Express Edition & therefore will not confuse readers with coverage of features found only in the Development Edition.- Covers using the free Express Edition of SQL Server;- Describes creating a database from scratch and builds on this;- Provides an understanding of SQL Server Express 2008, allowing you to build future solutions for you & your business.What you'll learn:- Learn what features exist within SQL Server 2008 Express Edition and how to install & upgrade the product and set up security;- Design and create a database;- Build database objects, such as tables & stored produres, graphically as well as programmatically;- Work with data_inserting, updating, deleting, and retrieving - using simple & complex queries, programs, and data views;- Generate reports from data;- Implement a solid database maintenance strategy that includes backing up & restoring your data when necessary;- Take advantage of advanced Transact-SQL techniques to get the most out of your data;- Ensure good performance by building the right indexes, defining the right relationships between tables, and joining tables in the most optimal manner.

