TAGLINE Power Up Your Automation and Administration with PowerShell KEY FEATURES ● Master PowerShell for efficient IT administration and configuration. ● Explore practical scenarios with clear explanations and essential scripts. ● Enhance automation skills to stay ahead in IT innovation. ● Optimize Microsoft product management with advanced PowerShell techniques. DESCRIPTION Unlock the power of PowerShell with this comprehensive guide, designed as your ultimate companion, the book is structured into three parts, each focusing on different aspects of PowerShell. You'll start with the basics and then explore PowerShell Core's unique features. Next, you'll delve into building blocks, pipelines, and data control with arrays, loops, and hash tables. As you progress, you'll master PowerShell security and develop advanced functions to automate complex tasks. Further chapters will guide you through optimizing Windows administration, managing tasks and jobs, and exploring remoting features for efficient multi-system management. Finally, you'll leverage PowerShell for cloud operations and integrate it seamlessly with the Microsoft ecosystem. This book provides a progressive journey in PowerShell automation, equipping you with essential skills for various tasks, from Windows administration to cloud operations. WHAT WILL YOU LEARN ● Master PowerShell and PowerShell Core fundamentals, syntax, and cmdlets. ● Develop robust scripts using variables, arrays, conditionals, loops, and hash tables. ● Implement security best practices to safeguard data and systems. ● Create advanced functions to streamline script development. ● Administer Windows environments efficiently with PowerShell. ● Automate tasks and optimize system performance with PowerShell. ● Utilize PowerShell remoting for remote administration and cross-platform execution. ● Manage cloud resources using PowerShell for provisioning and configuration. ● Integrate PowerShell with Microsoft ecosystem components like Active Directory and Azure. ● Create custom modules for enhanced efficiency, including support for other cloud vendors. ● Enhance PowerShell scripting and automation skills to automate tasks, troubleshoot issues, and optimize workflows across diverse computing environments. ● Master cloud automation with PowerShell, efficiently automating tasks in Azure and AWS to manage cloud resources effectively. WHO IS THIS BOOK FOR? This book is tailored for IT professionals, system administrators, database administrators, and automation engineers seeking to enhance efficiency through PowerShell automation across diverse platforms. Prerequisites include basic understanding of IT systems and familiarity with command-line interfaces. Whether managing server configurations, administering databases, or navigating complex projects, this resource equips you with the skills to streamline tasks effectively using PowerShell. TABLE OF CONTENTS Part 1 Fundamentals of PowerShell 1. Introduction to PowerShell 2. Introduction to PowerShell Core 3. PowerShell Building Blocks and Pipelines Part 2 PowerShell Scripting and Automation 4. Data Control and Arrays Using Conditional Statements, Loops, and Hashtables 5. PowerShell Security 6. PowerShell Advanced Functions 7. Windows Administration Using PowerShell Part 3 PowerShell Advanced Topics 8. PowerShell Tasks and Jobs 9. PowerShell Remoting 10. Managing Cloud Operations Using PowerShell 11. PowerShell and Microsoft Ecosystem Index
Over 150 recipes to leverage Microsoft's open source automation framework and command line shell Key FeaturesWork effectively on Windows, Linux, and macOS with PowerShell’s object-oriented approach and capabilitiesHandle structured data seamlessly without the need for manual parsingEnhance your native Linux capabilities with PowerShell Core 6.1Book Description PowerShell Core, the open source, cross-platform that is based on the open source, cross-platform .NET Core, is not a shell that came out by accident; it was intentionally created to be versatile and easy to learn at the same time. PowerShell Core enables automation on systems ranging from the Raspberry Pi to the cloud. PowerShell Core for Linux Administrators Cookbook uses simple, real-world examples that teach you how to use PowerShell to effectively administer your environment. As you make your way through the book, you will cover interesting recipes on how PowerShell Core can be used to quickly automate complex, repetitive, and time-consuming tasks. In the concluding chapters, you will learn how to develop scripts to automate tasks that involve systems and enterprise management. By the end of this book, you will have learned about the automation capabilities of PowerShell Core, including remote management using OpenSSH, cross-platform enterprise management, working with Docker containers, and managing SQL databases. What you will learnLeverage the object model of the shell, which is based on .NET CoreAdminister computers locally as well as remotely using PowerShell over OpenSSHGet to grips with advanced concepts of PowerShell functionsUse PowerShell for administration on the cloudKnow the best practices pertaining to PowerShell scripts and functionsExploit the cross-platform capabilities of PowerShell to manage scheduled jobs, Docker containers and SQL DatabasesWho this book is for PowerShell Core for Linux Administrators Cookbook is for you if you are a system administrator who wants to learn to control and automate a Linux environment with PowerShell Core 6.1. Basic knowledge of PowerShell scripting is necessary. It is assumed that you already understand how an operating system is structured and how to use the command-line interface to work with the operating system.
PowerShell Essentials - Your path to efficient automation and scripting KEY FEATURES ● Understand the concepts of .NET and PowerShell. ● Learn the basics of PowerShell, including the syntax, commands, and core concepts. ● Learn how to work with variables in PowerShell, including how to store data, perform arithmetic operations, and display data. ● Get familiar with the pipeline and work with the Scripts. ● Implement PowerShell solutions to manage large infrastructures through automation. DESCRIPTION In the last decade, PowerShell has propelled in every way in the automation arena. Since the inception of PowerShell, it has become a de facto tool for automation, and it is the favorite solution of many Windows administrators, with the capability to automate almost any task in the Microsoft ecosystem. Since the advent of PowerShell, it has been a lot easier to import the related modules and invoke the associated cmdlets call to take care of many day-to-day mundane activities, from simple to complex maintenance. Beginning with introductory chapters that cover Azure concepts, an overview of PowerShell, and other related tools, the reader will be introduced to the advanced concepts of Azure components without heavy emphasis on Cloud. This book would give an IT administrator's view of Microsoft Azure by equipping them to construct, manage, and administer workloads on-premise or in the Cloud. The later chapters are straightforward to understand and completely isolated from each section. For every section, the PowerShell code is designed, and readers with no prior experience can jump into the topics and get started with the examples. The aim of this book is to provide the reader with hands-on experience with Azure databases, enabling them to work with what is relevant in the market today and is clearly in the future. It would be great to have hands-on experience with PowerShell; this would help you to progress faster. However, if you have experience with PowerShell, you can jump to a specific chapter or topic in the book. WHAT YOU WILL LEARN ● Get to understand the Windows operating system as PowerShell is a cross-platform scripting language, so understand how it works on multi-platforms. ● Learn to use PowerShell for administration, such as on the Cloud, Active Directory, VMware and SQL Server, and more. ● Learn to administer infrastructure effectively. ● Practice real-world examples to ensure proficiency. WHO THIS BOOK IS FOR PowerShell serves as a crucial framework for IT professionals. It is a top choice for automation engineers, Windows administrators, and network administrators looking to standardize, automate server installation, integrate automation workflows, and streamline day-to-day Windows network management. Cloud engineers benefit from built-in PowerShell tools provided by various cloud vendors. Database administrators effectively administer SQL infrastructure with PowerShell's SQL modules. TABLE OF CONTENTS 1. Introducing PowerShell 2. PowerShell Constructs 3. Munging the Data Through Pipelines 4. Data Control Flow Using Branches and Loops 5. Learning about PowerShell Modules 6. Choosing Between PowerShell Core and PowerShell 7. PowerShell Administration and Scripting 8. Using the Active Directory Module 9. Building PowerShell GUI for Scripts 10. Managing Cloud Operations Using PowerShell 11. Understanding PowerShell and Data Science 12. Administrating Database Using PowerShell
Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook Description Many software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully. This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe. Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world. By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL. What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is for This Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.
Cut through the noise and get real results with a step-by-step approach to learning SQL Key Features A structured, straightforward introduction to SQL for beginners A SQL tutorial with step-by-step exercises and activities that help build key skills Structured to let you progress at your own pace, on your own terms Use your physical print copy to redeem free access to the online interactive edition Book Description You already know you want to learn SQL, and the best way to learn SQL is to learn by doing. The SQL Workshop focuses on building up your SQL database management skills so that you can easily store and retrieve data or become the in-house expert on complex queries. You'll learn from real examples that lead to real results. Throughout The SQL Workshop, you'll take an engaging step-by-step approach to understanding SQL programming. You won't have to sit through any unnecessary theory. If you're short on time you can jump into a single exercise each day or spend an entire weekend learning how to create functions and stored procedures. It's your choice. Learning on your terms, you'll build up and reinforce key skills in a way that feels rewarding. Every physical print copy of The SQL Workshop unlocks access to the interactive edition. With videos detailing all exercises and activities, you'll always have a guided solution. You can also benchmark yourself against assessments, track progress, and receive content updates. You'll even earn a secure credential that you can share and verify online upon completion. It's a premium learning experience that's included with your printed copy. To redeem, follow the instructions located at the start of your book. Fast-paced and direct, The SQL Workshop is the ideal companion for SQL beginners. You'll build and iterate on your code like a software developer, learning along the way. This process means that you'll find that your new skills stick, embedded as best practice. A solid foundation for the years ahead. What you will learn Learn how to create normalized databases Explore how to insert data into tables efficiently Explore various techniques to retrieve data from multiple tables Build advanced queries using techniques like subqueries and views Learn advanced SQL programming techniques such as functions and triggers Who this book is for Our goal at Packt is to help you be successful, in whatever it is you choose to do. The SQL Workshop is an ideal SQL tutorial for the SQL beginner who is just getting started. Pick up a Workshop today, and let Packt help you develop skills that stick with you for life.
PowerShell Essentials - Your path to efficient automation and scripting KEY FEATURES ● Understand the concepts of .NET and PowerShell. ● Learn the basics of PowerShell, including the syntax, commands, and core concepts. ● Learn how to work with variables in PowerShell, including how to store data, perform arithmetic operations, and display data. ● Get familiar with the pipeline and work with the Scripts. ● Implement PowerShell solutions to manage large infrastructures through automation. DESCRIPTION In the last decade, PowerShell has propelled in every way in the automation arena. Since the inception of PowerShell, it has become a de facto tool for automation, and it is the favorite solution of many Windows administrators, with the capability to automate almost any task in the Microsoft ecosystem. Since the advent of PowerShell, it has been a lot easier to import the related modules and invoke the associated cmdlets call to take care of many day-to-day mundane activities, from simple to complex maintenance. Beginning with introductory chapters that cover Azure concepts, an overview of PowerShell, and other related tools, the reader will be introduced to the advanced concepts of Azure components without heavy emphasis on Cloud. This book would give an IT administrator's view of Microsoft Azure by equipping them to construct, manage, and administer workloads on-premise or in the Cloud. The later chapters are straightforward to understand and completely isolated from each section. For every section, the PowerShell code is designed, and readers with no prior experience can jump into the topics and get started with the examples. The aim of this book is to provide the reader with hands-on experience with Azure databases, enabling them to work with what is relevant in the market today and is clearly in the future. It would be great to have hands-on experience with PowerShell; this would help you to progress faster. However, if you have experience with PowerShell, you can jump to a specific chapter or topic in the book. WHAT YOU WILL LEARN ● Get to understand the Windows operating system as PowerShell is a cross-platform scripting language, so understand how it works on multi-platforms. ● Learn to use PowerShell for administration, such as on the Cloud, Active Directory, VMware and SQL Server, and more. ● Learn to administer infrastructure effectively. ● Practice real-world examples to ensure proficiency. WHO THIS BOOK IS FOR PowerShell serves as a crucial framework for IT professionals. It is a top choice for automation engineers, Windows administrators, and network administrators looking to standardize, automate server installation, integrate automation workflows, and streamline day-to-day Windows network management. Cloud engineers benefit from built-in PowerShell tools provided by various cloud vendors. Database administrators effectively administer SQL infrastructure with PowerShell's SQL modules. TABLE OF CONTENTS 1. Introducing PowerShell 2. PowerShell Constructs 3. Munging the Data Through Pipelines 4. Data Control Flow Using Branches and Loops 5. Learning about PowerShell Modules 6. Choosing Between PowerShell Core and PowerShell 7. PowerShell Administration and Scripting 8. Using the Active Directory Module 9. Building PowerShell GUI for Scripts 10. Managing Cloud Operations Using PowerShell 11. Understanding PowerShell and Data Science 12. Administrating Database Using PowerShell
TAGLINE Power Up Your Automation and Administration with PowerShell KEY FEATURES ● Master PowerShell for efficient IT administration and configuration. ● Explore practical scenarios with clear explanations and essential scripts. ● Enhance automation skills to stay ahead in IT innovation. ● Optimize Microsoft product management with advanced PowerShell techniques. DESCRIPTION Unlock the power of PowerShell with this comprehensive guide, designed as your ultimate companion, the book is structured into three parts, each focusing on different aspects of PowerShell. You'll start with the basics and then explore PowerShell Core's unique features. Next, you'll delve into building blocks, pipelines, and data control with arrays, loops, and hash tables. As you progress, you'll master PowerShell security and develop advanced functions to automate complex tasks. Further chapters will guide you through optimizing Windows administration, managing tasks and jobs, and exploring remoting features for efficient multi-system management. Finally, you'll leverage PowerShell for cloud operations and integrate it seamlessly with the Microsoft ecosystem. This book provides a progressive journey in PowerShell automation, equipping you with essential skills for various tasks, from Windows administration to cloud operations. WHAT WILL YOU LEARN ● Master PowerShell and PowerShell Core fundamentals, syntax, and cmdlets. ● Develop robust scripts using variables, arrays, conditionals, loops, and hash tables. ● Implement security best practices to safeguard data and systems. ● Create advanced functions to streamline script development. ● Administer Windows environments efficiently with PowerShell. ● Automate tasks and optimize system performance with PowerShell. ● Utilize PowerShell remoting for remote administration and cross-platform execution. ● Manage cloud resources using PowerShell for provisioning and configuration. ● Integrate PowerShell with Microsoft ecosystem components like Active Directory and Azure. ● Create custom modules for enhanced efficiency, including support for other cloud vendors. ● Enhance PowerShell scripting and automation skills to automate tasks, troubleshoot issues, and optimize workflows across diverse computing environments. ● Master cloud automation with PowerShell, efficiently automating tasks in Azure and AWS to manage cloud resources effectively. WHO IS THIS BOOK FOR? This book is tailored for IT professionals, system administrators, database administrators, and automation engineers seeking to enhance efficiency through PowerShell automation across diverse platforms. Prerequisites include basic understanding of IT systems and familiarity with command-line interfaces. Whether managing server configurations, administering databases, or navigating complex projects, this resource equips you with the skills to streamline tasks effectively using PowerShell. TABLE OF CONTENTS Part 1 Fundamentals of PowerShell 1. Introduction to PowerShell 2. Introduction to PowerShell Core 3. PowerShell Building Blocks and Pipelines Part 2 PowerShell Scripting and Automation 4. Data Control and Arrays Using Conditional Statements, Loops, and Hashtables 5. PowerShell Security 6. PowerShell Advanced Functions 7. Windows Administration Using PowerShell Part 3 PowerShell Advanced Topics 8. PowerShell Tasks and Jobs 9. PowerShell Remoting 10. Managing Cloud Operations Using PowerShell 11. PowerShell and Microsoft Ecosystem Index
Over 150 recipes to leverage Microsoft's open source automation framework and command line shell Key FeaturesWork effectively on Windows, Linux, and macOS with PowerShell’s object-oriented approach and capabilitiesHandle structured data seamlessly without the need for manual parsingEnhance your native Linux capabilities with PowerShell Core 6.1Book Description PowerShell Core, the open source, cross-platform that is based on the open source, cross-platform .NET Core, is not a shell that came out by accident; it was intentionally created to be versatile and easy to learn at the same time. PowerShell Core enables automation on systems ranging from the Raspberry Pi to the cloud. PowerShell Core for Linux Administrators Cookbook uses simple, real-world examples that teach you how to use PowerShell to effectively administer your environment. As you make your way through the book, you will cover interesting recipes on how PowerShell Core can be used to quickly automate complex, repetitive, and time-consuming tasks. In the concluding chapters, you will learn how to develop scripts to automate tasks that involve systems and enterprise management. By the end of this book, you will have learned about the automation capabilities of PowerShell Core, including remote management using OpenSSH, cross-platform enterprise management, working with Docker containers, and managing SQL databases. What you will learnLeverage the object model of the shell, which is based on .NET CoreAdminister computers locally as well as remotely using PowerShell over OpenSSHGet to grips with advanced concepts of PowerShell functionsUse PowerShell for administration on the cloudKnow the best practices pertaining to PowerShell scripts and functionsExploit the cross-platform capabilities of PowerShell to manage scheduled jobs, Docker containers and SQL DatabasesWho this book is for PowerShell Core for Linux Administrators Cookbook is for you if you are a system administrator who wants to learn to control and automate a Linux environment with PowerShell Core 6.1. Basic knowledge of PowerShell scripting is necessary. It is assumed that you already understand how an operating system is structured and how to use the command-line interface to work with the operating system.
Get to grips with SQL fundamentals and learn how to efficiently create, read and update information stored in databases Key FeaturesUnderstand the features and syntax of SQL and use them to query databasesLearn how to create databases and tables and manipulate the data within themCreate advanced queries and apply them on realistic databases with hands-on activitiesBook Description Many software applications are backed by powerful relational database systems, meaning that the skills to be able to maintain a SQL database and reliably retrieve data are in high demand. With its simple syntax and effective data manipulation capabilities, SQL enables you to manage relational databases with ease. The SQL Workshop will help you progress from basic to advanced-level SQL queries in order to create and manage databases successfully. This Workshop begins with an introduction to basic CRUD commands and gives you an overview of the different data types in SQL. You'll use commands for narrowing down the search results within a database and learn about data retrieval from single and multiple tables in a single query. As you advance, you'll use aggregate functions to perform calculations on a set of values, and implement process automation using stored procedures, functions, and triggers. Finally, you'll secure your database against potential threats and use access control to keep your data safe. Throughout this Workshop, you'll use your skills on a realistic database for an online shop, preparing you for solving data problems in the real world. By the end of this book, you'll have built the knowledge, skills and confidence to creatively solve real-world data problems with SQL. What you will learnCreate databases and insert data into themUse SQL queries to create, read, update, and delete dataMaintain data integrity and consistency through normalizationCustomize your basic SQL queries to get the desired outputRefine your database search using the WHERE and HAVING clausesUse joins to fetch data from multiple tables and create custom reportsImprove web application performance by automating processesSecure a database with GRANT and REVOKE privilegesWho this book is for This Workshop is suitable for anyone who wants to learn how to use SQL to work with databases. No prior SQL or database experience is necessary. Whether you're an aspiring software developer, database engineer, data scientist, or systems administrator, this Workshop will quickly get you up and running.
India’s tech/startup industry today is estimated to be worth over $0.5 trillion, employing over 5 million people. And the stage for this incredible ‘tech-tonic’ rise and transformation of the country into the world’s software powerhouse, is Bengaluru. Being the backdrop to this dramatic transition, Bengaluru has changed irrevocably. The city has been through many avatars—pensioner’s paradise, PSU capital, garden city, India’s Silicon city and pub capital. Once known for secure state and federal government jobs, it is now a buzzing startup hub attracting job-seekers from India and abroad. And the new monikers will continue. From ed-tech to health-tech, mobility to EVs, Bengaluru is at the heart of the multiple shifts underway in the digital era. Truly, it is the city of new beginnings. In Unboxing Bengaluru—the first ever deep-dive into the city—Malini Goyal and Prashanth Prakash ably unravel the city’s journey and the ensuing social, behavioural, technological and consumptive changes. They look at why people are drawn to the city; how the cosmopolitan culture and multi-linguistic society gives it a distinct flavour; the parallel economies that have cropped up; how the influx of young workers have changed the city; and the fault-lines of unplanned and poorly managed growth over the decades. Richly researched and vividly written, Unboxing Bengaluru is filled with absorbing vignettes, extensive reportage and solid data. A fascinating book and a must-read for anyone interested in understanding the city, and indeed, India.
Thank you for visiting our website. Would you like to provide feedback on how we could improve your experience?
This site does not use any third party cookies with one exception — it uses cookies from Google to deliver its services and to analyze traffic.Learn More.