Microsoft programming Books

Book SynopsisLearn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO. What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, uTable of ContentsThe appendix will include: Notes on using SQL with PHP “Cultural Notes” - a description of some of the sample data Major Differences between DBMSs Setting up the Sample Database

Read more less

Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: Getting Started with Azure Security o Introduction to Cloud Security o Best practices for securing enterprise cloud o Create an overall security design baseline o Define Security Operations Strategy o Overview of NIST Cybersecurity framework Chapter 2: Design and deploy security for infrastructure, data and apps o Design and deploy a strategy for securing server and client endpoints \ o Design and deploy a strategy for securing SaaS, PaaS, and IaaS services o Design and deploy security for data across Azure enterprise environment o Design and deploy security for application across Azure enterprise environment Chapter 3: Design and deploy Identify solution. o Introduction to Azure identify security services o Design and deploy Azure information protection o Design and deploy Azure network watcher o Design and deploy Azure Policy Chapter 4: Design and deploy Identify solution. o Design and deploy Azure Automation o Design and deploy Azure IoT Hub o Design and deploy Microsoft Intune o Design and deploy Service Map o Enable Security Center Chapter 5: Design and deploy detect solution. o Design and deploy Azure Intelligent Security Graph o Design and deploy Azure monitor o Design and deploy Azure Sentinel Chapter 6: Design and deploy protect solution o Design and deploy Azure Application gateway o Design and deploy Azure Firewall o Design and deploy Azure WAF Chapter 7: Design and deploy protect solution. o Design and deploy Azure AD and AD Identity protection o Design and deploy Azure DDoS o Design and deploy Azure NSG Chapter 8: Design and deploy protect solution. o Design and deploy Azure NSG o Design and deploy Azure Bastion o Design and deploy Azure Encryption Chapter 9: Design and deploy respond solution o Design and deploy Azure Logic Apps o Design and deploy Azure Encryption o Define your security team Chapter 10: Design and deploy recover solution o Design and deploy Azure Backup o Design and deploy Site recovery

Read more less

Book SynopsisIntermediate-Advanced user levelTable of ContentsChapter 1: Getting Ready.- Chapter 2: Working with Table Design.- Chapter 3: Table Relationships and Working With Joins.- Chapter 4: Working with Calculated Data.- Chapter 5: Aggregating Data.- Chapter 6: Creating and Using Views and Friends.- Chapter 7: Working With Subqueries and Common Table Expressions.- Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions.- Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables.- Appendix A.

Read more less

Book SynopsisIntermediate-Advanced user levelTable of Contents

Read more less

