Author: Ronald R. Plew and Ryan K. Stephens
Paperback: 267 pages
Publisher: Sams; 2nd edition (2000)
Language: English
ISBN: 0672318997
Format: pdf
Details:
Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.

Author(s) : Paul Wilton and John W. Colby
Publisher : Wrox
Year : Mar 2005
ISBN 10 : 0764577328
ISBN 13 : 9780764577321
Language : English
Pages : 528
File type : PDF
Size : 3.6 MB (book + source code)

This book starts right from the basics with databases and SQL. Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases.

If you have some previous experience with databases and SQL, then you’ll have a head start and you may want to just skim Chapter 1. You’ll need to follow its instructions for creating the book’s example database, as this is used for all the examples throughout the book.

This book will look at Structured Query Language, or SQL as it’s usually abbreviated. SQL works with a database to create the database and to insert and extract data. Therefore, it’s essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that you’re equipped to create an effective database.

The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However, while standards are great, what’s available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.

TABLE OF CONTENT:
Chapter 01 - Introduction to SQL
Chapter 02 - Entering Information
Chapter 03 - Extracting Information
Chapter 04 - Advanced Database Design
Chapter 05 - Manipulating Data
Chapter 06 - Grouping and Aggregating Data
Chapter 07 - Selecting Data from Different Tables
Chapter 08 - Queries within Queries
Chapter 09 - Advanced Queries
Chapter 10 - Views
Chapter 11 - Transactions
Chapter 12 - SQL Security
Chapter 13 - Database Tuning
Appendix A - Exercise Answers
Appendix B - Setting up and Using the Five Database Systems
Appendix C - Initial Data Set

SQL for Dummies
by Allen G. Taylor

ISBN-10 / ASIN: 0764540750
ISBN-13 / EAN: 9780764540752

Publisher: For Dummies
Number Of Pages: 432
Publication Date: 2003-08-08

Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them. Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities – the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique. Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value in SQL For Dummies, 5th Edition; even if you have some experience designing and creating databases, you may discover a few things you didn't know about. Here's just a sampling of some of the things you'll find covered in SQL For Dummies, 5th Edition: Exploring relational database and SQL fundamentals Building and maintaining a simple database structure Building a multiple relational database Manipulating database data Examining SQL nuts and bolts: values, expressions, operators, and queries Providing database security and protecting your data Exploring ODBC and JDBC, and using SQL with XML Moving beyond the basics: cursors, persistent stored modules, and error-handling Top Ten lists on common SQL mistakes and retrieval tips Plain and simply, databases are the best tools ever invented for keeping track of the things you care about. After you understand databases and can use SQL to make them do your bidding, you wield tremendous power. SQL For Dummies, 5th Edition, can get you well on your way to harnessing the power of databases.

Product Description
Advanced JavaScript 3rd Edition is an in-depth examination of the most important features of JavaScript. The book assumes readers have a basic understanding of web development, but includes a review of JavaScript fundamentals in Chapters 1 through 3. This book gives the reader a comprehensive look at the fundamentals of JavaScript by examining objects, arrays, date and time functions, math, and all the essentials that are needed for complex yet robust JavaScript scripts. Topics are thoroughly examined with several complete examples.
Product Details

* Paperback: 616 pages
* Publisher: Wordware Publishing, Inc.; 3 edition (November 25, 2007)
* Language: English
* ISBN-10: 1598220330
* ISBN-13: 978-1598220339

Foundations of Microsoft Expression Web: The Basics and Beyond

# Paperback: 392 pages
# Publisher: Apress (May 7, 2007)
# Language: English
# ISBN-10: 1590598059

Microsoft Expression Suite promises new levels of power in creating rich dynamic user experiences on the web; Expression Web, one of the excellent programs within the suite, is a powerful web site creation tool that allows you to rapidly build up standards-compliant web pages, style them with CSS, add dynamic ASP.NET functionality to them, and publish them to the web--all from the comfort of one program.

Foundations of Microsoft Expression Web: The Basics and Beyond is one of the first books available on the program. The author--expert MS trainer and MVP Cheryl D. Wise--starts with the very basics, and then takes you to an advanced level through a series of practical real-world exercises. No prior knowledge of Microsoft Expression Suite is assumed, and the book is written with a highly professional tone. This makes it extremely useful whether you're a beginner or an advanced web developer or designer who wants to make use of the software.

About the Author
Cheryl D. Wise, founder and director of WiserWays LLC, has been creating web sites since 1994. A member of the Guild of Accessible Web Designers and a Certified Professional Web Developer (World Organization of Webmasters), Cheryl first received the Most Valuable Professional Award from Microsoft for FrontPage in 2003 and has received the award every year since. She has been teaching others to create standards-complaint accessible web sites at Start to Web, and has been doing other online training since 2004.

The CSS Anthology : 101 Essential Tips, Tricks & Hacks

A practical guide on CSS (Cascading Style Sheets) for professionals and novices, that can be used both as a tutorial and read cover-to-cover or as a handy and practical reference book to common problems, solutions and effects. The Question and Answer format makes it easy for readers to solve their problems and learn more about common pitfalls and workarounds. CSS has been growing steadily in its adoption as a technology. CSS gives the developer complete control over how an HTML page looks without using cumbersome HTML tags- truly separating content from presentation. Many major organizations have been adopting CSS technology e.g. www.wired.com.

Title: XHTML And CSS : A Web Standards Approach
Author(s): Patrick Griffiths
Publisher: New Riders Press
Language: English
ISBN-10: 0-321-31139-6
ISBN-13: 978-0-321-31139-9

Summary:
For readers who want to design Web pages that load quickly, are easy to update, accessible to all, work on all browsers and can be quickly adapted to different media-this comprehensive guide represents the best way to go about it. By focusing on the ways the two languages-XHTML and CSS-complement each other, Web design pro Patrick Griffiths provides the fastest, most efficient way of accomplishing specific Web design tasks. In succinct, approachable fashion, Patrick takes readers through every aspect of page coding (text, forms, page layout, and so on), describing the available code and warning of potential pitfalls. The book is peppered throughout with sidebars containing hands-on instruction in important techniques and tables with code options and syntax.