Book Video Training: Database

Showing posts with label Database. Show all posts

Friday, August 7, 2009

Oracle Databases on the Web

Covers how to set up database systems to drive commercial Web and intranet sites. Provides the insight of two experienced Oracle database administrators. Presents need-to-know information in an easy-to-read format with clear examples and illustrations. Provides an understanding of the World Wide Web and details on Web security. Details database design, including performance and tuning.

About the Author
Donald Burleson (Raleigh, NC) has been a database administrator for over 15 years and has designed numerous data warehouse systems with Oracle. He is the author of several books about Oracle, including High Performance Oracle Database Applications and Oracle Databases on the Web, and over 30 articles in magazines such as DBMS, Oracle Magazine, and Computerworld.

Robert Papaj (Rochester, NY) has 18 years of information systems experience in database administration across numerous DBMSs. Robert is an Oracle Master in database administration, technical support, application development, and application center consulting. Donald K. Burleson (Raleigh, NC) specializes in database technology and distributed database systems. He is an Adjunct Professor of Information Systems, the author of two other books on databases, and a writer for several national publications such as Computerworld, Database Programming & Design, and Oracle Technical Journal.
http://uploading.com/files/7NAS38JX/Orl.rar.html

http://rapidshare.com/files/264604747/Orl.rar

Wednesday, August 5, 2009

The Definitive Guide to SQLite

The Definitive Guide to SQLite
by Mike Owens | 464 pages | PDF | Apress| ISBN: 1590596730 | May 25, 2006 | 6 MB

Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.

http://uploading.com/files/7URTXD6S/The_Definitive_Guide_to_SQLite_Definitiv...zip.html
http://rapidshare.com/files/263902049/The_Definitive_Guide_to_SQLite_Definitive_Guide.1590596730.zip

Saturday, August 1, 2009

2780B Maintaining a Microsoft SQL Server 2005 Database

http://i269.photobucket.com/albums/jj44/downarchive2/keosoft/home_top_left.jpg

About this Course

Elements of this syllabus are subject to change.

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

Audience Profile

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for maintaining a database.

At Course Completion

After completing this course, students will be able to:

Install and configure SQL Server 2005.
Manage database files.
Backup and restore databases.
Manage security.
Monitor SQL Server.
Transfer data into and out of SQL Server.
Automate administrative tasks.
Replicate data between SQL Server instances.
Maintain high availability.

2779B Implementing a Microsoft SQL Server2005 Database

About this Course

Elements of this syllabus are subject to change.

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

Audience Profile

This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

At Course Completion

After completing this course, students will be able to:

Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2005.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
Implement data integrity in Microsoft SQL Server 2005 by using triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Use Notification Services to generate and send notifications.

D0wn10ad

http://www.easy-share.com/1905141979/ebook_Udovice2779B.part1.rar
http://www.easy-share.com/1905141926/ebook_Udovice2779B.part2.rar
http://hotfile.com/dl/2327639/0fdab77/ebook_Udovice2779B.part1.rar.html
http://hotfile.com/dl/2327681/e7427cc/ebook_Udovice2779B.part2.rar.html
http://rapidshare.com/files/231868341/ebook_Udovice2779B.part1.rar
http://rapidshare.com/files/231866911/ebook_Udovice2779B.part2.rar
http://www.enterupload.com/ais3qsv828ia/ebook_Udovice2779B.part2.rar.html

Dissecting SQL Server Execution Plans

Dissecting SQL Server Execution Plans
Simple Talk Publishing (April 28, 2008) | ISBN: N\a | 252 pages | PDF | 3 MB

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including which indexes are getting used and where no indexes are being used at all; how the data is being retrieved, and joined, from the tables defined in your query; how aggregations in GROUP BY queries are put together and the anticipated load, and the estimated cost, that all these operations place upon the system. All this information makes the execution plan a vitally important tool in the tool belt of database administrator, database developers, report writers, developers, and pretty much anyone who writes TSQL to access data in a SQL Server database. The goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject, right from the basics of capturing plans, through their interpretation, and then onto how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common performance issues, and more.

DOWNLOAD

http://uploading.com/files/6C2CBUHK/Dissecting_SQL_Server_Execution_Plans.rar.html

http://rapidshare.com/files/262378214/Dissecting_SQL_Server_Execution_Plans.rar

