The NoSQL Database for Cloud and Desktop Computing

EBook Description: MongoDB, a cross-platform NoSQL database, is the fastest-growing new database in the world. MongoDB provides a rich document orientated structure with dynamic queries that you�ll recognize from RDMBS offerings such as MySQL. In other words, this is a book about a NoSQL database that does not require the SQL crowd to re-learn how the database world works! MongoDB has reached 1.0 and already boasts 50,000+ users. The community is strong and vibrant and MongoDB is improving at a fast rate. With scalable and fast databases becoming critical for today�s applications, this book shows you how to install, administer and program MongoDB *without* pretending SQL never existed.

Maximize every powerful feature available in MySQL 5.1 with hands-on instruction from a MySQL expert. This definitive guide shows you how to use MySQL's advanced suite of data management tools, optimize performance and reliability, and secure and administer a robust RDBMS. MySQL Database Usage & Administration includes detailed code examples in each chapter to highlight real-world applications of the material covered. If you want to get the most out of MySQL, you need this practical handbook.
* Understand MySQL's features, technical architecture, subsystems, and commands
* Make database design decisions that optimizre performance, storage, and reliability
* Write complex queries using joins, subqueries, and views
* Group SQL statements into transactions and execute them atomically
* Build and use sophisticated stored procedures and functions
* Automate database operations with triggers and scheduled events
* Import and export data in different formats, includiong SQL, CSV, and XML
* Optimize server and query performance
* Administer a secure, high availability MySQL RDBMS
* Manage users and control access
* Perform database maintenance, replication, backup, and recovery

Implementing A Microsoft SQL Server 2008 R2 Database

This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.This course is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database. To be successful in this course, the student should have knowledge of basic relational database concepts and writing T-SQL queries.
DOWNLOAD:

Ado.NET 4 Database Programming with Vb 2010

* quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
* code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications.the route the professionals take for flexibility and control
* display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
* work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
* create local reports using Visual Studio's Report Designer and Report Viewer to display data easily.and clearly!.in tables, matrices, lists, and charts
* Use the Entity Framework to create an entity data model that maps business objects to database objects, then retrieve and maintain data through that model
* Use LINQ to query datasets, SQL Server databases, and entity data

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach's distinctive "paired-pages" format.where each skill is presented with examples and advice in a single 2-page spread.is great for both targeted learning and reference.

Maintaining a Microsoft SQL Server 2008 R2 Database

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

Audience Profile
The primary audience for this course is individuals who administer and maintain SQL Server databases. This course can also be helpful for individuals who develop applications that deliver content from SQL Server databases.

At Course Completion
After completing this course, students will be able to:

Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
Plan, install and configure SQL Server 2008 R2
Backup and restore databases
Import and export wizards and explain how they relate to SSIS
Use BCP and BULK INSERT to import data
Manage security
Assign, configure fixed database roles and create and assign user defined database roles
Configure and assign permissions
Implement SQL Server 2008 R2 Audits
Manage SQL Server 2008 R2 Agent and Jobs
Configure database mails, alerts and notifications
Maintain databases
Configure SQL Profiler Traces and Use the Database Tuning Advisor
Monitor data by using Dynamic Management Views
Execute multi-server queries and configure a central management server
Deploy a data-tier-application
Troubleshoot common issues

Database Fundamentals

This book helps new database professionals understand database concepts with the right blend of breadth and depth of information.
Who should read this book ?
This book is tailored for new database enthusiasts, application developers, database administrators, and anyone with an interest in the subject and looking to get exposure such as university students and new graduates.
How is this book structured ?
This book is divided into chapters, starting with the basic database concepts and information models in Chapter 1. Chapter 2 covers relational data models. Chapter 3 and 4 explain conceptual modeling and relational database design. In Chapters 5, 6 and 7 the focus is geared towards SQL. Chapter 8 highlights XML data storage and retrieval via SQL and XQuery. Chapter 9 addresses database security aspects. The book then concludes with an overview of various other key technologies and relevant applications that are increasingly popular in the industry today. Exercises and review questions can be found with most chapters. The solutions have been pred in Appendix A.

