تبلیغات
Computer Book - مطالب پایگاه داده

Beginning Database Design: From Novice to Professional, 2 edition

نوشته شده در تاریخ : جمعه 3 شهریور 1391   04:31 ب.ظ

نوع مطلب :پایگاه داده ،

  Beginning Database Design: From Novice to Professional, 2 edition
Beginning Database Design: From Novice to Professional, 2 edition By Clare Churcher
2012 | 252 Pages | ISBN: 1430242094 | EPUB + PDF | 10 MB + 14 MBBeginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack.
Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit.

  • Provides solid design principles by which to avoid pitfalls and support changing needs
  • Includes numerous examples of good and bad design decisions and their consequences
  • Shows a modern method for documenting design using the Unified Modeling Language

What you’ll learn

  • Avoid the most common pitfalls in database design.
  • Create clear use cases from project requirements.
  • Design a data model to support the use cases.
  • Apply generalization and specialization appropriately.
  • Secure future flexibility through a normalized design.
  • Ensure integrity through relationships, keys, and constraints.
  • Successfully implement your data model as a relational schema.
Who this book is for
Beginning Database Design, Second Edition is aimed at desktop power users, developers, database administrators, and others who are charged with caring for data and storing it in ways that preserve its meaning and integrity. Desktop users will appreciate the coverage of Excel as a plausible “database” for research systems and lab environments. Developers and database designers will find insight from the clear discussions of design approaches and their pitfalls and benefits. All readers will benefit from learning a modern notation for documenting designs that is based upon the widely used and accepted Universal Modeling Language.


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Database Design، Database،

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

نوشته شده در تاریخ : شنبه 28 مرداد 1391   10:39 ب.ظ

نوع مطلب :پایگاه داده ،

eBook Details:

  • Paperback: 620 pages
  • Publisher: Packt Publishing (July 19, 2012)
  • Language: English
  • ISBN-10: 1849685665
  • ISBN-13: 978-1849685665

eBook Description:

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

  • Get to grips with the OBIEE 11g suite for analyzing and reporting on your business data
  • Immerse yourself in BI upgrading techniques, using Agents and the Action Framework and much more in this book and e-book
  • A practical, from the coalface tutorial, bursting with step by step instructions and real world case studies to help you implement the suite’s powerful analytic capabilities

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial

The Oracle Business Intelligence Enterprise Edition 11g (OBIEE) suite delivers a full range of analytic and reporting capabilities, coupled with powerful user experience for creating reports, dashboards and more with your business data. Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial will have you unleashing that power in no time, helping you to take action and make the right decisions at a glance.

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial provides you with valuable insight and the step-by-step know-how you need to take advantage of everything the Oracle BI suite has to offer you, all utilizing real world case studies for a true implementation in action.

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial takes you on a journey right from inception to a full working OBI 11g System. Using a real-world data walk through you’ll explore topics like architecture, reporting and leveraging Essbase as a data source, as well as building the Oracle BI 11g metadata repository (RPD), and developing reports and dashboards in the new Fusion Middleware interface. This practical implementation guide equips you with from the coalface advice which will help you achieve a successful working application by journey’s end.

What you will learn from this book

  • Run though a full sample upgrade from a 10g repository using the upgrade assistants
  • Discover valuable best practices for designing a reporting database
  • Go further with your dashboard knowledge by implementing changes to standard colors, graphics and messages
  • Demonstrate how Agent options affect report delivery
  • Quickly get up and running with BI Publisher and learn to publish reports with bursting and scheduling
  • Speed up your OBIEE system with performance best practices such as Scale out and Caching
  • Go beyond out of the box solutions and develop great management tools
  • Make your knowledge stick by ending each chapter with a self review and further learning resources

Approach

Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial is a practical, from the coalface tutorial for beginner to intermediate readers. You’ll benefit from plenty of emphasis on the introduction of new features of the suite and go further with step by step instructions from the experts.

Who this book is for

If you are a BI developer or analyst who wants to get practical with your OBIEE 11g knowledge, Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial is for you. You will also find it helpful as a technical administrator, consultant or end user.

You should already have a good command of general BI practices and Oracle database, but no knowledge of Oracle BI 11g is required.


Uploaded Link: Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Oracle Business Intelligence Enterprise Edition 11g: A Hands-On Tutorial، Oracle،

Oracle Database XE 11gR2 Jump Start Guide

نوشته شده در تاریخ : پنجشنبه 26 مرداد 1391   11:37 ب.ظ

