Mensys Online Shop
| Category: | General - Books | By: | Wrox, an imprint of Wiley |
| More info: | www.wrox.com | Author(s): | Robert Vieira |
| Pages: | 682 | Year of publication: | 2009 |
- This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself;- Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server;- Discusses creating & changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting & Integration Services, & more;- Features updated » 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 comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in-depth look at SQL Server itself;- Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server;- Discusses creating & changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting & Integration Services, & more;- Features updated & new material, including new examples using Microsoft's AdventureWorks sample database.What you will learn from this book:- How RDBMSs store, manage, and retrieve data;- Ways to create and alter tables;- Various 'forms' of database normalization;- Techniques for writing scripts & working with stored procedures;- The positives & negatives of indexes;- Myriad consequences that locks & deadlocks have on system performance;- An understanding of triggers and how they are used.

