SQL Cookbook (Cookbooks

Edition: 1
Release: 2005-12-23
Publisher: O'Reilly Media
Binding: Paperback
ISBN/ASIN: 0596009763



SQL Cookbook (Cookbooks (O'Reilly))

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. Free download SQL Cookbook (Cookbooks books collection in PDF, EPUB, FB2, MOBI, and TXT formats. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. Best deals ebooks download SQL Cookbook (Cookbooks on amazon. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out

Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

Bucketization, and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way. SQL Cookbook (Cookbooks (O'Reilly)) with free ebook downloads available via rapidshare, mediafire, 4shared, and hotfile.

Download SQL Cookbook (Cookbooks

Cisco IOS Cookbook (Cookbooks Pdf

Edition: Second Edition
Release: 2006-12-29
Publisher: O'Reilly Media
Binding: Paperback
ISBN/ASIN: 0596527225



Cisco IOS Cookbook (Cookbooks (O'Reilly))

Never has something cried out for a cookbook quite as much as Cisco's Internetwork Operating System (IOS). Free download Cisco IOS Cookbook (Cookbooks books collection in PDF, EPUB, FB2, MOBI, and TXT formats. IOS is powerful and flexible, but also confusing and daunting. Most tasks can be accomplished in several different ways. And you don't want to spend precious time figuring out which way is best when you're trying to solve a problem quickly. That's what this cookbook is for. Best deals ebooks download Cisco IOS Cookbook (Cookbooks on amazon. Fortunately, most router configuration tasks can be broken down into several more or less independent steps: you configure an interface, you configure a routing protocol, you set up backup links, you implement packet filters and other access control mechanisms. What you really need is a set of recipes that show you how to perform the most common tasks, so you can quickly come up with a good configuration for your site. And you need to know that these solutions work: you don't want to find yourself implementing a backup link at 2 A.M. because your main link is down and the backup link you set up when you installed the router wasn't quite right.

Thoroughly revised and expanded, Cisco IOS Cookbook, 2nd Edition, adds sections on MPLS, Security, IPv6, and IP Mobility, and presents solutions to the most common configuration problems, including:Configuring interfaces of many types, from serial to ATM and Frame Relay Configuring all of the common IP routing protocols (RIP, EIGRP, OSPF, and BGP) Configuring authentication Configuring other services, including DHCP and NTP Setting up backup links, and using HSRP to configure backup routers Managing the router, including SNMP and other solutions Using access lists to control the traffic through the router

If you work with Cisco routers, you need a book like this to help you solve problems quickly and effectively. Even if you're experienced, the solutions and extensive explanations will give you new ideas and insights into router configuration. And if you're not experienced--if you've just been given responsibility for managing a network with Cisco routers--this book could be a job-saver. Cisco IOS Cookbook (Cookbooks (O'Reilly)) with free ebook downloads available via rapidshare, mediafire, 4shared, and hotfile.

Download Cisco IOS Cookbook (Cookbooks