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

Beginning Lua Programming or Creating Cool Web Sites with HTML XHTML and CSS

Beginning Lua Programming

Author: Aaron Brown

Lua offers a wide range of features that you can use to support and enhance your applications. With this book as your guide, you’ll gain a thorough understanding of all aspects of programming with this powerful language. The authors present the fundamentals of programming, explain standard Lua functions, and explain how to take advantage of free Lua community resources. Complete code samples are integrated throughout the chapters to clearly demonstrate how to apply the information so that you can quickly write your own programs.

See also: Raving Fans or Shift

Creating Cool Web Sites with HTML, XHTML, and CSS

Author: Dave Taylor

• Walks readers through the process of creating a basic Web site from scratch using HMTL, the basis for billions of Web pages, and then jazzing it up with advanced techniques from the author's award-winning sites

• This updated edition features new material that shows readers how to attract visitors to a site and keep them there, including new JavaScript examples and coverage of cascading style sheets and XHTML, technologies that make building successful Web sites even easier

• Also features exciting new tips and tricks for beginning and advanced users, as well as more expanded examples and samples for users to incorporate in their own sites

• The book moves from basic design and deployment to advanced page layout strategies, showing how to spice up new or existing sites with sound, video, and animation

Table of Contents:

	Preface
	Acknowledgments
Pt. I	Building a wicked cool web page	1
Ch. 1	So what's all this web jazz?	3
Ch. 2	Building your first web page : HTML basic	21
Ch. 3	Presenting text attractively	43
Ch. 4	Moving into the 21st century with cascading style sheets	57
Ch. 5	Lists and special characters	81
Ch. 6	Putting the web in world wide web : adding pointers and links	103
Ch. 7	From dull to cool by adding graphics	121
Pt. II	Rockin' page design strategies	157
Ch. 8	Tables and frames	159
Ch. 9	Forms, user input, and the common gateway interface	195
Ch. 10	Advanced form design	219
Ch. 11	Activating your pages with JavaScript	235
Ch. 12	Advanced cascading style sheets	261
Ch. 13	Site development with weblogs	293
Pt. III	Expanding your page into a web site	307
Ch. 14	Web sites versus web pages	309
Ch. 15	Thinking about your visitors and your site's usability	323
Ch. 16	Validating your pages and style sheets	335
Ch. 17	Building traffic and being found	351
	App. A: Step-by-step web site planning guide	373
	App. B: Finding a home for your web site	379
	Index	385