null
Loading…
Skip to main content

Holiday gifts by Fri, Dec 18? Order by Fri, Dec 4. Plan gifts

Free shipping works great on most orders over $95 in the contiguous US

Specialists Mon–Fri, 8:30 am–5 pm PTSpecialists Mon–Fri, 8:30–5 PT866-522-6657

Printed to order
Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data book cover by Dejan Sarka
Paperback

Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data

by Dejan Sarka

Paperback · 302 pages Apress · 2021

Format

Paperbackfrom $23.55
Volume pricing

The more copies, the less each one costs

Applied automatically in your cart. No code needed.

More than a box of books

Built for school and campus orders

PDF quotes, purchase orders, tax exemption and multi-site delivery, handled by one account manager.

About the book

Advanced Analytics with Transact-SQL

Learn about business intelligence (BI) features in T-SQL and how they can help you with data science and analytics efforts without the need to bring in other languages such as R and Python. This book shows you how to compute statistical measures using your existing skills in T-SQL. You will learn how to calculate descriptive statistics, including centers, spreads, skewness, and kurtosis of distributions. You will also learn to find associations between pairs of variables, including calculating linear regression formulas and confidence levels with definite integration. 

No analysis is good without data quality. Advanced Analytics with Transact-SQL introduces data quality issues and shows you how to check for completeness and accuracy, and measure improvements in data quality over time. The book also explains how to optimize queries involving temporal data, such as when you search for overlapping intervals. More advanced time-oriented information in the book includes hazard and survival analysis. Forecasting with exponential moving averages and autoregression is covered as well.

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


Who This Book Is For

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.


The book, Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data [Bulk, Wholesale, Quantity] ISBN#9781484271728 in Paperback by Dejan Sarka may be ordered in bulk quantities. Minimum starts at 25 copies. Availability based on publisher status and quantity being ordered.

Details

Publisher
Apress
Author
Dejan Sarka
Format
Paperback
Published
Jul 17, 2021
ISBN-13
9781484271728
Pages
302
Printing
Printed on demand
Buying for a group

Advanced Analytics with Transact-SQL in bulk: pricing

Volume pricing applies automatically in your cart. No codes, no account needed.

CopiesPrice per copyYou save
25 – 99 $26.59 30% off list
100 – 249 $25.83 32% off list
250 – 499 $25.07 34% off list
500 – 999 $24.31 36% off list
1,000+ $23.55 38% off list
Ways groups use it

Popular for

1
Course and classroom adoption

A copy for every student in the class or section.

2
Faculty and staff book studies

Shared reading for professional development.

3
Orientation and campus events

Common reads and first-year programs.

How fast can I get copies of Advanced Analytics with Transact-SQL?

This title is printed on demand, so it needs production time before it ships. Need them by a specific date? Request a quote and we'll confirm timing before you pay.

Can you ship to several locations or people's homes?

Yes. We ship in bulk to one address, to multiple sites, or to individual recipients, in the US and internationally. See fulfillment options.

Can I get a formal quote for approval before ordering?

Yes. Request a quote and we'll send a PDF you can forward for approval.

Do you accept purchase orders and tax-exempt orders?

Yes. We accept purchase orders upon approval, as well as cards, PayPal, ACH, wire transfers and checks. BookPal is a tax-exempt supplier in all 50 states. See purchase orders and sales tax exemption.

What if I find a lower price?

Send us the link. We match prices from other bulk booksellers and distributors on a new copy in the same edition, available to ship in the quantity you need. Clearance sales and pricing errors are the exception, and we'll tell you quickly if that's the case. Start a price match.

Customer reviews

What buyers say

Be the first to review
Send for approval

Get a yes from your approver

Advanced Analytics with Transact-SQL: Exploring Hidden Patterns and Rules in Your Data
Email it to my approver

Your approver gets a link to this page with the quantity set and an "Approve and order" button. Nothing is sent until you press send in your email app.

Log In
Review Your Cart
Your cart is empty Your cart is empty Your cart is empty

Menu

Recently Viewed Recently Viewed
Back to top Back to top