2,408 Results for : sql
-
Learn More Python 3 the Hard Way (eBook, PDF)
Transform Your Ideas into High-Quality Python Code! Zed Shaw has perfected the world's best system for becoming a truly effective Python 3.x developer. Follow it and you will succeed-just like the tens of millions of programmers he's already taught. You bring the discipline, commitment, and persistence; the author supplies everything else. In Learn Python 3 the Hard Way, Zed Shaw taught you the basics of Programming with Python 3. Now, in Learn More Python 3 the Hard Way, you'll go far beyond the basics by working through 52 brilliantly crafted projects. Each one helps you build a key practical skill, combining demos to get you started and challenges to deepen your understanding. Zed then teaches you even more in 12 hours of online videos, where he shows you how to break, fix, and debug your code. First, you'll discover how to analyze a concept, idea, or problem to implement in software. Then, step by step, you'll learn to design solutions based on your analyses and implement them as simply and elegantly as possible. Throughout, Shaw stresses process so you can get started and build momentum, creativity to solve new problems, and quality so you'll build code people can rely on. Manage complex projects with a programmer's text editor Leverage the immense power of data structures Apply algorithms to process your data structures Master indispensable text parsing and processing techniques Use SQL to efficiently and logically model stored data Learn powerful command-line tools and skills Combine multiple practices in complete projects It'll be hard at first. But soon, you'll just get it-and that will feel great! This course will reward you for every minute you put into it. Soon, you'll go beyond merely writing code that runs: you'll craft high-quality Python code that solves real problems. You'll be a serious Python programmer. Perfect for Everyone Who's Already Started Working with Python, including Junior Developers and Seasoned Python Programmers Upgrading to Python 3.6+ Register your product at informit.com/register for convenient access to downloads, updates, and/or corrections as they become available.- Shop: buecher
- Price: 21.95 EUR excl. shipping
-
Data Warehouse Systems
With this textbook, Vaisman and Zimányi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most basic principles to recent findings and applications. To this end, their work is structured into three parts. Part I describes "Fundamental Concepts" including conceptual and logical data warehouse design, as well as querying using MDX, DAX and SQL/OLAP. This part also covers data analytics using Power BI and Analysis Services. Part II details "Implementation and Deployment," including physical design, ETL and data warehouse design methodologies. Part III covers "Advanced Topics" and it is almost completely new in this second edition. This part includes chapters with an in-depth coverage of temporal, spatial, and mobility data warehousing. Graph data warehouses are also covered in detail using Neo4j. The last chapter extensively studies big data management and the usage of Hadoop, Spark, distributed, in-memory, columnar, NoSQL and NewSQL database systems, and data lakes in the context of analytical data processing.As a key characteristic of the book, most of the topics are presented and illustrated using application tools. Specifically, a case study based on the well-known Northwind database illustrates how the concepts presented in the book can be implemented using Microsoft Analysis Services and Power BI. All chapters have been revised and updated to the latest versions of the software tools used. KPIs and Dashboards are now also developed using DAX and Power BI, and the chapter on ETL has been expanded with the implementation of ETL processes in PostgreSQL. Review questions and exercises complement each chapter to support comprehensive student learning. Supplemental material to assist instructors using this book as a course text is available online and includes electronic versions of the figures, solutions to all exercises, and a set of slides accompanying each chapter.Overall, students, practitioners and researchers alike will find this book the most comprehensive reference work on data warehouses, with key topics described in a clear and educational style."I can only invite you to dive into the contents of the book, feeling certain that once you have completed its reading (or maybe, targeted parts of it), you will join me in expressing our gratitude to Alejandro and Esteban, for providing such a comprehensive textbook for the field of data warehousing in the first place, and for keeping it up to date with the recent developments, in this current second edition."From the foreword by Panos Vassiliadis, University of Ioannina, Greece.- Shop: buecher
- Price: 109.99 EUR excl. shipping
-
Modern Data Engineering with Apache Spark
Leverage Apache Spark within a modern data engineering ecosystem. This hands-on guide will teach you how to write fully functional applications, follow industry best practices, and learn the rationale behind these decisions. With Apache Spark as the foundation, you will follow a step-by-step journey beginning with the basics of data ingestion, processing, and transformation, and ending up with an entire local data platform running Apache Spark, Apache Zeppelin, Apache Kafka, Redis, MySQL, Minio (S3), and Apache Airflow.Apache Spark applications solve a wide range of data problems from traditional data loading and processing to rich SQL-based analysis as well as complex machine learning workloads and even near real-time processing of streaming data. Spark fits well as a central foundation for any data engineering workload. This book will teach you to write interactive Spark applications using Apache Zeppelin notebooks, write and compile reusable applications and modules, and fully test both batch and streaming. You will also learn to containerize your applications using Docker and run and deploy your Spark applications using a variety of tools such as Apache Airflow, Docker and Kubernetes.Reading this book will empower you to take advantage of Apache Spark to optimize your data pipelines and teach you to craft modular and testable Spark applications. You will create and deploy mission-critical streaming spark applications in a low-stress environment that paves the way for your own path to production.What You Will LearnSimplify data transformation with Spark Pipelines and Spark SQLBridge data engineering with machine learningArchitect modular data pipeline applications Build reusable application components and libraries Containerize your Spark applications for consistency and reliabilityUse Docker and Kubernetes to deploy your Spark applicationsSpeed up application experimentation using Apache Zeppelin and Docker Understand serializable structured data and data contracts Harness effective strategies for optimizing data in your data lakes Build end-to-end Spark structured streaming applications using Redis and Apache Kafka Embrace testing for your batch and streaming applications Deploy and monitor your Spark applications Who This Book Is ForProfessional software engineers who want to take their current skills and apply them to new and exciting opportunities within the data ecosystem, practicing data engineers who are looking for a guiding light while traversing the many challenges of moving from batch to streaming modes, data architects who wish to provide clear and concise direction for how best to harness and use Apache Spark within their organization, and those interested in the ins and outs of becoming a modern data engineer in today's fast-paced and data-hungry world- Shop: buecher
- Price: 52.99 EUR excl. shipping
-
Power BI Data Modeling: Build Interactive Visualizations, Learn DAX, Power Query, and Develop BI Models (English Edition) (eBook, ePUB)
Build Power BI Models Efficiently and Effectively KEY FEATURES ● Extensive examples illustrating Power BI and data modeling concepts.● Includes graphical images and explanations of using Power BI.● Numerous hands-on practical examples are teaching best practices in predictive modeling. DESCRIPTION Creating data models has never been straightforward. This book demonstrates how to formulate a complete business analytics model that combines several data sources, executes numerous computations, and scales across hundreds of BI users. To begin, you'll learn about the Microsoft Power BI ecosystem by downloading the Power BI desktop and exploring all of its features and capabilities. Through examples, you'll learn how to connect to databases of Excel; and SQL Server, shaping the data with Power Query, and then transforming the data into actionable information. You will gain knowledge of the DAX language by exploring it, writing DAX functions, and creating hierarchies. You will be trained to develop effective business intelligence models by studying numerous data modeling topics. You get to put professionals' best practices to the test when handling large data scenarios and executing analytics on top of them. Additionally, the book discusses how to scale Power BI while considering its storage, memory, and security requirements. You'll see that several new topics have been included, including performance tuning, DAX Studio, sharing Power BI reports, and publishing reports to Sharepoint online. WHAT YOU WILL LEARN● Conduct profiling, cleansing, and transformation of data.● Build data models, aggregate data, and create hierarchies.● Practice DAX language, write calculations, and execute them.● Utilize advanced features including AI visualizations and performance analyzer.● Examine various connection types and connect data from different sources.● Enhance performance by boosting storage and memory. WHO THIS BOOK IS FORThis book is intended for data analysts, business analysts, and any other business user who are interested in learning how to develop data models using Power BI from beginning to end. To follow this book and master Power BI, a basic understanding of data visualization would be sufficient. AUTHOR BIO Nisal Mihiranga is a Big Data Engineering and Machine Learning Architect who has 10+ years' experience in the IT domain, and nearly 8 years of exposure to the Microsoft Business Intelligence stack. Throughout his career Nisal has engaged with many data warehousing and Microsoft BI projects from designing to insights delivery phase. He is a Microsoft Certified Trainer (MCT) with experience in conducting technical training programs including Microsoft Power BI in Sri Lanka, Singapore and Australia.- Shop: buecher
- Price: 9.49 EUR excl. shipping
-
C# 10 and .NET 6 - Modern Cross-Platform Development - Sixth Edition
A comprehensive guide for beginners to learn the key concepts, real-world applications, and latest features of C# 10 and .NET 6 with hands-on exercises using Visual Studio 2022 and Visual Studio Code Key Features:Explore the newest additions to C# 10, the .NET 6 class library, and Entity Framework Core 6 Create professional websites and services with ASP.NET Core 6 and Blazor Build cross-platform apps for Windows, macOS, Linux, iOS, and Android Book Description: This latest edition is extensively revised to accommodate all the latest features that come with C# 10 and .NET 6. You will learn object-oriented programming, writing, testing, and debugging functions, implementing interfaces, and inheriting classes. The book covers the .NET APIs for performing tasks like managing and querying data, monitoring and improving performance, and working with the filesystem, async streams, serialization, and encryption. It provides examples of cross-platform apps you can build and deploy, such as websites and services using ASP.NET Core. The best application for learning the C# language constructs and many of the .NET libraries does not distract with unnecessary application code. Hence, the C# and .NET topics covered in Chapters 1 to 12 feature console applications. In Chapters 13 to 17, having mastered the basics, you will build practical applications and services using ASP.NET Core, the Model-View-Controller (MVC) pattern, and Blazor. There are also two new online chapters on using .NET MAUI to build cross-platform apps and building services using a variety of technologies, including Web API, OData, gRPC, GraphQL, SignalR, and Azure Functions. What You Will Learn:Build rich web experiences using Blazor, Razor Pages, the Model-View-Controller (MVC) pattern, and other features of ASP.NET Core Build your own types with object-oriented programming Write, test, and debug functions Query and manipulate data using LINQ Integrate and update databases in your apps using Entity Framework Core, Microsoft SQL Server, and SQLite Build and consume powerful services using all the latest technologies, including gRPC and GraphQL Build cross-platform apps using .NET MAUI and XAML Who this book is for: This book is best for beginners to C# and .NET, or programmers who have worked with C# in the past but feel left behind by the changes in the past few years. This book doesn't expect you to have any C# or .NET experience; however, you should have a general understanding of programming. Students and professionals with a science, technology, engineering, or mathematics (STEM) background can certainly benefit from this book.- Shop: buecher
- Price: 59.99 EUR excl. shipping
-
Mastering VMware Horizon 7 - Second Edition (eBook, PDF)
Learn advanced desktop virtualization techniques and strategies and dive deeper into VMware Horizon 7, take responsibility for optimizing your end user experienceAbout This BookBuild better virtualized services for your users with VMware Horizon 7Take full advantage of Horizon's range of features for confidence and control in your virtualized solutionsTake responsibility for transforming your organization - this guide will get you started!Who This Book Is ForAdmins, architects... whatever your role, if you find virtualization a bit of a headache this book is for you. You'll go deep into VMware Horizon and see just what its capable of. It will take you to an advanced level, but at a pace that ensures you're always solving real-world problems. You'll need some experience in desktop management using Windows and Microsoft Office, and familiarity with Active Directory, SQL, Windows Remote Desktop Session Hosting, and VMware vSphere technology.What You Will LearnSuccessfully configure Horizon 7 for the needs of your usersFind out how VMware is perfect for end-user computing delivering virtual desktops, session-based desktops, and hosted applications all from the same platformLearn how to develop, and deploy a complete end-to-end solutionDiscover how to optimize desktop OS images for virtual desktopsBuild, optimize, and tune desktop operating systems to deliver a superior end-user experienceExplore the Horizon 7 infrastructure, so you can take full advantage of it!In DetailDesktop virtualization can be a bit of a headache. But VMware Horizon 7 changes all that. With a rich and adaptive UX, improved security and a range of useful features for storage and networking optimization, there's plenty to love.But to properly fall in love with it, you need to know how to use it. And that means venturing deeper into the software, taking advantage of its extensive range of features, many of which are underused and underpromoted. This guide will take you through everything you need to know to not only successfully virtualize your desktop infrastructure but also to maintain and optimize the infrastructure to keep all your users happy.We'll show you how to assess and analyze your infrastructure, and how to use that analysis to design a solution that meets your organizational and user needs. Once you've done that, you'll find out how to build your virtualized environment, before deploying your virtualized solution. But more than that, we'll also make sure you know everything you need to know about the full range of features on offer, including mobile cloud, so you can use them to take full control of your virtualized infrastructure.Style and approachFocusing on an end-user project, this useful, yet comprehensive guide will show you how to take full advantage of VMware's Horizon 7 solution and how to successfully implement it for your organization.- Shop: buecher
- Price: 40.95 EUR excl. shipping
-
Visual FoxPro 9: Made Simple (eBook, ePUB)
Client-Server Applications with Visual FoxPro KEY FEATURES ● Explain all features of Visual FoxPro in a step-by-step manner.● Various commands, functions and features of Visual FoxPro are explained in detail and illustrated through practical examples.● Provides several useful tips for an efficient use of Visual FoxPro.● Explains Triggers, Referential Integrity, Data Buffering and Transactions in easy-to-understand language Object-Oriented Programming with Visual FoxPro explained in detail. DESCRIPTION Book is based on Visual FoxPro 9 version 6, 7 or 8, as any important command, function or feature not supported in prior versions is clearly stated in the book. The book is organised into 23 chapters and each chapter covers a distinct set of topics. If you are familiar with Visual FoxPro, you may read the chapters in any sequence; however, beginners are advised to read the book from beginning to end.The book covers almost all commands, functions and features of Visual FoxPro. shown with actual screen images of Visual FoxPro 9, running under Windows XP. WHAT YOU WILL LEARN The objective of this book is to help you to become proficient in Visual FoxPro. DBMS (Database Management System) software and its applications are explained in a simple and easy to understand manner. The style adopted in the book will help to learn Visual FoxPro in a step-by-step mode. You don't need to have any prior knowledge about database management or Visual FoxPro. All you require, beside this book, is Visual FoxPro installed on a Windows PC. WHO THIS BOOK IS FOR Book is developed for people who want to learn Visual Foxpro in a relatively short time. It will prove an asset to both fresher as well as experienced computer users and will serve as a solid foundation in making them good and efficient programmers of tomorrow. AUTHOR BIO Ravi Kant Taxali, a prolific writer is the author of many bestsellers-dBASE III PLUS Made Simple, WordStar Professional 4.0 Made Simple, Lotus 1-2-3 Made Simple, PC Software Made Simple, PC Software for Windows 98 Made Simple, IT Tools and Applications and FoxPro 2.5 Made Simple for DOS and Windows. Currently, he is engaged in developing software and websites using Visual FoxPro, SQL Server, MySQL, PERL, PHP, Java and Microsoft Office. He has worked in Department of Electronics (DOE) (now, Department of Information Technology) for over 15 years at various positions. His job profile at DOE included conducting short-term courses on microprocessors, PC software,database design and microprocessor based systems. An Electronics Engineer, he has worked inthe computer industry prior to joining DOE. He has been to USA on a United Nations Development Programme (UNDP) fellowship and to Singapore under the Colombo Plan fellowship to study relational databases. He also contributes technical articles and cartoons to magazines.- Shop: buecher
- Price: 9.49 EUR excl. shipping
-
Pro C# 10 with .NET 6
Welcome to the most comprehensive foundational guide available on the topic of C# coding and .NET. This book goes beyond "do this, to achieve this" to drill down into the core stuff that makes a good developer, great. This expanded 11th edition delivers loads of new content on Entity Framework, Razor Pages, Web APIs and more. You will find the latest C# 10 and .NET 6 features served up with plenty of "behind the curtain" discussion designed to expand developers' critical thinking skills when it comes to their craft. Coverage of ASP.NET Core, Entity Framework Core, and more sits alongside the latest updates to the new unified .NET platform, from performance improvements to Windows Desktop apps on .NET 6, updates in XAML tooling, and expanded coverage of data files and data handling. Going beyond the latest features in C# 10, all code samples are rewritten for this latest release.Dive in and discover why this essential classic is a favorite of C# developers worldwide. Gain a solid foundation in object-oriented development techniques, attributes and reflection, generics and collections, and numerous advanced topics not found in other texts (such as CIL opcodes and emitting dynamic assemblies). Pro C# 10 with .NET 6 will build your coding confidence putting C# into practice, and exploring the .NET universe and its vast potential on your own terms.What You Will LearnExplore C# 10 features and updates in records and record structs, global and implicit using directives, file level namespaces, extended property patterns, and moreDevelop applications with C# and modern frameworks for services, web, and smart client applicationsHit the ground running with ASP.NET Core web applications using MVC and Razor Pages, including view components, custom tag helpers, custom validation, GDPR support, and areasBuild ASP.NET RESTful services complete with versioning, enhanced swagger, and basic authenticationEmbrace Entity Framework Core for building real-world, data-centric applications, with deeply expanded coverage new to this edition including SQL Server temporal table supportDive into Windows Desktop Apps on .NET 6 using Windows Presentation FoundationUnderstand the philosophy behind .NETDiscover the new features in .NET 6, including single file applications, smaller container images, and moreWho This Book Is ForDevelopers of any level who want to either learn C# and .NET or want to take their skills to the next level."Amazing! Provides easy-to-follow explanations and examples. I remember reading the first version of this book; this is a 'must-have' for your collection if you are learning .NET!" - Rick McGuire, Senior Application Development Manager, Microsoft"Phil is a journeyman programmer who brings years of experience and a passion for teaching to make this fully revised and modernized 'classic' a 'must-have'. Any developer who wants full-spectrum, up-to-date coverage of both the C# language and how to use it with .NET and ASP.NET Core should get this book."- Brian A. Randell, Partner, MCW Technologies and Microsoft MVP- Shop: buecher
- Price: 51.00 EUR excl. shipping
-
Data Analysis with Python and Pyspark
Think big about your data! PySpark brings the powerful Spark big data processing engine to the Python ecosystem, letting you seamlessly scale up your data tasks and create lightning-fast pipelines. In Data Analysis with Python and PySpark you will learn how to: Manage your data as it scales across multiple machines Scale up your data programs with full confidence Read and write data to and from a variety of sources and formats Deal with messy data with PySpark's data manipulation functionality Discover new data sets and perform exploratory data analysis Build automated data pipelines that transform, summarize, and get insights from data Troubleshoot common PySpark errors Creating reliable long-running jobs Data Analysis with Python and PySpark is your guide to delivering successful Python-driven data projects. Packed with relevant examples and essential techniques, this practical book teaches you to build pipelines for reporting, machine learning, and other data-centric tasks. Quick exercises in every chapter help you practice what you've learned, and rapidly start implementing PySpark into your data systems. No previous knowledge of Spark is required. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology The Spark data processing engine is an amazing analytics factory: raw data comes in, insight comes out. PySpark wraps Spark's core engine with a Python-based API. It helps simplify Spark's steep learning curve and makes this powerful tool available to anyone working in the Python data ecosystem. About the book Data Analysis with Python and PySpark helps you solve the daily challenges of data science with PySpark. You'll learn how to scale your processing capabilities across multiple machines while ingesting data from any source-whether that's Hadoop clusters, cloud data storage, or local data files. Once you've covered the fundamentals, you'll explore the full versatility of PySpark by building machine learning pipelines, and blending Python, pandas, and PySpark code. What's inside Organizing your PySpark code Managing your data, no matter the size Scale up your data programs with full confidence Troubleshooting common data pipeline problems Creating reliable long-running jobs About the reader Written for data scientists and data engineers comfortable with Python. About the author As a ML director for a data-driven software company, Jonathan Rioux uses PySpark daily. He teaches the software to data scientists, engineers, and data-savvy business analysts. Table of Contents 1 Introduction PART 1 GET ACQUAINTED: FIRST STEPS IN PYSPARK 2 Your first data program in PySpark 3 Submitting and scaling your first PySpark program 4 Analyzing tabular data with pyspark.sql 5 Data frame gymnastics: Joining and grouping PART 2 GET PROFICIENT: TRANSLATE YOUR IDEAS INTO CODE 6 Multidimensional data frames: Using PySpark with JSON data 7 Bilingual PySpark: Blending Python and SQL code 8 Extending PySpark with Python: RDD and UDFs 9 Big data is just a lot of small data: Using pandas UDFs 10 Your data under a different lens: Window functions 11 Faster PySpark: Understanding Spark's query planning PART 3 GET CONFIDENT: USING MACHINE LEARNING WITH PYSPARK 12 Setting the stage: Preparing features for machine learning 13 Robust machine learning with ML Pipelines 14 Building custom ML transformers and estimators- Shop: buecher
- Price: 62.99 EUR excl. shipping
-
Data Analysis with Python and PySpark (eBook, ePUB)
Think big about your data! PySpark brings the powerful Spark big data processing engine to the Python ecosystem, letting you seamlessly scale up your data tasks and create lightning-fast pipelines. In Data Analysis with Python and PySpark you will learn how to: Manage your data as it scales across multiple machines Scale up your data programs with full confidence Read and write data to and from a variety of sources and formats Deal with messy data with PySpark's data manipulation functionality Discover new data sets and perform exploratory data analysis Build automated data pipelines that transform, summarize, and get insights from data Troubleshoot common PySpark errors Creating reliable long-running jobs Data Analysis with Python and PySpark is your guide to delivering successful Python-driven data projects. Packed with relevant examples and essential techniques, this practical book teaches you to build pipelines for reporting, machine learning, and other data-centric tasks. Quick exercises in every chapter help you practice what you've learned, and rapidly start implementing PySpark into your data systems. No previous knowledge of Spark is required. About the technology The Spark data processing engine is an amazing analytics factory: raw data comes in, insight comes out. PySpark wraps Spark's core engine with a Python-based API. It helps simplify Spark's steep learning curve and makes this powerful tool available to anyone working in the Python data ecosystem. About the book Data Analysis with Python and PySpark helps you solve the daily challenges of data science with PySpark. You'll learn how to scale your processing capabilities across multiple machines while ingesting data from any source-whether that's Hadoop clusters, cloud data storage, or local data files. Once you've covered the fundamentals, you'll explore the full versatility of PySpark by building machine learning pipelines, and blending Python, pandas, and PySpark code. What's inside Organizing your PySpark code Managing your data, no matter the size Scale up your data programs with full confidence Troubleshooting common data pipeline problems Creating reliable long-running jobs About the reader Written for data scientists and data engineers comfortable with Python. About the author As a ML director for a data-driven software company, Jonathan Rioux uses PySpark daily. He teaches the software to data scientists, engineers, and data-savvy business analysts. Table of Contents 1 Introduction PART 1 GET ACQUAINTED: FIRST STEPS IN PYSPARK 2 Your first data program in PySpark 3 Submitting and scaling your first PySpark program 4 Analyzing tabular data with pyspark.sql 5 Data frame gymnastics: Joining and grouping PART 2 GET PROFICIENT: TRANSLATE YOUR IDEAS INTO CODE 6 Multidimensional data frames: Using PySpark with JSON data 7 Bilingual PySpark: Blending Python and SQL code 8 Extending PySpark with Python: RDD and UDFs 9 Big data is just a lot of small data: Using pandas UDFs 10 Your data under a different lens: Window functions 11 Faster PySpark: Understanding Spark's query planning PART 3 GET CONFIDENT: USING MACHINE LEARNING WITH PYSPARK 12 Setting the stage: Preparing features for machine learning 13 Robust machine learning with ML Pipelines 14 Building custom ML transformers and estimators- Shop: buecher
- Price: 42.40 EUR excl. shipping