Two Minute SQL Server StumpersVol. 5

Two Minute SQL Server StumpersVol. 5
Red gate books | 2009 | ISBN: n\a | 207 pages | PDF | 2 MB

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.

DOWNLOAD

http://uploading.com/files/XWC6WNAM/SSC_Stumper_Vol_5.rar.html

http://rapidshare.com/files/262378196/SSC_Stumper_Vol_5.rar

Oracle Applications DBA Field Guide

Product Description

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 quick-to-navigate format.

Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you’re an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Applications Release 12 and Fusion.

download

Friday, July 31, 2009

Beginning Database Design Solutions

Product Description
This book is intended for IT professionals and students who want to learn how to design, analyze, and understand databases. The material will benefit those who want a better high-level understanding of databases such as proposal managers, architects, project managers, and even customers. The material will also benefit those who will actually design, build, and work with databases such as database designers, database administrators, and programmers. In many projects, these roles overlap so the same person may be responsible for working on the proposal, managing part of the project, and designing and creating the database.

This book is aimed at IT professionals and students of all experience levels. It does not assume that you have any previous experience with databases or programs that use them. It doesn’t even assume that you have experience with computers. All you really need is a willingness and desire to learn.

This book explains database design. It tells how to plan a database’s structure so the database will be robust, resistant to errors, and flexible enough to accommodate a reasonable amount of future change. It explains how to discover database requirements, build data models to study data needs, and refine those models to improve the database’s effectiveness.

The book solidifies these concepts by working through a detailed example that designs a realistic database. Later chapters explain how to actually build databases using two common database products: Access 2007 and MySQL.

The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security.

This book explains database design. It tells how to determine what should go in a database and how the database should be structured to give the best results.

This book does not focus on actually creating the database. The details of database construction are different for different database tools so, to remain as generally as useful as possible, this book doesn’t concentrate on any particular database system. You can apply the techniques described here equally to whatever database tool you use whether it’s Access, SQL Server, Oracle, MySQL, or some other database product.

Most database products include free editions that you can use for smaller projects. For example, SQL Server Express Edition, Oracle Express Edition, and MySQL Community Server are all free.

To remain database neutral, the book does not assume you are using a particular database so you don’t need any particular software or hardware. To work through the Exercises, all you really need is a pencil and some paper. You are welcome to type solutions into your computer if you like but you may actually find working with pencil and paper easier than using a graphical design tool to draw pictures, at least until you are comfortable with database design and are ready to pick a computerized design tool.