نوع مطلب :پایگاه داده ،

eBook Details:

  • Paperback: 146 pages
  • Publisher: Packt Publishing (July 10, 2012)
  • Language: English
  • ISBN-10: 1849686742
  • ISBN-13: 978-1849686747

eBook Description:

Oracle Database XE 11gR2 Jump Start Guide

  • Install and configure Oracle Database XE on Windows and Linux
  • Develop database applications using Oracle Application Express
  • Back up, restore, and tune your database
  • Includes clear step-by-step instructions and examples

Oracle Database XE 11gR2 Jump Start Guide

Oracle Database XE 11gR2 is an excellent beginner-level database and is a great platform to learn database concepts.

Oracle Database XE 11gR2 Jump Start Guide helps you to install, administer, maintain, tune, back up and upgrade your Oracle Database Express Edition. The book also helps you to build custom database applications using Oracle Application Express.

Using this book, you will be able to install Oracle Database XE on Windows/Linux operating system.

This book helps you understand different database editions and it guides you through the installation procedure with the aid of screenshots. You will learn to interact with the database objects. You will gain a solid understanding of stored sub-programs which is followed by an introduction to Oracle Application Express (APEX). Solid database performance tuning strategies are also discussed in this book followed by backup and recovery scenarios.

All in all, Oracle Database XE 11gR2 Jump Start Guide delivers everything that you should know to get started with Oracle Database administration.

What you will learn from this book

  • Install and uninstall Oracle Database XE on Windows and Linux environment
  • Set up local and remote database connections and resize Oracle SGA
  • Install SQL Developer, access table data, modify table data, understand transaction control statements and most commonly used SQL functions
  • Create and manage database objects like tables, indexes, constraints, views, sequences, and synonyms
  • Develop PL/SQL stored subprograms
  • Create rich and responsive applications using Oracle Application Express
  • Understand Oracle logical and physical components such as SGA, PGA, Tablespaces, and Flash Recovery Area
  • Move data between different Oracle Database XE versions
  • Upgrade Oracle Database Express Edition to other Oracle Database Editions
  • Protect and recover your database
  • Tune the database for optimal performance

Approach

This book discusses concepts and tasks through real-world examples. The author uses simple language, screenshots, and a step-by-step approach to get you started with Oracle Database administration.

Who this book is for

If you are a student or beginner who is learning to administer Oracle Database, then this book is for you. This book is designed to cover the problems that novice DBAs particularly struggle with, so no prior knowledge of Oracle database administration is expected.


Uploaded Link: Oracle Database XE 11gR2 Jump Start Guide


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Oracle Database XE 11gR2 Jump Start Guide، Oracle Database، Oracle،

Programming Microsoft SQL Server 2012

نوشته شده در تاریخ : پنجشنبه 26 مرداد 1391   12:07 ق.ظ

eBook Details:

  • Paperback: 816 pages
  • Publisher: Microsoft Press (July 31, 2012)
  • Language: English
  • ISBN-10: 0735658226
  • ISBN-13: 978-0735658226

eBook Description:

Programming Microsoft SQL Server 2012

  • Build and deploy databases using the SQL Server Data Tools IDE
  • Query and manipulate complex data with powerful Transact-SQL enhancements
  • Integrate non-relational features, including native file streaming and geospatial data types
  • Consume data with Microsoft ADO.NET, LINQ, and Entity Framework
  • Deliver data using Windows® Communication Foundation (WCF) Data Services and WCF RIA Services
  • Move your database to the cloud with Windows Azure™ SQL Database
  • Develop Windows Phone cloud applications using SQL Data Sync
  • Use SQL Server BI components, including xVelocity in-memory technologies

Programming Microsoft SQL Server 2012: Your essential guide to key programming features in Microsoft SQL Server 2012

Take your database programming skills to a new level and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

Programming Microsoft SQL Server 2012: Discover how to:

  • Build and deploy databases using the SQL Server Data Tools IDE
  • Query and manipulate complex data with powerful Transact-SQL enhancements
  • Integrate non-relational features, including native file streaming and geospatial data types
  • Consume data with Microsoft ADO.NET, LINQ, and Entity Framework
  • Deliver data using Windows® Communication Foundation (WCF) Data Services and WCF RIA Services
  • Move your database to the cloud with Windows Azure™ SQL Database
  • Develop Windows Phone cloud applications using SQL Data Sync
  • Use SQL Server BI components, including xVelocity in-memory technologies

