Your Ad Here
 
Samay Live
 
EBooks » Database


Sams (June 30, 2000)
PDF | 450 pages | 1.2mb(rar)

Writing Stored Procedures for Microsoft SQL Server/by Matt Shepker (Author)
Description
Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures, but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built, you are taught how to determine which logic within an application makes sense to be put into this scheme. Additionally, you're provided with guidance on making stored procedures that are portable across applications.



McGraw-Hill Osborne Media; 4 edition (July 9, 2008)
PDF | 709 pages | English | 4mb(rar)
Microsoft SQL Server 2008 A Beginner's Guide/by Dusan Petkovic (Author)
Description
Get Started on Microsoft SQL Server 2008 in No Time
Learn to use all of the powerful features available in SQL Server 2008 quickly and easily. Microsoft SQL Server 2008: A Beginner's Guide explains the fundamentals of each topic alongside examples and tutorials that walk you through real-world database tasks. Install SQL Server 2008, construct high-performance databases, use powerful Transact-SQL statements, create stored procedures and triggers, and execute simple and complex database queries. Performance tuning, Database Engine security, Business Intelligence, and XML are also covered.     
    * Set up, configure, and maintain SQL Server 2008
    * Build and manage database objects using Transact-SQL statements
    * Create stored procedures and user-defined functions
    * Optimize database performance, availability, and reliability
    * Implement solid security using authentication, encryption, and authorization
    * Automate tasks using SQL Server Agent
    * Create reliable data backups and perform flawless system restores
    * Use all-new SQL Server 2008 Business Intelligence, development, and administration tools
    * Learn in detail the SQL Server XML technology (SQLXML)

Addison-Wesley Professional; 4 edition (September 8, 2008)
PDF | 1224 pages | English | 4mb(rar)
MySQL (4th Edition) (Developer's Library)/by Paul DuBois (Author) Description The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn't "free" about MySQL (the application) is its server's commercial use; all clients and noncommercial server use are free. DuBois's tome isn't free either, but its list price is modest in light of its value and the value of its namesake.

Grant Allen “Beginning DB2: From Novice to Professional"
Apress | 2008-08-11 | ISBN: 159059942X | 544 pages | PDF | 9,95 MB

IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find
A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM
Dozens of examples so that you are never in doubt as to how things work
Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more
Aimed at developers who want a robust database to back their applications
What you’ll learn Install and manage DB2 Express Edition on Linux and Windows. Manage IML data seamlessly using IBM’s pureXML storage engine. Connect DB2 databases to web and desktop applications via languages such as PHP, Ruby, C#, Python, and more. Protect your data with a sound backup and restore strategy. Design and manage database schemas and security within the database. Know when and why to upgrade to more powerful editions of DB2.
Who is this book for?
Application developers, including web application developers, looking for a robust, zero–cost database to back their applications. Database administrators looking to get up to speed quickly with DB2.

 

Christian Antognini “Troubleshooting Oracle Performance"
Apress | 2008-06-23 | ISBN: 1590599179 | 616 pages | PDF | 6,55 MB

What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
Written for developers by an application developer who has learned by doing
Gives a systematic approach to solving database application performance problems
Helps you plan for performance as you would for any other application requirement
What you’ll learn
See how to treat and plan for performance as a basic application requirement.
Identify performance problems using a systematic and repeatable approach.
Configure your query optimizer to meet your application performance goals.
Optimize table accesses, joins, and physical table layout.
Read and recognize inefficient SQL execution plans.
Reduce inefficiencies from too much procedural code.
Who is this book for?
For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications

 
Username:
Password:
 
Sign Up | Lost Password
 
 

Execution time : 0.00808215141296