Book SynopsisThe Comprehensive, Expert Guide to C# Language Programming “This book has been a classic for years, and remains one of the most venerable and trusted titles in the world of C# content, and probably far beyond! . . . Mark is super smart, insists on understanding everything to the core, and has phenomenal insight into how things affect real developers. . . . He goes right to the essence and communicates with great integrity—no sugarcoating—and has a keen eye for practical value and real-world problems.” –Mads Torgersen, C# Program Manager, Microsoft Essential C# 7.0 is a well-organized, no-fluff guide to C# 7.0 for programmers at all levels of experience. Reflecting the most important C# features from 3.0 through 7.0 and including modern programming patterns, it will help you write code that’s simple, powerful, robust, secure, and maintainable. Author Mark Michaelis is a world-class C# expert: a long-time Microsoft MVP and Regional Director who also has served on Microsoft’s C# design review team. He presents a comprehensive tutorial and reference for the entire language, including expert coverage of key C# 7.0 enhancements, C# 7.0’s use with .NET Core/.NET Standard, and cross-platform compilation. He illustrates key C# constructs with succinct examples, and presents best-practice coding guidelines. To help you maintain existing code, separate indexes provide version-specific answers for C# 5.0, 6.0, and 7.0, and visual icons show when each language innovation was introduced. Make the most of C# 7.0 enhancements, including tuples, deconstructors, pattern matching, local functions, and ref returns Work efficiently with C# data types, operators, control flow, methods, and parameters Write more robust code with C# object-oriented constructs Implement reliable, effective exception handling Reduce code complexity with generics, delegates, lambda expressions, and events Leverage advanced dynamic and declarative programming techniques Query diverse data collections using LINQ with query expressions Create custom collections that operate against business objects Access .NET collections via collection interfaces and standard query operators Master multithreading and synchronization, including the async/await paradigm Optimize performance and interoperability with P/Invoke and unsafe code Run your code on Linux or macOS with C# 7.0 cross-platform compilation Includes C# 7.1, 7.2, and 7.3 language enhancements This guide offers you a complete foundation for successful development with modern versions of the C# language in any project or environment.Table of ContentsFigures xv Tables xvii Foreword xix Preface xxi Acknowledgments xxxiii About the Author xxxv Chapter 1: Introducing C# 1 Hello, World 2 C# Syntax Fundamentals 11 Working with Variables 20 Console Input and Output 24 Managed Execution and the Common Language Infrastructure 32 Multiple .NET Frameworks 37 Chapter 2: Data Types 43 Fundamental Numeric Types 44 More Fundamental Types 53 null and void 67 Conversions between Data Types 69 Chapter 3: More with Data Types 77 Categories of Types 77 Nullable Modifier 80 Tuples 83 Arrays 90 Chapter 4: Operators and Control Flow 109 Operators 110 Introducing Flow Control 126 Code Blocks ({}) 132 Code Blocks, Scopes, and Declaration Spaces 135 Boolean Expressions 137 Bitwise Operators (<<, >>, |, &, ^, ~) 147 Control Flow Statements, Continued 153 Jump Statements 165 C# Preprocessor Directives 171 Chapter 5: Methods and Parameters 181 Calling a Method 182 Declaring a Method 189 The using Directive 195 Returns and Parameters on Main() 200 Advanced Method Parameters 203 Recursion 215 Method Overloading 217 Optional Parameters 220 Basic Error Handling with Exceptions 225 Chapter 6: Classes 241 Declaring and Instantiating a Class 245 Instance Fields 249 Instance Methods 251 Using the this Keyword 252 Access Modifiers 259 Properties 261 Constructors 278 Static Members 289 Extension Methods 299 Encapsulating the Data 301 Nested Classes 304 Partial Classes 307 Chapter 7: Inheritance 313 Derivation 314 Overriding the Base Class 326 Abstract Classes 338 All Classes Derive from System.Object 344 Verifying the Underlying Type with the is Operator 345 Pattern Matching with the is Operator 346 Pattern Matching within a switch Statement 347 Conversion Using the as Operator 349 Chapter 8: Interfaces 353 Introducing Interfaces 354 Polymorphism through Interfaces 355 Interface Implementation 360 Converting between the Implementing Class and Its Interfaces 366 Interface Inheritance 366 Multiple Interface Inheritance 369 Extension Methods on Interfaces 369 Implementing Multiple Inheritance via Interfaces 371 Versioning 374 Interfaces Compared with Classes 375 Interfaces Compared with Attributes 377 Chapter 9: Value Types 379 Structs 383 Boxing 390 Enums 398 Chapter 10: Well-Formed Types 411 Overriding object Members 411 Operator Overloading 424 Referencing Other Assemblies 432 Defining Namespaces 442 XML Comments 445 Garbage Collection 449 Resource Cleanup 452 Lazy Initialization 461 Chapter 11: Exception Handling 465 Multiple Exception Types 465 Catching Exceptions 469 General Catch Block 473 Guidelines for Exception Handling 475 Defining Custom Exceptions 479 Rethrowing a Wrapped Exception 483 Chapter 12: Generics 487 C# without Generics 488 Introducing Generic Types 493 Constraints 506 Generic Methods 519 Covariance and Contravariance 524 Generic Internals 531 Chapter 13: Delegates and Lambda Expressions 537 Introducing Delegates 538 Declaring Delegate Types 542 Lambda Expressions 550 Anonymous Methods 556 Chapter 14: Events 575 Coding the Publish-Subscribe Pattern with Multicast Delegates 576 Understanding Events 591 Chapter 15: Collection Interfaces with Standard Query Operators 603 Collection Initializers 604 What Makes a Class a Collection: IEnumerable 607 Standard Query Operators 613 Anonymous Types with LINQ 646 Chapter 16: LINQ with Query Expressions 657 Introducing Query Expressions 658 Query Expressions Are Just Method Invocations 676 Chapter 17: Building Custom Collections 679 More Collection Interfaces 680 Primary Collection Classes 683 Providing an Indexer 702 Returning Null or an Empty Collection 705 Iterators 705 Chapter 18: Reflection, Attributes, and Dynamic Programming 721 Reflection 722 nameof Operator 733 Attributes 735 Programming with Dynamic Objects 759 Chapter 19: Multithreading 771 Multithreading Basics 774 Working with System.Threading 781 Asynchronous Tasks 789 Canceling a Task 810 The Task-based Asynchronous Pattern 816 Executing Loop Iterations in Parallel 846 Running LINQ Queries in Parallel 856 Chapter 20: Thread Synchronization 863 Why Synchronization? 864 Timers 893 Chapter 21: Platform Interoperability and Unsafe Code 897 Platform Invoke 898 Pointers and Addresses 910 Executing Unsafe Code via a Delegate 920 Chapter 22: The Common Language Infrastructure 923 Defining the Common Language Infrastructure 924 CLI Implementations 925 .NET Standard 928 Base Class Library 929 C# Compilation to Machine Code 929 Runtime 932 Assemblies, Manifests, and Modules 936 Common Intermediate Language 939 Common Type System 939 Common Language Specification 940 Metadata 941 .NET Native and Ahead of Time Compilation 942 Index 945 Index of 7.0 Topics 995 Index of 6.0 Topics 998 Index of 5.0 Topics 1001

