Bestsellers > Books > Databases
|
|
Bestsellers > Books > Databases
|
|
Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET»rank: 241386by: Dejan Sunderic
: :Create and Use Stored Procedures for Optimal Database PerformanceDevelop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers. Essential Skills for Database ProfessionalsGroup and execute T-SQL statements using batches, scripts, ... |
Pro SQL Server 2008 XML (Pro)»rank: 264749by: Michael Coles
: :Knowledge and ability to apply XML are de rigueur in today’s world, and SQL Server developers and administrators are no exception to that rule. Pro SQL Server 2008 XML is your key to unlocking the powerful XML feature set first introduced in SQL Server 2005 and since refined in SQL Server 2008. Author Michael Coles shows how to store XML using SQL Server’s built–in XML data type. Learn to query and manipulate XML data using standard technologies such as XQuery and XSLT. No SQL Server database professional can afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need ... |
||
SQL Fundamentals»rank: 1800829by: John J. Patrick
: :There are plenty of SQL books, but this is the one to buy if you really want to understand how SQL works and how to make it work for you. It emphasizes practical concepts and examples from the two leading SQL implementations: Access on the desktop, and Oracle for the enterprise. Start with the basics: creating simple queries to retrieve information from a single table. Next, move on to more complex queries involving many tables. Key topics include outer joins, process verification and program testing. Each topic is discussed in detail, with practical examples that show how to write queries others can understand and modify; verify the correctness of your ... |
Access Hacks: Tips & Tools for Wrangling Your Data (Hacks)»rank: 350722by: Ken Bluttman
: :As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly. This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level. For Access beginners, it helps them acquire ... |
||
SQL Server 2005 Management and Administration»rank: 514269by: Ross Mistry, Chris Amaris, Alec Minty, Rand Morimoto
: :Microsoft SQL Server 2005 Management and Administration, based on Service Pack 2, addresses the challenges database administrators regularly encounter on SQL Server 2005 by providing detailed guidance in the areas of management, administration, security, and monitoring. With coverage of the new features and functionality of SQL Server 2005 Service Pack 2, this book is designed to be comprehensive, resulting in something for all database administrators—from simple tips to tactical solutions. Microsoft SQL Server 2005 Management and Administration goes far beyond the basic installation and setup information found in many other resources. The book looks at day-to-day administration, best practices, tips, and step-by-step configurations based on real-world examples found in the ... |
Microsoft SQL Server 2005 Integration Services (SQL Server Series)»rank: 101919by: Kirk Haselden
: :All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL). Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option ... |
||
Oracle Tuning Power Scripts: With 100+ High Performance SQL Scripts (Oracl in-Focus)»rank: 155173by: Harry Conway, Mike Ault, Don Burleson
: :Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site. |
FileMaker Pro 8 for Windows & Macintosh (Visual QuickStart Guide)»rank: 107043by: Nolan Hester
: :Need to learn FileMaker Pro fast? Try a Visual QuickStart Guide! If you've recently upgraded to FileMaker Pro 8, teach yourself this powerful database software the quick and easy way! Using pictures rather than lengthy explanations, this Visual QuickStart Guide takes you from working with records and files to creating and designing databases, printing and networking with FileMaker, and Web publishing with FileMaker in no time. Step-by-step tasks show you how to use new features like PDF and Excel makers; fast match, fast send, layout alignment, email merge, and table import tools; and popular features like digital image management to organize digital photos with minimal effort and XML support to ... |
||
Oracle Applications DBA Field Guide (Expert's Voice in Oracle)»rank: 148617by: Paul Jackson, Elke Phelps
: : Administrators and managers as well as more advanced users will find plenty of hard facts for administering Oracle Applications in a work environment, but it's also quite portable and not the weighty tome you'd expect from such a survey. — Midwest Book Review, California Bookwatch Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux serversall in an easy reading and ... |
Access 2002 Desktop Developer's Handbook»rank: 80710by: Paul Litwin, Ken Getz, Mike Gunderloy
: :DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET YOUR ORGANIZATION'S SPECIAL NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Desktop Developer's Handbook offers complete coverage of every aspect of building Access applications for single users and small workgroups. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage includes * Understanding the Access event model * Using VBA class modules * Applying sound database design principles * Using Access SQL * Controlling controls * Using ActiveX Data Objects (ADO) * Designing effective forms and reports * Taking advantage of shared Office programmability * ... |