Computerbooks for PRO

Data, Measurements and Standards in SQL

Data, Measurements and Standards in SQL reveals the shift these programmers need to make to overcome this deadlock. By collecting and detailing the diverse standards of myriad industries, and then giving a declaration for the units that can be used in an SQL schema, Celko enables readers to write and implement portable data that can interface to any number of external application systems!
This book doesn't limit itself to one subject, but serves as a detailed synopsis of measurement scales and data standards for all industries, thereby giving RDBMS programmers and designers the knowledge and know-how they need to communicate effectively across business boundaries.

• Collects and details the diverse data standards of myriad industries under one cover, thereby creating a definitive, one-stop-shopping opportunity for database programmers.
• Enables readers to write and implement portable data that can interface to any number external application systems, allowing readers to cross business boundaries and move up the career ladder.
• Expert advice from one of the most-read SQL authors in the world who is well known for his ten years of service on the ANSI SQL standards committee and Readers Choice Award winning column in Intelligent Enterprise.

Download: Data, Measurements and Standards in SQL

Publisher	Morgan Kaufmann
ISBN	0123747228
Release Date	01 October 2009

MySQL Database Usage & Administration

Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.

• Understand MySQL's features, technical architecture, subsystems, and commands   
• Make database design decisions that optimizre performance, storage, and reliability   
• Write complex queries using joins, subqueries, and views   
• Group SQL statements into transactions and execute them atomically   
• Build and use sophisticated stored procedures and functions   
• Automate database operations with triggers and scheduled events   
• Import and export data in different formats, includiong SQL, CSV, and XML   
• Optimize server and query performance   
• Administer a secure, high availability MySQL RDBMS   
• Manage users and control access   
• Perform database maintenance, replication, backup, and recovery

Download: MySQL Database Usage & Administration

Publisher	McGraw-Hill/Osborne
ISBN	0071605495
Release Date	14 October 2009

Learning SQL, Second Edition

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:

• Move quickly through SQL basics and learn several advanced features
• Use SQL data statements to generate, manipulate, and retrieve data
• Create database objects, such as tables, indexes, and constraints, using SQL schema statements
• Learn how data sets interact with queries, and understand the importance of subqueries
• Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

Download: Learning SQL, Second Edition

Publisher	O'Reilly
ISBN	0596520832
Release Date	27 April 2009

SQL The Complete Reference, 3rd Edition

SQL: The Complete Reference, Third Edition shows you how to work with SQL commands and statements, set up relational databases, load and modify database objects, perform powerful queries, tune performance, and implement reliable security policies. Learn how to employ DDL statements and APIs, integrate XML and Java scripts, use SQL objects, build web servers, handle remote access, and perform distributed transactions. Techniques for managing in-memory, stream, and embedded databases that run on today's mobile, handheld, and wireless devices are included in this in-depth volume.

• Build SQL-based relational databases and applications
• Create, load, and modify database objects using SQL
• Construct and execute simple, multitable, and summary queries
• Implement security measures with authentication, privileges, roles, and views
• Handle database optimization, backup, recovery, and replication
• Work with stored procedures, functions, extensions, triggers, and objects
• Extend functionality using APIs, dynamic SQL, and embedded SQL
• Explore advanced topics such as DBMS transactions, locking mechanisms, materialized views, and two-phase commit protocol
• Understand the latest market trends and the future of SQL

Download: SQL The Complete Reference, 3rd Edition

Publisher	McGraw-Hill/Osborne
ISBN	0071592555
Release Date	12 August 2009

Simply SQL

Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You'll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun. 

• Step through the basic SQL syntax
• Learn how to use best practices in database design
• Master advanced syntax like inner joins,  groups, and subqueries
• Understand the SQL datatypes

Download: Simply SQL

Publisher	SitePoint
ISBN	0980455251
Release Date	28 December 2008

SQL and Relational Theory: How to Write Accurate SQL Code

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, the author demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:

• Should database access granted be through views instead of base tables?
• Nulls in your database are causing you to get wrong answers. Why? What can you do about it?
• Could you write an SQL query to find employees who have never been in the same department for more than six months at a time?
• SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them?
• Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation?

Download: SQL and Relational Theory: How to Write Accurate SQL Code