Read more less

Book SynopsisOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping UpTable of ContentsOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping Up

Read more less

Book SynopsisChapter 1: Azure--A Solutions Development Platform.- Chapter 2: Beginning Application Development with Azure Web Apps, SQL Database, and Blob Storage.- Chapter 3: DevOps with Visual Studio Team Services and Azure.- Chapter 4: Azure Active Directory and Multi-Tenancy.- Chapter 5: Getting Started with Azure NoSQL Services.- Chapter 6: Security and Data Protection.- Chapter 7: Integrating Azure Search.- Chapter 8: Data Visualization with Power BI Embedded.Table of ContentsChapter 1: Azure--A Solutions Development Platform.- Chapter 2: Beginning Application Development with Azure Web Apps, SQL Database, and Blob Storage.- Chapter 3: DevOps with Visual Studio Team Services and Azure.- Chapter 4: Azure Active Directory and Multi-Tenancy.- Chapter 5: Getting Started with Azure NoSQL Services.- Chapter 6: Security and Data Protection.- Chapter 7: Integrating Azure Search.- Chapter 8: Data Visualization with Power BI Embedded.

Read more less

Book SynopsisBeginning user levelTable of ContentsPart I: Power App FundamentalsChapter 1: Introducing Power AppsChapter 2: Subscribing to Power AppsChapter 3: Creating Your First AppChapter 4: Sharing AppsChapter 5: Using FormulasPart II: Working with DataChapter 6: Setting Up SharePoint, SQL, and more Chapter 7: Working with Tables and RowsChapter 8: Searching and Retrieving DataPart III: Developing Canvas AppsChapter 9: Canvas App DesignChapter 10: Using Simple ControlsChapter 11: Using Table/Record Data ControlsPart IV: Developing Model Driven and Portal AppsChapter 12: Building a Dataverse DatabaseChapter 13:Developing Model-Driven AppsChapter 14: Building Portal AppsChapter 15: Retrieving Data from Portal Apps.Part V: Enhancing AppsChapter 16: Working with Images and MediaChapter 17: Storing and Retrieving FilesChapter 18: Integrating Maps and Location ServicesChapter 19: Charting DataChapter 20: Adding Artificial Intelligence to AppsPart VI: ReusabilityChapter 21: Building Reusable Canvas ComponentsChapter 22: Building Reusable Code ComponentsPart VII: Offline and IntegrationChapter 23: Working OfflineChapter 24: Creating Custom Data ConnectorsPart VIII: Administration Chapter 25: Using Power AutomateChapter 26: Transferring Apps and DataChapter 27: Administering SecurityAppendix A - Sample App Data Structure

Read more less

Book SynopsisThe author shows developers with litte or no ADO.NET background how to apply ADO.NET fast to real world scenarios by giving examples and code that really works.Table of ContentsA table of contents is not available for this title.

Read more less