“Goals of Effective Database Design,” explains the reasons why people and organizations use databases. It explains a database’s purpose and conditions that it must satisfy to be useful. This also describes the basic ACID (Atomicity, Consistency, Isolation, Durability) and CRUD (Create, Read, Update, Delete) features that any good database should have. It explains in high-level general terms what makes a good database and what makes a bad database.
“Database Types,” explains some of the different types of databases that you might decide to use. These include flat files, spreadsheets, hierarchical databases (XML), object databases, and relational databases. The relational database is one of the most powerful and most commonly used forms of database so it is the focus of this book, but it is important to realize that there are alternatives that may be more appropriate under certain circumstances. This gives some tips on deciding which kind of database might be best for a particular project.
“Relational Database Fundamentals,” explains basic relational database concepts such as tables, rows, and columns. It explains the common usage of relational database terms in addition to the more technical terms that are sometimes used by database theorists. It describes different kinds of constraints that databases use to guarantee that the data is stored safely and consistently.
“Understanding User Needs,” explains how to learn about the users’ needs and gather user requirements. It tells how to study the users’ current operations, existing databases (if any), and desired improvements. It describes common questions that you can ask to learn about users’ operations, desires, and needs, and how to build the results into requirements documents and specifications. This explains what use cases are and tells how to use them and the requirements to guide database design and to measure success.
“Translating User Needs into Data Models,” introduces data modeling. It explains how to translate the user’s conceptual model and the requirements into other more precise models that define the database design rigorously. This describes several database modeling techniques including user-interface models, semantic object models, entity-relationship diagrams, and relational models.
“Extracting Business Rules,” explains how a database can handle business rules. It explains what business rules are, how they differ from database structure requirements, and how you can identify business rules. This explains the benefits of separating business rules from the database structure and tells how achieve that separation.
“Normalizing Data,” explains one of the biggest tools in database design: normalization. Normalization techniques allow you to restructure a database to increase its flexibility and make it more robust. This explains the various forms of normalization, emphasizing the stages that are most common and important: first, second, and third normal forms (1NF, 2NF, and 3NF). It explains how each of these kinds of normalization helps prevent errors and tells why it is sometimes better to leave a database slightly less normalized to improve performance.
“Designing Databases to Support Software Applications,” explains how databases fit into the larger context of application design and lifecycle. This explains how later development depends on the underlying database design. It discusses multi-tier architectures that can help decouple the application and database design so there can be at least some changes to either without requiring changes to the other.
“Common Design Patterns,” explains some common patterns that are useful in many applications. Some of these techniques include implementing various kinds of relationships among objects, storing hierarchical and network data, recording temporal data, and logging and locking.
“Common Design Pitfalls,” explains some common design mistakes that occur in database development. It describes problems that can arise from insufficient planning, incorrect normalization, and obsession with ID fields and performance.
“User Needs and Requirements,” walks through the steps required to analyze the users’ problem, define requirements, and create use cases. It describes interviews with fictitious customers that are used to identify the application’s needs and translate them into database requirements.
“Building a Data Model,” translates the requirements gathered in the previous into a series of data models that precisely define the database’s structure. This builds user-interface models, entity-relationship diagrams, semantic object models, and relational models to refine the database’s initial design. The final relational models match the structure of a relational database fairly closely so they are easy to implement.
“Extracting Business Rules,” identifies the business rules embedded in the relational model. It shows how to extract those rules in order to separate them logically from the database’s structure. This makes the database more robust in the face of future changes to the business rules.
“Normalization and Refinement,” refines the relational model by normalizing it. It walks through several versions of the database that are in different normal forms. It then selects the degree of normalization that provides a reasonable tradeoff between robust design and acceptable performance.
“Microsoft Access,” explains how to build a database with Microsoft Access 2007. This explains enough to get started and to use Access to build non-trivial databases. You can use other versions of Access to work through this, although the locations of menus, buttons, and other Access features are different in different versions.
“MySQL,” explains how to build a database with MySQL. This tells where to download a free version of MySQL. It explains how to use the MySQL Command Line Client as well as some useful graphical tools including MySQL Query Browser and MySQL Workbench.
“Introduction to SQL,” provides an introduction to SQL (Structured Query Language). It explains how to use SQL commands to add, insert, update, and delete data. By using SQL, you can help insulate a program from the idiosyncrasies of the particular database product that it uses to store data.
“Building Databases with SQL Scripts,” explains how to use SQL scripts to build a database. It explains the advantages of this technique, such as the ability to create scripts to initialize a database before performing tests. It also explains some of the restrictions on this method, such as the fact that the user must create and de…

Download

Oracle VM Manager 2.1.2

Product Description

Manage a Flexible and Elastic Data Center with Oracle VM Manager

Learn quickly to install Oracle VM Manager and Oracle VM Servers
Learn to manage your Virtual Data Center using Oracle VM Manager

Import VMs from the Web, template, repositories, and other VM formats such as VMware
Learn powerful Xen Hypervisor utilities such as xm, xentop, and virsh
A practical hands-on book with step-by-step instructions

Download

Oracle PL/SQL: Expert Techniques For Developers and Database Administrators

Product Description
Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You’ll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to OLAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, such as data structure management, error management, data management, application management, and transaction management. It covers the practical “how-to” techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards that can’t be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

Download

Mastering Oracle Scheduler in Oracle 11g Databases

Product Description

Schedule, manage, and execute jobs that automate your business processes.

Automate jobs from within the Oracle database with the built-in Scheduler.
Boost database performance by managing, monitoring, and controlling jobs more effectively.
Contains easy-to-understand explanations, simple examples, debugging tips, and real-life scenarios.

download

Wednesday, July 29, 2009

Oracle 10g RAC Grid, Services & Clustering

Product Description
Grid architecture is Oracle’s strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the distribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC.

Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes network configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

* Focuses on implementing, testing and tuning features of Real Application Clusters (RAC) database
version 10g Release 2
* Provides extensive coverage of usage, day-to-day functions and operations
* Includes tips and techniques such as script samples
to illustrate various features of RAC
* A jumpstart into all the key features of 10g R2 RAC

