Лекции курса Oracle 10g DBA 1

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

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future performance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

Become your own database guru and master the art and craft of SQL(structured query language)to access, manage, and manipulate data in a variety of relational database software programs. Get the inside tour of the major components of SQL with a copy of SQL For Dummies, 3rd Edition, by programming pro Allen Taylor. Whether you're seeking a friendly summary of basic SQL commands and statements -- or you're looking for advanced advice on database security, error handling, nested queries, ODBC, and dynamic SQL -- you'll find what you need in this book's easy-to-follow steps and examples, all written in clear, concise language.

A practical, step-by-step approach to making sense out of data

Making Sense of Data educates readers on the steps and issues that need to be considered in order to successfully complete a data analysis or data mining project. The author provides clear explanations that guide the reader to make timely and accurate decisions from data in almost every field of study. A step-by-step approach aids professionals in carefully analyzing data and implementing results, leading to the development of smarter business decisions. With a comprehensive collection of methods from both data analysis and data mining disciplines, this book successfully describes the issues that need to be considered, the steps that need to be taken, and appropriately treats technical topics to accomplish effective decision making from data.

Досконально осмотрено внедрение языка Transact-SQL для администрирования и манипуляции данными СУБД Microsoft SQL Server. Материал сопровождается великим количеством практических образцов, написанных творцом. Уделено внимание вопросцам внедрения Transact-SQL при общем использовании 1С и Microsoft SQL Server. На прилагаемом к книжке компакт-диске размешены образцы запросов, тестовая база данных, а также доборная документация и статьи творца, посвященные базам данных. Диск к книжке 34 Мб.

Whether you're practicing for an exam or interview or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect.

Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge.

If you spend enough time in SQL Server to answer the questions in this book then you'd benefit from the SQL Toolbelt.

The SQL Toolbelt allows developers and DBAs to gain access to all the SQL Sever tools we currently produce. This means that when you are working with SQL Server databases, you can have the most powerful set of tools immediately to hand.

A cutting-edge response to Ralph Kimball’s challenge to the data warehouse community that answers some tough questions about the effectiveness of the relational approach to data warehousing
•Written by one of the best-known exponents of the Bill Inmon approach to data warehousing
•Addresses head-on the tough issues raised by Kimball and explains how to choose the best modeling technique for solving common data warehouse design problems
•Weighs the pros and cons of relational vs. dimensional modeling techniques
•Focuses on tough modeling problems, including creating and maintaining keys and modeling calendars, hierarchies, transactions, and data quality

Written by renowned experts on both Oracle Essbase and Oracle OLAP, this exclusive Oracle Press guide explains the unique features and benefits of these powerful online analytic processing products. Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution provides the details you need to architect the OLAP solution that meets your requirements. Proven techniques for building robust applications and tuning and maintaining your OLAP environment are included in this authoritative resource. Real-world case studies illustrate the material presented.

* Learn OLAP concepts and history
* Understand OLAP as a key component of any business intelligence architecture
* Design and build Oracle OLAP analytic workspaces
* Plan and create Oracle Essbase databases
* Generate reports from Oracle OLAP, Oracle Essbase, Oracle Business Intelligence Enterprise Edition, and other tools
* Accelerate and enhance data warehouses with Oracle OLAP
* Use Oracle Essbase with performance management applications, including Oracle Hyperion Planning, Oracle Hyperion Profitability and Cost Management, Oracle Crystal Ball, and Oracle Smart Space
* Develop custom applications using Java APIs
* Configure, optimize, tune, and maintain Oracle Essbase and Oracle OLAP

A short guide for everyone on how to structure your data and set-up your MySQL database tables efficiently and easily.

* How best to collect, name, group, and structure your data
* Design your data with future growth in mind
* Practical examples from initial ideas to final designs
* The quickest way to learn how to design good data structures for MySQL
* From the author of Mastering phpMyAdmin

Разработка и использование баз данных используя СУБД PostgreSQL под операционной системой Windows

All-in-One is All You Need

Get complete coverage of all three Microsoft Certified IT Professional database developer exams for SQL Server 2005 in this comprehensive volume. Written by a SQL Server expert and MCITP, this definitive exam guide features learning objectives at the beginning of each chapter, exam tips, practice questions, and in-depth explanations. Detailed and authoritative, the book serves as both a complete certification study guide and an essential on-the-job reference.

Get full details on all exam topics including how to:

* Install and configure SQL Server 2005
* Manage database design
* Use Transact-SQL and XML
* Work with functions, triggers, and CLR integration
* Optimize, monitor, and secure databases
* Create stored procedures
* Handle disaster recovery
* Work with Service Broker, Web Services, and MARS
* Use SQL Server Reporting Services and Notification Services
* Manage locks, deadlocks, and cursors
* Transfer data using Replication and SQL Server Integration Services