|
#1
14th August 2009
|
|||||
|
|||||
SQL SPECIAL
HI! friends... posting some SQL Books...
FRIENDS...YOU ARE INVITED TO POST BOOKS ON SQL... COME ON... COME TOGETHER AND SHARE... ENJOY... Last edited by yogeshrm_2000 : 15th August 2009 at 12:02 AM. 
|
|
#2
14th August 2009
|
|||||
|
|||||
|
XML and SQL Developing Web Applications
 Paperback: 256 pages Publisher: Addison-Wesley Professional (December 16, 2001) Language: English ISBN-10: 0201657961 ISBN-13: 978-0201657968 Format: PDF XML and SQL: Developing Web Applications is a guide for Web developers and database programmers interested in building robust XML applications backed by SQL databases. It makes it easier than ever for Web developers to create and manage scalable database applications optimized for the Internet. The author offers an understanding of the many advantages of both XML and SQL and provides practical information and techniques for utilizing the best of both systems. The book explores the stages of application development step by step, featuring a real-world perspective and many examples of when and how each technology is most effective. Specific topics covered include: * Project definition for a data-oriented application * Creating a bullet-proof data model * DTDs (document type definitions) and the design of XML documents * When to use XML, and what parts of your data should remain purely relational * Related standards, such as XSLT and XML Schema * How to use the XML support incorporated into Microsoft's SQL Server™ 2000 * The XML-specific features of J2EE™ (Java™ 2 Enterprise Edition) Throughout this book, numerous concrete examples illustrate how to use each of these powerful technologies to circumvent the other's limitations. If you want to use the best part of XML and SQL to create robust, data-centric systems then there is no better resource than this book. Download Link: password : usawarez.org Last edited by yogeshrm_2000 : 14th August 2009 at 11:15 PM.
|
|
#3
14th August 2009
|
|||||
|
|||||
|
Oracle PL/SQL Language Pocket Reference, Second Edition
Oracle PL/SQL Language Pocket Reference, Second Edition
 Publisher: O'Reilly | ISBN: 0596004729 | edition 2003 | CHM | 128 pages | 1 mb The new edition of this must-have pocket guide boils down the most vital information from Oracle PL/SQL Programming, the bestseller that many consider "the Bible" for PL/SQL development. Indispensable for new and seasoned Oracle database developers alike, this pocket guide summarizes features available in Oracle's powerful new product-- Oracle9i --and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java classes from PL/SQL. O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you've reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you'll want to have. Download:
|
|
#4
14th August 2009
|
|||||
|
|||||
|
Sybex Mastering SQL Server 2008
Sybex Mastering SQL Server 2008
 As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support�the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection. Download : Pass : Mumbhai.org Last edited by yogeshrm_2000 : 14th August 2009 at 11:24 PM.
|
|
#5
14th August 2009
|
|||||
|
|||||
 Repped !
|
|
#6
14th August 2009
|
|||||
|
|||||
|
Data Analysis Using SQL and Excel
Data Analysis Using SQL and Excel
 Wiley | 645 Pages | 2007 | ISBN:0470099518 | PDF | 10,60 MB Three key efforts are essential to effectively transform data into actionable information: retrieving data with SQL, presenting data with Excel, and understanding statistics as the foundation of data analysis. Data mining expert Gordon Linoff focuses on these topics and shows you how SQL and Excel can be used to extract business information from relational databases. He begins by taking a look at how data is central to the task of understanding customers, products, and markets, and he then goes on to show you how to use that data to define business dimensions, store transactions about customers, and summarize important data to produce results. Along the way, he shares stories based on his personal experience in the field, intended to enrich your understanding of why some things work�and others don't. download:
|
|
#7
14th August 2009
|
|||||
|
|||||
|
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
 Design and implement fast, scalable and maintainable cubes A real-world guide to designing cubes with Analysis Services 2008 Model dimensions and measure groups in BI Development Studio Implement security, drill-through, and MDX calculations Learn how to deploy, monitor, and performance-tune your cube Filled with best practices and useful hints and tips In Detail Microsoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success. This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success. This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution. In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle. This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project. What you will learn from this book? Build a data mart suitable for use with Analysis Services Create and configure an Analysis Services project in Business Intelligence Development Studio Use the Dimension Wizard and the Dimension Editor to build dimensions Create measure groups and associate them with dimensions Add calculations to the cube, including implementing currency conversion and a date tool dimension Explore the security model, including dimension security and cell security, and implement dynamic security Tune queries to get the best possible performance Automate processing and partition creation Monitor your cube to see who's actually using it Approach This is a practical tutorial for Analysis Services that shows readers how to solve problems commonly encountered while designing cubes, and explains which features of Analysis Services work well and which should be avoided. The book walks through the whole cube development lifecycle, from building dimensions, cubes and calculations to tuning and moving the cube into production. Who this book is written for? This book is aimed at Analysis Services developers who already have some experience but who want to go into more detail on advanced topics, and who want to learn best practices for cube design. About the Author Alberto Ferrari Alberto Ferrari is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to BI development and he works as a trainer for software houses that need to design complex BI solutions.He co-authored the "SqlBI Methodology", which can be found on the SqlBI site. Chris Webb Chris Webb has been working with Microsoft Business Intelligence tools for almost ten years in a variety of roles and industries. He is an independent consultant and trainer based in the UK, specializing in Microsoft SQL Server Analysis Services and the MDX query language. He is the co-author of "MDX Solutions for Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", is a regular speaker at conferences, and blogs on BI at cwebbbi.spaces.live.com. He is a recipient of Microsoft's Most Valuable Professional award for his work in the SQL Server community. Marco Russo Marco Russo is a consultant and trainer in software development based in Italy, focusing on development for Microsoft Windows operating systems. He's involved in several Business Intelligence projects, including those of relational and multidimensional warehouse design, with particular experience in sectors like banking and financial services, manufacturing and commercial distribution. He previously wrote several books about .NET and recently co-authored "Introducing Microsoft LINQ" and "Programming Microsoft LINQ", both published by Microsoft Press. He also wrote "The many-to-many revolution", a mini-book about many-to-many dimension relationships in Analysis Services, and co-authored the "SQLBI Methodology" with Alberto Ferrari. Marco is a founder of SQLBI (sqlbi.com) and his blog is available at sqlblog.com/blogs/marco_russo Alberto Ferrari Alberto Ferrari is a consultant and trainer for the BI development area with the Microsoft suite for Business Intelligence. His main interests are in the methodological approaches to BI development and he works as a trainer for software houses that need to design complex BI solutions.He co-authored the "SqlBI Methodology", which can be found on the SqlBI site. Chris Webb Chris Webb has been working with Microsoft Business Intelligence tools for almost ten years in a variety of roles and industries. He is an independent consultant and trainer based in the UK, specializing in Microsoft SQL Server Analysis Services and the MDX query language. He is the co-author of "MDX Solutions for Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase", is a regular speaker at conferences, and blogs on BI at cwebbbi.spaces.live.com. He is a recipient of Microsoft's Most Valuable Professional award for his work in the SQL Server community. Marco Russo Marco Russo is a consultant and trainer in software development based in Italy, focusing on development for Microsoft Windows operating systems. He's involved in several Business Intelligence projects, including those of relational and multidimensional warehouse design, with particular experience in sectors like banking and financial services, manufacturing and commercial distribution. He previously wrote several books about .NET and recently co-authored "Introducing Microsoft LINQ" and "Programming Microsoft LINQ", both published by Microsoft Press. He also wrote "The many-to-many revolution", a mini-book about many-to-many dimension relationships in Analysis Services, and co-authored the "SQLBI Methodology" with Alberto Ferrari. Marco is a founder of SQLBI (sqlbi.com) and his blog is available at sqlblog.com/blogs/marco_russo Product Details Paperback: 360 pages Publisher: Packt Publishing (July 15, 2009) Language: English ISBN-10: 1847197221 ISBN-13: 978-1847197221 Filesize: 5 MB Download-Link:
|
|
#8
14th August 2009
|
|||||
|
|||||
|
Learning Oracle PL-SQL, O'Reilly
Learning Oracle PL-SQL, O'Reilly
 5.12 Mb PL/SQL, Oracle's programming language for stored procedures, delivers a world of possibilities for your database programs. PL/SQL supplements the standard relational database language, SQL, with a wide range of procedural features, including loops, IF-THEN statements, advanced data structures, and rich transactional control--all closely integrated with the Oracle database server. Knowing where to start with Oracle's procedural language is not always obvious to a newcomer, especially considering the language's feature set and the sheer size of the official documentation (not to mention Oracle's ever-increasing number of pre-built PL/SQL programs). But "Learning Oracle PL/SQL" offers the signposts and guidance you need to come up to speed on the language, delivered in a manageable number of pages while covering all the essentials. Topics include: PL/SQL--what is it, and why use it? Why use PL/SQL instead of Java? Syntax and examples of all core language constructs Creating, using, and reusing stored procedures, functions, and packages Building web-based applications using PL/SQL features available "out of the box" (such as PL/SQL Server Pages) Securing PL/SQL programs against attack Benefits of third-party developer tools and integrated development environments Connecting PL/SQL to email, Java, and the Internet Meticulously crafted with all-new examples downloadable from examples.oreilly.com/learnoracle, the book addresses language features available in all versions of Oracle, from Oracle7 to Oracle8i to Oracle9i. "Learning Oracle PL/SQL" was written by PL/SQL experts Bill Pribyl and Steven Feuerstein, whose easy-to-read style and attention todetail has made other O'Reilly books (such as the bestselling "Oracle PL/SQL Programming") very popular among Oracle developers worldwide. "Learning Oracle PL/SQL" is meant for a wide range of target audiences, including both beginning programmers and those already experienced with other programming languages. Whether you are a new developer, a crossover programmer from another database system, or a new database administrator who needs to learn PL/SQL, this book will get you well on your way. It is the perfect introduction to "Oracle PL/SQL Programming," also by Pribyl and Feuerstein. download:
|
|
#9
14th August 2009
|
|||||
|
|||||
|
Accelerated SQL Server 2008
Accelerated SQL Server 2008
 Accelerated SQL Server 2008 | Pages 816 | PDF | Size 11232 KB Accelerated SQL Server 2008 The expert tuition and approach to rapid learning in Accelerated SQL Server 2008, one of the first SQL Server 2008 books available, will enable SQL Server and other database professionals to make the leap to the latest release of Microsoft’s flagship database management system quickly. Take full advantage of the new features of SQL Server 2008, know what tools are available, and quickly realize the power and ease of use that SQL Server 2008 has to offer. Lightning–quick introduction to SQL Server 2008 Written by top experts in the field Provides a solid grounding in key features and technologies What you’ll learn Manage SQL Server installations through the brand–new Declarative Management Framework. Protect yourself from downtime with high–availability features such as failover clustering. Speed your applications by taking advantage of new performance–enhancement features in SQL Server 2008. Find what you need using full–text search. Store, retrieve, and manage XML in the database. Derive competitive advantage from business intelligence tools such as Analysis Services and Reporting Services. Who is this book for? Database professionals who need to make the leap to SQL Server 2008, and who need to make that leap quickly. This audience primarily includes users of previous releases of SQL Server such as SQL Server 2000 and SQL Server 2005. The audience also includes database professionals with experience on competing platforms who are moving laterally to SQL Server. download :
|
|
#10
14th August 2009
|
|||||
|
|||||
|
Beginning Microsoft SQL Server 2008 Programming
Beginning Microsoft SQL Server 2008 Programming
(Wrox Programmer to Programmer)  Product Description > This comprehensive introduction to SQL Server begins with an overview of database design basics and the SQL query language along with an in�depth look at SQL Server itself > Progresses on to a clear explanation of how to implement fundamental concepts with the new 2008 version of SQL Server > Discusses creating and changing tables, managing keys, writing scripts, working with stored procedures, programming with XML, using SQL Server Reporting and Integration Services, and more > Features updated and new material, including new examples using Microsoft's AdventureWorks sample database From the Back Cover Starting simply and gradually progressing to increasingly advanced topics, this introduction to the SQL Server database focuses on what is distinctive about the SQL environment�SQL Server 2008, in particular�versus other programming environments. Author Robert Vieira draws on his experience as one of the leading authorities on Microsoft SQL Server and uses his unique tutorial approach to explain the significant changes to the fundamental core components of SQL Server 2008. You'll begin with an overview of database design concepts and learn how to implement these fundamental concepts with Microsoft SQL Server 2008. Then, you'll take a look at the role of an RDBMS (relational database management system) and where it fits in the grand scheme of system development. Thorough coverage of the key additions and changes to the 2008 version of SQL Server include discussions on DATE and TIME datatypes, hierarchyID datatypes, MERGE and multiple inserts, recursive queries, and more. With this book, you will conquer the many changes and challenges of Microsoft SQL Server 2008. What you will learn from this book > How RDBMSs store, manage, and retrieve data > Ways to create and alter tables > Various �forms� of database normalization > Techniques for writing scripts and working with stored procedures > The positives and negatives of indexes > Myriad consequences that locks and deadlocks have on system performance > An understanding of triggers and how they are used Who this book is for This book is for developers who are looking for a complete introduction to database design concepts and learning SQL. A basic understanding of development fundamentals is helpful. Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved. Filesize: 5 MB Download-Link: Quote:
Last edited by yogeshrm_2000 : 14th August 2009 at 11:43 PM.
|
|
| Thread Tools | |
|
|
|
All times are GMT +5.5. The time now is 03:16 AM. |
MMS Collection
or do rep 
or atleast rate the thread 