download

Oracle Performance Tuning for 10gR2, Second Edition

Product Description
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.

Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.

* Fully updated for version 10gR2 and provides all necessary transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective

download

Oracle 10g Data Warehousing

Book Description
New edition of successful book with Oracle employees and consultants as authors.

download

Tuesday, July 28, 2009

Learning jQuery 1.3

Learning jQuery 1.3
Packt Publishing (February 13, 2009) | ISBN: 1847196705 | 444 pages | PDF | 10 MB

To build interesting, interactive sites, developers are turning to JavaScript libraries such as jQuery to automate common tasks and simplify complicated ones. Because many web developers have more experience with HTML and CSS than with JavaScript, the library’s design lends itself to a quick start for designers with little programming experience. Experienced programmers will also be aided by its conceptual consistency.

Revised and updated for version 1.3 of jQuery, this book teaches you the basics of jQuery for adding interactions and animations to your pages. Even if previous attempts at writing JavaScript have left you baffled, this book will guide you past the pitfalls associated with AJAX, events, effects, and advanced JavaScript language features.

In this book, the authors share their knowledge, experience, and enthusiasm about jQuery to help you get the most from the library and to make your web applications shine. The book introduces jQuery and shows how you can write a functioning jQuery program in just three lines of code. It then guides you through CSS selectors and shows how to enhance the basic event handling mechanisms to give them a more elegant syntax. You will then learn to add impact to your actions through a set of simple visual effects and also to create, copy, reassemble, and embellish content using jQuery’s DOM modification methods. You will also learn to send and retrieve information with AJAX methods. The book will then step you through many detailed, real-world examples and even equip you to extend the jQuery library itself with your own plug-ins.

Better Interaction Design and Web Development with Simple JavaScript Techniques

* An introduction to jQuery that requires minimal programming experience
* Detailed solutions to specific client-side problems
* For web designers to create interactive elements for their designs
* For developers to create the best user interface for their web applications
* Packed with great examples, code, and clear explanations
* Revised and updated version of the first book to help you learn jQuery

What you will learn from this book?

This book will give you the tools you need to be on the cutting edge of the web development community. With these techniques at your disposal, you can:

* Use selectors to get anything you want from a page
* Make things happen on your page with events
* Add flair to your actions with animation effects
* Change your page on command with DOM manipulation
* Use AJAX to get the most out of server-side code
* Transform drab, static information containers into beautiful, dynamic tables
* Breathe new life into online forms
* Create dynamic shufflers, rotators, and galleries
* Get started with official jQuery plug-ins
* Customize by writing your own jQuery plug-ins

Approach

This book begins with a tutorial to jQuery, followed by an examination of common, real-world client-side problems, and solutions to each of them making it an invaluable resource for answers to all your jQuery questions.

Who this book is written for?

This book is for web designers who want to create interactive elements for their designs, and for developers who want to create the best user interface for their web applications. Basic JavaScript programming knowledge is required. You will need to know the basics of HTML and CSS, and should be comfortable with the syntax of JavaScript. No knowledge of jQuery is assumed, nor is experience with any other JavaScript libraries required.
Product Details

Download

http://rapidshare.com/files/260819691/jQ1.3.rar

Oracle Database 11g The Complete Reference

Product Description

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 Clusters

download

Readings in Database Systems, 4th Edition

Product Description
Lessons from database research have been applied in academic fields ranging from bioinformatics to next-generation Internet architecture and in industrial uses including Web-based e-commerce and search engines. The core ideas in the field have become increasingly influential. This text provides both students and professionals with a grounding in database research and a technical context for understanding recent innovations in the field. The readings included treat the most important issues in the database area—the basic material for any DBMS professional.

This fourth edition has been substantially updated and revised, with 21 of the 48 papers new to the edition, four of them published for the first time. Many of the sections have been newly organized, and each section includes a new or substantially revised introduction that discusses the context, motivation, and controversies in a particular area, placing it in the broader perspective of database research. Two introductory articles, never before published, provide an organized, current introduction to basic knowledge of the field; one discusses the history of data models and query languages and the other offers an architectural overview of a database system. The remaining articles range from the classical literature on database research to treatments of current hot topics, including a paper on search engine architecture and a paper on application servers, both written expressly for this edition. The result is a collection of papers that are seminal and also accessible to a reader who has a basic familiarity with database systems.

