|
| |
|
EBooks » Database
 Relational databases are tricky beasts. Other kinds of commercial software are infinitely easier to understand. Word processors are really just high-tech typewriters, and it's pretty clear that the backspace key beats that little jar of white stuff cold. Spreadsheets present a familiar enough paradigm, even to non-accountants, and email is close enough to the postal system for the model to be comprehensible. Databases are different. Other kinds of software have a real-world analogy. Sometimes, as in the Windows desktop, the analogy is a little tenuous, but the analogies are close enough; you can get there from here. But relational databases are completely artificial. They're like geometry: They can be used to build models of the real world, but they don't exist in the real world. When was the last time you poured some wine for you and your sweetie and went out on the front porch to watch the geometry frolic on the lake? Now, I'm talking about databases here, not tables. Tables exist aplenty, from the telephone book to the dictionary. But relational databases? Nope. Uh-uh. You're not going to find them frolicking on the lake, either. The card files at the library, which contain author, title, and subject files, come close to being a database but they're still separate sets of data that are only correlated by the good graces of the local librarian.  MySQL is the world`s most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It`s also surprisingly rich in features. If you`re a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn`t such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MySQL`s capabilities quickly and easily AppDev Microsoft SQL Server 2000
 These are the remaining CD's of a training series consisting of 14 CD's, for more info, please visit:
hxxp://www.appdev.com/prodfamily.asp?catalog%5Fname=AppDevCatalog&category%5Fname=SQ00Product
Please use WinZip 10 to unzip these files. I used WinZip 10 to zip/split .RAR files which have inside them ISO images... it's very compress and light weight for you ALL to download...
For all my uploads to rapidshare, please visit:
http://rapidshare.de/users/2G5BFK
You need WinZip 10 to open these files, it's there in my public folder... Paperback: 624 pages Publisher: Wrox (May 7, 2004) Language: English ISBN: 0764568787 SQL Server Reporting Services is the customizable reporting solution
for report designers and programmers. This hands-on guide will get you
up to speed quickly. You can create powerful reports without
programming knowledge and extend reporting solutions using VB, C#, and
ASP.NET. Packed with detailed examples of building reports, designing
report solutions, and developing deployment strategies for interacting
with various platforms, this book prepares you to take full advantage
of a revolutionary new tool. What you will learn from this book Details
of programming reports and report scripting Advanced report design,
including drill-down reports, nested lists, drill-through, links, and
dynamic content How to manage reports using Report Manager or program
code High-level strategies for business support systems Rendering
reports using .NET code, .NET IO namespace classes, and URL rendering
Deployment strategies to handle hardware, software, and platform
considerations, licensing issues, and scaling options Who this book is
for This book is for developers and report designers using VB, C#, and
ASP.NET who need to tie into SQL Server to build customized reports or
to integrate reports into Windows or Web-based applications. Wrox
Professional guides are planned and written by working programmers to
meet the real-world needs of programmers, developers, and IT
professionals. Focused and relevant, they address the issues technology
professionals face every day. They provide examples, practical
solutions, and expert education in new technologies, all designed to
help programmers do a better job.
Product Details
- Paperback: 628 pages
- Publisher: O'Reilly Media, Inc.; 1 edition (December 16, 2005)
- Language: English
- ISBN: 0596009763
You know the rudiments of the SQL query language, yet you feel you
aren't taking full advantage of SQL's expressive power. 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 FROM WHERE . But there is so much more you can do with the language. 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.
|
| |
|