Programming Microsoft SQL Server 2012: Your essential guide to key programming features in Microsoft SQL Server 2012

Take your database programming skills to a new level and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications.

DownloadUploaded Link: Programming Microsoft SQL Server 2012


نوشته شده توسط:محمد زحمتکش کناری



Beginning Microsoft SQL Server 2012 Programming

نوشته شده در تاریخ : چهارشنبه 17 خرداد 1391   03:00 ب.ظ

نوع مطلب :پایگاه داده ،

eBook Details:

  • Paperback: 864 pages
  • Publisher: Wrox; 1st edition (April 24, 2012)
  • Language: English
  • ISBN-10: 1118102282
  • ISBN-13: 978-1118102282

eBook Description:

Beginning Microsoft SQL Server 2012 Programming

The 2012 release of Microsoft SQL Server changes how you develop applications for SQL Server. With this comprehensive resource, SQL Server authority Robert Vieira presents the fundamentals of database design and SQL concepts, and then shows you how to apply these concepts using the updated SQL Server. Publishing time and date with the 2012 release, Beginning Microsoft SQL Server 2012 Programming begins with a quick overview of database design basics and the SQL query language and then quickly proceeds to show you how to implement the fundamental concepts of Microsoft SQL Server 2012.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: SQL Server 2012،

Oracle Identity and Access Manager 11g for Administrators

نوشته شده در تاریخ : پنجشنبه 14 مهر 1390   11:31 ب.ظ

نوع مطلب :پایگاه داده ،

157765317728 Oracle Identity and Access Manager 11g for Administrators

Book Description

Oracle Identity Management is intended to help organizations quickly and reliably manage information about users on multiple systems and applications. Regulatory Compliance and the desire to expose business applications over the Internet have made Identity and Access management skills particularly desirable in recent times. Oracle Access Manager is a recommended Single Sign-On solution for Fusion Middleware including WebCenter, SOA Suite, Portal, and E-Business Suite; more and more companies are implementing Oracle Access Manager. This book will guide you through the important administrative aspects of Identity Mangement.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: OAM، OIM، oracle، پایگاه داده oracle،

