Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.
Many data science resources incorporate statistical methods but lack a deeper statistical perspective. If you’re familiar with the R programming language, and have some exposure to statistics, this quick reference bridges the gap in an accessible, readable format.
With this book, you’ll learn:Why exploratory data analysis is a key preliminary step in data scienceHow random sampling can reduce bias and yield a higher quality dataset, even with big dataHow the principles of experimental design yield definitive answers to questionsHow to use regression to estimate outcomes and detect anomaliesKey classification techniques for predicting which categories a record belongs toStatistical machine learning methods that “learn” from dataUnsupervised learning methods for extracting meaning from unlabeled data
The first edition of Ralph Kimball's The Data WarehouseToolkit introduced the industry to dimensional modeling,and now his books are considered the most authoritative guides inthis space. This new third edition is a complete library of updateddimensional modeling techniques, the most comprehensive collectionever. It covers new and enhanced star schema dimensional modelingpatterns, adds two new chapters on ETL techniques, includes new andexpanded business matrices for 12 case studies, and more.Authored by Ralph Kimball and Margy Ross, known worldwide aseducators, consultants, and influential thought leaders in datawarehousing and business intelligenceBegins with fundamental design recommendations and progressesthrough increasingly complex scenariosPresents unique modeling techniques for business applicationssuch as inventory management, procurement, invoicing, accounting,customer relationship management, big data analytics, and moreDraws real-world case studies from a variety of industries,including retail sales, financial services, telecommunications,education, health care, insurance, e-commerce, and more
Design dimensional databases that are easy to understand andprovide fast query response with The Data WarehouseToolkit: The Definitive Guide to Dimensional Modeling, 3rdEdition.
Data warehousing has revolutionized the way businesses in a widevariety of industries perform analysis and make strategicdecisions. Since the first edition of Data WarehousingFundamentals, numerous enterprises have implemented datawarehouse systems and reaped enormous benefits. Many more are inthe process of doing so. Now, this new, revised edition covers theessential fundamentals of data warehousing and businessintelligence as well as significant recent trends in the field.
The author provides an enhanced, comprehensive overview of datawarehousing together with in-depth explanations of critical issuesin planning, design, deployment, and ongoing maintenance. ITprofessionals eager to get into the field will gain a clearunderstanding of techniques for data extraction from sourcesystems, data cleansing, data transformations, data warehousearchitecture and infrastructure, and the various methods forinformation delivery.
This practical Second Edition highlights the areas ofdata warehousing and business intelligence where high-impacttechnological progress has been made. Discussions on developmentsinclude data marts, real-time information delivery, datavisualization, requirements gathering methods, multi-tierarchitecture, OLAP applications, Web clickstream analysis, datawarehouse appliances, and data mining techniques. The book alsocontains review questions and exercises for each chapter,appropriate for self-study or classroom work, industry examples ofreal-world situations, and several appendices with valuableinformation.
Specifically written for professionals responsible fordesigning, implementing, or maintaining data warehousing systems,Data Warehousing Fundamentals presents agile, thorough, andsystematic development principles for the IT professional andanyone working or researching in information management.