Publisher	O'Reilly
ISBN	0596523068
Release Date	05 February 2009

Beginning XML Databases

The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.

You'll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.

Download: Beginning XML Databases

Publisher	Wrox Press
Author(s)	Gavin Powell
ISBN	0471791202
Release Date	13 November 2006

Microsoft Visual Studio 2008 Unleashed

Microsoft Visual Studio 2008 Unleashed is an end-to-end, deep dive into the Visual Studio development environment. It’s meant to provide you guidance on how you can squeeze the ultimate productivity out of the many features built into the .NET development tools. Understanding how to use your tools will make you a better developer. This book was written with that premise as its focus.   

The authors have folded in real-world development experience alongside detailed information about the IDE. The result is practical, easy-to-employ information that will make you a more productive and complete developer. This book also helps to ease your transition from other development environments and former versions of Visual Studio. 

Finally, this book provides an entire section dedicated to Visual Studio Team System. It will help you understand how the Team Architect, Team Developer, Team Database Developer, and Team Tester work with the Team Foundation Server to increase team collaboration, visibility, and productivity.

Download: Microsoft Visual Studio 2008 Unleashed

Publisher	Sams
ISBN	0672329727
Release Date	09 June 2008

OCP Oracle Database 11g: New Features for Administrators Exam Guide

Prepare for the Oracle Certified Professional Oracle Database 11g New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference

Download: OCP Oracle Database 11g: New Features for Administrators Exam Guide

Publisher	McGraw-Hill/Osborne
ISBN	0071496823
Release Date	28 April 2008

Oracle Database 11g PL/SQL Programming

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C , and Java procedures, Web-enable your database, cut development time, and optimize performance.

Download: Oracle Database 11g PL/SQL Programming

Publisher	McGraw-Hill/Osborne
ISBN	0071494456
Release Date	21 March 2008

Perl by Example (4th Edition)

Perl by Example, Fourth Edition, is the easiest, most hands-on way to learn Perl. Legendary Silicon Valley programming instructor Ellie Quigley has thoroughly updated her classic to deliver the skills and information today’s Perl users need most–including all-new coverage of MySQL database programming and a Perl QuickStart designed to get experienced users up and running fast. 

Quigley illuminates every technique with focused, classroom-tested code examples, detailed line-by-line explanations, and real program output. This exceptionally clear, easy-to-understand book takes you from your first Perl script to database-driven applications. It’s the only Perl book you’ll ever need!

Download: Perl by Example (4th Edition)

Publisher	Prentice Hall
ISBN	0132381826
Release Date	15 November 2007

Beginning PHP and MySQL E-Commerce, Second Edition

 

Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition covers every step of the design and building process involved in creating powerful, extendable e–commerce web sites. Based around a real–world example involving a web site selling t–shirts, you’ll learn how to create and manage a product catalog, build and integrate a shopping cart, and process customer accounts and PayPal/credit card transactions.
With the e–commerce framework in place, authors Emilian Balanescu and Cristian Darie show you how to integrate advanced features sure to set your web site apart from the competition. You’ll learn how to expand your catalog using Amazon Web Services, optimize the web site for the search engines, and take advantage of Ajax to build an even more user–friendly shopping cart.

Download: Beginning PHP and MySQL E-Commerce, Second Edition

Publisher	Apress
Author(s)	Cristian Darie
ISBN	1590598644
Release Date	15 February 2008

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, packages, and triggers; and overall program performance.
This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.

Download: Oracle PL/SQL Best Practices

Publisher	O'Reilly
Author(s)	Steven Feuerstein
ISBN	0596514107
Release Date	22 October 2007

SQL Server 2005 Bible

This comprehensive tutorial and reference shows readers how to increase productivity and write stored procedures using the language with which they're most familiar
Includes revised content covering new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server
Guides readers through developing SQL Server databases, developing data connections, administering SQL Server, and keeping databases performing at their peak through performance tuning and optimization
Presents dozens of specific examples in both a graphical format and as SQL code and includes numerousbest practices describing the most effective way to accomplish a given task
Companion Web site provides all of the code examples found in the book

Download: SQL Server 2005 Bible

Publisher	John Wiley and Sons
Author(s)	Paul Nielsen
ISBN	0764542567
Release Date	06 November 2006