download

Saturday, July 25, 2009

Beginning Database Design Solutions

The book finishes by describing some of the topics you need to understand to keep a database running effectively such as database maintenance and security.

This book explains database design. It tells how to determine what should go in a database and how the database should be structured to give the best results.

Most database products include free editions that you can use for smaller projects. For example, SQL Server Express Edition, Oracle Express Edition, and MySQL Community Server are all free.

“Goals of Effective Database Design,” explains the reasons why people and organizations use databases. It explains a database’s purpose and conditions that it must satisfy to be useful. This also describes the basic ACID (Atomicity, Consistency, Isolation, Durability) and CRUD (Create, Read, Update, Delete) features that any good database should have. It explains in high-level general terms what makes a good database and what makes a bad database.
“Database Types,” explains some of the different types of databases that you might decide to use. These include flat files, spreadsheets, hierarchical databases (XML), object databases, and relational databases. The relational database is one of the most powerful and most commonly used forms of database so it is the focus of this book, but it is important to realize that there are alternatives that may be more appropriate under certain circumstances. This gives some tips on deciding which kind of database might be best for a particular project.
“Relational Database Fundamentals,” explains basic relational database concepts such as tables, rows, and columns. It explains the common usage of relational database terms in addition to the more technical terms that are sometimes used by database theorists. It describes different kinds of constraints that databases use to guarantee that the data is stored safely and consistently.
“Understanding User Needs,” explains how to learn about the users’ needs and gather user requirements. It tells how to study the users’ current operations, existing databases (if any), and desired improvements. It describes common questions that you can ask to learn about users’ operations, desires, and needs, and how to build the results into requirements documents and specifications. This explains what use cases are and tells how to use them and the requirements to guide database design and to measure success.
“Translating User Needs into Data Models,” introduces data modeling. It explains how to translate the user’s conceptual model and the requirements into other more precise models that define the database design rigorously. This describes several database modeling techniques including user-interface models, semantic object models, entity-relationship diagrams, and relational models.
“Extracting Business Rules,” explains how a database can handle business rules. It explains what business rules are, how they differ from database structure requirements, and how you can identify business rules. This explains the benefits of separating business rules from the database structure and tells how achieve that separation.
“Normalizing Data,” explains one of the biggest tools in database design: normalization. Normalization techniques allow you to restructure a database to increase its flexibility and make it more robust. This explains the various forms of normalization, emphasizing the stages that are most common and important: first, second, and third normal forms (1NF, 2NF, and 3NF). It explains how each of these kinds of normalization helps prevent errors and tells why it is sometimes better to leave a database slightly less normalized to improve performance.
“Designing Databases to Support Software Applications,” explains how databases fit into the larger context of application design and lifecycle. This explains how later development depends on the underlying database design. It discusses multi-tier architectures that can help decouple the application and database design so there can be at least some changes to either without requiring changes to the other.
“Common Design Patterns,” explains some common patterns that are useful in many applications. Some of these techniques include implementing various kinds of relationships among objects, storing hierarchical and network data, recording temporal data, and logging and locking.
“Common Design Pitfalls,” explains some common design mistakes that occur in database development. It describes problems that can arise from insufficient planning, incorrect normalization, and obsession with ID fields and performance.
“User Needs and Requirements,” walks through the steps required to analyze the users’ problem, define requirements, and create use cases. It describes interviews with fictitious customers that are used to identify the application’s needs and translate them into database requirements.
“Building a Data Model,” translates the requirements gathered in the previous into a series of data models that precisely define the database’s structure. This builds user-interface models, entity-relationship diagrams, semantic object models, and relational models to refine the database’s initial design. The final relational models match the structure of a relational database fairly closely so they are easy to implement.
“Extracting Business Rules,” identifies the business rules embedded in the relational model. It shows how to extract those rules in order to separate them logically from the database’s structure. This makes the database more robust in the face of future changes to the business rules.
“Normalization and Refinement,” refines the relational model by normalizing it. It walks through several versions of the database that are in different normal forms. It then selects the degree of normalization that provides a reasonable tradeoff between robust design and acceptable performance.
“Microsoft Access,” explains how to build a database with Microsoft Access 2007. This explains enough to get started and to use Access to build non-trivial databases. You can use other versions of Access to work through this, although the locations of menus, buttons, and other Access features are different in different versions.
“MySQL,” explains how to build a database with MySQL. This tells where to download a free version of MySQL. It explains how to use the MySQL Command Line Client as well as some useful graphical tools including MySQL Query Browser and MySQL Workbench.
“Introduction to SQL,” provides an introduction to SQL (Structured Query Language). It explains how to use SQL commands to add, insert, update, and delete data. By using SQL, you can help insulate a program from the idiosyncrasies of the particular database product that it uses to store data.
“Building Databases with SQL Scripts,” explains how to use SQL scripts to build a database. It explains the advantages of this technique, such as the ability to create scripts to initialize a database before performing tests. It also explains some of the restrictions on this method, such as the fact that the user must create and de…

