Building Custom Tasks for SQL Server Integration Services, 2nd Edition
by Andy Leonard
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS task to the Azure Data Factory (ADF) Azure-SSIS Integration Runtime (I...
Price: $34.99 | Publisher: Apress | Release: 2021
by Alice Zhao
If you use SQL in your day-to-day work as a data analyst, data scientist, or data engineer, this popular pocket guide is your ideal on-the-job reference. You'll find many examples that address the language's complexities, along with key aspects of SQL used in Microsoft SQL Server, MySQL, Oracle Database, PostgreSQL, and SQLite.In this updated edition, author Alice Zhao describes how these database...
Price: $28.14 | Publisher: O'Reilly Media | Release: 2021
by Matt Fuller, Manfred Moser, Martin Traverso
Perform fast interactive analytics against different data sources using the Trino high-performance distributed SQL query engine. With this practical guide, you'll learn how to conduct analytics on data where it lives, whether it's Hive, Cassandra, a relational database, or a proprietary data store. Analysts, software engineers, and production engineers will learn how to manage, use, and even devel...
Price: $64.73 | Publisher: O'Reilly Media | Release: 2021
High Performance SQL Server, 2nd Edition
by Benjamin Nevarez
Design and configure SQL Server instances and databases in support of high-throughput, mission-critical applications providing consistent response times in the face of variations in numbers of users and query volumes. In this new edition, with over 100 pages of additional content, every original chapter has been updated for SQL Server 2019, and the book also includes two new chapters covering SQL Server on ...
Price: $44.53 | Publisher: Apress | Release: 2021
by Kathi Kellenberger, Lee Everest
Get a performance-oriented introduction to the T-SQL language underlying the Microsoft SQL Server and Azure SQL database engines. This fourth edition is updated to include SQL Notebooks as well as up-to-date syntax and features for T-SQL on-premises and in the Azure cloud. Exercises and examples now include the WideWorldImporters database, the newest sample database from Microsoft for SQL Server. Also new i...
Price: $27.69 | Publisher: Apress | Release: 2021
Advanced Analytics with Transact-SQL
by Dejan Sarka
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. Yo...
Price: $32.55 | Publisher: Apress | Release: 2021
by Anthony Nocentino, Ben Weissman
Build a modern data platform by deploying SQL Server in Kubernetes. Modern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. This book introduces Kubernetes and its core concepts. Then it shows you how to build and interact with a Kubernetes cluster. Next, it goes deep i...
Price: $45.93 | Publisher: Apress | Release: 2021
by Philip Joyce
Solve problems by embedding Python code in a C programs, SQL methods, Python sockets. This book uses rudimentary mathematics and basic programming to create practical Python applications for embedding. You'll start with an introduction to C and Python, assuming a fundamental understanding of what programming is. You will also review the basics of the database management language, SQL. You will learn ho...
Price: $33.74 | Publisher: Apress | Release: 2021
FREE EBOOK - The Julia Express
by Bogumil Kaminski
Julia is a high-level, dynamic programming language. Its features are well suited for numerical analysis and computational science.Julia works with other languages (C, Python, R, Rust, C++, SQL, JavaScript, ...)The Purpose of this open book is to introduce programmers to the Julia programming by example. This is a simplified exposition of the language....
Publisher: Self-publishing | Release: 2021
Microsoft Azure Data Solutions
by Daniel A. Seara, Francesco Milano, Danilo Dominici
Cloud technologies are advancing at an accelerating pace, supplanting traditional relational and data warehouse storage solutions with novel, high-value alternatives. Now, three pioneering Azure Data consultants offer an expert introduction to the relational, non-relational, and data warehouse solutions offered by the Azure platform. Drawing on their extensive experience helping organizations get more value...
Price: $36.23 | Publisher: Microsoft Press | Release: 2021