Базы данных

A textbook and study guide for new and intermediate Microsoft Access users, this book takes Access developers through the development process step by step. Terms and concepts are explained as they arise and relevant examples are provided to keep users ontrack and to teach them how to the use the appropriate Access features in the same context in which they will use them in their own work. Users are guided through the process of creating a working database from the first step (defining the business problem it is intended to solve) through the last (deploying the application into an organization and providing ongoing support to users). Also included are case studies that provide practical guidelines for situations Access users might find themselves in.

Introduction to SQL and PL/SQL is today's most hands-on and easy-to-understand resource for learning the increasingly important SQL and PL/SQL databases and preparing for the first Oracle certification exam. Two sample databases build on concepts taught in each chapter and allow readers to practice what they learn without having to suffer through a complex and potentially difficult design process.

Prepare for the Oracle Certified Professional Oracle Database 10 g New Features for Administrators exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the upgrade exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. In each chapter, you’ll find examples, practice questions, lab questions, a two-minute drill, and a chapter summary to highlight what you’ve learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCP exam.

Microsoft Access 2002: Microsoft Office Specialist is designed with one thing in mind: preparing you to pass the Microsoft Office Specialist exam. Follow along as you cover a series of Skill Sets specific to the Access 2002 exam. Then test your understanding of each Skill Set by completing the hands-on projects at the end of the book. Target the skills you need to be successful. With this book as your guide, you won't need to study anything extra--it's like getting a peek at the exam before you take it!

Design and deliver insightful and interactive Web-based reports. Transform your company's valuable data into easily shared information with help from this definitive resource. Written by a member of the development team, this hands-on guide covers everything from installation to administration and shows you how to create visually appealing reports with ease and accuracy. You'll get a firm understanding of the entire report-building process by following a case study throughout the course of the book. Learn first-hand how to extract data using Query Builder and master key tools such as the Report Wizard and Report Manager. Leverage the power of Microsoft's most powerful server-based reporting solution to improve business decision-making and facilitate company-wide - even worldwide - communication. Essential Skills for Database Professionals: - Follow steps to prepare for a smooth installation process. - Explore the ins and outs of the SELECT query...

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas: Database design Queries Programming Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the...

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10 g , and free code will be available for download.

This 4 page, laminated, full-color guide is a fantastic resource for anyone who uses Access 97! In a concise user-friendly format, it provides step-by-step instructions, short cuts and tips on how to execute the basic commands of the software. The guide includes instructions on: Opening Access 97, Table Wizard, Definitions, Toolbars, Modifying a Table in Design View, Modifying a Table in Datasheet View, Creating Table Relationships, Working with Forms, Working with Queries, Filtering a Table, Working with Database Objects, Working with Reports, Formatting Reports or Forms, Importing and Exporting a Database, General Printing, Printing Mailing Labels and Keyboard Shortcuts.

В книге рассматривается создание динамических приложений клиент/сервер с помощью PL/SQL. Прекрасно разбирающиеся в Oracle эксперты рассказывают о возможностях PL/SQL, объясняют синтаксис и семантику написания сценариев и полностью детализируют все функциональные возможности PL/SQL в Oracle Database 10g. Вы научитесь писать мощные программы на PL/SQL, взаимодействовать с базами данных Oracle, выполнять сложные вычисления и обрабатывать сбойные ситуации. В дополнение к этому вы получите массу полезных советов и методик программирования от знающих всю подноготную Oracle специалистов и множество реальных примеров от членов мирового сообщества Oracle.

This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value. Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain...

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 205 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 an afford to be without knowledge of the XML feature set. Pro SQL Server 2008 XML delivers on the knowledge that you need to remain competitive in your career. * Shows how to store, query, and manipulate XML documents in SQL Server * Proides step–by–step examples showing best practices and advanced features * Accurately discusses how SQL Server’s XML feature set stacks up against the ISO XML standards