Product Description: The book will cover the introduction to the Topic and can be used as a very useful study material for those who want to learn the topic in brief via a short and complete book. Thought-provoking and accessible in approach, this updated and expanded second edition of the * provides a user-friendly introduction to the subject, Taking a clear structural framework, it guides the reader through the subject's core elements...read more

Product Description: My support site is saszero2hero.com. Despite the popularity of R and Python, many large private companies in insurance, banking, and pharmaceutical industries, to name a few, still predominantly use SAS. If you plan to work or are already working in one of the companies that use SAS for data manipulation and analysis, you might want to learn SAS...read more

Product Description: Why buy this book? Like many people, I also ask this question before spending my hard-earned bucks. In the existence of free web material and many well-written comprehensive books, this question gets more weight. SQL is older than most of us, so I can’t claim to be conveying some extraordinary stuff through this book...read more

Getting SQL Server talking to Hadoop is a smooth process when you follow this tutorial. Learn all the tools and techniques you need integrate the data and then extract powerful business insights from the merged result. Overview Integrate data from unstructured (Hadoop) and structured (SQL Server 2012) sources Configure and install connectors for a bi-directional transfer of data Full of illustrations, diagrams, and tips with clear, step-by-step instructions and practical examples In Detail With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indeed complementary. While petabytes of unstructured data can be stored in Hadoop taking hours to be queried, terabytes of structured data can be stored in SQL Server 2012 and queried in seconds. This leads to the need to transfer and integrate data between Hadoop and SQL Server. Microsoft SQL Server 2012 with Hadoop is aimed at SQL Server developers. It will quickly show you how to get Hadoop activated on SQL Server 2012 (it ships with this version). Once this is done, the book will focus on how to manage big data with Hadoop and use Hadoop Hive to query the data. It will also cover topics such as using in-memory functions by SQL Server and using tools for BI with big data. Microsoft SQL Server 2012 with Hadoop focuses on data integration techniques between relational (SQL Server 2012) and non-relational (Hadoop) worlds. It will walk you through different tools for the bi-directional movement of data with practical examples. You will learn to use open source connectors like SQOOP to import and export data between SQL Server 2012 and Hadoop, and to work with leading in-memory BI tools to create ETL solutions using the Hive ODBC driver for developing your data movement projects. Finally, this book will give you a glimpse of the present day self-service BI tools such as Excel and PowerView to consume Hadoop data and provide powerful insights on the data. What you will learn from this book Use the Native SQOOP Connector for data movement between SQL Server 2012 and Hadoop Configure and use the Hive ODBC driver to enable any ODBC compliant client to consume Hadoop data Create ETL solutions and automate data movement jobs between SQL Server 2012 and Hadoop using SQL Server Integration Services Provide powerful reporting on the integrated data with just a matter of a few clicks using Microsoft self-service BI tools Merge structured and unstructured data together in a common warehouse for analysis, which is essential Approach This book will be a step-by-step tutorial, which practically teaches working with big data on SQL Server through sample examples in increasing complexity. Who this book is written for Microsoft SQL Server 2012 with Hadoop is specifically targeted at readers who want to cross-pollinate their Hadoop skills with SQL Server 2012 business intelligence and data analytics. A basic understanding of traditional RDBMS technologies and query processing techniques is essential.

Design, implement, and deliver a successful database solution with Microsoft SQL Server 2014 Overview Discover SQL Server 2014’s new in-memory OLTP engine and performance-related improvements Explore the fundamentals of database planning and the Server Transact-SQL language syntax Gain hands-on experience with the use of scalar and table-valued functions, branching, and more advanced data structures In Detail SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve the performance of your applications, making them as much as ten times more efficient in some cases. Whether you are thinking about becoming a database developer, architect, or administrator, or you are a seasoned database expert, this book will provide you with all the skills you need to successfully create, design, and deploy databases using SQL Server 2014. You will also learn how to add, modify, and delete data stored within a database. You will use Transact-SQL statements to create and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers. Finally, you will learn about how SQL Server works, how indexes and statistics improve query performance, and the new SQL Server 2014 in-memory technologies. What you will learn from this book Get introduced to SQL Server 2014's new in-memory database engine Understand SQL Server database architecture and relational database design Use joins, subqueries, CTEs, and windowing functions to write advanced Transact-SQL queries Learn about tools that let you monitor SQL Server database performance Identify and troubleshoot blocks or deadlocks that might slow down a system Design, create, and manage advanced database objects that include scalar and table-valued functions, views, stored procedures, and triggers Use SQL Server 2014's structured error handling blocks to handle errors that occur in the Transact-SQL batches and programmable objects Approach This book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014. Who this book is written for If you are a database developer, architect, or administrator who wants to learn how to design, implement, and deliver a successful database solution with SQL Server 2014, then this book is for you. Existing users of Microsoft SQL Server will also benefit from this book as they will learn what's new in the latest version.

