Скачать книги бесплатно

Подготовка к сертификационным испытаниям с помощью официальных материалов издательства Oracle Press. В каждой из глав вы найдете подробное изложение экзаменационных материалов, а также практические вопросы и итоги главы, особо выделяющие главное из того, что вы узнали. Этот материал является наиболее полным и исчерпывающим из имеющихся на рынке учебников для подготовки к экзаменам на OCA.

Изложены теоретические основы проектирования баз данных и методология их практического применения в процессах принятия решений при управлении производством и бизнесом.
Для студентов средних профессиональных учебных заведений.

«Менеджер обмена данными» создан для обеспечения информационного обмена внутри предприятия и между партнёрами. Он поддерживает единство внешних и внутренних потоков информации и в то же время позволяет вести постоянный отбор и фильтрацию перемещаемых данных.
Современное предприятие - сложная структура. Её элементы - подразделения различного предназначения, удалённые офисы и филиалы - сами по себе представляют собой многоуровневые системы управления и взаимодействия. Координация работы всех служб в режиме максимальной согласованности и эффективности - острейшая проблема менеджмента.
Оперативное и целесообразное реагирование на изменение коммерческой ситуации, своевременное согласование действий с учётом интересов всех участников логистической цепи, уменьшение неоправданных простоев и расходов на местах стыка в цепи сотрудничества - всё это обеспечивается оптимальным движением информационных потоков.
Автоматизированное решение обозначенных проблем обеспечивает «Менеджер обмена данными».

The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

* Install Oracle Database 11g or upgrade from an earlier version
*Create database tables, sequences, indexes, views, and user accounts
*Construct SQL statements, procedures, queries, and subqueries
*Optimize security using virtual private databases and transparent data encryption
*Import and export data using SQL*Loader and Oracle Data Pump
*Use SQL replay, change management, and result caching
*Avoid human errors using flashback and automatic undo management
*Build and tune PL/SQL triggers, functions, and packages
*Develop database applications using Java, JDBC, and XML
*Optimize availability and scalability with Oracle Real Application Cluste

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It’s easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers arent left out, however. Those who choose to can go deep and leverage the full power and flexibility of Oracles database engine.

Getting started with APEX is easy. Learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the “hood” of APEX and expose the full power behind its easy–to–use GUI interface. They show you what you need to know to produce powerful, professionally polished applications, things such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are well–qualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hard–core APEX developer. His coauthor, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their fulltime careers on developing APEX applications. Pro Oracle APEX is your opportunity to learn APEX from the very best.

SQL Server reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.

Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

What you will learn from this book
* Details of programming reports and report scripting
* Advanced report design, including drill-down reports, nested lists, drill-through, links and dynamic content
* High-level strategies for business and support systems
* Rendering reports using .NET code, .NET 10 namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
* How to design reports for mobile services
* Various tools used to define data sources and semantic metadata models
* How to use parameters and expressions to define creative report solutions
* Advanced object-oriented programming techniques, with examples in C# and VB 2005.

Product Description
Microsoft SQL Server 2005 Unleashed offers comprehensive coverage of SQL Server 2005 that goes beyond the basic syntax and information you’ll find in the product manuals, providing in-depth information derived from the authors’ real-world experience to help you build upon your working knowledge of the product and take your experience and knowledge to a higher level. This book focuses primarily on the information needed by system and database administrators, as well as for users with overlapping duties as both DBA and developer. Included is extensive coverage of the new features and upgraded tools and capabilities of SQL Server 2005, including .NET Framework integration, Integration Services, Service Broker, Database Mirroring and Snapshots, and Reporting Services.



Detailed information on…

* Installing, upgrading, and administering SQL Server 2005
* Database maintenance, backup, and recovery
* Creating and managing tables, views, stored procedures, triggers, and user-defined functions
* Database and index design
* SQL Server query optimization, and performance monitoring and tuning
* Transactions, transaction management, and distributed transactions
* SQL Server Management Studio—NEW!
* SQL Server Notification Services; Integration Services—NEW!; Analysis Services; Reporting Services—NEW!; Web Services—NEW!
* SQL Server Service Broker—NEW!
* SQL Server and Microsoft .NET Framework integration, including CLR-based stored procedures, functions, and triggers—NEW!
* SQL Server high availability and SQL Server clustering and replication
* Database Mirroring—NEW!
* Database Snapshots—NEW!
* Using XML in SQL Server 2005
* SQL Server tools and utilities

Product Description
Get the practical, pocket-sized guide for IT professionals who need to administer, maintain, and optimize SQL Server 2008. Written by award-winning author William Stanek, this portable reference delivers essential details for using SQL Server 2008 to help protect and manage your company s data whether automating tasks, creating indexes and views, performing backups and recovery, replicating transactions, tuning performance, managing server activity, importing and exporting data, or performing other key tasks. Featuring quick-reference tables, lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field!
Key Book Benefits
Provides fast facts and immediate reference for administering SQL Server 2008 Delivers must-know details for taking advantage of the improved scalability, security features, and management tools in SQL Server 2008 Features concise tables, easy-to-scan lists, and step-by-step instructions for fast answers, wherever you need them

Product Description
Written by industry professionals who have been working with SQL Server 2008 since the earliest code, this reference expertly covers the programming fundamentals for SQL Server 2008 with crucial real-world context and extensive code samples.

Get the hands-on programming instruction, practical examples, and best practices you need to master the core programmability features in SQL Server 2008. Led by three experts in database design and business intelligence solutions, you ll learn the essential tools and techniques for developing robust applications. Discover how to:
-Program views, stored applications, triggers, and functions using T-SQL
-Work with the new data types, LINQ, and the ADO.NET Entity Framework
-Automate common administration and maintenance tasks
-Debug databases, reports, and objects using Microsoft Visual Studio® 2008
-Write transactional code and implement local and distributed transactions
-Use business intelligence tools, such as SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services

Many of the book s examples, exercises, and code samples are available for download from the companion Web site.

The 283 page book is titled Mastering SQL Server Profiler, and as you can guess from the title, the focus is on learning how to use SQL Server Profiler. Not only does it cover the basics, it includes a discussion of every Profiler event and data column that can be collected, and in addition, shows you how to apply it to your day-to-day work as a DBA or developer.

The book covers these topics:

* Getting Started with Profiler
* Working with Traces and Templates
* Profiler GUI Tips and Tricks
* How to Identify Slow Running Queries
* How to Identify and Troubleshoot SQL Server Problems
* Using Profiler to Audit Database Activity
* Using Profiler with the Database Engine Tuning Advisor
* Correlating Profiler with Performance Monitor
* How to Capture Profiler Traces Programmatically
* Profiler Best Practices
* Profiler Events and Data Column Explained