Business Intelligence with Databricks SQL. Concepts, tools, and techniques for scaling business intelligence on the data lakehouse

Vihag Gupta

In this new era of data platform system design, data lakes and data warehouses are giving way to the lakehouse – a new type of data platform system that aims to unify all data analytics into a single platform. Databricks, with its Databricks SQL product suite, is the hottest lakehouse platform out there, harnessing the power of Apache Spark™, Delta Lake, and other innovations to enable data warehousing capabilities on the lakehouse with data lake economics.This book is a comprehensive hands-on guide that helps you explore all the advanced features, use cases, and technology components of Databricks SQL. You’ll start with the lakehouse architecture fundamentals and understand how Databricks SQL fits into it. The book then shows you how to use the platform, from exploring data, executing queries, building reports, and using dashboards through to learning the administrative aspects of the lakehouse – data security, governance, and management of the computational power of the lakehouse. You’ll also delve into the core technology enablers of Databricks SQL – Delta Lake and Photon. Finally, you’ll get hands-on with advanced SQL commands for ingesting data and maintaining the lakehouse.By the end of this book, you’ll have mastered Databricks SQL and be able to deploy and deliver fast, scalable business intelligence on the lakehouse.

IBM SPSS Modeler Cookbook. If you've already had some experience with IBM SPSS Modeler this cookbook will help you delve deeper and exploit the incredible potential of this data mining workbench. The recipes come from some of the best brains in the business

Keith McCormick, Thomas J Khabaza, Dean Abbott, Meta S. Brown, ...

IBM SPSS Modeler is a data mining workbench that enables you to explore data, identify important relationships that you can leverage, and build predictive models quickly allowing your organization to base its decisions on hard data not hunches or guesswork.IBM SPSS Modeler Cookbook takes you beyond the basics and shares the tips, the timesavers, and the workarounds that experts use to increase productivity and extract maximum value from data. The authors of this book are among the very best of these exponents, gurus who, in their brilliant and imaginative use of the tool, have pushed back the boundaries of applied analytics. By reading this book, you are learning from practitioners who have helped define the state of the art.Follow the industry standard data mining process, gaining new skills at each stage, from loading data to integrating results into everyday business practices. Get a handle on the most efficient ways of extracting data from your own sources, preparing it for exploration and modeling. Master the best methods for building models that will perform well in the workplace.Go beyond the basics and get the full power of your data mining workbench with this practical guide.

Clean Android Architecture. Take a layered approach to writing clean, testable, and decoupled Android applications

As an application’s code base increases, it becomes harder for developers to maintain existing features and introduce new ones. In this clean architecture book, you'll learn to identify when and how this problem emerges and how to structure your code to overcome it.The book starts by explaining clean architecture principles and Android architecture components and then explores the tools, frameworks, and libraries involved. You’ll learn how to structure your application in the data and domain layers, the technologies that go in each layer, and the role that each layer plays in keeping your application clean. You’ll understand how to arrange the code into these two layers and the components involved in assembling them. Finally, you'll cover the presentation layer and the patterns that can be applied to have a decoupled and testable code base.By the end of this architecture book, you'll be able to build an application following clean architecture principles and have the knowledge you need to maintain and test the application easily.

Microsoft Cybersecurity Architect Exam Ref SC-100. Get certified with ease while learning how to develop highly effective cybersecurity strategies

Microsoft Cybersecurity Architect Exam Ref SC-100 is a comprehensive guide that will help cybersecurity professionals design and evaluate the cybersecurity architecture of Microsoft cloud services. Complete with hands-on tutorials, projects, and self-assessment questions, you’ll have everything you need to pass the SC-100 exam.This book will take you through designing a strategy for a cybersecurity architecture and evaluating the governance, risk, and compliance (GRC) of the architecture. This will include cloud-only and hybrid infrastructures, where you’ll learn how to protect using the principles of zero trust, along with evaluating security operations and the overall security posture. To make sure that you are able to take the SC-100 exam with confidence, the last chapter of this book will let you test your knowledge with a mock exam and practice questions.By the end of this book, you’ll have the knowledge you need to plan, design, and evaluate cybersecurity for Microsoft cloud and hybrid infrastructures, and pass the SC-100 exam with flying colors.

