Mensys Online Shop
| Category: | General - Books | By: | O'Reilly |
| More info: | www.oreilly.com | Author(s): | Ken Bluttman, Wayne S. Freeze |
| Pages: | 351 | Year of publication: | 2007 |
- Develop basic and sophistaced queries;- Apply aggregate functions, custom functions, regular expressions & crosstabs;- Apply queries to perform nonpassive activities, such as inserting, updating, and deleting data;- Create & manipulate tables and queries programmatically;- Manage text-based data, isolate parts of a string, and work with numbers that are stored as text;- Use arrays, read & write to the Windows registry, encrypt data, and use transaction processing;- Operate » 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.
- Develop basic and sophistaced queries;- Apply aggregate functions, custom functions, regular expressions & crosstabs;- Apply queries to perform nonpassive activities, such as inserting, updating, and deleting data;- Create & manipulate tables and queries programmatically;- Manage text-based data, isolate parts of a string, and work with numbers that are stored as text;- Use arrays, read & write to the Windows registry, encrypt data, and use transaction processing;- Operate FileSystemObject, use XML with XSLT, communicate with SQL Server, and exchange data with other Office products;- Deal with business & finance problems, including methods for calculating depreciation, loan paybacks, and Return on Investment;- Explore statistical techniques, such as frequency, variance, kurtosis, linear regression, and combinations & permutations.