حصريا أكبر مجموعة كتب للداتا بيز على مستوى المنتديات الهندسيه فقط على منتدى هندسة أسوان "متجدد" Data Base Books

حصريا أكبر مجموعة كتب للداتا بيز على مستوى المنتديات الهندسيه فقط على منتدى هندسة أسوان والموضوع

هيكون متجدد إن شاء الله والروابط هتبقى متاحه للجميع حتى الزوار ولغير المشتركين ولكن

أرجو من كل المستفيدين من الموضوع أن يقوموا بتقييم الموضوع وهو زر علامة الموجب

الموجب الموجود على يسار الموضوع أو أى مشاركه

ويلا نبدأ على بركة الله





[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Robert Doyen, Meg Schneider, “Making Millions For Dummies”
For Dummies | 2008 | ISBN: 0470276746 | 384 pages | PDF | 3 MB

Making
Millions For Dummies lays out in simple, easy-to-understand steps the
best ways to achieve wealth. Through a proven methodology of saving,
building a successful business, smart investing, and carefully managing
assets, this up-front, reliable guide shows readers how to achieve
millionaire or multimillionaire status. It provides the lowdown on
making wise financial decisions, with guidance on managing investments
and inheritances, minimizing taxes, making money grow, and, most
important, how to avoid common and costly financial mistakes.
Millionaire wannabes will see how to maintain financial security
throughout their life with this easy-to-follow road map to financial
independence. For individuals who yearn to make millions but don't want
to be restricted to owning or running a business, the book features
other options, such as inventing and patenting the next big thing,
consulting, selling high-value collectibles, and flipping or owning
real estate.





[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Mike Hotek, “Microsoft SQL Server 2008 Step by Step”
Microsoft Press | 2008 | ISBN: 0735626049 | 800 pages | CHM | 10,2 MB

Teach yourself how to design and create SQL Server 2008 databases one step at a time. Work at your own pace through the book s practical, skill-building lessons and the hands-on practice files on CD. You ll begin by learning to install and configure SQL Server 2008, design a model database, and work with tables and indexes. Next, you ll learn techniques to manipulate, maintain, and retrieve data. Finally, you ll learn more-advanced techniques, such as using views, functions, and triggers. As you complete each lesson, you can hone your skills using the practice exercises on the companion CD. Plus, you can review and download code samples illustrating the author s own, professional techniques direct from the companion Web site.






[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Leonard Lobel, Andrew J. Brust, Stephen Forte, "Programming Microsoft SQL Server 2008"
Microsoft Press | 2008-10-29 | ISBN: 0735625999 | 976 pages | CHM | 16,9 MB

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 books examples, exercises, and code samples are available for download from the companion Web site.

depositfiles.com

http://rapidshare.com/files/200250385/ProgrMicS.rar

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

Product Description
The Comprehensive Resource for SQL Server 2005 Administrators, Consultants, and Developers
Whether you’re a systems administrator, database application developer, or IT consultant, you’ll quickly ratchet up your knowledge of Microsoft SQL Server 2005 with this thorough and comprehensive guide. Light on theory and heavy on practicality, it cuts to the chase with real-world examples of large-scale business applications, an entire chapter on troubleshooting, and crucial information on SQL Server 2005’s enhanced connectivity. For new users of Microsoft SQL Server, this book takes you quickly, but systematically, through the introductory topics.


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


David Lockman, "Sams Teach Yourself Oracle8 Database Development in 21 Days"
Publisher: Sams | 1997-08-15 | ISBN 0672310783 | PDF | 665 pages | 3.21 MB

Sams Teach Yourself Database Development with Oracle in 21 Days is a tutorial that will teach the reader the basics of developing Oracle database applications. This book focuses on teaching the concepts behind logical and physical database design, a working knowledge of SQL and PL/SQL, and the basics of Developer/2000, and Oracle Power Objects.






Summary: Not Perfect, but the Best for Beginners
Rating: 5

"Teach Yourself Oracle8 Database Development in 21 Days" is not a perfect book, but is probably the best general book for beginners. As noted by other reviewers, the book is best used with a working installation of the Oracle 8 database -- something not supplied with the book. The book will give you a good, general understanding of database design, SQL, PL/SQL, Oracle Reports, Forms, and Queries, Graphics, and some basic database administration. While not as in depth as more advanced, more narrowly focused books, this book answered questions (e.g. how to convert Forms and Reports from development to Runtime versions) that I didn't see answered anywhere else. Overall, a must have for the novice Oracle user and a good reference for intermediate users, as well.


Summary: Need advisory as to the need for software.
Rating: 4

First, let me say I have not read the book entirely. My observation, as a visual type learner, is I expected the CD to contain all I needed to conduct tutorials. This is not the case. You need some level of an Oracle database on your computer as well as the Developer 2000 software. I think it would be good business for the publisher or Amazon.com comments to advise what you need in order to benefit from the enclosed CD tutorial. Other than that, what I have observed from the book is it is well organized and will be very informative, even without the required software to run the book's CD tutorial.


Summary: For those new to Oracle, this is a great way to start.
Rating: 3

This book covers the basics of Oracle database and Developer/2000 tools. It is a great textbook since it covers the material in easy to understand format and uses numerous screens to guide the reader through the learning process. As a teacher, I had been searching for years for a book that would properly cover the material for an introductory Oracle course. This book is the best I have found so far, and it amazes me how similar it it to the handouts I had produced myself over the years. The book however does have a couple of flaws (and hence the three star rating). First, contrary to the title, it has very little on Oracle 8. Second, it does not cover SQL*Plus. The other shortcomings are minor if you accept this book as only an introductory book. Regardless, if you are teaching an introductory Oracle course and are looking for an easy to use textbook, this is the book for you (until someone does a better one).


Summary: A revision-INTEGRATION of the Oracle Tools and Database
Rating: 3

This book help you to know the differents parts of a database. First its cover the Analyst of a project. After that it explains how to create tables, triggers, etc in the database. After that it explains how to make Forms, Reports and Graphics with Developer 2000. Then it explains the Oracle Power objects. It's a great book to integrate all the aknowdlegde that you could have about Oracle. It also contains an exam after each date. This book helps me to undestand what I alwas do some things in the Database


Summary: Great For New Oracle Users
Rating: 4

First, I should state that I have NOT read this book cover-to-cover. I've used it more as a reference. But if you are new to Oracle and Databases of this size, this is a great "just get me started" book. Books on Oracle tend to assume you already have a PhD in `Oracleese', this book does not. It gives you a good overview of all the Oracle products. Do not expect a lot of detail. Examples show you the very basics of `here's how to get a report started" or "here's a very basic pie chart" Which is great since Oracle's Design tools are not intuitive and can be frustrating and intimidating to the new user even if your familiar with other report or graphing tools. This book is great for you if you just want to get your feet wet, with out a lot of frustration, and then play on your own. I do recommend it for the new oracle developer.



[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

Beginning Database Design
Wrox | December 5, 2005 | ISBN 0764574906 | PDF | 504 pages | 6,9 Mb

The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements.








[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Michael Coles, "Pro SQL Server 2008 XML"
Apress | 2008-05-19 | ISBN: 1590599837 | 496 pages | PDF | 6.7 MB

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 2005 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 can 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
* Provides 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

What you’ll learn?

* Store XML documents using SQL Server’s built–in XML data type.
* Query those stored documents using SQL/XML and XQuery.
* Manipulate and transform XML using XSLT and XPath.
* Understand how SQL Server’s XML support compares to the ISO XML standards.
* Create SOAP endpoints for use in web services applications.
* Create primary and secondary XML indexes to improve performance of XML queries.

Who is this book for?

SQL Server SQL/T–SQL developers and .NET developers who want to take advantage of the specific server–side XML functionality available in SQL Server 2008.

Details: [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Download: 6.7 MB, rar'd PDF


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Ken England, Gavin JT Powell, "Microsoft SQL Server 2005 Performance Optimization and Tuning Handbook"
Digital Press | 2007-04-13 | ISBN: 1555583199 | 520 pages | PDF | 7.3 MB


Database professionals will find that this new edition aids in mastering the latest version of Microsofts SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.

Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions. Assistance on DML, data types (including collections), XML, DDL for basic database objects such as tales, views and indexes, partitioning, and security is also considered.



* Identifies the most common issues DBAs face day to day for easy reference
*Provides DBAs with solutions actually used by the authors in enterprise environments to resolve common and specialized problems to optimization issues.
* Addresses issues that have been introduced by new features which can add more control but reduce performance.

Details: [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Download: 7.3 MB, rar'd PDF


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Robert G. Freeman, Arup Nanda, "Oracle Database 11g New Features"
McGraw-Hill Osborne Media |2007-11-05 | ISBN:0071496610 | 362 pages | PDF | 4,8 MB

Your Must-Have Guide to Everything New in Oracle Database 11g
Realize the full potential of Oracle Database 11g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including:





New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components
Improved Automated Memory Management capabilities
New database design features, such as virtual columns, tablespace encryption, and true table-level data compression
New Database Advisors for data recovery and repair, partitioning, and streams performance
New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer
Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization
Improved auditing and security capabilities
Advanced BI, data warehousing, and partitioning features
New SQL and PL/SQL enhancements

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Michael Gertz, Sushil Jajodia, "Handbook of Database Security Applications and Trends"
Springer | 2007-11-30 | ISBN:0387485325 | 579 pages | PDF | 4,7 MB

The Handbook of Database Security: Applications & Trends, an edited volume by renowned researchers within data security, provides an up-to-date overview of data security models, techniques, and architectures in a variety of data management applications and settings. This edited volume represents the most comprehensive work on numerous data security aspects published in the last ten years.
The Handbook of Database Security: Applications & Trends places a particular focus on data-centric security aspects that reach beyond traditional and well-studied data security aspects in databases. It also covers security in advanced database systems, data privacy and trust management, and data outsourcing, and outlines directions for future research in these fields.





The Handbook of Database Security: Applications & Trends is designed for a professional audience composed of practitioners and researchers in industry and academia as a reference book. This volume is also suitable for advanced-level students in computer science interested in the state-of-the-art in data security.

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Thomas Rizzo, Adam Machanic, Robin Dewson, Rob Walters, Joseph Sack, Julian Skinner, Louis Davidson, "Pro SQL Server 2005"
Apress | 2005-11-02 | ISBN: 1590594770 | 704 pages | PDF | 12.9 MB

SQL Server 2005 is a landmark release of Microsoft's powerful relational database management system for the Windows platform, and one that will change the way you architect your data systems and develop your data-driven applications. Pro SQL Server 2005 takes a deep look at the full range of SQL Server enhancements, and includes meaningful and relevant examples showing how these new features work and how you can build applications effectively. This book provides a critical examination of all of the major new functionality in SQL Server 2005, covering topics that are essential for DBAs and developers alike, including:






* T-SQL programming

* CLR integration and assembly programming

* Using SQL Server Integration Services for data extraction, transformation, and loading

* The new native XML datatype and how to use it

* Security enhancements and Service Broker SQL Server 2005 is a vast new release and each author provides practical, in-depth coverage of the core topics in their specialist areas – always illustrated with realistic examples. As a result, you'll be able to work on your own SQL Server 2005 solutions quickly and painlessly. Ultimately, this book provides you with a starting point, a roadmap, and then the tools and knowledge to exploit this powerful new database to its fullest extent. So, sit back, fire up your computer and your brain and get ready to learn SQL Server 2005.

Details: [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Download: 12.9 MB, rar'd PDF


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Kalen Delaney, Sunil Agarwal, Craig Freedman, Ron Talmage, Adam Machanic, "Inside Microsoft SQL Server 2005: Query Tuning and Optimization"
Microsoft Press | 2007-09-26 | ISBN: 0735621969 | 448 pages | CHM | 6.3 MB


Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. Youll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.





Details: [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Download: 6.3 MB, rar'd CHM


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

OR

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

By Joe Celko (Author) Do you need an introductory book on data and databases? If the book is by Joe Celko, the answer is yes. Data and Databases: Concepts in Practice is the first introduction to relational database technology written especially for practicing IT professionals. If you work mostly outside the database world, this book will ground you in the concepts and overall framework you must master if your data-intensive projects are to be successful. If you're already an experienced database programmer, administrator, analyst, or user, it will let you take a step back from your work and examine the founding principles on which you rely every day-helping you to work smarter, faster, and problem-free. Whatever your field or level of expertise, Data and Databases offers you the depth and breadth of vision for which Celko is famous. No one knows the topic as well as he, and no one conveys this knowledge as clearly, as effectively-or as engagingly. Filled with absorbing war stories and no-holds-barred commentary, this is a book you'll pick up again and again, both for the information it holds and for the distinctive style that marks it as genuine Celko.







ISBN : 978-1-55860-432-2

Publisher : Morgan Kaufmann

Language : English

400 pages

Format : PDF

Books Date : Thu Jan 1 1998

Download (1Mb):

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

JD Edwards EnterpriseOne: The Complete Reference
960 pages | McGraw-Hill Osborne Media; 1 edition (November 19, 2008) | 0071598731 | 17 Mb

Your definitive guide to JD Edwards EnterpriseOne

Implement and maintain a fully integrated, SOA-based ERP framework across your entire corporation. JD Edwards EnterpriseOne: The Complete Reference explains how to install and administer JD Edwards EnterpriseOne, store BI information in data marts and warehouses, manage servers and portals, and develop customized applications and kernel processes. YouAnd'll also learn how to create and distribute packages, use the security workbench, optimize performance, and apply the latest JD Edwards EnterpriseOne updates and tools releases.



Set up and configure the JD Edwards EnterpriseOne applications suite
Work with Oracle, SQL Server, DB2, MSDE, and SSE data sources
Define JD Edwards EnterpriseOne path codes, task views, and environments
Deploy the object configuration manager and solution explorer
Build client and server packages, media objects, and data warehouses
Secure JD Edwards EnterpriseOne using LDAP, single sign-on, and third-party tools
Administer portals and Web sites using JD Edwards EnterpriseOneAnd's HTML server and server manager
Troubleshoot and tune your system using the performance workbench

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

JD Edwards EnterpriseOne: The Complete Reference
960 pages | McGraw-Hill Osborne Media; 1 edition (November 19, 2008) | 0071598731 | 17 Mb

Your definitive guide to JD Edwards EnterpriseOne

Implement and maintain a fully integrated, SOA-based ERP framework across your entire corporation. JD Edwards EnterpriseOne: The Complete Reference explains how to install and administer JD Edwards EnterpriseOne, store BI information in data marts and warehouses, manage servers and portals, and develop customized applications and kernel processes. YouAnd'll also learn how to create and distribute packages, use the security workbench, optimize performance, and apply the latest JD Edwards EnterpriseOne updates and tools releases.



Set up and configure the JD Edwards EnterpriseOne applications suite
Work with Oracle, SQL Server, DB2, MSDE, and SSE data sources
Define JD Edwards EnterpriseOne path codes, task views, and environments
Deploy the object configuration manager and solution explorer
Build client and server packages, media objects, and data warehouses
Secure JD Edwards EnterpriseOne using LDAP, single sign-on, and third-party tools
Administer portals and Web sites using JD Edwards EnterpriseOneAnd's HTML server and server manager
Troubleshoot and tune your system using the performance workbench

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

Are you a database administrator who wants to add design and development skills to your toolkit? Then this CBT Nuggets SQL Server 2008 Exam-Pack 70-450 training pack is for you.
SQL Server 2008 brings you lots of terrific features. Shared server-wide management capability allows you to automate processes, schedule tasks and set performance alerts. Plus you can edit and insert code and run reports.
Trainer Don Jones begins his video series with the basics: SQL terminology, how relational databases work, how they store and retrieve data and the fundamentals of the T-SQL language. Then he teaches you how to install, migrate, upgrade and consolidate your data from previous SQL versions to 2008 SQL Server. Plus, he shows you how some of the “handy” tips and tricks you may have used in earlier versions of SQL can trip you up in SQL Server 2008.




Don’s training covers SQL Server management studio — SQL Server 2008’s all-in-one interface — and SQL Server Configuration Manager — which gives you complete control over all SQL Server 2008 Services. It also covers plenty of other advanced features, including:
* Installation, verifying and launching Server Management tools
* Instance and Object Security Authentication
* Transparent Data Encryption (TDE)
* High Availability Overview, clustering, failover and replication
* Backup, restore and testing recovery models
Once you’ve finished the series, you’ll be installing and managing SQL Server 2008 in a variety of situations. As a result of this training you’ll:
* increase your database reliability
* optimize your database security
* enhance the overall performance of your databases
Exam Information:
This video series is mapped to Microsoft’s 70-450 exam. Passing this exam moves you closer to being a fully-certified Database Administrator (DBA). When combined with MCTS SQL Server 2008, Implementation and Maintenance certification (exam 70-432), you earn prestigious MCITP Certification for SQL Server 2008. (Training for MCTS exam 70-432 will be available from CBT Nuggets later this year.)
Exam pack 70-450 contains the following videos:
* Introduction and Overview
* SQL Server 2008 Functional Concepts and Architecture
* SQL Server 2008 Physical Concepts and Architecture
* Planning a SQL Server 2008 Installation
* Installing SQL Server 2008
* Creating and Using a Database
* Migrating, Consolidating, and Upgrading
* SQL Server Instance Security
* SQL Server Database Security
* High Availability Overview
* Backing up SQL Server
* Restoring SQL Server
* Database Mirroring and Clustering (free video)
* Monitoring SQL Server
* SQL Server Performance Optimization
* Maintaining SQL Server
* Managing SQL Server
* Using SQL Server Agent
* Distributing Data with SQL Server Integration Services
* Linked Servers and Replication
Here’s what you’ll learn in each video of the Microsoft SQL Server 2008: Exam-Pack 70-450 Series:
Video 1 - “Introduction and Overview” - Review the table of contents for this series of nuggets, and introduction to the SQL Server 2008 tools.
Video 2 - “SQL Server 2008 Functional Concepts and Architecture” - Terminology, the purpose of SQL Server, the T-SQL language, Data Definition Language vs. Data Manipulation Language, and how databases work: How data is stored in pages, how filestreams and blobs work, other data types, the function of the transaction log, how database indexes work, and how database triggers work.
Video 3 - “SQL Server 2008 Physical Concepts and Architecture” - CPU, memory, and storage concerns; SQL Server services; database physical architecture, database file placement strategies.
Video 4 - “Planning a SQL Server 2008 Installation” - Planning for instances, planning for storage, planning for security, planning for availability.
Video 5 - “Installing SQL Server 2008″ - Preparing for the installation, performing the installation, verifying the installation, and launching SQL Server management tools.
Video 6 - “Creating and Using a Database” - Creating a database, database options, creating a table, executing a query, managing the database file.
Video 7 - “Migrating, Consolidating, and Upgrading” - Generation migration and consolidation concerns, instance configuration options, database configuration options, SQL Server version upgrades.
Video 8 - “SQL Server Instance Security” - Instance-level authentication, instance-level security - including service accounts, endpoint security, TCP ports and SSL certificates, etc.
Video 9 - “SQL Server Database Security” - Database and object security, ownership chains, designing security policies and audit plans, SQL Server encryption options - including Transparent Data Encryption (TDE).
Video 10 - “High Availability Overview” - Goals of high availability, hardware, failover clustering, database mirroring, replication, and log shipping.
Video 11 - “Backing up SQL Server” - Selecting a recovery model, backup compression options, selecting a backup type, scheduling backups, file and filegroup backup schemes, verifying backups, mirrored backups.
Video 12 - “Restoring SQL Server” - Page, file, filegroup, and online restores; orphaned users; rebuilding a complete instance; encryption and recovery; recovery paths and forks; point-in-time and mark recovery; testing your recovery plan.
Video 13 - “Database Mirroring and Clustering” - Mirroring: High performance, high protection, high availability; differences between mirroring and clustering, setting up mirroring; how clustering works; setting up clustering (differences from regular setup).
Video 14 - “Monitoring SQL Server” - Monitoring options (system monitor, event logs, management views, WMI, remote monitoring, and triggers), data collectors, event notifications.
Video 15 - “SQL Server Performance Optimization” - Dedicated Administrator Connection (DAC), locking and blocking, deadlocks, index utilization, Database Tuning Advisor.
Video 16 - “Maintaining SQL Server” - Database maintenance plans, rebuilding and reorganizing indexes, how the Query Optimizer works, maintaining the Query Optimizer (statistics).
Video 17 - “Managing SQL Server” - Managing resource utilization (Resource Governor and Query Governor), policy-based management, data compression strategies, automating SQL Server management (PowerShell, Agent, DDL triggers, etc).
Video 18 - “Using SQL Server Agent” - Creating and managing jobs, proxies, multi-server administration, scheduling jobs.
Video 19 - “Distributing Data with SQL Server Integration Services” - Introducing SSIS, SSIS package security options, scheduling SSIS packages, deploying SSIS packages.
Video 20 - “Linked Servers and Replication” - Linked servers and connection strings, introducing replication, replication types, understanding replication conflicts, health monitoring for replication, horizontal and virtual partitioning in replication.
All trademarks and copyrights are the property of their respective holders.
download links:
[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

When using software products with graphical interfaces, we frequently focus so much on the details of how to use the interface that we forget about the more general concepts that allow us to understand and put the software to effective use. This is particularly true of a powerful database product like Microsoft Access. Novice, and sometimes even experienced, programmers are so concerned with how something is done in Access that they often lose sight of the general principles that underlie their database applications.





Access Database Design & Programming, 2nd Edition, an update to the bestselling first edition, features:
A discussion of Access’ new VBA Integrated Development Environment, which, for the first time, is the one used by Word, Excel, and PowerPoint
An expansion of the discussion of the VBA language itself, in response to reader requests
A discussion of Microsoft’s latest data access technology, called Active Data Objects (or ADO), along with a discussion of Open Database Connectivity(ODBC), which is intimately connected with ADO
Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, this book focuses instead on the core concepts, enabling programmers to develop solid, effective database applications. As a result, important topics such as designing forms and reports, database security, database replication, and programming for multiuser applications are simply not discussed. This book is a kind of “second course” in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to successfully develop in the Microsoft Access environment. Anyone interested in learning Access in-depth, rather than just scraping the surface, will enjoy and immensely benefit from reading this book.
Although this book is really an introduction directed to intermediate Microsoft Access users who are novice programmers, it should appeal to all levels of Access developers. For novice programmers, it focuses on a key body of knowledge that is typically neglected, but is nevertheless essential for developing effective database applications. For intermediate and advanced developers, its treatment of database design and queries provides a handy treatment that otherwise has to be gleaned from relatively uninteresting textbooks, while its programming chapters constitute a handy reference to some basic operations that can be performed using DAO or the Access object model.

Download Here

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Jono Bacon, “Practical PHP and MySQL(R): Building Eight Dynamic Web Applications”
Prentice Hall PTR | 2006-11-14 | ISBN: 0132239973 | 528 pages | PDF | 4,8 MB

Practical PHP and MySQL reflects Jono’s commitment to the spirit of making open source subjects accessible to everyone. The book carefully walks you through the code for eight useful, dynamic Web applications. Projects are presented in a playful way, like the forum project that touts horror movies that make you ‘hide behind the couch...
–From the Foreword by Christopher Negus, Series Editor

Suddenly, it’s easy to build commercial-quality Web applications using free and open source software. With this book, you’ll learn from eight ready-to-run, real-world applications–all backed by clear diagrams and screenshots, well-documented code, and simple, practical explanations.





Leading open source author Jono Bacon teaches the core skills you’ll need to build virtually any application. You’ll discover how to connect with databases, upload content, perform cascading deletes, edit records, validate registrations, specify user security, create reusable components, use PEAR extensions, and even build Ajax applications.

Working from complete examples on the CD-ROM, you’ll create

• Generic dynamic Web sites
• Blogs
• Discussion forums
• Shopping carts
• Auction sites
• Calendars
• FAQ systems
• Reusable components
• Content management systems
• News sites


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

RS mirror
:
[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

Product Description
Packed with examples, Simply SQL is a step-by-step introduction to learning SQL. You’ll discover how easy it is to use SQL to interact with best-practice, robust databases. Rather than bore you with theory, it focuses on the practical use of SQL with common databases and uses plenty of diagrams, easy-to-read text, and examples to help make learning SQL easy and fun.

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Thomas Kyte, “Effective Oracle by Design”
McGraw-Hill Osborne Media | 2003-08-21 | ISBN: 0072230657 | 688 pages | DJVU | 53,2 MB

Streamline Application Development with Help from an Oracle Expert

Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.
Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools
Take advantage of Oracle's scalable architectural implementations
Handle administration with SPFILES,Oracle Managed Files, and Automatic Segment Space Management



Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery
Improve statement processing by using bind variables and reducing parsing
Make full use of the Cost Based Optimizer (CBO)
Choose data structures that result in effectively designed schemas
Write efficient SQL statements and high-performance PL/SQL code
Learn invaluable techniques from an Oracle insider


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Mirror :
[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation is the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you’ll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching methodology, the accompanying PrepLogic testing software, and superior Web site support at [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط] The book follows the exam objectives and features numerous exercises to give you hands-on opportunities, exam tips that give you advice for test day, and warnings that alert you to possible mistakes. The Fast Facts section condenses the most important information for last-minute review, and the practice exam is representative of the actual exam.




Each book in the Training Guide series is published under the direction of Series Editor Ed Tittel, the leading authority on IT certification. This book has been subjected to rigorous technical review by a team of industry experts, ensuring content is superior in both coverage and technical accuracy, and has earned the distinction of Cramsession Approved Study Material.
The CD features PrepLogic Practice Tests, Preview Edition. This product includes one complete PrepLogic Practice Test with approximately the same number of questions found on the actual vendor exam. Each question contains full, detailed explanations of the correct and incorrect answers. The engine offers two study modes, Practice Test and Flash Review, full exam customization, and a detailed score report

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


Lynn Beighley, Michael Morrison, “Head First PHP&MySQL (A Brain-Friendly Guide)”
O'Reilly Media, Inc. | 2008-12-30 | ISBN: 0596006306 | 812 pages | PDF | 48,6 MB

If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.





Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.
Use PHP to transform static HTML pages into dynamic web sites
Create and populate your own MySQL database tables, and work with data stored in files
Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY
Use cookies and sessions to track visitors' login information and personalize the site for users
Protect your data from SQL injection attacks
Use regular expressions to validate information on forms
Dynamically display text based on session info and create images on the fly
Pull syndicated data from other sites using PHP and XML
Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

http://rapidshare.com/files/194368609/First_PHP_MySQL.rar

Product Description
If you’re ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.
Head First PHP & MySQL offers the same visually rich format that’s turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you’ve learned.

Throughout the book, you’ll build sophisticated examples — including a mailing list, a job board, and an online dating site — to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you’re ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

Programmers and software architects don’t really make a conscious decision to design an application (particularly one with online exposure) around the three-tier model-view-controller design pattern anymore. Three-tier, largely because of its adaptability and stability, is the norm. All of which means you need a database to underpin each of your applications. Designing your databases correctly can make the difference between slow-running, complicated code and software that’s speedy, modular, and easy to work with. Database Design for Mere Mortals prepares someone with only a passing familiarity with databases for the important job of building the persistence layer (also called the data model) for software.






Michael Hernandez explains database design in tradesman’s terms. That is, he shows his readers how to identify the business problems that have to be satisfied by a database, then proceeds to explain how to build a solid solution to them. Hernandez’s approach combines procedural guidelines (first identify critical facts, then apply a certain logic to yield tables, then establish cross-references, and so on) with practical definitions that clear up much of the rich trove of jargon surrounding databases. He walks through numerous examples, and doesn’t shy away from the complexities that always exist in real customers’ requirements. If you’re not familiar with database design, and want to be, this is the book you need. –David Wall
Topics covered: How to design databases that fit business requirements and make software construction easier. In addition to explaining relational database concepts, the author explains data integrity, null values, keys, table relationships (one-to-one, one-to-many, and many-to-many), and data types. He emphasizes processes designers should follow in building a new database or improving an existing one.

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]

[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


C Date, “SQL and Relational Theory: How to Write Accurate SQL Code”
O'Reilly Media, Inc. | 2009-02-05 | ISBN: 0596523068 | 426 pages | CHM | 1,15 MB

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as:


Should database access granted be through views instead of base tables?
Nulls in your database are causing you to get wrong answers. Why? What can you do about it?
Could you write an SQL query to find employees who have never been in the same department for more than six months at a time?
SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them?
Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation?

Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.


[ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]


RS: [ندعوك للتسجيل في المنتدى أو التعريف بنفسك لمعاينة هذا الرابط]/193280735/SQL_Relational_Theory.rar