Implementing Enterprise Observability for Success. Strategically plan and implement observability using real-life examples

Manisha Agrawal, Karun Krishnannair

Observability can be implemented in multiple ways within an organization based on the organization’s needs. So, it’s crucial for organizations to decide whether they need observability and to what extent, what skills and tools will suit them, and how long will it take to implement it. Implementing Enterprise Observability for Success provides a step-by-step approach to help you create an observability strategy, understand the principles behind the creation of the strategy, and logical steps to plan and execute the implementation.You’ll learn about observability fundamentals and challenges, the importance of data and analytics along with different tools. Further, you’ll discover the various layers from which data should be collected for setting up observability.Through real- life examples distilled from the author's experience in implementing observability at an enterprise level, you’ll uncover some of the non-technical & technical drivers of observability like the culture of the organization, the hierarchy of stakeholders, tools at disposal and the willingness to invest.By the end of this book, you’ll be well-equipped to plan the observability journey, identify different stakeholders, spot the technology stack required, and lay out an effective plan for organization-wide adoption.

Reimagine Remote Working with Microsoft Teams. A practical guide to increasing your productivity and enhancing collaboration in the remote world

Sathish Veerapandian, Harsharanjeet Kaur, Ashok Madhvarayan, Sriram Rajamanickam

The outbreak of the pandemic has forced the world to embrace remote working and the modern style of virtual business. However, end users may find it challenging to cope with this sudden change in working style, not aware of all the features and remote working tools available to make their life easy. Microsoft Teams is an exceptional platform, adopted by many organizations for unified communication and collaboration, and this book will help you to make the most of its capabilities.Complete with step-by-step explanations and screenshots, this book guides you through the topics that you'll find useful in your daily use of Teams. You'll learn how to manage your teams and projects with Microsoft Teams in a structured and organized way. The book provides hands-on information with a focus on the end user side to help corporate users to increase productivity and become a Microsoft Teams superuser. Finally, you'll explore the most effective ways of using the app with best practices and tips and tricks for making the most of the features available for your scenario.By the end of this Microsoft Teams book, you'll have mastered Microsoft Teams and be fully equipped as a modern collaboration end user to effectively increase your remote work productivity.

Building Micro Frontends with React 18. Develop and deploy scalable applications using micro frontend strategies

Vinci J Rufus

Although deservedly popular and highly performant tools for building modern web applications, React and single-page applications (SPAs) become more and more sluggish as your applications and teams grow. To solve this problem, many large web apps have started to break down monolith SPAs into independently deployable smaller apps and components—a pattern called micro frontends. But micro frontends aren't a perfect solution, but rather a double-edged sword. This book teaches you how to architect and build them with the right principles to reap all the benefits without the pitfalls.This book will take you through two patterns of building micro frontends, the multi-SPA pattern and the micro apps pattern. You’ll find out which patterns to use and when, as well as take a look at the nuances of deploying these micro frontends using cloud-native technologies such as Kubernetes and Firebase. With the help of this book, you’ll gain an in-depth understanding of state management, solving problems with routing, and deployment strategies between the different micro frontends.By the end of this book, you’ll have learned how to design and build a React-based micro frontend application using module federation and deploy it to the cloud efficiently.

Liferay Portal 6.2 Enterprise Intranets. A practical guide to adopting portal development best practices in an Enterprise world

UiPath Associate Certification Guide. The go-to guide to passing the Associate certification exam with the help of mock tests and quizzes

Niyaz Ahmed, Lahiru Fernando, Rajaneesh Balakrishnan

