Sign-In
Cart
Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data
Paperback
DatabasesProbability & StatisticsProgramming
Publisher Price: $37.99
ISBN13: 9781484271728
Publisher: Apress
Published: Jul 17 2021
Pages: 302
Weight: 1.24
Height: 0.68 Width: 7.00 Depth: 10.00
Language: English
Every web/retail shop wants to know the products customers tend to buy together. Trying to predict the target discrete or continuous variable with few input variables is important for practically every type of business. This book helps you understand data science and the advanced algorithms use to analyze data, and terms such as data mining, machine learning, and text mining.
Key to many of the solutions in this book are T-SQL window functions. Author Dejan Sarka demonstrates efficient statistical queries that are based on window functions and optimized through algorithms built using mathematical knowledge and creativity. The formulas and usage of those statistical procedures are explained so you can understand and modify the techniques presented.
T-SQL is supported in SQL Server, Azure SQL Database, and in Azure Synapse Analytics. There are so many BI features in T-SQL that it might become your primary analytic database language. If you want to learn how to get information from your data with the T-SQL language that you already are familiar with, then this is the book for you. What You Will Learn
- Describe distribution of variables with statistical measures
- Find associations between pairs of variables
- Evaluate the quality of the data you are analyzing
- Perform time-series analysis on your data
- Forecast values of a continuous variable
- Perform market-basket analysis to predict customer purchasing patterns
- Predict target variable outcomes from one or more input variables
- Categorize passages of text by extracting and analyzing keywords
Database developers and database administrators who want to translate their T-SQL skills into the world of business intelligence (BI) and data science. For readers who want to analyze large amounts of data efficiently by using their existing knowledge of T-SQL and Microsoft's various database platforms such as SQL Server and Azure SQL Database. Also for readers who want to improve their querying by learning new and original optimization techniques.
Also in
Probability & Statistics
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Wickham, Hadley
Grolemund, Garrett
Paperback
AP Statistics Premium, 2027: 9 Practice Tests + Comprehensive Review + Online Practice
Sternstein, Martin, PH. D.
Paperback
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Wickham, Hadley
Grolemund, Garrett
Cetinkaya-Rundel, Mine
Paperback
Graph Paper Composition Notebook: Quad Ruled 5x5, Grid Paper for Students in Math and Science
Wizo, Math
Paperback
Stat 208 Statistical Thinking: A Book for Stat 208 at Virginia Commonwealth University
Street IV, W. Scott
Durfee, Becky
Paperback
The Art of Uncertainty: How to Navigate Chance, Ignorance, Risk and Luck
Spiegelhalter, David
Paperback
Forecasting: Principles and Practice, the Pythonic Way
Hyndman, Rob J.
Athanasopoulos, George
Paperback
Introduction to Statistics: An Intuitive Guide for Analyzing Data and Unlocking Discoveries
Frost, Jim
Paperback
The Art of Uncertainty: How to Navigate Chance, Ignorance, Risk and Luck
Spiegelhalter, David
Hardcover
How the World Really Works: The Science Behind How We Got Here and Where We're Going
Smil, Vaclav
Paperback
Mastering Claude AI: Practical Journey from First Prompts to Pro with Claude AI
Dickey, Ryan
Paperback
Scale: The Universal Laws of Life, Growth, and Death in Organisms, Cities, and Companies
West, Geoffrey
Paperback
The Random Universe: How Models and Probability Help Us Make Sense of the Cosmos
Jaffe, Andrew H.
Hardcover
Ai-Assisted Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Bruce, Peter
Bruce, Andrew
Gedeck, Peter
Paperback
Advanced Statistics in Research: Reading, Understanding, and Writing Up Data Analysis Results
Hatcher, Larry
Paperback
Mathematical Foundations of Quantum Computing: A Scaffolding Approach
Cheng, Ran
Lee, Peter
Yu, James
Hardcover
Schaum's Outline of Probability and Statistics, 4th Edition: 897 Solved Problems + 20 Videos
Spiegel, Murray R.
Schiller, John J.
Srinivasan, R. Alu
Paperback
An Introduction to Statistical Learning: With Applications in R
James, Gareth
Witten, Daniela
Hastie, Trevor
Paperback
The Only Math Book You'll Ever Need, Revised Edition: Hundreds of Easy Solutions and Shortcuts for Mastering Everyday Numbers
Heller, Barbara R.
Kogelman, Stanley
Paperback
SQL Server 2025 Unveiled: The Ai-Ready Enterprise Database with Microsoft Fabric Integration
Ward, Bob
Paperback
How the World Really Works: The Science Behind How We Got Here and Where We're Going
Smil, Vaclav
Hardcover
Mathletics: How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition
Pelechrinis, Konstantinos
Winston, Wayne L.
Nestler, Scott
Paperback
Building Large Language Models from Scratch: Design, Train, and Deploy Llms with Pytorch
Grigorov, Dilyan
Paperback
Regression Modeling Strategies: With Applications to Linear Models, Logistic and Ordinal Regression, and Survival Analysis
Harrell Jr, Frank E.
Paperback
Schaum's Outline of Probability, Random Variables, and Random Processes, Fourth Edition
Hsu, Hwei P.
Paperback
Quantum Computing and Quantum Machine Learning for Engineers and Developers
Rosas-Bustos, Jose
Fraser, Roydon Andrew
Van Griensven Thé, Jesse
Hardcover
Probably Overthinking It: How to Use Data to Answer Questions, Avoid Statistical Traps, and Make Better Decisions
Downey, Allen B.
Paperback
Making ChatGPT Work for You: Getting the Most Out of Generative AI as a Non-Techie
Evelyn, Lydia
Paperback
Probably the Best Book on Statistics Ever Written: How to Beat the Odds and Make Better Decisions
Shapira, Haim
Hardcover
Challenging Mathematical Problems with Elementary Solutions, Vol. I: Volume 1
Yaglom, A. M.
Yaglom, I. M.
Paperback
The End of Average: Unlocking Our Potential by Embracing What Makes Us Different
Rose, Todd
Paperback
The Master Algorithm: How the Quest for the Ultimate Learning Machine Will Remake Our World
Domingos, Pedro
Paperback
Databricks Data Intelligence Platform: Unlocking the Genai Revolution
Gupta, Nikhil
Yip, Jason
Paperback
Scorecasting: The Hidden Influences Behind How Sports Are Played and Games Are Won
Moskowitz, Tobias
Wertheim, L. Jon
Paperback
Probably Overthinking It: How to Use Data to Answer Questions, Avoid Statistical Traps, and Make Better Decisions
Downey, Allen B.
Hardcover
Time Series Analysis and Its Applications: With R Examples
Stoffer, David S.
Shumway, Robert H.
Hardcover
AI for Robotics: Toward Embodied and General Intelligence in the Physical World
Imran, Alishba
Gopalakrishnan, Keerthana
Paperback
Large Language Models: A Deep Dive: Bridging Theory and Practice
Somers, Garrett
Kamath, Uday
Keenan, Kevin
Hardcover
Building Generative AI Agents: Using Langgraph, Autogen, and Crewai
Deshmukh, Gaurav
Taulli, Tom
Paperback
The Theory That Would Not Die: How Bayes' Rule Cracked the Enigma Code, Hunted Down Russian Submarines, and Emerged Triumphant from Two Centuries of C
McGrayne, Sharon Bertsch
Paperback
Machine Learning Q and AI: 30 Essential Questions and Answers on Machine Learning and AI
Raschka, Sebastian
Paperback
Modern Time Series Forecasting with Python - Second Edition: Industry-ready machine learning and deep learning time series analysis with PyTorch and p
Tackes, Jeffrey
Joseph, Manu
Paperback
Challenging Mathematical Problems with Elementary Solutions, Vol. II: Volume 2
Yaglom, A. M.
Yaglom, I. M.
Paperback
Learning Statistics with Jamovi: A Tutorial for Beginners in Statistical Analysis
Foxcroft, David
Navarro, Danielle
Paperback
An Introduction to Statistical Learning: With Applications in Python
Hastie, Trevor
James, Gareth
Witten, Daniela
Hardcover
Mathematical Foundations of Quantum Computing: A Scaffolding Approach
Lee, Peter
Yu, James
Cheng, Ran
Paperback
Guesstimation: Solving the World's Problems on the Back of a Cocktail Napkin
Weinstein, Lawrence
Adam, John a.
Paperback
Deep Learning in Computational Mechanics: An Introductory Course
Weeger, Oliver
Jokeit, Moritz
Herrmann, Leon
Hardcover
Unlocking Dbt: Design and Deploy Transformations in Your Cloud Data Warehouse
Dorsey, Dustin
Cyr, Cameron
Paperback
High-Dimensional Probability: An Introduction with Applications in Data Science
Vershynin, Roman
Hardcover
The ESRI Guide to GIS Analysis, Volume 2: Spatial Measurements and Statistics
Griffin, Lauren Scott
Mitchell, Andy
Paperback
The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition
Hastie, Trevor
Tibshirani, Robert
Friedman, Jerome
Hardcover
ACCUPLACER Math Prep: ACCUPLACER Math Test Study Guide with Two Practice Tests [Includes Detailed Answer Explanations]
Tpb Publishing
Paperback
Observability for Large Language Models: Site Reliability and Chaos Engineering for AI at Scale
Sharma, Ankush
Paperback
Bayesian Analysis with Python - Third Edition: A practical guide to probabilistic modeling
Martin, Osvaldo
Paperback
Introduction to Statistics: An Intuitive Guide for Analyzing Data and Unlocking Discoveries
Frost, Jim
Hardcover
Prompt Engineering for Everyone: A Self-Taught, Human-Centered Approach to AI Programming
Tavakoli, Hamid
Paperback
Damned Lies and Statistics: Untangling Numbers from the Media, Politicians, and Activists
Best, Joel
Hardcover
An Introduction to Statistical Learning: With Applications in Python
Hastie, Trevor
James, Gareth
Witten, Daniela
Paperback
Large Language Model Recipes: A Hands-On Guide to Fine-Tuning, Optimization, Deployment, and Real-World Applications
Kaata, Sashi Kiran
Bolla, Bharath Kumar
Subbaiah, Kalpa
Paperback
The Design Inference: Eliminating Chance through Small Probabilities
Dembski, William A.
Ewert, Winston
Hardcover
R in Action, Third Edition: Data Analysis and Graphics with R and Tidyverse
Kabacoff, Robert I.
Paperback
Practical Generative Ai: From Concept to Deployment: Building and Deploying Ethical AI-Powered Solutions
McKeone, James
Singh, Pramod
Paperback
Enterprise Guide for Implementing Generative AI and Agentic AI: A Practical Guide to Developing, Deploying, and Operationalizing Ai-Driven Application
Sinha, Vikas
Edward, Shakuntala Gupta
Bhattacharya, Rahul
Paperback
Student's Solutions Guide for Introduction to Probability, Statistics, and Random Processes
Pishro-Nik, Hossein
Paperback
A Modern Introduction to Probability and Statistics: Understanding Why and How
Kraaikamp, C.
Lopuhaä, H. P.
Dekking, F. M.
Hardcover
Large Language Models: From Theory to Production
Pacheco Aznar, David
Vanegas, Esteban
Noguer I. Alonso, Miquel
Paperback
Exercises and Projects for The Little SAS Book, Sixth Edition
Ottesen, Rebecca A.
Delwiche, Lora D.
Slaughter, Susan J.
Paperback
Making Statistics Work: Information Theory and Bayesian Inference
Foley, Duncan
Scharfenaker, Ellis
Paperback