Pluralsight – Redgate SQL Prompt

Pluralsight  – Redgate  SQL  Prompt  English | Duration: 1h 47m | WMV3 | 1024×768 | 15fps 289kbps | WMA 128kbps | 272MB Genre: eLearning Using Redgate SQL Prompt to complete SQL code as you type, define your own SQL code snippets, and refactor the metadata defining your database

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008

Practical DMX Queries for Microsoft SQL Server Analysis Services 2008 Language: English | Publisher: McGraw-Hill | ISBN: 0071748660 | 2011 | PDF | 336 pages | 16 mb Extract real, actionable business intelligence using DMX Practical DMX Queries for SQL Server Analysis Services shows how to write DMX queries within Microsoft‘s BI stack. This solutions-based guide contains more than 240 DMX queries that can be immediately applied across a wide variety of BI-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows: Query: Introduction and description of query and its use Syntax: Complete syntax Result: Screen shot showing the data returned from the Analysis Services data mining model by the query Analysis: Analysis of the results and tips...

Practical Database Programming with Java

From the Back CoverCovers fundamental and advanced Java database  programming  techniques for beginning and experienced readersThis book covers the practical considerations and applications in database programming using Java NetBeans IDE, JavaServer Pages, JavaServer Faces, and Java Beans, and comes complete with authentic examples and detailed explanations.Two data-action methods are developed and presented in this important resource. With Java Persistence API and plug-in Tools, readers are directed step by step through the entire database programming development process and will be able to design and build professional data-action projects with a few lines of code in mere minutes. The second method, runtime object, allows readers to design and build more sophisticated and practical Java database applications. Advanced and updated Java database programming techniques such as Java Enterprise Edition development kits, Enterprise Java Beans, JavaServer Pages, JavaServer Faces,...

Ryan Stephens, “Sams Teach Yourself SQL in 24 Hours”

Ryan Stephens, “Sams Teach Yourself SQL in 24 Hours0″  Publisher: Sams | ISBN: 0672324423 | edition 2002 | CHM | 504 pages | 1 mb Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.

MongoDB in Action

MongoDB in Action By Kyle Banker Publisher: Man..ning Public..ations 2011 | 312 Pages | ISBN: 1935182870 | PDF | 5 MB MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. About the Technology Big data can mean big headaches. MongoDB is a document-oriented database designed to be flexible, scalable, and very fast, even with big data loads. It’s built for high availability, supports rich, dynamic schemas, and lets you easily distribute data across multiple servers.

Database Design Using Entity-Relationship Diagrams

Sikha Bagui, Richard Earp – Database Design Using Entity-Relationship Diagrams Publisher: Auеrbach Publicаtions | 2003-06-27 | ISBN: 0849315484 | PDF | 264 pages | 3.74 MB Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. 

Expert One-on-One Oracle

Expert One-on-One Oracle Apress | August 14, 2003 | ISBN-10: 1590592433 | 1297 pages | PDF | 8.25 MB Thomas Kyte has a simple philosophy: You can treat Oracle as a black box and shove data inside of it, or you can learn how Oracle works and exploit it as a powerful computing environment. If you choose the latter, you will see there are few information management problems you cannot solve quickly and elegantly. Kyte has selected the most important features and techniques to discuss in Expert One-on-One Oracle, which he teaches in a proof-by-example manner. He discusses available features, implementing software using these features, and avoiding potential pitfalls.

Managing Oracle Fusion Applications

Managing Oracle Fusion Applications By Richard Bingham Publisher: McG,,.raw-Hil..l 2011 | 350 Pages | ISBN: 0071750339 | PDF | 5 MB Master Oracle Fusion ApplicationsAdminister a fully integrated application management framework across your enterprise using the detailed information contained in this Oracle Press guide. Managing Oracle Fusion Applications first explains key principles and then logically groups utilities into practical, ready-to-use toolboxes. Learn how to build lifecycle models, deliver dynamic business intelligence, optimize performance, mitigate risk, and integrate the latest Web 2.0 and social networking features.

Programming Entity Framework: Code First

Programming Entity Framework: Code First By Julia Lerman, Rowan Miller Publisher: O’Re.,.illy Me..dia 2011 | 192 Pages | ISBN: 1449312942 | PDF | 6 MB Take advantage of the Code First data modeling approach in ADO.NET Entity Framework, and learn how to build and configure a model based on existing classes in your business domain. With this concise book, you’ll work hands-on with examples to learn how Code First can create an in-memory model and database by default, and how you can exert more control over the model through further configuration.

MySQL to DB2 Conversion Guide

MySQL to DB2 Conversion Guide By Whei-Jen Chen, Angela Carlson Publisher: I.B.M Corp. 2009 | 476 Pages | ISBN: 0738433659 | PDF | 5 MB Switching database vendors is often considered an exhausting challenge for database administrators and developers. Complexity, total cost, and the risk of downtime are often the reasons that restrain IT decision makers from starting the migration project. The primary goal of this book is to show that, with the proper planning and guidance, converting from MySQL to IBM® DB2® is not only feasible but straightforward.