Book Synopsis* Coverage of all three significant .NET code generation mechanisms: Manual code generation, XSL/XML and CodeDom. * Includes a database metadata extraction tool based on SQL-92 standards. * Real solutions to the problem of protecting handcrafted code across regeneration. * Covers code generation in the broader picture of how applications are developed. * Includes real world samples for a complete middle tier and simple User Interface. Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisThe Software Factory methodology is based on recognition of these similarities and a drive to extend the concept of "reusability" to the point where we achieve entirely automated product lines. Based on an analysis and understanding of the common features and techniques of a set of applications, a Software Factory defines a tailored, end-to-end methodology for building these applications. At the heart of the Software factory methodology is the concept of Domain Specific Languages (DSLs), which in essence are development environments specifically tailored to the set of applications in hand. It removes a certain degree of flexibility but greatly enhances productivity by removing a lot of the coding complexity (for an analogy, consider the use of the now ubiquitous drag-and-drop controls in Winforms or Visual Basic). Further, in the SF methodology, patterns, process advice, and best practices can be harvested and applied for all applications in the set. There are some good books on the theory of SF already on the market. Up until this point, a lot of these concepts were fairly theoretical and abstract.Trade ReviewFrom the reviews: "The purpose of this work is to introduce and demystify the concept of software factories in the .NET environment. … The book covers both the theory and practice of software factories, including an acknowledgment of the genesis of the term in the late 1960s. … this book is recommended reading for people involved in the management of large software development groups, particularly ones that develop many similar products. It provides a good theoretical discussion, and practical illustration … in the creation of software solutions." (Neil D. Burgess, ACM Computing Reviews, Vol. 49 (3), March, 2008)Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisA complete handbook on Microsoft Identity Manager 2016 – from design considerations to operational best practices About This Book • Get to grips with the basics of identity management and get acquainted with the MIM components and functionalities • Discover the newly-introduced product features and how they can help your organization • A step-by-step guide to enhance your foundational skills in using Microsoft Identity Manager from those who have taught and supported large and small enterprise customers Who This Book Is For If you are an architect or a developer who wants to deploy, manage, and operate Microsoft Identity Manager 2016, then this book is for you. This book will also help the technical decision makers who want to improve their knowledge of Microsoft Identity Manager 2016. A basic understanding of Microsoft-based infrastructure using Active Directory is expected. Identity management beginners and experts alike will be able to apply the examples and scenarios to solve real-world customer problems. What You Will Learn • Install MIM components • Find out about the MIM synchronization, its configuration settings, and advantages • Get to grips with the MIM service capabilities and develop custom activities • Use the MIM Portal to provision and manage an account • Mitigate access escalation and lateral movement risks using privileged access management • Configure client certificate management and its detailed permission model • Troubleshoot MIM components by enabling logging and reviewing logs • Back up and restore the MIM 2015 configuration • Discover more about periodic purging and the coding best practices In Detail Microsoft Identity Manager 2016 is Microsoft's solution to identity management. When fully installed, the product utilizes SQL, SharePoint, IIS, web services, the .NET Framework, and SCSM to name a few, allowing it to be customized to meet nearly every business requirement. The book is divided into 15 chapters and begins with an overview of the product, what it does, and what it does not do. To better understand the concepts in MIM, we introduce a fictitious company and their problems and goals, then build an identity solutions to fit those goals. Over the course of this book, we cover topics such as MIM installation and configuration, user and group management options, self-service solutions, role-based access control, reducing security threats, and finally operational troubleshooting and best practices. By the end of this book, you will have gained the necessary skills to deploy, manage and operate Microsoft Identity Manager 2016 to meet your business requirements and solve real-world customer problems. Style and approach The concepts in the book are explained and illustrated with the help of screenshots as much as possible. We strive for readability and provide you with step-by-step instructions on the installation, configuration, and operation of the product. Throughout the book, you will be provided on-the-field knowledge that you won't get from whitepapers and help files.

Read more less

