[yogeshrm_2000]

Beginning PL/SQL
- From Novice to Professional




Description
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features.

Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule &emdash; cover whats most needed and used by PL/SQL professionals and avoid whats not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.

* Discover the 20% of PL/SQL that gives you 80% of the bangkey topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.
* Learn how to write production-level, object-oriented PL/SQLyoull explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQLs object-oriented features as well.
* Work through real examples of using of PL/SQLyoull learn PL/SQL by applying it to real-world business problems, not by heavy theory.

What youll learn
* How important SQL is in PL/SQL
* How to use PL/SQL in both a relational and object-relational setting
* How to create maintainable, modular, and reusable PL/SQL program units
* The importance of testing as you go, and of building a permanent test plan for each module
* The importance of building debugging capabilities into your code and building a permanent debug facility for each module
* The importance of documenting as you go, and in the process building a permanent documentation set for your reusable modules
* How to apply modular PL/SQL to solve real-world problems

Who is this book for?
Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
About the Apress Beginning Series

The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!

About the Author
Donald Bales is a computer applications consultant specializing in the analysis, design, and programming of client-server and web-based distributed systems, systems integration, and data warehousing. Don has over 20 years' experience with Oracle as both a developer and a database administrator, and 10 years' experience with Java. He is currently working on the migration of medical and industrial hygiene systems to a web environment for a major oil company. When he is not developing applications, Donald can often be found working with horses, playing the piano, or playing the bagpipes. Donald has had several careers, and has at various times been a mechanic, a general contractor, Mr. Mom, a developer, and currently a consultant. He has a bachelor of science degree in business from Elmhurst College in Elmhurst, Illinois. Don currently resides in Downers Grove, Illinois, with his wife Diane and his daughter Kristyn.

Download Link:

http://rapidshare.com/files/263711541/plsql.rar

[yogeshrm_2000]

Dissecting SQL Server Execution Plans




Execution plans show you what�s going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including which indexes are getting used and where no indexes are being used at all; how the data is being retrieved, and joined, from the tables defined in your query; how aggregations in GROUP BY queries are put together and the anticipated load, and the estimated cost, that all these operations place upon the system. All this information makes the execution plan a vitally important tool in the tool belt of database administrator, database developers, report writers, developers, and pretty much anyone who writes TSQL to access data in a SQL Server database. The goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject, right from the basics of capturing plans, through their interpretation, and then onto how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common performance issues, and more.

Download Link:

http://rapidshare.com/files/26223112..._hvanhtuan.rar

[yogeshrm_2000]

Two Minute SQL Server Stumpers Vol.5




Whether you're practicing for an exam or interview or just wanting to see who�s got the biggest SQL Server brain in your office, this book is perfect.

Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge.

If you spend enough time in SQL Server to answer the questions in this book then you'd benefit from the SQL Toolbelt.

The SQL Toolbelt allows developers and DBAs to gain access to all the SQL Sever tools we currently produce. This means that when you are working with SQL Server databases, you can have the most powerful set of tools immediately to hand.

Download Link:

http://rapidshare.com/files/26222461..._hvanhtuan.rar

[yogeshrm_2000]

SQL Bible



# Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2
# Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platforms
# Covers growing use of SQL with Web services and XML

by Alex Kriegel, Boris M. Trukhnov
Paperback: 831 pages
Language: English
Format: CHM

Download Link:

http://rapidshare.com/files/13436745/b0312.rar.html

[yogeshrm_2000]

Learning SQL Server 2008 Reporting Services





536 pages
A step-by-step guide to getting the most of Microsoft SQL Server Reporting Services 2008
Everything you need to create and deliver data-rich reports with SQL Server 2008 Reporting Services as quickly as possible
Packed with hands-on-examples to learn and improve your skills
Connect and report from databases, spreadsheets, XML Data, and more
No experience of SQL Server Reporting Services required.
Microsoft SQL Server Reporting Services 2008 is the third generation Microsoft reporting software that is more tightly integrated with SQL Server 2008 than ever before. It provides a complete server-based platform that is designed to support a wide variety of reporting needs, including managed enterprise reporting, special purpose reporting, embedded reporting, and web-based reporting.
Ideal for beginners who need to create reports as quickly as possible, this book will lead you through practical examples to teach you a full range of skills for reporting with SQL Server 2008 Reporting Services. A series of carefully picked exercises help you practice the most important aspects of report creation. By the end of the book, you will have the confidence to take on the most complex of reports, and be producing reports that will make you the envy of your organization.

What you will learn from this book?
Install SQL Server 2008 and configure the SQL Server Reporting Services
Learn the various components and tools that enable end-to-end support for all reporting activities
Use the report viewer control to get started with the essentials of retrieving and displaying data
Create a Report Model using the Visual Studio 2008 Template
Learn to modify reports on a report server and create linked files with report manager
Embed Microsoft Report Viewer Controls in web and Windows applications
Create interactive reports with charts and gauges using Report Builder
Create several kinds of reports with Report Builder 2.0
Create server reports and report models and deploy them
Get the full details of available programming interfaces and their usage
Learn to work with Crystal Reports 2008
Import reports created using MS Access
Learn how to use the Programming API, convert Report file types, use command-line utilities and more

Filename: Learning.SQL.rar
Filesize: 14 MB

Download-Link:

http://rapidshare.com/files/275393037/Learning.SQL.rar

[dbilla]

Thanks Again

[yogeshrm_2000]

Originally Posted by dbilla

Thanks Again

Thanks for comment friend!!!

[vickydcrazy]

Hi Yogesh,
Could you please upload the ebook: Sybex Guide for Microsoft SQL Server Certification 70-432?

This will be a great help. Thank you.

Vicky

[yogeshrm_2000]

SQL Visual QuickStart Guide 2nd Edition

Publisher: Peachpit Press Publications | ISBN: 0321334175 | edition 2005 | CHM | 480 pages | 9,16 mb

As dynamic, database-driven Web sites become the standard, more and more nonprogrammers just like yourself are being forced to work with database information and create and edit database objects. With SQL and this task-based guide to it, you can do it too--no programming experience required!
After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily launches into the tasks that will get you comfortable with SQL fast. In addition to explaining SQL basics, this updated reference covers the ANSI SQL:2003 standard and contains a wealth of brand-new information, including a new chapter on set operations and common tasks, well-placed optimization tips to make your queries run fast, sidebars on advanced topics, and added IBM DB2 coverage.

http://rapidshare.com/files/10919489...ion__2006_.chm