9789355512376 (16 results)

paperback. Condition: New. Ships in a BOX from Central Missouri! UPS shipping for most packages, (Priority Mail for AK/HI/APO/PO Boxes).

Condition: As New. Unread book in perfect condition.

Condition: New.

Condition: New. In.

Paperback. Condition: new. Paperback. Learning real-world analytics using SQLKey FeaturesHands-on approach to learning the fundamentals of data analysisCovers all levels of SQL expertise from novice to master with examplesIncludes techniques and approaches to query complex databases more effectively DescriptionThis book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data.The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides readers through the process of building queries, using simple and then more complex table joins and progressively more advanced data filtering, to deliver advanced queries based on a variety of SQL techniques. The reader will understand how to deliver relevant and trustworthy analysis of the data through learning how to apply fundamental computations in T-SQL, relational logic, and how to group and aggregate data. There is also coverage of other SQL concepts, such as formatting queries, writing subqueries, creating derived tables, joining and filtering tables, etc. In addition to that, the book discusses how to conduct rolling analyses, examine time-series data, and manage large and complex datasets.After finishing the book, readers won't merely be able to write complex queries; rather, they will be able to construct their methodology for analysing relational datasets and arriving at the desired insights.What you will learnAnalyze data using simple math and logic, multiple filters, and data aggregation.Become proficient with table expressions, subqueries, and writing complex computations.Perform rolling analysis and time series analysis using advanced methods.Review SQL concepts such as table joins, data filtering, query structuring, and table derivation.Who this book is forThis book is for data professionals, such as database developers, SQL developers, data analysts, and BI experts, who wish to construct complex queries and extract the desired analytics from their datasets. The book also encourages smart new learners to learn SQL and use it right away in their first jobs.Table of Contents1. Writing Basic SQL Queries2. Using Multiple Tables When Querying Data3. Using Advanced Table Joins4. Filtering Data5. Applying Complex Filters to Queries6. Making Simple Calculations7. Aggregating Output8. Working with Dates in SQL Server9. Formatting Text in Query Output10. Formatting Numbers and Dates11. Using Basic Logic to Enhance Analysis12. Subqueries13. Derived Tables14. Common Table Expressions15. Correlated Subqueries16. Dataset Manipulation17. Using SQL for More Advanced Calculations18. Segmenting and Classifying Data19. Rolling Analysis20. Analyzing Data Over Time21. Complex Data OutputRead more This book teaches SQL analytics from basics to advanced levels, covering table joins, data filtering, complex computations, time-series analysis, and more. Suitable for data professionals and beginners looking to enhance their SQL skills for data analysis. Shipping may be from multiple locations in the US or from the UK, depending on stock availability.

PF. Condition: New.

Condition: New.

Condition: As New. Unread book in perfect condition.

Condition: New.

Condition: New.

Paperback. Condition: new. Paperback. Learning real-world analytics using SQLKey FeaturesHands-on approach to learning the fundamentals of data analysisCovers all levels of SQL expertise from novice to master with examplesIncludes techniques and approaches to query complex databases more effectively DescriptionThis book will take you on an interactive journey to master SQL querying from the most fundamental to the most advanced level using various T-SQL techniques to provide meaningful insights from your SQL Server data.The book begins with an introduction to the fundamental concepts of both SQL and SQL Server. It then guides readers through the process of building queries, using simple and then more complex table joins and progressively more advanced data filtering, to deliver advanced queries based on a variety of SQL techniques. The reader will understand how to deliver relevant and trustworthy analysis of the data through learning how to apply fundamental computations in T-SQL, relational logic, and how to group and aggregate data. There is also coverage of other SQL concepts, such as formatting queries, writing subqueries, creating derived tables, joining and filtering tables, etc. In addition to that, the book discusses how to conduct rolling analyses, examine time-series data, and manage large and complex datasets.After finishing the book, readers won't merely be able to write complex queries; rather, they will be able to construct their methodology for analysing relational datasets and arriving at the desired insights.What you will learnAnalyze data using simple math and logic, multiple filters, and data aggregation.Become proficient with table expressions, subqueries, and writing complex computations.Perform rolling analysis and time series analysis using advanced methods.Review SQL concepts such as table joins, data filtering, query structuring, and table derivation.Who this book is forThis book is for data professionals, such as database developers, SQL developers, data analysts, and BI experts, who wish to construct complex queries and extract the desired analytics from their datasets. The book also encourages smart new learners to learn SQL and use it right away in their first jobs.Table of Contents1. Writing Basic SQL Queries2. Using Multiple Tables When Querying Data3. Using Advanced Table Joins4. Filtering Data5. Applying Complex Filters to Queries6. Making Simple Calculations7. Aggregating Output8. Working with Dates in SQL Server9. Formatting Text in Query Output10. Formatting Numbers and Dates11. Using Basic Logic to Enhance Analysis12. Subqueries13. Derived Tables14. Common Table Expressions15. Correlated Subqueries16. Dataset Manipulation17. Using SQL for More Advanced Calculations18. Segmenting and Classifying Data19. Rolling Analysis20. Analyzing Data Over Time21. Complex Data OutputRead more This book teaches SQL analytics from basics to advanced levels, covering table joins, data filtering, complex computations, time-series analysis, and more. Suitable for data professionals and beginners looking to enhance their SQL skills for data analysis. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability.

PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000.

PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000.

Condition: New. Dieser Artikel ist ein Print on Demand Artikel und wird nach Ihrer Bestellung fuer Sie gedruckt. KlappentextrnrnLearning real-world analytics using SQL KEY FEATURES &#9679 Hands-on approach to learning the fundamentals of data analysis&#9679 Covers all levels of SQL expertise from novice to master with examp.

Taschenbuch. Condition: Neu. Querying SQL Server | Run T-SQL operations, data extraction, data manipulation, and custom queries to deliver simplified analytics (English Edition) | Adam Aspin | Taschenbuch | Kartoniert / Broschiert | Englisch | 2022 | BPB Publications | EAN 9789355512376 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand.

Taschenbuch. Condition: Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - Learning real-world analytics using SQL.