Product Description: This MySQL functions book studies popular SQL Functions used in the MySQL Workbench query browser such as cast and conversion functions, string functions, information functions, control flow functions, encryption functions, aggregate functions, math functions, date and time functions and BIT functions...read more

Product Description: Learn how to build powerful spatial database solutions with PostGIS quickly and efficiently About This BookLearn how to construct your own solutions using the most exciting Geographic Information System (GIS) tool on the market, PostGISUse this book to develop a complete GIS application from scratchA practical, agile, and step-by-step guide for using PostGIS to create great GIS solutionsWho This Book Is ForThis book is a quick guide for anyone who wants to get started with PostGIS and develop their very own GIS projects quickly...read more

Product Description: This book on Raiser’s Edge SQL Server queries explores common SQL Server codes that I have used in the industry over the last 2 years. The database is used for the purpose of customer relationship management (CRM) and fundraising within the marketing industry...read more

Assesses the place of Gilbert and Sullivan operettas in history of the British theater, looks at six major works, and discusses the working relationship of the librettist and composer

Product Description: Hadoop queries in Pig or Hive can be too slow for real-time data analysis. Impala, an ultra-speedy query engine from Cloudera, supercharges Hadoop by avoiding the typical Map-Reduce overhead and parallelizing queries so that they can run on multiple nodes...read more

Product Description: Take your data access skills to the next level with Entity Framework About This BookLearn how to create, retrieve, update, and delete the data in a relational database using .NETChoose from an array of examples in C# and VB.NET that showcase the key concepts of Entity FrameworkThis is a fast-paced, practical guide based on the code-first approach for the Entity object-relational mapperWho This Book Is ForThis book is intended for software developers with some prior experience with the Microsoft ...read more

Product Description: Note: The current edition of this book is Murach's MySQL, 2nd Edition.This practical, hands-on training and reference guide is perfect for developers who need to learn MySQL. Written by Joel Murach, the author of bestselling "Java Servlets and JSP" and "PHP and MySQL" books, this is exactly the database book that web developers should have on their desks...read more

Optimize your database server to be fast, efficient, and highly secure using the brand new features of SQL Server 2014 with this book and ebook. Overview Design your SQL Server 2014 infrastructure by combining both onpremise and WindowsAzurebased technology Implement the new InMemory OLTP database engine feature to enhance the performance of your transaction databases This is a handson tutorial that explores the new features of SQL Server 2014 along with giving real world examples In Detail The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such as SQL Server 2014 have evolved to allow DBAs to utilize both services to maintain their key service level agreements, ensuring that their important databases are always available. SQL Server 2014 has a strong focus on business intelligence, making it a vital tool if you are looking to improve the performance of your processes as a relational database professional. Getting Started with SQL Server 2014 Administration will guide you through your first steps of learning SQL Server 2014 by introducing you to its new features and helping you create a hybrid environment, which is both highly available and allows you to get the best performance from your databases. This book is for anyone who wants to boost their database application performance to the next level. What you will learn from this book Design a SQL Server infrastructure combining on-premise servers and Windows Azure Storage Create a backup strategy that allows you to store your SQL Server backup in the Windows Azure cloud Improve database performance by using the In-Memory OLTP features Implement the delayed durability feature to improve transaction latency Use a cloud-based replica to build an AlwaysOn Availability Group Learn the other enhancements and new features that can help improve database performance Approach This is an easy-to-follow handson tutorial that includes real world examples of SQL Server 2014's new features. Each chapter is explained in a stepbystep manner which guides you to implement the new technology.