Leverage Oracle Database

Protect your critical business assets and achieve maximum database uptime using the detailed information in this Oracle Press guide. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, Oracle Real Application Clusters, and Oracle Data Guard, Second Edition provides cost-effective solutions to current availability challenges. Discover how to grid-enable your IT framework, roll out Oracle Real Application Clusters, maintain standby databases, and deploy Oracle Flashback. Monitoring, tuning, and disaster recovery techniques are also covered in this comprehensive resource.

Install Oracle Clusterware (as part of Oracle's grid infrastructure) or upgrade from an earlier version
Build test clusters and hosts using Oracle VM
Work with Oracle Automatic Storage Management and Oracle Automatic Storage Management Cluster File System
Create synchronized standby databases using Oracle Data Guard
Reliably archive and restore data with Oracle Recovery Manager
Use Oracle Flashback to identify and undo user errors
Configure Oracle Enterprise Manager Grid Control for management of an Oracle maximum availability architecture environment

ADO.NET 4 Database Programming with VB 2010

* quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
* code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications...the route the professionals take for flexibility and control
* display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
* work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
* create local reports using Visual Studio's Report Designer and Report Viewer to display data easily...and clearly!...in tables, matrices, lists, and charts
* Use the Entity Framework to create an entity data model that maps business objects to database objects, then retrieve and maintain data through that model
* Use LINQ to query datasets, SQL Server databases, and entity data

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach's distinctive "paired-pages" format...where each skill is presented with examples and advice in a single 2-page spread...is great for both targeted learning and reference.

Oracle Database 11g

xample-laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation's flagship database product.

* Learn what's new in Oracle that really counts.
* See actual examples and test run output.
* Make sound decisions on new feature adoption.

Sift the gold from the silt and discover which new features of the latest release of Oracle's flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step-by-step testing and a heart-felt emphasis on what matters in the real-world to help you get the most out of Oracle Database 11g.

Oracle Database 11g: New Features for DBAs and Developers

Oracle Database 11g : New Features for DBAs and Developers is a comprehensive, example�laden review of the most significant new features and improvements offered by the latest release of Oracle Corporation�s flagship database product.

* Learn what�s new in Oracle that really counts.
* See actual examples and test run output.
* Make sound decisions on new feature adoption.

Sift the gold from the silt and discover which new features of the latest release of Oracle�s flagship database product are really worth adopting. Years of database administration experience from authors Sam Alapati and Charles Kim are combined with sound, step�by�step testing and a heart�felt emphasis on what matters in the real�world to help you get the most out of Oracle Database 11g.

Pro SQL Server 2008 Relational Database Design and Implementation

Learn effective and scalable database design techniques in a SQL Server environment. Pro SQL Server 2008 Relational Database Design and Implementation covers everything from design logic that business users will understand all the way to the physical implementation of the design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, authors Louis Davidson, Kevin Kline, Scott Klein, and Kurt Windisch show how to "get it right" in SQL Server database design and lay a solid groundwork for the future use of valuable business data.
Solid foundation in best practices and relational theory
Maximize SQL Server features to enhance security, performance, scalability
Thorough treatment from conceptual design to an effective, physical implementation

What you'll learn
Develop conceptual models of client data using interviews and client documentation.
Normalize data models to enhance scalability and the long term use of valuable data.
Translate conceptual models into high-performing SQL Server databases.
Secure and protect the integrity of data as part of meeting regulatory requirements.
Take full advantage of new SQL Server features such as the spatial datatype, XML support, transparent data encryption, and more.
Create effective indexing to speed query performance.

• Free IAS eBooks
• Free GRE eBooks
• Free MBA eBooks
• Free GATE eBooks