This book explains various commercial and open source products that perform SQL on Hadoop and big data. It equips the reader with an understanding of the various architectures being used and how the t
Master a graph data modeling technique superior to traditional data modeling for both relational and NoSQL databases (graph, document, key-value, and column), leveraging cognitive psychology to improv
Automate your database administration workload through a combination of PowerShell and T-SQL. Automate SQL Server build processes, monitor multiple instances from a single location, and automate routi
The Concept and Object Modeling Notation (COMN) is able to cover the full spectrum of analysis and design. A single COMN model can represent the objects and concepts in the problem space, logical data
A practical guide to data mining using SQL and ExcelData Analysis Using SQL and Excel, 2nd Edition shows you how to leverage the two most popular tools for data query and analysis—SQL and Excel—to per
This graduate text book provides a formal analysis of alternative, non-relational data models and storage mechanisms and gives a decent overview of non-SQL query languages. It describes a perspective
Bioinformatics encompasses a broad and ever-changing range of activities involved with the management and analysis of data from molecular biology experiments. Despite the diversity of activities and a
Una guia practica, detallada y completa sobre como implementar y explotar bases de datos Oracle de forma eficiente.Codigo SQL del libro descargable en:http://www.optimizacionsqlenoracle.com?En que con
What you need to get the job done.The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying d
Based on the Artech House classic ANSI SQL Data Modeling and Structure Processing, this expanded and updated book offers you an essential tool for utilizing the ANSI SQL outer join operation to perfor
Relational database design and SQL (Structured Query Language) programming teach-by-practical-diagrams-&-examples book for developers, programmers, systems analysts and project managers who are ne
Hands-on troubleshooting methods on the most recent release of SQL ServerThe 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critica
The demand for SQL information and training continues to grow with the need for a database behind every website capable of offering web-based information queries. SQL is the de facto standard for data
A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs,
Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the i
SQL是關系型數據庫的處理語言,具有強大的處理功能。本書以SQL92標準為重點(部分章節增加了SQL:1999和SQL:2003),全面系統地介紹了sQL語法、功能和特點,并以目前廣泛流行的關系數據庫SQL Server 2005/2008和Oracle 9i/10g/11g為基礎,詳細介紹了各種語法的示例,這些示例都是在實際工作中經常用到的,通俗易懂,具有很強的實用性。本書擁有完善的體系、全面的
A guide to designing and implemeting database solutions using SQL Server covers such topics as relational theory, data modeling, database security, normalization, and concurrency.
A Fully Integrated Study System for OCA Exam 1Z0-051Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each ch
Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use
Database professionals will find that this new edition aids in mastering the latest version of Microsoft’s SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in applica
Before SQL programmers could begin working with OLTP (On-Line Transaction Processing) systems, they had to unlearn procedural, record-oriented programming before moving on to SQL’s declarative, set-or
Stored procedures and built-in functions can greatly expand the power and usefulness of SQL, but surprisingly these highly useful tools remain untapped by many programmers. For programmers who are new
Explains how SQL Server and its core technologies are designed, how they work, and how they interoperate. As a complement to his other two books on SQL, Henderson explores Windows' process and thread
Introduces the basic relational database terminology and techniques for extracting information from Oracle databases. Written for beginners, the book focuses on the SQL*Plus query language and the SEL