Search

Showing posts with label SQL. Show all posts
Showing posts with label SQL. Show all posts

Tuesday, July 28, 2009

Practical Guide to Using SQL in Oracle


 Practical Guide to Using SQL in Oracle

Practical Guide to Using SQL in Oracle

Product Description
Structured Query Language has become the standard for generating, manipulating, and retrieving database information. The dramatic increase in the popularity of relational databases, coupled with Oracle s having the largest market share, has created a demand for programmers who can write SQL code correctly and efficiently. This book provides a systematic approach to learning SQL in Oracle. Each chapter is written in a step-by-step manner and includes examples that can be run using Oracle. Using the sample tables and data provided, readers will be able to perform the examples to gain hands-on experience with Oracle programming.

Click Following Button to download!!!


Continue Reading...!

SQL Performance Tuning-Submitted by jokhio-07CS24


SQL Performance Tuning

Peter Gulutzan, Trudy Pelzer, «SQL Performance Tuning»
Addison Wesley | ISBN: 0201791692 | 2002 | PDF | 352 pages | 2.38 MB



SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization’s critically important data. Covering today’s most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.

Click Following Button to download!!!

Continue Reading...!

SQL for Dummies-Submitted by Jokhio07CS24

SQL for Dummies
By Allen G. Taylor
432 pages
Publisher: For Dummies; 5 edition (August 8, 2003)
ISBN-10: 0764540750
ISBN-13: 978-0764540752

Product Description
Many database management system (DBMS) tools run on a variety of hardware platforms. The differences among the tools can be many, but all serious products have one thing in common: They support data access and manipulation in SQL, the industry-standard language specifically designed to enable people to create and manage databases. If you know SQL, you can build relational databases and get useful information out of them.

Relational database management systems are vital to many organizations. People often think that creating and maintaining these systems are extremely complex activities – the domain of database gurus who possess enlightenment beyond that of ordinary mortals. Well, SQL For Dummies, 5th Edition, sweeps away the database mystique.

Written in easy-to-understand terms and updated with the latest information on SQL, this handy reference shows you step-by-step how to make your database designs a reality using SQL:2003. But you don't have to be a database newbie to find value in SQL For Dummies, 5th Edition; even if you have some experience designing and creating databases, you may discover a few things you didn't know about.
Click Following Button to download!!!


Continue Reading...!

Monday, July 27, 2009

Programming SQL Server 2005 O'rielly Media-Submnitted by Jokhio 07CS24

Programming SQL Server 2005

Book Description
SQL Server 2005, Microsoft’s next-generation data management and analysis solution, represents a huge leap forward. It comes with a myriad of changes that deliver increased security, scalability, and power–making it the complete data package. Used properly, SQL Server 2005 can help organizations of all sizes meet their data challenges head on.

Programming SQL Server 2005 from O’Reilly provides a practical look at this updated version of Microsoft’s premier database product. It guides you through all the new features, explaining how they work and how to use them. The first half of the book examines the changes and new features of the SQL Server Engine itself. The second addresses the enhanced features and tools of the platform, including the new services blended into this popular version. Each chapter contains numerous code samples-written in C# and compiled using the Visual Studio 2005 development environment-that show you exactly how to program SQL Server 2005.

Programming SQL Server 2005 can help you:

  • Build, deploy, and manage enterprise applications that are more secure, scalable, and reliable
  • Maximize IT productivity by reducing the complexity of building, deploying, and managing database applications
  • Share data across multiple platforms, applications, and devices to make it easier to connect internal and external systems

Because the goal of Programming SQL Server 2005 is to introduce all facets of Programming SQL Server 2005, it’s beneficial to programmers of all levels. The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts.

Any IT professional who wants to learn about SQL Server 2005’s comprehensive feature set, interoperability with existing systems, and automation of routine tasks will find the answers in this authoritative guide.

Click Following Button to download!!!
Continue Reading...!

Thursday, February 26, 2009

Sams Teach Your Self SQL in 21 Days


Paperback: 864 pages
Publisher: Sams 2nd edition (October 25, 2002)
Language: English
ISBN-10: 0672324512
ISBN-13: 978-0672324512
Product Dimensions: 9.1 x 7.3 x 2 inches

Product Description: -

Sams Teach Yourself SQL in 21 Days, Fourth Edition provides a sold foundation in understanding the fundamentals of SQL (Structured Query Language). SQL is the query language used by relational databases such a Oracle, Microsoft Access, and Microsoft SQL Server. The new edition covers object-oriented programming with SQL, ODBC, JDBC, embedded SQL, accessing remote databases, and constructs. All new examples based on an open source database such as MySQL enhance this new edition by making the examples readily useable for readers.



From the Publisher
Fully updated and revised to include coverage of PL/SQL and Transact SQL. this easy-to-understand guide teaches users everything they need to know from database concepts and processes to implementing security and constructing and optimizing queries. - Q&A sections, step-by-step instructions, and review sections make learning easy and fun

- Shows how to create tables, modify data, incorporate security features, and tune the database for optimum performance

- Emphasizes common database concepts, including SQL functions and queries --This text refers to an out of print or unavailable edition of this title.

Continue Reading...!

Sunday, February 22, 2009

SQL-A Practical Introduction


Author:Akeel I Din
Publisher: Black Well
Language: English
Paperback: 179 pages
Format: PDF
Description:
A very good book every SQL basics is clearly explained... Download to read it now... Be first to download...
Click Here to download
Continue Reading...!