Sql Cookbook

Author: Anthony Molinaro
Publisher: "O'Reilly Media, Inc."
ISBN: 0596009763
Size: 62.52 MB
Format: PDF, Kindle
View: 7297
Download
A guide to SQL covers such topics as retrieving records, metadata queries, working with strings, data arithmetic, date manipulation, reporting and warehousing, and hierarchical queries.

Mysql Cookbook

Author: Paul DuBois
Publisher: "O'Reilly Media, Inc."
ISBN: 144937414X
Size: 26.90 MB
Format: PDF, ePub, Docs
View: 1362
Download
MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

Learning Sql

Author: Alan Beaulieu
Publisher: "O'Reilly Media, Inc."
ISBN: 059655558X
Size: 26.57 MB
Format: PDF
View: 2123
Download
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 Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Transact Sql Cookbook

Author: Ales Spetic
Publisher: "O'Reilly Media, Inc."
ISBN: 1565927567
Size: 11.46 MB
Format: PDF, ePub, Mobi
View: 1422
Download
This guide contains a wealth of solutions to problems that SQl Server programmers face. The recipes in the book range from those that show how to perform simple tasks to ones that are more complicated.

Transact Sql Programming

Author: Kevin Kline
Publisher: "O'Reilly Media, Inc."
ISBN: 9781565924017
Size: 52.75 MB
Format: PDF, Mobi
View: 1799
Download
Provides detailed information about Transact-SQL programming and shows specific differences between the Microsoft and Sybase versions of the language.

Sql Pocket Guide

Author: Jonathan Gennick
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596554538
Size: 33.50 MB
Format: PDF, ePub, Mobi
View: 4572
Download
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two. Now available in an updated second edition, our very popular SQL Pocket Guide is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The SQL Pocket Guide is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including: Oracle Database 10g, Release 2 (includingthe free Oracle Database 10g Express Edition (XE)) Microsoft SQL Server 2005 MySQL 5 IBM DB2 8.2 PostreSQL 8.1 database

Ado Net 3 5 Cookbook

Author: Bill Hamilton
Publisher: "O'Reilly Media, Inc."
ISBN: 0596101406
Size: 45.32 MB
Format: PDF, ePub
View: 3776
Download
Rather than theory, this text provides easy-to-find coding solutions to real problems, offering clear explanations of how and why the code works, potential pitfalls, and sources of additional information.

Sql Performance Tuning

Author: Peter Gulutzan
Publisher: Addison-Wesley Professional
ISBN: 9780201791693
Size: 63.32 MB
Format: PDF, ePub, Mobi
View: 260
Download
A very practical guide to making databases run faster and better. A poorly performing database application can cost each user time, and have an impact on other applications running on the same computer or the same network. This book will help DBAUs and programmers improve the performance of their databases.

Asp Net 2 0 Cookbook

Author: Michael A Kittel
Publisher: "O'Reilly Media, Inc."
ISBN: 0596518668
Size: 73.89 MB
Format: PDF, Kindle
View: 5639
Download
Completely revised for ASP.NET 2.0, this new edition of the best-selling ASP.NET Cookbook has everything you need to go from beginning to advanced Windows-based web site development using Microsoft's popular Visual Studio 2005 and ASP.NET 2.0 developer tools. Written for the impatient professional, ASP.NET 2.0 Cookbook contains more than 125 recipes for solving common and not-so-common problems you are likely to encounter when building ASP.NET-based web applications. The recipes in this book, which run the gamut from simple coding techniques to more comprehensive development strategies, are presented in the popular Problem-Solution-Discussion format of the O'Reilly Cookbook series. As with the first edition, every solution is coded in both C# and Visual Basic 2005. Among the additions and revisions to this new edition are: Three new chapters, including 25 new recipes for Master and Content pages, Personalization using Profiles and Themes, Custom Web Parts, and more New code for every solution, rewritten to take advantage of features and techniques new to ASP.NET 2.0 and available for download The ASP.NET 2.0 Cookbook continues to provide the most comprehensive coverage you'll find anywhere of: Tabular controls, including the new GridView control Data validation, including the new ASP.NET 2.0 validation controls, as well as techniques for performing your own validation programmatically User and custom controls Error handling, performance tuning, and caching Whether you're new to ASP.NET or an experienced Microsoft developer, with ASP.NET 2.0 Cookbook, deliverance from a long day (or night) at your computer could be just one recipe away.

Ruby Cookbook

Author: Lucas Carlson
Publisher: "O'Reilly Media, Inc."
ISBN: 1449373674
Size: 79.23 MB
Format: PDF
View: 6764
Download
Why spend time on coding problems that others have already solved when you could be making real progress on your Ruby project? This updated cookbook provides more than 350 recipes for solving common problems, on topics ranging from basic data structures, classes, and objects, to web development, distributed programming, and multithreading. Revised for Ruby 2.1, each recipe includes a discussion on why and how the solution works. You’ll find recipes suitable for all skill levels, from Ruby newbies to experts who need an occasional reference. With Ruby Cookbook, you’ll not only save time, but keep your brain percolating with new ideas as well. Recipes cover: Data structures including strings, numbers, date and time, arrays, hashes, files and directories Using Ruby’s code blocks, also known as closures OOP features such as classes, methods, objects, and modules XML and HTML, databases and persistence, and graphics and other formats Web development with Rails and Sinatra Internet services, web services, and distributed programming Software testing, debugging, packaging, and distributing Multitasking, multithreading, and extending Ruby with other languages