Migrating to the Cloud: Oracle Client/Server Modernization

Book Description Whether your company is planning on database migration, desktop application migration, or has IT infrastructure consolidation projects, this book gives you all the resources you’ll need. It gives you recommendations on tools, strategy and best practices and serves as a guide as you plan, determine effort and budget, design, execute and roll your modern Oracle system out to production. Focusing on Oracle grid relational database technology and Oracle Fusion Middleware as the target cloud -based architecture, your company can gain organizational efficiency, agility, increase innovation and reduce IT Total Cost of Ownership (TCO) by moving to service-oriented, Web-based cloud  architectures.

CBT Nuggets – Microsoft Database SQL Server 2005 Implementation 70-431

CBT Nuggets – Microsoft Database SQL Server 2005 Implementation 70-431 Trainer: Garth C. Schulte | Videos: 20 | Time: 14 hrs | English | 606.60 MB Genre: eLearningIn this series, instructor Garth Schulte shows you what’s new, what’s different, and what’s useful about SQL Server 2005. As you go through and watch each video, you learn not only the features that SQL Server 2005 has, but what they do and — most importantly — how to use them. Plus you’ll be preparing for MCTS certification exam 70-431 at the same time. Passing the 70-431 exam earns you certification as a Microsoft Certified Technology Specialist (MCTS), which tells employers that you are a specialist at implementing and maintaining a SQL Server 2005 installation. A basic understanding of computers and networking, such as A+ and...

Train Signal SQL Server 2008 Administration Training

Train Signal  SQL  Server  2008 Administration  Training  English | format: VMW | wmv3 800×600, 60 kb/s, 15.00 | wmav2, 44100 Hz, mono, 48 kb/s | 517MB Genre: Video Training If you want to develop hands-on experience as an SQL Server 2008 Administrator, or prepare for the 70-432 exam then this course is for you! We are excited to announce our long awaited SQL Server 2008 Administration Training course. Whether you’re a beginner or experienced in SQL Server administration, this course covers SQL Server 2008 in depth as you configure and maintain your own enterprise data management system!

Oracle9i Administration and Management

Oracle9i Administration and Management By Michael R. Ault, Michael Ault Publisher: Wi,.,ley 2002 | 1024 Pages | ISBN: 0471218863 | PDF | 6 MB Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably. Shows the best techniques, tips, and tools for Oracle systems New edition focuses on the 9i version, but also covers releases 8 and 8i since many organizations still support these versions Companion Web site includes all of the software scripts to manage a database, plus links to lite and demo versions of database management software and other DBA tools 

PostgreSQL 9 Administration Cookbook

Simon Riggs & Hannu Krosing – “PostgreSQL 9 Administration Cookbook”, 1st Ed. Publisher: Packt Publishing | Pages: 360 | October 2010 | ISBN-10: 1849510288 | PDF + code | 4.7 Mb Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience.

SQL Server Hardware Choices Made Easy

Glenn Berry,”SQL Server Hardware Choices Made Easy” R..ed g..te | PDF | 79 pages | ISBN 13: 9781906434724 | ISBN 10: N/A | 2.6Mb Relational databases place heavy demands on their underlying hardware. Many databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. The idea behind this eBook is to provide a quick “heads up” to the issue that I have found the most important when choosing and configuring hardware for use with SQL Server, by providng a series of specific tips or peaces of advice.

SQL Server MVP Deep Dives, Volume 2

SQL Server MVP Deep Dives, Volume 2 By Kalen Delaney Publisher: Man..ning Public..ations 2011 | 688 Pages | ISBN: 1617290475 | EPUB + PDF | 15 MB + 21 MB SQL Server MVP Deep Dives, Volume 2 lets you learn from the best in the business – 64 SQL Server MVPs offer completely new content in this second volume on topics ranging from testing and policy management to integration services, reporting, and performance optimization techniques…and more.

Microsoft® SQL Server® 2008 T-SQL Fundamentals

Itzik Ben-Gan – Microsoft® SQL Server® 2008 T-SQL Fundamentals Microsoft Press | 2008 | ISBN: 0735626014 | English | 688 pages | CHM | 1.9 MB This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you’ll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language – helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow...

MySQL, 2nd Edition

Paul DuBois, “MySQL, 2nd Edition”  Publisher: Sams | ISBN: 0735712123 | edition 2003 | CHM | 1248 pages | 1,9 mb In the second edition of MySQL Paul DuBois provides an updated, comprehensive guide to one of the most popular relational database systems. MySQL is the most popular open source database server in the world, with more than 2 million installations and customers including Yahoo!, MP3.com, Motorola, and NASA.