Book SynopsisBlazor is an essential tool if you want to build interactive web apps without JavaScript, but it has a learning curve. Updated with the latest code in .NET 7 and C# 11 and written by someone who adopted Blazor early, this book will help you overcome the challenges associated with being a beginner with Blazor and teach you the best coding practices. You’ll start by learning how to leverage the power of Blazor and exploring the full capabilities of both Blazor Server and Blazor WebAssembly. Then you'll move on to the practical part, centered around a sample project – a blog engine. You'll apply all your newfound knowledge about creating Blazor projects, the inner workings of Razor syntax, validating forms, and creating your own components. This new edition also looks at source generators, dives deeper into Blazor WebAssembly with ahead-of-time, and includes a dedicated new chapter demonstrating how to move components of an existing JavaScript (Angular, React) or MVC-based website to Blazor or combine the two. You’ll also see how to use Blazor (Hybrid) together with .NET MAUI to create cross-platform desktop and mobile applications. When you reach the end of this book, you'll have the confidence you need to create and deploy production-ready Blazor applications, and you'll have a big-picture view of the Blazor landscape.Key Features Create a production-ready Blazor application from start to finish Learn Blazor fundamentals, gain actionable insights, and discover best practices Find out how, when, and why to use Blazor Server and Blazor WebAssembly, as well as Blazor Hybrid What you will learnUnderstand the different technologies that can be used with Blazor, such as Blazor Server, Blazor WebAssembly, and Blazor Hybrid Find out how to build simple and advanced Blazor components Explore the differences between Blazor Server and Blazor WebAssembly projects Discover how Minimal APIs work and build your own API Explore existing JavaScript libraries in Blazor and JavaScript interoperability Learn techniques to debug your Blazor Server and Blazor WebAssembly applications Test Blazor components using bUnit Who this book is forThis book is for .NET web developers and software developers who want to use their existing C# skills to build interactive SPA applications running either inside the web browser using Blazor WebAssembly, or on the server using Blazor Server. You’ll need intermediate-level web-development skills, basic knowledge of C#, and prior exposure to .NET web development before you get started; the book will guide you through the rest.Table of ContentsTable of Contents Hello Blazor Creating Your First Blazor App Managing State – Part 1 Understanding Basic Blazor Components Creating Advanced Blazor Components Building Forms with Validation Creating an API Authentication and Authorization Sharing Code and Resources JavaScript Interop Managing State Part 2 Debugging the Code Testing Deploy to Production Moving from, or Combining, an Existing Site Going Deeper into WebAssembly Examining Source Generators Visiting .NET MAUI Where to Go from Here

Read more less

Book SynopsisBuild your first digital twin MVP and gain first-hand experience of using the technology, the challenges it presents, and its impact on your organizationKey Features Create a digital twin prototype using Microsoft Azure Digital Twin Explore the digital twin approach to the design, operations, and maintenance of industrial assets and products Understand key characteristics and components of a digital twin through practical use cases and business scenarios Book DescriptionDigital twin technology enables organizations to create digital representations of physical entities such as assets, systems, and processes throughout their life cycle. It improves asset performance, utilization, and safe operations and reduces manufacturing, operational, and maintenance costs. The book begins by introducing you to the concept of digital twins and sets you on a path to develop a digital twin strategy to positively influence business outcomes in your organization. You'll understand how digital twins relate to physical assets, processes, and technology and learn about the prerequisite conditions for the right platform, scale, and use case of your digital twins. You'll then get hands-on with Microsoft's Azure Digital Twins platform for your digital twin development and deployment. The book equips you with the knowledge to evaluate enterprise and specialty platforms, including the cloud and industrial IoT required to set up your digital twin prototype. Once you've built your prototype, you'll be able to test and validate it relative to the intended purpose of the twin through pilot deployment, full deployment, and value tracking techniques. By the end of this book, you'll have developed the skills to build and deploy your digital twin prototype, or minimum viable twin, to demonstrate, assess, and monitor your asset at specific stages in the asset life cycle.What you will learn Identify key criteria for the applicability of digital twins in your organization Explore the RACI matrix and rapid experimentation for choosing the right tech stack for your digital twin system Evaluate public cloud, industrial IoT, and enterprise platforms to set up your prototype Develop a digital twin prototype and validate it using a unit test, integration test, and functional test Perform an RoI analysis of your digital twin to determine its economic viability for the business Discover techniques to improve your digital twin for future enhancements Who this book is forThe digital twin book is for mid-career subject experts, including engineers and operations managers, building their first prototype (MVP) using digital twin technology. The book will help professionals responsible for mechanical, process, and reliability engineering domains. You don't have to be a developer or programmer, but beginner-level programming skills will be helpful.Table of ContentsTable of Contents Introduction to Digital Twin Planning Your Digital Twin Identifying the First Digital Twin Getting Started with Our First Digital Twin Setting Up a Digital Twin Prototype Building the Digital Twin Prototype Deployment and Value Tracking Enhancing the Digital Twin

Read more less