- Table View
- List View
Learn Office 2016 for Mac
by Guy Hart-DavisOffice for Mac remains the leading productivity suite for Mac, with Apple's iWork and the free OpenOffice. org trailing far behind. Now, it's been updated with a cleaner interface and more compatibility with Exchange and SharePoint. Learn Office 2011 for Mac OS X offers a practical, hands-on approach to using Office 2011 applications to create and edit documents and get work done efficiently. You'll learn how to customize Office, design, create, and share documents, manipulate data in a spreadsheet, and create lively presentations. You'll also discover how to organize your email, contacts, and tasks with the new Outlook for Mac. Conveying information quickly and concisely, the book brings you from beginner or intermediate to an experienced and confident user. This book provides the best combination of accessible and focused coverage of the Office 2011 applications. Rather than cover every seldom-used feature, the book covers real-world usage, putting emphasis on practical tasks and troubleshooting common problems, such as sharing documents with Windows users and older versions of Office. "
Learn OpenCV 4 by Building Projects: Build real-world computer vision and image processing applications with OpenCV and C++, 2nd Edition (02 RRP including tax)
by Prateek Joshi David Millán Escrivá Vinícius G. MendonçaExplore OpenCV 4 to create visually appealing cross-platform computer vision applicationsKey FeaturesUnderstand basic OpenCV 4 concepts and algorithmsGrasp advanced OpenCV techniques such as 3D reconstruction, machine learning, and artificial neural networksWork with Tesseract OCR, an open-source library to recognize text in imagesBook DescriptionOpenCV is one of the best open source libraries available, and can help you focus on constructing complete projects on image processing, motion detection, and image segmentation. Whether you’re completely new to computer vision, or have a basic understanding of its concepts, Learn OpenCV 4 by Building Projects – Second edition will be your guide to understanding OpenCV concepts and algorithms through real-world examples and projects. You’ll begin with the installation of OpenCV and the basics of image processing. Then, you’ll cover user interfaces and get deeper into image processing. As you progress through the book, you'll learn complex computer vision algorithms and explore machine learning and face detection. The book then guides you in creating optical flow video analysis and background subtraction in complex scenes. In the concluding chapters, you'll also learn about text segmentation and recognition and understand the basics of the new and improved deep learning module.By the end of this book, you'll be familiar with the basics of Open CV, such as matrix operations, filters, and histograms, and you'll have mastered commonly used computer vision techniques to build OpenCV projects from scratch.What you will learnInstall OpenCV 4 on your operating systemCreate CMake scripts to compile your C++ applicationUnderstand basic image matrix formats and filtersExplore segmentation and feature extraction techniquesRemove backgrounds from static scenes to identify moving objects for surveillanceEmploy various techniques to track objects in a live videoWork with new OpenCV functions for text detection and recognition with TesseractGet acquainted with important deep learning tools for image classificationWho this book is forIf you are a software developer with a basic understanding of computer vision and image processing and want to develop interesting computer vision applications with OpenCV, Learn OpenCV 4 by Building Projects for you. Prior knowledge of C++ will help you understand the concepts covered in this book.
Learn OpenGL: Beginner's guide to 3D rendering and game development with OpenGL and C++
by Frahaan HussainA step-by-step instructional guide to understanding the fundamentals of game development with OpenGL. Right from the setup to the important features, we'll get a better understanding of games and the engines behind them.Key FeaturesLearn the basics of drawing along with fundamentals of shading to create amazing objects.Get in-depth knowledge of lighting and materials to make realistic objects.Understand the fundamentals of model loading and cube mapping.Book DescriptionLearn OpenGL is your one-stop reference guide to get started with OpenGL and C++ for game development. From setting up the development environment to getting started with basics of drawing and shaders, along with concepts such as lighting, model loading, and cube mapping, this book will get you up to speed with the fundamentals.You begin by setting up your development environment to use OpenGL on Windows and macOS. With GLFW and GLEW set up using absolute and relative linking done, you are ready to setup SDL and SFML for both the operating systems.Now that your development environment is set up, you'll learn to draw using simple shaders as well as make the shader more adaptable and reusable. Then we move on to more advanced topics like texturing your objects with images and transforming your objects using translate, rotate and scale.With these concepts covered, we'll move on to topics like lighting to enable you to incorporate amazing dynamic lights in your game world.By the end of the book, you'll learn about model loading, right from setting up ASSIMP to learning about the model class and loading a model in your game environment. We will conclude by understanding cube mapping to bring advance worlds to your game.What you will learnSet up GLFW and GLEW on Windows and macOS with absolute, relative LinkingSet up SDL and SFML on your system using absolute and relative LinkingDraw using the simple shadersCreate a camera and learn to populate your game world with objectsLearn about color and lighting concepts to create an amazing game worldUnderstand model loading and cube mapping to advance your gameWho this book is forThis book is targeted towards anyone and everyone who is interested in creating games, learning how game engines work and most importantly for anyone who is interested in learning OpenGL. The ideal reader for this book would be anyone with a passion for learning game development or looking out for an OpenGL reference guide. The skills that you'll learn in this book will be applicable to all your game development needs. You'll require a strong foundation in C++ to understand and apply the concepts of this book.
Learn OpenGL ES
by Prateek MehtaWant to create sophisticated games and graphics-intensive apps? Learn OpenGL ES gets you started immediately with OpenGL ES. After mastering the basics of OpenGL ES itself, you will quickly find yourself writing and building game apps, without having to learn about object oriented programming techniques. This book demonstrates the use of a powerful open-source modeling tool, Blender. You will be guided, step by step, through the development of Tank Fence, a dynamic, interactive 3D game. Along the way you'll gain skills in building apps with Eclipse and the Android SDK or NDK, rendering graphics using hardware acceleration, and multithreading for performance and responsiveness. iOS developers will also find this book's information invaluable when writing their apps. You'll learn everything you need to know about: Creating simple, efficient game UIs Designing the basic building blocks of an exciting, interactive 3D game Pulling all the elements together with Blender, a powerful open-source tool for modeling, animation, rendering, compositing, video editing, and game creation Taking the next big step using custom and inbuilt functions, texturing, shading, light sources, and more Refining your mobile game app through collision detection, player-room-obstacle classes, and storage classes Doing all this efficiently on mobile devices with limited resources and processing What you'll learn How to install and use OpenGL ES 2. 0 on Android GLSL ES Fundamentals State Management Modeling 3D Objects Using Blender Using the Perl Mesh Parser Vertex Buffer Objects Using Color Masks sampler2D and samplerCube Uniforms Multi-Texturing Lambert Illumination Model Implementing the Lighting Equation Design, write, and build Tank Fence, an interactive 3D game Who this book is for Learn OpenGL ES is ideal for mobile game and interactive app developers who want to know more about the OpenGL ES engine and and use it to build more sophisticated, graphically-rich games and other apps. While the code is developed on Android, iOS developers will also find this book invaluable. Table of Contents 1. Why OpenGL ES? 2. UI for games: Keep it simple 3. First Steps: Mobile Game App Development 4. 3D Modeling 5. Functions, Shading, Light Source and Objects 6. Carrying Further: Collision Detection
Learn OpenOffice.org Spreadsheet Macro Programming: OOoBasic and Calc automation
by Dr Mark Alexander BainA fast, fun, and friendly tutorial. Full of practical, step-by-step examples and clear explanations of all of the important concepts. ou don't need to be a programmer to use this book, but you do need to be familiar with the concept of a program and how simple things like a loop might work. If all you have is a taster of simple programs from high school then you will be fine.
Learn OpenShift: Deploy, build, manage, and migrate applications with OpenShift Origin 3.9
by Denis Zuev Aleksey Usov Artemii KropachevGain hands-on experience of installing OpenShift Origin 3.9 in a production configuration and managing applications using the platform you builtKey FeaturesGain hands-on experience of working with Kubernetes and DockerLearn how to deploy and manage applications in OpenShiftGet a practical approach to managing applications on a cloud-based platformExplore multi-site and HA architectures of OpenShift for productionBook DescriptionDocker containers transform application delivery technologies to make them faster and more reproducible, and to reduce the amount of time wasted on configuration. Managing Docker containers in the multi-node or multi-datacenter environment is a big challenge, which is why container management platforms are required. OpenShift is a new generation of container management platforms built on top of both Docker and Kubernetes. It brings additional functionality to the table, something that is lacking in Kubernetes. This new functionality significantly helps software development teams to bring software development processes to a whole new level.In this book, we’ll start by explaining the container architecture, Docker, and CRI-O overviews. Then, we'll look at container orchestration and Kubernetes. We’ll cover OpenShift installation, and its basic and advanced components. Moving on, we’ll deep dive into concepts such as deploying application OpenShift. You’ll learn how to set up an end-to-end delivery pipeline while working with applications in OpenShift as a developer or DevOps. Finally, you’ll discover how to properly design OpenShift in production environments.This book gives you hands-on experience of designing, building, and operating OpenShift Origin 3.9, as well as building new applications or migrating existing applications to OpenShift.What you will learnUnderstand the core concepts behind containers and container orchestration toolsUnderstand Docker, Kubernetes, and OpenShift, and their relation to CRI-OInstall and work with Kubernetes and OpenShiftUnderstand how to work with persistent storage in OpenShiftUnderstand basic and advanced components of OpenShift, including security and networkingManage deployment strategies and application’s migration in OpenShiftUnderstand and design OpenShift high availability Who this book is forThe book is for system administrators, DevOps engineers, solutions architects, or any stakeholder who wants to understand the concept and business value of OpenShift.
Learn Penetration Testing: Understand the art of penetration testing and develop your white hat hacker skills
by Rishalin PillayGet up to speed with various penetration testing techniques and resolve security threats of varying complexityKey FeaturesEnhance your penetration testing skills to tackle security threatsLearn to gather information, find vulnerabilities, and exploit enterprise defensesNavigate secured systems with the most up-to-date version of Kali Linux (2019.1) and Metasploit (5.0.0)Book DescriptionSending information via the internet is not entirely private, as evidenced by the rise in hacking, malware attacks, and security threats. With the help of this book, you'll learn crucial penetration testing techniques to help you evaluate enterprise defenses.You'll start by understanding each stage of pentesting and deploying target virtual machines, including Linux and Windows. Next, the book will guide you through performing intermediate penetration testing in a controlled environment. With the help of practical use cases, you'll also be able to implement your learning in real-world scenarios. By studying everything from setting up your lab, information gathering and password attacks, through to social engineering and post exploitation, you'll be able to successfully overcome security threats. The book will even help you leverage the best tools, such as Kali Linux, Metasploit, Burp Suite, and other open source pentesting tools to perform these techniques. Toward the later chapters, you'll focus on best practices to quickly resolve security threats.By the end of this book, you'll be well versed with various penetration testing techniques so as to be able to tackle security threats effectivelyWhat you will learnPerform entry-level penetration tests by learning various concepts and techniquesUnderstand both common and not-so-common vulnerabilities from an attacker's perspectiveGet familiar with intermediate attack methods that can be used in real-world scenariosUnderstand how vulnerabilities are created by developers and how to fix some of them at source code levelBecome well versed with basic tools for ethical hacking purposesExploit known vulnerable services with tools such as MetasploitWho this book is forIf you’re just getting started with penetration testing and want to explore various security domains, this book is for you. Security professionals, network engineers, and amateur ethical hackers will also find this book useful. Prior knowledge of penetration testing and ethical hacking is not necessary.
Learn pfSense 2.4: Get up and running with Pfsense and all the core concepts to build firewall and routing solutions
by David ZientaraInstall, Configure and Setup different connections with pfSenseKey FeaturesBuild firewall and routing solutions with PfSense.Learn how to create captive portals, how to connect Pfsense to your https environment and so on.Practical approach towards building firewall solutions for your organizationBook DescriptionAs computer networks become ubiquitous, it has become increasingly important to both secure and optimize our networks. pfSense, an open-source router/firewall, provides an easy, cost-effective way of achieving this – and this book explains how to install and configure pfSense in such a way that even a networking beginner can successfully deploy and use pfSense.This book begins by covering networking fundamentals, deployment scenarios, and hardware sizing guidelines, as well as how to install pfSense. The book then covers configuration of basic services such as DHCP, DNS, and captive portal and VLAN configuration. Careful consideration is given to the core firewall functionality of pfSense, and how to set up firewall rules and traffic shaping. Finally, the book covers the basics of VPNs, multi-WAN setups, routing and bridging, and how to perform diagnostics and troubleshooting on a network.What you will learnInstall pfSenseConfigure additional interfaces, and enable and configure DHCPUnderstand Captive portalUnderstand firewalls and NAT, and traffic shapingLearn in detail about VPNsUnderstand Multi-WANLearn about routing and bridging in detailUnderstand the basics of diagnostics and troubleshooting networksWho this book is forThis book is towards any network security professionals who want to get introduced to the world of firewalls and network configurations using Pfsense. No knowledge of PfSense is required
Learn PHP 7
by Steve PrettymanThis new book on PHP 7 introduces writing solid, secure, object-oriented code in the new PHP 7: you will create a complete three-tier application using a natural process of building and testing modules within each tier. This practical approach teaches you about app development and introduces PHP features when they are actually needed rather than providing you with abstract theory and contrived examples. In Learn PHP 7, programming examples take advantage of the newest PHP features, including enhanced password encryption using password_hash. This book takes a learn-by-doing approach, providing you with complete coding examples. "Do It" exercises in each chapter provide the opportunity to make adjustments to the example code. The end of chapter programming exercises allow you to develop your own applications using the algorithms demonstrated in the chapter. Each tier is logically and physically separated using object-oriented and dependency injection techniques, thus allowing independent tiers that can be updated with little or no effect on the other tiers. In addition to teaching good programming practices through OOP, there is a strong emphasis on creating secure code. As each chapter is completed, the reader is provide the opportunity to design and create an application reinforcing the concepts learned. What you'll learn What are the PHP 7 language basics: conditional statements, loops, arrays, and methods (functions) How to combine PHP with HTML5, CSS3, and JavaScript to create web applications How to work with XML, JSON, and MySQL data How to use secure coding techniques How to create error logs, user logs, and application logs What are the various backup and recovery techniques How to use Try/Catch blocks as emphasized with PHP 7 to handle program exceptions Who this book is for This book is for those who are new to PHP and new to the new PHP 7 programming language, the most popular for web development. Table of Contents 1. Introduction to PHP 7 2. Interfaces, Platforms, Containers: Three-Tiers Programming 3. Modular Programming 4. Secure User Interfaces 5. Handling and Logging Exceptions 6. Data Objects 7. Authentication 8. Multi-functional Interfaces
Learn PHP 8: Using MySQL, JavaScript, CSS3, and HTML5
by Steve PrettymanWrite solid, secure, object-oriented code in the new PHP 8. In this book you will create a complete three-tier application using a natural process of building and testing modules within each tier. This practical approach teaches you about app development and introduces PHP features when they are actually needed rather than providing you with abstract theory and contrived examples. In Learn PHP 8, programming examples take advantage of the newest PHP features; you’ll follow a learn-by-doing approach, which provides you with complete coding examples. “Do It” exercises in each chapter provide the opportunity to make adjustments to the example code. The end-of-chapter programming exercises allow you to develop your own applications using the algorithms demonstrated in the chapter. Each tier is logically and physically separated using object-oriented and dependency injection techniques, thus allowing independent tiers that can be updated with little or no effect on the other tiers. In addition to teaching good programming practices through OOP, there is a strong emphasis on creating secure code. As each chapter is completed, you’ll have the opportunity to design and create an application reinforcing the concepts learned. What You Will Learn Program PHP 8 web applications Use interfaces, containers, and platforms Apply modular programming Manage data objects and use MySQL and other databases Work with multi-functional and secure user interfaces Handle logging exceptions and more Who This Book Is For Those new to web development, specifically PHP programming. Also, this book can be useful to those who have some PHP/web development experience who are new to PHP 8.
Learn Physics with Functional Programming: A Hands-on Guide to Exploring Physics with Haskell
by Scott N. WalckDeepen your understanding of physics by learning to use the Haskell functional programming language.Learn Physics with Functional Programming is your key to unlocking the mysteries of theoretical physics by coding the underlying math in Haskell.You&’ll use Haskell&’s type system to check that your code makes sense as you deepen your understanding of Newtonian mechanics and electromagnetic theory, including how to describe and calculate electric and magnetic fields.As you work your way through the book&’s numerous examples and exercises, you&’ll learn how to:Encode vectors, derivatives, integrals, scalar fields, vector fields, and differential equationsExpress fundamental physical principles using the logic of Haskell&’s type system to clarify Newton&’s second law, Coulomb&’s law, the Biot-Savart law, and the Maxwell equationsUse higher-order functions to express numerical integration and approximation methods, such as the Euler method and the finite-difference time-domain (FDTD) methodCreate graphs, models, and animations of physical scenarios like colliding billiard balls, waves in a guitar string, and a proton in a magnetic fieldWhether you&’re using this book as a core textbook for a computational physics course or for self-study, Learn Physics with Functional Programming will teach you how to use the power of functional programming to explore the beautiful ideas of theoretical physics.
Learn Pixi.js
by Rex SpuyCreate and display interactive graphics, build scenes and animated transitions, make cross-platform, responsive games and applications for multiple screen resolutions, and use Pixi. js's spectacular WebGL rendering effects. Learn how to create applications for desktop and touch-screen devices, and how to use the best open-source plugins to extend Pixi. js's capabilities in a myriad of exciting ways. If you've ever wondered what you need to know to start making games, or what technology you need to build high-performance mobile apps, this book will show you the way. Learn Pixi. js is your one-stop shop for everything you need to know to quickly start making spectacular cross-platform interactive games and animations. Take a step-by-step tour of Pixi. js's features by building fun game projects. Learn how to use Pixi. js to make richly interactive graphics and all kind of cross-platform applications. Learn Pixi. js is a fun and practical brief introduction to using the powerful Pixi. js graphics-rendering engine for making websites, games and mobile apps. What you'll learn Make high-performance interactive games and mobile applications Create responsive applications for multiple resolutions and screen sizes Create multi-touch applications Learn to use ES6, the latest version of JavaScript Who this book is for Learn Pixi. js is for intermediate JavaScript or web developers who want to dive head-first into making high performance games and mobile applications. It's for creative self-starters who learn by example and want to quickly apply what they've learnt to their own projects. Learn Pixi. js is a non-technical and friendly guide to help you take your JavaScript and game development skills to the next level. Table of Contents Chapter 1: Making sprites Chapter 2: Moving sprites Chapter 3: Making shapes Chapter 4: Collision Detection Chapter 5: Animating Sprites Chapter 6: Visual Effects and Transitions Chapter 7: Mouse and Touch Events
Learn PostgreSQL: Build and manage high-performance database solutions using PostgreSQL 12 and 13
by Enrico Pirozzi Luca FerrariA comprehensive guide to building, managing, and securing scalable and reliable database and data warehousing applications using Postgres 12 and 13 Key Features Set up your database cluster and monitor, secure, and fine-tune it for optimal performance Learn the fundamentals of database management and implement client- and server-side programming using SQL and PL/pgSQL Explore useful tips to develop efficient PostgreSQL database solutions from scratch Book Description PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it's scalable and highly efficient. In this book, you'll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this guide will teach you how to achieve the right database design required for a reliable environment. You'll learn how to install and configure a PostgreSQL server and even manage users and connections. The book then progresses to key concepts of relational databases, before taking you through the Data Definition Language (DDL) and commonly used DDL commands. To build on your skills, you'll understand how to interact with the live cluster, create database objects, and use tools to connect to the live cluster. You'll then get to grips with creating tables, building indexes, and designing your database schema. Later, you'll explore the Data Manipulation Language (DML) and server-side programming capabilities of PostgreSQL using PL/pgSQL, before learning how to monitor, test, and troubleshoot your database application to ensure high-performance and reliability. By the end of this book, you'll be well-versed with the Postgres database and be able to set up your own PostgreSQL instance and use it to build robust solutions. What you will learn Understand how users and connections are managed by running a PostgreSQL instance Interact with transaction boundaries using server-side programming Identify bottlenecks to maintain your database efficiently Create and manage extensions to add new functionalities to your cluster Choose the best index type for each situation Use online tools to set up a memory configuration that will suit most databases Explore how Postgres can be used in multi-instance environments to provide high-availability, redundancy, and scalability Who this book is for This Postgres book is for anyone interested in learning about the PostgreSQL database from scratch. Anyone looking to build robust data warehousing applications and scale the database for high-availability and performance using the latest features of PostgreSQL will also find this book useful. Although prior knowledge of PostgreSQL is not required, familiarity with databases is expected.
Learn Power BI: A beginner's guide to developing interactive business intelligence solutions using Microsoft Power BI
by Greg DecklerSolve business challenges with Microsoft Power BI's advanced visualization and data analysis techniques Key Features Create effective storytelling reports by implementing simple-to-intermediate Power BI features Develop powerful analytical models to extract key insights for changing business needs Build, publish, and share impressive dashboards for your organization Book Description To succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This Power BI book is an entry-level guide that will get you up and running with data modeling, visualization, and analytical techniques from scratch. You'll find this book handy if you want to get well-versed with the extensive Power BI ecosystem. You'll start by covering the basics of business intelligence and installing Power BI. You'll then learn the wide range of Power BI features to unlock business insights. As you progress, the book will take you through how to use Power Query to ingest, cleanse, and shape your data, and use Power BI DAX to create simple to complex calculations. You'll also be able to add a variety of interactive visualizations to your reports to bring your data to life. Finally, you'll gain hands-on experience in creating visually stunning reports that speak to business decision makers, and see how you can securely share these reports and collaborate with others. By the end of this book, you'll be ready to create simple, yet effective, BI reports and dashboards using the latest features of Power BI. What you will learn Explore the different features of Power BI to create interactive dashboards Use the Query Editor to import and transform data Perform simple and complex DAX calculations to enhance analysis Discover business insights and tell a story with your data using Power BI Explore data and learn to manage datasets, dataflows, and data gateways Use workspaces to collaborate with others and publish your reports Who this book is for If you're an IT manager, data analyst, or BI user new to using Power BI for solving business intelligence problems, this book is for you. You'll also find this book useful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.
Learn Power BI: A comprehensive, step-by-step guide for beginners to learn real-world business intelligence, 2nd Edition
by Greg DecklerLearn how to use Power BI to deliver the insights needed to help your enterprise survive and thriveKey FeaturesLearn simple through to advanced Power BI features in a clear, concise way using real-world examplesDevelop powerful analytical models and reports that extract key business insightsPublish, share and collaborate on impressive reports, dashboards, apps, and goalsBook DescriptionTo succeed in today's transforming business world, organizations need business intelligence capabilities to make smarter decisions faster than ever before. This updated second edition of Learn Power BI takes you on a journey of data exploration and discovery, using Microsoft Power BI to ingest, cleanse, and organize data in order to unlock key business insights that can then be shared with others. This newly revised and expanded edition of Learn Power BI covers all of the latest features and interface changes and takes you through the fundamentals of business intelligence projects, how to deploy, adopt, and govern Power BI within your organization, and how to leverage your knowledge in the marketplace and broader ecosystem that is Power BI. As you progress, you will learn how to ingest, cleanse, and transform your data into stunning visualizations, reports, and dashboards that speak to business decision-makers. By the end of this Power BI book, you will be fully prepared to be the data analysis hero of your organization – or even start a new career as a business intelligence professional.What you will learnGet up and running quickly with Power BIUnderstand and plan your business intelligence projectsConnect to and transform data using Power QueryCreate data models optimized for analysis and reportingPerform simple and complex DAX calculations to enhance analysisDiscover business insights and create professional reportsCollaborate via Power BI dashboards, apps, goals, and scorecardsDeploy and govern Power BI, including using deployment pipelinesWho this book is forIf you're an IT manager, data analyst, or BI user new to using Power BI for solving business intelligence problems, this book is for you. You'll also find this book helpful if you want to migrate from other BI tools to create powerful and interactive dashboards. No experience of working with Power BI is expected.
Learn Power Query: A low-code approach to connect and transform data from multiple sources for Power BI and Excel
by Linda Foulkes Warren SparrowDiscover how you can combine data from various sources to create data models to suit your business requirements with the help of this clear and concise guide Key Features Understand how Power Query overcomes the shortcomings of Excel Power Pivot in handling complex data Create customized dashboards and multi-dimensional reports using Power Query and Power BI Learn the Power Query M language and write advanced queries using custom functions Book Description Power Query is a data connection technology that allows you to connect, combine, and refine data from multiple sources to meet your business analysis requirements. With this Power Query book, you'll be empowered to work with a variety of data sources to create interactive reports and dashboards using Excel and Power BI. You'll start by learning how to access Power Query across different versions of Excel and install the Power BI engine. After you've explored Power Pivot, you'll see why Excel users find it challenging to clean data in Power Pivot and learn how Power Query can help to tackle the problem. The book will show you how to transform data using the Query Editor and write functions in Power Query. A dedicated section will focus on functions such as IF, Index, and Modulo, and creating parameters to alter query paths in a table. You'll also work with dashboards, get to grips with multi-dimensional reporting, and create automated reports. As you advance, you'll cover the M formula language in Power Query, delve into the basic M syntax, and write the M query language with the help of examples such as loading all library functions offline in Excel and Power BI. Finally, the book will demonstrate the difference between M and DAX and show how results are produced in M. By the end of this book, you'll be ready to create impressive dashboards and multi-dimensional reports in Power Query and turn data into valuable insights. What you will learn Convert worksheet data into a table format ready for query output Create a dynamic connection between an Access database and Excel workbook Reshape tabular data by altering rows, columns, and tables using various Power Query tools Create new columns automatically from filenames and sheet tabs, along with multiple Excel data files Streamline and automate reports from multiple sources Explore different customization options to get the most out of your dashboards Understand the difference between the DAX language and Power Query's M language Who this book is for This Power Query book is for business analysts, data analysts, BI professionals, and Excel users looking to take their skills to the next level by learning how to collect, combine, and transform data into insights using Power Query. Working knowledge of Excel and experience in constructing and troubleshooting Excel formulas and functions is expected.
Learn PowerShell Core 6.0: Automate and control administrative tasks using DevOps principles
by David Das Neves Jan-Hendrik PetersEnhance your skills in expert module development, deployment, security, DevOps, and cloudKey FeaturesA step-by-step guide to get you started with PowerShell Core 6.0Harness the capabilities of PowerShell Core 6.0 to perform simple to complex administration tasksLearn core administrative concepts such as scripting, pipelines, and DSCBook DescriptionBeginning with an overview of the different versions of PowerShell, Learn PowerShell Core 6.0 introduces you to VSCode and then dives into helping you understand the basic techniques in PowerShell scripting. You will cover advanced coding techniques, learn how to write reusable code as well as store and load data with PowerShell.This book will help you understand PowerShell security and Just Enough Administration, enabling you to create your own PowerShell repository. The last set of chapters will guide you in setting up, configuring, and working with Release Pipelines in VSCode and VSTS, and help you understand PowerShell DSC. In addition to this, you will learn how to use PowerShell with Windows, Azure, Microsoft Online Services, SCCM, and SQL Server. The final chapter will provide you with some use cases and pro tips.By the end of this book, you will be able to create professional reusable code using security insight and knowledge of working with PowerShell Core 6.0 and its most important capabilities.What you will learnGet to grips with Powershell Core 6.0Explore basic and advanced PowerShell scripting techniquesGet to grips with Windows PowerShell SecurityWork with centralization and DevOps with PowerShellImplement PowerShell in your organization through real-life examplesLearn to create GUIs and use DSC in productionWho this book is forIf you are a Windows administrator or a DevOps user who wants to leverage PowerShell to automate simple to complex tasks, then this book is for you. Whether you know nothing about PowerShell or just enough to get by, this guide will give you what you need to go to take your scripting to the next level. You’ll also find this book useful if you’re a PowerShell expert looking to expand your knowledge in areas such as PowerShell Security and DevOps.
Learn PowerShell in a Month of Lunches, Fourth Edition: Covers Windows, Linux, and macOS
by Travis Plunk James Petty Tyler LeonhardtDesigned for busy IT professionals, this innovative guide will take you from the basics to PowerShell proficiency through 25 tutorials you can do in your lunch break.In Learn PowerShell in a Month of Lunches, Fourth Edition you will learn: Discoverability with the Help system Background jobs and automation techniques Simple scripting to automate repetitive tasks Managing cloud services from major cloud providers Extending PowerShell with commands Common syntax and commands cheat sheet Learn PowerShell in a Month of Lunches, Fourth Edition is a task-focused guide for administering your systems using PowerShell. It covers core language features and admin tasks, with each chapter a mini-tutorial you can easily complete in under an hour. Discover how PowerShell works on different operating systems, and start automating tasks so they take just a few seconds to complete. No previous scripting experience required. The book is based on the bestselling Learn Windows PowerShell in a Month of Lunches by community legends Don Jones and Jeffery Hicks. PowerShell team members Travis Plunk and Tyler Leonhardt and Microsoft MVP James Petty have updated this edition to the latest version of PowerShell, including its multi-platform expansion into Linux and macOS. About the technology PowerShell gives you complete command line control over admin tasks like adding users, exporting data, and file management. Whether you&’re writing one-liners or building complex scripts to manage cloud resources and CI/CD pipelines, PowerShell can handle the task. And now that PowerShell is truly cross-platform, you don&’t have to switch scripting languages when you move between Windows, Linux, and macOS. About the book Learn PowerShell in a Month of Lunches, Fourth Edition is a new edition of the bestseller that introduced PowerShell to over 100,000 readers. With bite-sized lessons and hands-on exercises, this amazing book guides you from your first command to writing and debugging reusable scripts for Windows, Linux, and macOS. Set aside just an hour a day and you&’ll soon be tackling increasingly complex automation tasks with PowerShell. What's inside Discoverability with the Help system PowerShell on macOS and Linux Background jobs and automation techniques Managing cloud services from major cloud providers Common syntax and commands cheat sheet About the reader No previous experience with PowerShell or Bash required. About the author James Petty is CEO of PowerShell.org and The DevOps Collective, and a Microsoft MVP. Travis Plunk is an engineer on the PowerShell team. Tyler Leonhardt is an engineer on Visual Studio Code. Don Jones and Jeffery Hicks are the original authors of Learn Windows PowerShell in a Month of Lunches.
Learn PowerShell Scripting in a Month of Lunches
by Don Jones Jeffery HicksSummaryDiscover how scripting is different from command-line PowerShell, as you explore concrete hands-on examples in this handy guide. The book includes and expands on many of the techniques presented in Learn PowerShell Toolmaking in a Month of Lunches.Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.About the TechnologyAutomate it! With Microsoft's PowerShell language, you can write scripts to control nearly every aspect of Windows. Just master a few straightforward scripting skills, and you'll be able to eliminate repetitive manual tasks, create custom reusable tools, and build effective pipelines and workflows. Once you start scripting in PowerShell, you'll be amazed at how many opportunities you'll find to save time and effort. About the BookLearn PowerShell Scripting in a Month of Lunches teaches you how to expand your command-line PowerShell skills into effective scripts and tools. In 27 bite-size lessons, you'll discover instantly useful techniques for writing efficient code, finding and squashing bugs, organizing your scripts into libraries, and much more. Advanced scripters will even learn to access the .NET Framework, store data long term, and create nice user interfaces.What's InsideDesigning functions and scriptsEffective pipeline usageDealing with errors and bugsProfessional-grade scripting practicesAbout the Reader Written for devs and IT pros comfortable with PowerShell and Windows. About the AuthorsDon Jones is a PowerShell MVP, speaker, and trainer who has written dozens of books on information technology topics. Jeffery Hicks is a PowerShell MVP and an independent consultant, trainer, and author. Don and Jeff coauthored Manning's Learn Windows PowerShell in a Month of Lunches, Learn PowerShell Toolmaking in a Month of Lunches, and PowerShell in Depth. Table of ContentsPART 1 - INTRODUCTION TO SCRIPTING Before you begin Setting up your scripting environment WWPD: what would PowerShell do? Review: parameter binding and the PowerShell pipeline Scripting language crash course The many forms of scripting (and which to use) Scripts and security PART 2 - BUILDING A POWERSHELL SCRIPTAlways design first Avoiding bugs: start with a command Building a basic function and script module Going advanced with your function Objects: the best kind of output Using all the pipelines Simple help: making a comment Dealing with errors Filling out a manifest PART 3 - GROWN-UP SCRIPTING Changing your brain when it comes to scripting Professional-grade scripting An introduction to source control with git Pestering your script Signing your script Publishing your script PART 4 - ADVANCED TECHNIQUES Squashing bugs Making script output prettier Wrapping up the .NET Framework Storing data-not in Excel! Never the end
Learn PowerShell Scripting in a Month of Lunches, Second Edition: Write and organize scripts and tools (In a Month of Lunches)
by James Petty Don Jones Jeffery HicksAutomate complex tasks and processes with PowerShell scripts. This amazing book teaches you how to write, test, and organize high-quality, reusable scripts for Windows, Linux, and cloud-based systems.Learn PowerShell Scripting in a Month of Lunches, Second Edition takes you beyond command-line PowerShell and opens up the amazing world of scripting and automation. In just 27 bite-sized lessons, you&’ll learn to write scripts that can eliminate repetitive manual tasks, create custom reusable tools, and build effective pipelines and workflows. In Learn PowerShell Scripting in a Month of Lunches, Second Edition you&’ll learn: Setting up a reliable scripting environment Designing functions and scripts Effective pipeline usage Scripting and security Dealing with errors and bugs Source control with git Sharing and publishing scripts Professional-grade scripting practices The PowerShell language lets you write scripts to control nearly every aspect of Windows. Just master a few straightforward scripting skills, and you'll save yourself from hours of tedious tasks. This revised second edition is fully updated to PowerShell&’s latest version, including hands-on examples that perfectly demonstrate modern PowerShell&’s cross-platform applications. About the technology You can write PowerShell scripts to automate nearly any admin task on Windows, Linux, and macOS. This book shows you how! In just 27 short lessons you can complete on your lunch break, you&’ll learn to create, organize, test, and share scripts and tools that will save you hours of time in your daily work. About the book Learn PowerShell Scripting in a Month of Lunches, Second Edition is a hands-on introduction to PowerShell automation and toolbuilding. Updated for the latest version of PowerShell, this thoroughly revised bestseller teaches you how to write efficient scripts, find and squash bugs, and organize your tools into libraries. Along the way, you&’ll even pick up tips for securing and managing Linux and macOS systems. What's inside Setting up a reliable scripting environment Designing functions and scripts Effective pipeline usage Sharing and publishing scripts About the reader Beginning to intermediate knowledge of PowerShell required. About the author James Petty is CEO of PowerShell.org and The DevOps Collective and a Microsoft MVP. Don Jones and Jeffery Hicks are the authors of the first edition of Learn PowerShell Scripting in a Month of Lunches. Table of Contents PART 1 1 Before you begin 2 Setting up your scripting environment 3 WWPD: What would PowerShell do? 4 Review: Parameter binding and the PowerShell pipeline 5 Scripting language: A crash course 6 The many forms of scripting (and which to choose) 7 Scripts and security PART 2 8 Always design first 9 Avoiding bugs: Start with a command 10 Building a basic function and script module 11 Getting started with advanced functions 12 Objects: The best kind of output 13 Using all the streams 14 Simple help: Making a comment 15 Errors and how to deal with them 16 Filling out a manifest PART 3 17 Changing your brain when it comes to scripting 18 Professional-grade scripting 19 An introduction to source control with Git 20 Pestering your script 21 Signing your script 22 Publishing your script PART 4 23 Squashing bugs 24 Enhancing script output presentation 25 Wrapping up the .NET Framework 26 Storing data—not in Excel! 27 Never the end
Learn Programming in Python with Cody Jackson: Grasp the basics of programming and Python syntax while building real-world applications
by Cody JacksonKick-start your development journey with this end-to-end guide that covers Python programming fundamentals along with application developmentKey FeaturesGain a solid understanding of Python programming with coverage of data structures and Object-Oriented Programming (OOP)Design graphical user interfaces for desktops with libraries such as Kivy and TkinterWrite elegant, reusable, and efficient code Book DescriptionPython is a cross-platform language used by organizations such as Google and NASA. It lets you work quickly and efficiently, allowing you to concentrate on your work rather than the language. Based on his personal experiences when learning to program, Learn Programming in Python with Cody Jackson provides a hands-on introduction to computer programming utilizing one of the most readable programming languages–Python. It aims to educate readers regarding software development as well as help experienced developers become familiar with the Python language, utilizing real-world lessons to help readers understand programming concepts quickly and easily. The book starts with the basics of programming, and describes Python syntax while developing the skills to make complete programs. In the first part of the book, readers will be going through all the concepts with short and easy-to-understand code samples that will prepare them for the comprehensive application built in parts 2 and 3. The second part of the book will explore topics such as application requirements, building the application, testing, and documentation. It is here that you will get a solid understanding of building an end-to-end application in Python. The next part will show you how to complete your applications by converting text-based simulation into an interactive, graphical user interface, using a desktop GUI framework. After reading the book, you will be confident in developing a complete application in Python, from program design to documentation to deployment.What you will learnUse the interactive shell for prototyping and code execution, including variable assignment Deal with program errors by learning when to manually throw exceptions Employ exceptions for code management Enhance code by utilizing Python's built-in shortcuts to improve efficiency and make coding easier Interact with files and package Python data for network transfer or storage Understand how tests drive code writing, and vice versaExplore the different frameworks that are available for GUI developmentWho this book is forLearn Programming in Python with Cody Jackson is for beginners or novice programmers who have no programming background and wish to take their first step in software development. This book will also be beneficial for intermediate programmers and will provide deeper insights into effective coding practices in Python.
Learn Programming with C: An Easy Step-by-Step Self-Practice Book for Learning C
by Sazzad M.S. Imran Md Atiqur AhadAuthored by two standout professors in the field of Computer Science and Technology with extensive experience in instructing, Learn Programming with C: An Easy Step-by Step Self-Practice Book for Learning C is a comprehensive and accessible guide to programming with one of the most popular languages. Meticulously illustrated with figures and examples, this book is a comprehensive guide to writing, editing, and executing C programs on different operating systems and platforms, as well as how to embed C programs into other applications and how to create one’s own library. A variety of questions and exercises are included in each chapter to test the readers’ knowledge. Written for the novice C programmer, especially undergraduate and graduate students, this book’s line-by-line explanation of code and succinct writing style makes it an excellent companion for classroom teaching, learning, and programming labs.
Learn PySpark: Build Python-based Machine Learning and Deep Learning Models
by Pramod SinghLeverage machine and deep learning models to build applications on real-time data using PySpark. This book is perfect for those who want to learn to use this language to perform exploratory data analysis and solve an array of business challenges.You'll start by reviewing PySpark fundamentals, such as Spark’s core architecture, and see how to use PySpark for big data processing like data ingestion, cleaning, and transformations techniques. This is followed by building workflows for analyzing streaming data using PySpark and a comparison of various streaming platforms. You'll then see how to schedule different spark jobs using Airflow with PySpark and book examine tuning machine and deep learning models for real-time predictions. This book concludes with a discussion on graph frames and performing network analysis using graph algorithms in PySpark. All the code presented in the book will be available in Python scripts on Github.What You'll LearnDevelop pipelines for streaming data processing using PySpark Build Machine Learning & Deep Learning models using PySpark latest offeringsUse graph analytics using PySpark Create Sequence Embeddings from Text data Who This Book is For Data Scientists, machine learning and deep learning engineers who want to learn and use PySpark for real time analysis on streaming data.
Learn Python by Building Data Science Applications: A fun, project-based guide to learning Python 3 while building real-world apps
by David Katz Philipp KatsUnderstand the constructs of the Python programming language and use them to build data science projects Key Features Learn the basics of developing applications with Python and deploy your first data application Take your first steps in Python programming by understanding and using data structures, variables, and loops Delve into Jupyter, NumPy, Pandas, SciPy, and sklearn to explore the data science ecosystem in Python Book Description Python is the most widely used programming language for building data science applications. Complete with step-by-step instructions, this book contains easy-to-follow tutorials to help you learn Python and develop real-world data science projects. The “secret sauce” of the book is its curated list of topics and solutions, put together using a range of real-world projects, covering initial data collection, data analysis, and production. This Python book starts by taking you through the basics of programming, right from variables and data types to classes and functions. You'll learn how to write idiomatic code and test and debug it, and discover how you can create packages or use the range of built-in ones. You'll also be introduced to the extensive ecosystem of Python data science packages, including NumPy, Pandas, scikit-learn, Altair, and Datashader. Furthermore, you'll be able to perform data analysis, train models, and interpret and communicate the results. Finally, you'll get to grips with structuring and scheduling scripts using Luigi and sharing your machine learning models with the world as a microservice. By the end of the book, you'll have learned not only how to implement Python in data science projects, but also how to maintain and design them to meet high programming standards. What you will learn Code in Python using Jupyter and VS Code Explore the basics of coding – loops, variables, functions, and classes Deploy continuous integration with Git, Bash, and DVC Get to grips with Pandas, NumPy, and scikit-learn Perform data visualization with Matplotlib, Altair, and Datashader Create a package out of your code using poetry and test it with PyTest Make your machine learning model accessible to anyone with the web API Who this book is for If you want to learn Python or data science in a fun and engaging way, this book is for you. You'll also find this book useful if you're a high school student, researcher, analyst, or anyone with little or no coding experience with an interest in the subject and courage to learn, fail, and learn from failing. A basic understanding of how computers work will be useful.
Learn Python Programming: A beginner's guide to learning the fundamentals of Python language to write efficient, high-quality code, 2nd Edition
by Fabrizio RomanoBuild a solid foundation in coding by utilizing the language and its core characteristicsKey FeaturesLeverage the features of Python programming through easy-to-follow examplesDevelop a strong set of programming skills that can be applied on all platformsCreate GUIs and data science-based applicationsBook DescriptionLearn Python Programming creates a foundation for those who are interested in developing their skills in Python programming. The book starts with the fundamentals of programming with Python and ends by exploring different topics such as GUIs and real-world apps.You will begin by exploring the foundations of and fundamental topics on Python and learn to manipulate them. Then, you'll explore different programming paradigms that will allow you to find the best approach to a situation, and you’ll also understand how to carry out performance optimization as well as effective debugging.As you make your way through the chapters, you'll control the flow of a program, and persist and utilize an interchange format to exchange data. You'll also walk through cryptographic services in Python and understand secure tokens. Throughout, the book covers various types of applications, and it concludes with building real-world applications based on all the concepts that you learned.By the end of the book, you'll have a proper understanding of the Python language and a solid grasp on how to work with data. You'll know how to quickly build a website and harness the power of Python's renowned data science libraries.What you will learnGet Python up and running on Windows, Mac, and LinuxGrasp fundamental concepts of coding using data structures and control flowWrite elegant, reusable, and efficient code in any situationUnderstand when to use the functional or object-oriented programming (OOP) approachWalk through the basics of security and concurrent/asynchronous programmingCreate bulletproof, reliable software by writing testsExplore examples of GUIs, scripting, and data scienceWho this book is forLearn Python Programming is for individuals with relatively little experience in coding or Python. It's also ideal for aspiring programmers who need to write scripts or programs to accomplish tasks. The book takes you all the way to creating a full-fledged application.