Visual QuickStart Guide or Engineering with Excel

Visual QuickStart Guide: SQL

Author: Chris Fehily

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too--no programming experience required!

After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.

Best of all, the book's examples were tested on the latest versions of Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and PostgreSQL. On the companion Web site, you can download the SQL scripts and sample database for all these systems and put your knowledge to work immediately on a real database..

Interesting book: Perfect Phrases for Performance Reviews or The 17 Indisputable Laws Of Teamwork

Engineering with Excel

Author: Ronald W Larsen

Based on Excel 2007 , Engineering with Excel, 3e  takes a comprehensive look at using Excel in engineering.  This book focuses on applications and is intended to serve as both a textbook and a reference for students.

Booknews

This textbook for a first-year engineering course explains how to apply the Excel spreadsheet program to perform common engineering calculations. Topics include graphing, matrix operations, linear regression, macros, Visual Basic for applications, financial calculations, statistics functions, and numerical integration techniques for differential equations. Annotation c. Book News, Inc., Portland, OR (booknews.com)

Table of Contents:

1	Introduction to Excel	1
2	Graphing with Excel	46
3	Excel Functions	84
4	Matrix Operations in Excel	126
5	Linear Regression in Excel	153
6	Iterative Solutions Using Excel	187
7	Using Macros in Excel	225
8	Programming in Excel with VBA	268
9	Sharing Excel Information with Other Programs	296
10	Time Value of Money with Excel	335
11	Financial Calculations with Excel	363
12	Excel's Statistics Functions	387
13	Numerical Differentiation Using Excel	409
14	Numerical Integration Using Excel	433
15	Numerical Integration Techniques for Differential Equations Using Excel	459
	Index	490