(Oracle PL/SQL by Example (4th Edition

نوشته شده در تاریخ : شنبه 9 مهر 1390   09:17 ب.ظ

 Oracle PL/SQL by Example (4th Edition)
Oracle PL/SQL by Example (4th Edition)
Publisher: Prentice Hall | 2008 | ISBN: 0137144229 | Pages: 768 | PDF | 13,69 MB

This integrated learning solution teaches all the Oracle PL/SQL skills you need, hands-on, through real-world labs, extensive examples, exercises, and projects! Completely updated for Oracle 11g, Oracle PL/SQL by Example, Fourth Edition covers all the fundamentals, from PL/SQL syntax and program control through packages and Oracle 11g’s significantly improved triggers. One step at a time, you’ll walk through every key task, discovering the most important PL/SQL programming techniques on your own. Building on your hands-on learning, the authors share solutions that offer deeper insights and proven best practices. End-of-chapter projects bring together all the techniques you’ve learned, strengthening your understanding through real-world practice.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: oracle، database، پایگاه داده، اوراكل،

Database System Concepts, Sixth Edition

نوشته شده در تاریخ : جمعه 8 مهر 1390   11:04 ب.ظ

نوع مطلب :پایگاه داده ،

 Database System Concepts, Sixth Edition
MG–H | English | 2010 | ISBN: 0073523321 | 1376 pages | PDF | 16 MB

Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 6th edition and is one of the cornerstone texts of database education. It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible.The text is designed for a first course in databases at the junior/senior undergraduate level or the first year graduate level. It also contains additional material that can be used as supplements or as introductory material for an advanced course. Because the authors present concepts as intuitive descriptions, a familiarity with basic  structures,  organization, and a high-level   are the only prerequisites. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Database، مفاهیم سیستم پایگاه داده، كتاب مفاهیم سیستم پایگاه داده، دانلود كتاب مفاهیم سیستم پایگاه داده، پایگاه داده،

Metaclasses and Their Application: Data Model Tailoring and Database Integration

نوشته شده در تاریخ : یکشنبه 27 شهریور 1390   06:21 ب.ظ

نوع مطلب :پایگاه داده ،

 Metaclasses and Their Application: Data Model Tailoring and Database Integration

Publisher: Spr..in..ger 1995 | 210 Pages | ISBN: 3540600639 | PDF | 13 MB

Conventional object-oriented data models are closed: although they allow users to define application-specific classes, they usually come with a fixed set of modelling primitives. This constitutes a major problem, as different application domains, e.g. database integration or multimedia, need special support.

Using an extended metaclass concept, this book provides for the solution of this problem a simple but extendible open object-oriented data model, a so-called RISC model.



ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: database،

(Database Processing: Fundamentals, Design, and Implementation (12th Edition

نوشته شده در تاریخ : یکشنبه 27 شهریور 1390   05:58 ب.ظ

نوع مطلب :پایگاه داده ،

 Database Processing: Fundamentals, Design, and Implementation (12th Edition)

Prentice Hall | ISBN : 0132145375 | July 23, 2011 | 642 pages | PDF | 36MB

Get straight to the point of database processing. Database Processing reflects a new teaching method that gets readers straight to the point with its thorough and modern presentation of database processing fundamentals. The twelfth edition has been thoroughly updated to reflect the latest software


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Database،

AppDev Microsoft SQL Server 2010 For Developers

نوشته شده در تاریخ : پنجشنبه 3 شهریور 1390   04:33 ب.ظ

appdev280607 AppDev Microsoft SQL Server 2010 For Developers

AppDev   2010 For  DVD | 2.2 GB
In this course, you’ll learn about the features that are available in SQL Server,  design and create a database, and build basic queries using Transact-SQL, the language of SQL Server. Then, you’ll learn  build effective views, stored procedures, triggers, and user-defined functions using Transact-SQL. You’ll learn  use the Transact-SQL programminglanguage for error handling and hierarchical queries, dealing with complex data structures and processes,  make your databases more scalable through partitioning, and use .NET languages like Visual C# and Visual Basic to build database objects.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: Developers، sql server،

Pro Oracle Application Express 4

نوشته شده در تاریخ : یکشنبه 23 مرداد 1390   05:38 ب.ظ

نوع مطلب :توسعه وب ،پایگاه داده ،

26511389611 Pro Oracle Application Express 4

Book Description

 Oracle Application Express 4 is your key to mastering one of the most innovative products to come out of Oracle in years. Application Express, termed “APEX” for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: development، Oracle APEX، PL/SQL، sql،

Expert PL/SQL Practices: for Oracle Developers and DBAs

نوشته شده در تاریخ : یکشنبه 23 مرداد 1390   05:37 ب.ظ

نوع مطلب :پایگاه داده ،

2651138966 Expert PL/SQL Practices: for Oracle Developers and DBAs

Book Description

Expert  Practices is a book of collected wisdom on PL/SQL from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of that you write.

The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you  combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: development، oracle، Oracle DBA، PL/SQL،

Oracle Application Express 4 Recipes

نوشته شده در تاریخ : یکشنبه 23 مرداد 1390   05:36 ب.ظ

2651138967 Oracle Application Express 4 Recipes

Book Description

  Express 4 Recipes provides an example-based approach to learning Application Express—the ground-breaking, rapid application  platform included with every Oracle license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction.

The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create  entry screens, visualize  in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy problem/solution format, which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: oracle، Oracle APEX، PL/SQL،

Oracle WebCenter 11g PS3 Administration Cookbook

نوشته شده در تاریخ : شنبه 22 مرداد 1390   06:45 ب.ظ

نوع مطلب :پایگاه داده ،

442390591 Oracle WebCenter 11g PS3 Administration Cookbook

Book Description

 Suite 11g is the modern user experience platform for the enterprise and the Web.  Suite 11g delivers social and collaborative services to help optimize connections between people, information, and applications. WebCenter has changed a lot with its last release. This book will guide you through all the important and new features for managing and administering WebCenter with advanced recipes.

 WebCenter 11g PS3   is a practical guide that provides over 90 advanced recipes with step-by-step instructions covering important aspects of managing and administering Oracle WebCenter.

The book starts by creating an enterprise portal with WebCenter and enhancing it with the new features from the latest 11g version. It then teaches you to build complex navigation models and page hierarchies in detail. It then dives into building Wikis and integrating content with document services. Finally it covers the important administrative concepts of WebCenter Spaces, security, and managing WebCenter applications.


ادامه مطلب


نوشته شده توسط:محمد زحمتکش کناری


برچسب ها: administration، Cookbook، Oracle WebCenter،
  • تعداد کل: 3 
  • 1  
  • 2  
  • 3