UiPath is the most popular vendor in the Robotic Process Automation (RPA) industry. If you're an RPA enthusiast or citizen developer who wants to succeed in the industry, achieving this certification can help you get accredited and ready for real-world challenges using UiPath.UiPath Associate Certification Guide offers complete, up-to-date coverage of the UiPath RPA Associate certification exam to help you pass on the first attempt and get certified. The book is written in a clear, succinct way with self-assessment questions, quizzes with answers at the end of each chapter, exam tips, and mock exams with detailed answers and explanations. You'll start by getting to grips with the basic concepts of UiPath RPA, and then progress to an in-depth discussion of all the concepts required for Associate certification. Finally, you'll develop UiPath skills by gaining the required knowledge and implement these skills using sample business cases.By the end of this UiPath book, you'll have covered everything you need to pass the exam, gained the knowledge you need to work on real-world case studies, and learned how to apply the various concepts to build enterprise-level use cases.

Building Data Science Applications with FastAPI. Develop, manage, and deploy efficient machine learning applications with Python

François Voron

FastAPI is a web framework for building APIs with Python 3.6 and its later versions based on standard Python-type hints. With this book, you’ll be able to create fast and reliable data science API backends using practical examples.This book starts with the basics of the FastAPI framework and associated modern Python programming language concepts. You'll be taken through all the aspects of the framework, including its powerful dependency injection system and how you can use it to communicate with databases, implement authentication and integrate machine learning models. Later, you’ll cover best practices relating to testing and deployment to run a high-quality and robust application. You’ll also be introduced to the extensive ecosystem of Python data science packages. As you progress, you’ll learn how to build data science applications in Python using FastAPI. The book also demonstrates how to develop fast and efficient machine learning prediction backends and test them to achieve the best performance. Finally, you’ll see how to implement a real-time face detection system using WebSockets and a web browser as a client.By the end of this FastAPI book, you’ll have not only learned how to implement Python in data science projects but also how to maintain and design them to meet high programming standards with the help of FastAPI.

BMC Control-M 7: A Journey from Traditional Batch Scheduling to Workload Automation

Qiang Ding

Control-M is one of the most widely used enterprise class batch workload automation platform. With a strong knowledge of Control-M, you will be able to use the tool to meet ever growing batch needs. There has been no book that can guide you to implement and manage this powerful tool successfully... until now. With this book you will quickly master Control-M and be able to call yourself a Control-M specialist!BMC Control-M 7: A Journey from Traditional Batch Scheduling to Workload Automation will lead you into the world of Control-M and guide you to implement and maintain a Control-M environment successfully. By mastering this workload automation tool, you will see new opportunities opening up before you.With this book you will be able to take away and put into practice knowledge from every aspect of Control-M ñ implementation, administration, design and management of Control-M job flows, and more importantly how to move into workload automation and let batch processing utilize the cloud.You will start off with batch processing and workload automation, and then get an understanding of how Control-M meets these needs. Then we will look more in depth at the technical details of Control-M, and finally look at how to work with it to meet critical business needs. Throughout the book, you will learn important concepts and features, as well as learn from the Author's experience, accumulated over many years. By the end of the book you will be set up to work efficiently with this tool and also understand how to utilize the latest features of Control-M.

Getting Started with OpenCart Module Development. Master your OpenCart modules and code!

Rupak Nepali

OpenCart is an online shopping tool which is free to use. It has become widely popular because of its support for custom extensions and module development. This book helps you understand how to use the features available in OpenCart using step-by-step instructions.Getting Started with OpenCart Module Development gives you step-by-step explanations and illustrations on how to clone, customize, and develop modules and pages with OpenCart.This book shows you how to create custom OpenCart modules and pages which are needed as per the requirements of the clients to manage custom data. It describes each and every code used to make a Hello World module, a feedback module, a tips module, an order total module, and a shipping and payment module.The book covers installing, configuring, and uninstalling modules as well as how to clone them. It also discusses all the available Global Library methods of OpenCart as well as ways to handle the files and folders of a shipping and payment module. At the end of the book, you will learn how to make custom pages to manage data by creating a feedback module and how to create the order total using a tips module.In Getting Started with OpenCart Module Development, you will learn everything you need to know to create custom OpenCart modules.