download

Thursday, July 23, 2009

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Marco Russo, Alberto Ferrari, Chris Webb, "Expert Cube Development with Microsoft SQL Server 2008 Analysis Services"
Packt Publishing | 2009-07-15 | ISBN: 1847197221 | 360 pages | PDF | 5 MB

Design and implement fast, scalable and maintainable cubes

# A real-world guide to designing cubes with Analysis Services 2008
# Model dimensions and measure groups in BI Development Studio
# Implement security, drill-through, and MDX calculations
# Learn how to deploy, monitor, and performance-tune your cube
# Filled with best practices and useful hints and tips

In DetailMicrosoft's SQL Server Analysis Services 2008 is an OLAP server that allows users to analyze business data quickly and easily. However, designing cubes in Analysis Services can be a complex task: it's all too easy to make mistakes early on in development that lead to serious problems when the cube is in production. Learning the best practices for cube design before you start your project will help you avoid these problems and ensure that your project is a success.

This book offers practical advice on how to go about designing and building fast, scalable, and maintainable cubes that will meet your users' requirements and help make your Business Intelligence project a success.

This book gives readers insight into the best practices for designing and building Microsoft Analysis Services 2008 cubes. It also provides details about server architecture, performance tuning, security, and administration of an Analysis Services solution.

In this book, you will learn how to design and implement Analysis Services cubes. Starting from designing a data mart for Analysis Services, through the creation of dimensions and measure groups, to putting the cube into production, we'll explore the whole of the development lifecycle.

This book is an invaluable guide for anyone who is planning to use Microsoft Analysis Services 2008 in a Business Intelligence project.

What you will learn from this book?

# Build a data mart suitable for use with Analysis Services
# Create and configure an Analysis Services project in Business Intelligence Development Studio
# Use the Dimension Wizard and the Dimension Editor to build dimensions
# Create measure groups and associate them with dimensions
# Add calculations to the cube, including implementing currency conversion and a date tool dimension
# Explore the security model, including dimension security and cell security, and implement dynamic security
# Tune queries to get the best possible performance
# Automate processing and partition creation
# Monitor your cube to see who's actually using it

Approach

This is a practical tutorial for Analysis Services that shows readers how to solve problems commonly encountered while designing cubes, and explains which features of Analysis Services work well and which should be avoided. The book walks through the whole cube development lifecycle, from building dimensions, cubes and calculations to tuning and moving the cube into production.

Who this book is written for?

This book is aimed at Analysis Services developers who already have some experience but who want to go into more detail on advanced topics, and who want to learn best practices for cube design.

Enjoy this great book! Brought to you by SMIRK

http://uploading.com/files/8GSCXVFP/1847197221.rar.html

http://rapidshare.com/files/259157338/1847197221.rar

Wednesday, July 22, 2009

Oracle Database 10g: The complete Reference

Oracle Database 10g - The Complete Reference

Oracle documentation is thoroughgoing and voluminous, currently spanning multiple CDs.
Oracle Database 10g: The complete Reference is the first entity that has gathered all the major Oracle
definitions, commands, functions, features and products together in a single, massive core
reference - one volume that every Oracle user and developer can keep handy on his or her desk,
The audience for this book will usually fall into one of three categories:
* An Oracle end user
* A developer who is new to Oracle
* An experienced Oracle developer

D0wn10ad

Mirr0r