Teaching with iPad How-To. Use your iPad creatively for everyday teaching tasks in schools and universities with this book and

Sumit Kataria, Shubhangi Harsha

The iPad is a great teaching tool. It is an amazing eReader for accessing textbooks and journals. It is also great for multimedia content like videos, audio, presentations, and 3D animations. Most importantly Apple's app ecosystem makes it very powerful. You can find apps for almost any teaching task in app store and use them instantly.You will start with simple tasks like creating presentations and visualizations. Soon you will be making interactive books and resources as well as teaching practical lessons such as music and art! Teaching with iPad How-to starts with the most basic task of planning your lessons. As you go through the book you will learn how to 'carry' your textbooks on Little Books, create your own resources and finally publish your courseware.Be it organizing your notes, creating charts and presentations, or just recording attendance, this book will help you do all these tasks very efficiently on your iPad. In this book, you will also learn to create and distribute timetables, create your own textbooks and make your classes interesting and full of information by using the iPad's 3D and subject-specific resources.You will learn to make your teaching job interesting and engaging for your students by using iPad as your teaching and organizing tool.

Learning RHEL Networking. Gain Linux administration skills by learning new networking concepts in Red Hat Enterprise Linux 7

Practical Machine Learning. Learn how to build Machine Learning applications to solve real-world data analysis challenges with this Machine Learning book – packed with practical tutorials

Sunila Gollapudi

This book explores an extensive range of machine learning techniques uncovering hidden tricks and tips for several types of data using practical and real-world examples. While machine learning can be highly theoretical, this book offers a refreshing hands-on approach without losing sight of the underlying principles. Inside, a full exploration of the various algorithms gives you high-quality guidance so you can begin to see just how effective machine learning is at tackling contemporary challenges of big dataThis is the only book you need to implement a whole suite of open source tools, frameworks, and languages in machine learning. We will cover the leading data science languages, Python and R, and the underrated but powerful Julia, as well as a range of other big data platforms including Spark, Hadoop, and Mahout. Practical Machine Learning is an essential resource for the modern data scientists who want to get to grips with its real-world application.With this book, you will not only learn the fundamentals of machine learning but dive deep into the complexities of real world data before moving on to using Hadoop and its wider ecosystem of tools to process and manage your structured and unstructured data. You will explore different machine learning techniques for both supervised and unsupervised learning; from decision trees to Naïve Bayes classifiers and linear and clustering methods, you will learn strategies for a truly advanced approach to the statistical analysis of data. The book also explores the cutting-edge advancements in machine learning, with worked examples and guidance on deep learning and reinforcement learning, providing you with practical demonstrations and samples that help take the theory–and mystery–out of even the most advanced machine learning methodologies.

WordPress 3 Ultimate Security. WordPress is for everyone and so is this brilliant book on making your site impenetrable to hackers. This jargon-lite guide covers everything from stopping content scrapers to understanding disaster recovery

Most likely – today – some hacker tried to crack your WordPress site, its data and content – maybe once but, with automated tools, very likely dozens or hundreds of times. There's no silver bullet but if you want to cut the odds of a successful attack from practically inevitable to practically zero, read this book.WordPress 3 Ultimate Security shows you how to hack your site before someone else does. You'll uncover its weaknesses before sealing them off, securing your content and your day-to-day local-to-remote editorial process. This is more than some 10 Tips ... guide. It's ultimate protection – because that's what you need.Survey your network, using the insight from this book to scan for and seal the holes before galvanizing the network with a rack of cool tools. Solid!The WordPress platform is only as safe as the weakest network link, administrator discipline, and your security knowledge. We'll cover the bases, underpinning your working process from any location, containing content, locking down the platform, your web files, the database, and the server. With that done, your ongoing security is infinitely more manageable.Covering deep-set security yet enjoyable to read, WordPress 3 Ultimate Security will multiply your understanding and fortify your site.