-Titulo Original : T-sql Fundamentals-Fabricante : Microsoft Press-Descripcion Original: Effectively query and modify data using Transact-SQLMaster T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database. Itzik Ben-Gan explains key T-SQL concepts and helps you apply your knowledge with hands-on exercises. The book first introduces T-SQL’s roots and underlying logic. Next, it walks you through core topics such as single-table queries, joins, subqueries, table expressions, and set operators. Then the book covers more-advanced data-query topics such as window functions, pivoting, and grouping sets. The book also explains how to modify data, work with temporal tables, and handle transactions, and provides an overview of programmable objects. Microsoft Data Platform MVP Itzik Ben-Gan shows you how to: Review core SQL concepts and its mathematical roots Create tables and enforce data integrity Perform effective single-table queries by using the SELECT statement Query multiple tables by using joins, subqueries, table expressions, and set operators Use advanced query techniques such as window functions, pivoting, and grouping sets Insert, update, delete, and merge data Use transactions in a concurrent environment Get started with programmable objects-from variables and batches to user-defined functions, stored procedures, triggers, and dynamic SQL About the Author TZIK BEN-GAN is a mentor with and co-founder of SolidQ. A Microsoft Data Platform MVP since 1999, Itzik has taught numerous training events around the world focused on T-SQL querying, query tuning, and programming. Itzik is the author of several books about T-SQL. He has written many articles for SQL Server Pro as well as articles and white papers for MSDN and The SolidQ Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server Connections, presentations to various SQL Server user groups, and SolidQ events. Itzik is a subject-matter expert within SolidQ for its T-SQL related activities. He authored SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly worldwide. You can learn more about Itzik at ...

-Titulo Original : Microsoft Onenote Step By Step-Fabricante : Microsoft Press-Descripcion Original: The quick way to learn Microsoft OneNote! This is learning made easy. Get productive fast with OneNote and jump in wherever you need answers. Brisk lessons and colorful screenshots show you exactly what to do, step by step--and practice files help you build your skills. Access local and online OneNote notebooks from any device Create notes that include handwriting, drawings, screen clips, audio clips, video clips, and structured equations Revise, reorganize, flag, format, search, and share your notes Customize OneNote for the way you like to work Get more done by integrating OneNote with Microsoft Word, Excel, and Outlook Share notes by using email, Microsoft OneDrive, and SharePoint Look up just the tasks and lessons you need About the Author Curtis Frye is the author of more than 30 books, including Microsoft Excel 2016 Step by Step for Microsoft Press and Brilliant Excel VBA Programming for Pearson, UK. He has also created and recorded more than three dozen courses for lynda , including Tableau 9 Essential Training and Up and Running with Public Data Sets. In addition to his work as a writer, Curt is a popular conference speaker and performer, both as a solo presenter and as part of the Portland, Oregon ComedySportz improvisational comedy troupe. He lives in Portland with his wife and three cats...

-Titulo Original : Windows Internals, Part 1 System Architecture, Processes, Threads, Memory Management, And More (developer Reference)-Fabricante : Microsoft Press-Descripcion Original: The definitive guide-fully updated for Windows 10 and Windows Server 2016 Delve inside Windows architecture and internals, and see how core components work behind the scenes. Led by a team of internals experts, this classic guide has been fully updated for Windows 10 and Windows Server 2016. Whether you are a developer or an IT professional, you’ll get critical, insider perspectives on how Windows operates. And through hands-on experiments, you’ll experience its internal behavior firsthand-knowledge you can apply to improve application design, debugging, system performance, and support. This book will help you: - Understand the Window system architecture and its most important entities, such as processes and threads - Examine how processes manage resources and threads scheduled for execution inside processes - Observe how Windows manages virtual and physical memory - Dig into the Windows I/O system and see how device drivers work and integrate with the rest of the system - Go inside the Windows security model to see how it manages access, auditing, and authorization, and learn about the new mechanisms in Windows 10 and Server 2016 About the Author Pavel Yosifovich is a software developer and trainer, specializing in Microsoft technologies and tools. He is also an MVP and a PluralSight author...

-Titulo Original : Software Estimation Demystifying The Black Art (developer Best Practices)-Fabricante : Microsoft Press-Descripcion Original: Often referred to as the “black art” because of its complexity and uncertainty, software estimation is not as difficult or puzzling as people think. In fact, generating accurate estimates is straightforward once you understand the art of creating them. In his highly anticipated book, acclaimed author Steve McConnell unravels the mystery to successful software estimation distilling academic information and real-world experience into a practical guide for working software professionals. Instead of arcane treatises and rigid modeling techniques, this guide highlights a proven set of procedures, understandable formulas, and heuristics that individuals and development teams can apply to their projects to help achieve estimation proficiency. Discover how to: Estimate schedule and cost or estimate the functionality that can be delivered within a given time frame Avoid common software estimation mistakes Learn estimation techniques for you, your team, and your organization * Estimate specific project activities including development, management, and defect correction Apply estimation approaches to any type of project small or large, agile or traditional Navigate the shark-infested political waters that surround project estimates When many corporate software projects are failing, McConnell shows you what works for successful software estimation. From the Publisher Unlike other books that focus exclusively on the science of estimation including rigid modeling techniques and continuous feedback loops that are not cost effective to most organizations this unique guide offers practical, tested, hands-on advice for estimating software development costs in the real world. It is written by the award-winning author of Code Complete. Key Book Benefits: Delivers practical insights about a critical subject too-often obscured by academic jargon Two-color graphics present mathematical information in an easy-to-understand format Provides specific practices that can be used immediately by any software development organization Features numerous, to-the-point tips about the estimation process, as well as individual steps to creating successful estimates About the Author Steve McConnell is recognized as one of the premier authors and voices in the development community. He is Chief Software Engineer of Construx Software and was the lead developer of Construx Estimate and of SPC Estimate Professional, winner of Software Development magazines Productivity Award. He is the author of several books, including Code Complete and Rapid Development, both honored with Software Development magazines Jolt Award...

-Titulo Original : Microsoft Excel Data Analysis And Business Modeling (office 2021 And Microsoft 365)-Fabricante : Microsoft Press-Descripcion Original: Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston’s hands-on, scenario-focused guide helps you use today’s Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts. Solve real problems with Microsoft Excel and build your competitive advantage Quickly transition from Excel basics to sophisticated analytics Use recent Power Query enhancements to connect, combine, and transform data sources more effectively Use the LAMBDA and LAMBDA helper functions to create Custom Functions without VBA Use New Data Types to import data including stock prices, weather, information on geographic areas, universities, movies, and music Build more sophisticated and compelling charts Use the new XLOOKUP function to revolutionize your lookup formulas Master new Dynamic Array formulas that allow you to sort and filter data with formulas and find all UNIQUE entries Illuminate insights from geographic and temporal data with 3D Maps Improve decision-making with probability, Bayes’ theorem, and Monte Carlo simulation and scenarios Use Excel trend curves, multiple regression, and exponential smoothing for predictive analytics Use Data Model and Power Pivot to effectively build and use relational data sources inside an Excel workbook About the Author Wayne L. Winston is Professor Emeritus of Decision Sciences at the Indiana University School of Business. He has also taught at the University of Houston and Wake Forest. He has won more than 40 teaching awards and taught Excel modeling and analytics at many Fortune 500 companies, accounting firms, the U.S. Army, and the U.S. Navy. He is a two-time Jeopardy! champion, and also is a co-developer of a player tracking system utilized by Mark Cuban and the Dallas Mavericks...

-Titulo Original : Exam Ref Sc-200 Microsoft Security Operations Analyst-Fabricante : Microsoft Press-Descripcion Original: Prepare for Microsoft Exam SC-200 and help demonstrate your real-world mastery of skills and knowledge required to work with stakeholders to secure IT systems, and to rapidly remediate active attacks. Designed for Windows administrators, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level. Focus on the expertise measured by these objectives: Mitigate threats using Microsoft 365 Defender Mitigate threats using Azure Defender Mitigate threats using Azure Sentinel This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience with threat management, monitoring, and/or response in Microsoft 365 environments About the Exam Exam SC-200 focuses on knowledge needed to detect, investigate, respond, and remediate threats to productivity, endpoints, identity, and applications; design and configure Azure Defender implementations; plan and use data connectors to ingest data sources into Azure Defender and Azure Sentinel; manage Azure Defender alert rules; configure automation and remediation; investigate alerts and incidents; design and configure Azure Sentinel workspaces; manage Azure Sentinel rules and incidents; configure SOAR in Azure Sentinel; use workbooks to analyze and interpret data; and hunt for threats in the Azure Sentinel portal. About Microsoft Certification Passing this exam fulfills your requirements for the Microsoft 365 Certified: Security Operations Analyst Associate certification credential, demonstrating your ability to collaborate with organizational stakeholders to reduce organizational risk, advise on threat protection improvements, and address violations of organizational policies. See full details at: microsoft /lear...

-Titulo Original : Exam Ref Da-100 Analyzing Data With Microsoft Power Bi-Fabricante : Microsoft Press-Descripcion Original: Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced data analytics professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the Microsoft Certified Associate level. Focus on the expertise measured by these objectives: Prepare the data Model the data Visualize the data Analyze the data Deploy and maintain deliverables This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an experienced business intelligence professional or data analyst, or have a similar role Analyzing Data with Microsoft Power BI About the Exam Exam DA-100 focuses on skills and knowledge needed to acquire, profile, clean, transform, and load data; design and develop data models; create measures with DAX; optimize model performance; create reports and dashboards; enrich reports for usability; enhance reports to expose insights; perform advanced analysis; manage datasets, and create and manage workspaces. About Microsoft Certification Passing this exam earns your Microsoft Certified: Data Analyst Associate certification, demonstrating your ability to help businesses maximize the value of data assets by using Microsoft Power BI. As subject matter experts, Data Analysts design and build scalable data models, clean and transform data, and enable advanced analytic capabilities that provide meaningful business value through easy-to-comprehend data visualizations. See full details at: microsoft /learn About the Author DANIIL MASLYUK is an independent business intelligence consultant, trainer, and speaker who specializes in Microsoft Power BI. Daniil blogs at xxlbi and tweets as @DMaslyuk. ...

-Titulo Original : Mos Study Guide For Microsoft Word Exam Mo-100-Fabricante : Microsoft Press-Descripcion Original: Advance your proficiency with Word. And earn the credential that proves it! Demonstrate your expertise with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist: Word Associate (Word and Word 2019) certification, this official Study Guide delivers: * In-depth preparation for each MOS objective * Detailed procedures to help build the skills measured by the exam * Hands-on tasks to practice what you’ve learned * Ready-made practice files Sharpen the skills measured by these objectives: * Manage Documents * Insert and Format Text, Paragraphs, and Sections * Manage Tables and Lists * Create and Manage References * Insert and Format Graphic Elements EXAM MO-100 About the MOS: Associate Certification A Microsoft Office Specialist (MOS): Associate certification validates your hands-on competency in the correct application of the principal features of an Office product. It demonstrates that you can apply these features to complete associate-level tasks independently and are ready to enter the job market. See full details at: microsoft /learn Practice Files Available at: MicrosoftPressStore /MOSWord100/Downloads About the Author Joan Lambert is a training and certification specialist who has worked closely with Microsoft technologies since 1986, authored over 50 books about Windows and Office, and holds multiple Microsoft certifications...

-Titulo Original : Mos Study Guide For Microsoft Excel Expert Exam Mo-201-Fabricante : Microsoft Press-Descripcion Original: Advance your expert-level proficiency with Excel. And earn the credential that proves it! Demonstrate your expert-level competency with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Microsoft Excel Expert (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Workbook Options and Settings Manage and Format Data Create Advanced Formulas and Macros Manage Advanced Charts and Tables About the MOS: Expert Certification A Microsoft Office Specialist (MOS): Expert certification validates your hands-on experience and competency with an Office product at an expert level. It demonstrates that you can apply the product’s principal features at an advanced level, can complete expert tasks independently, and are ready to enter the job market. See full details at: microsoft /learn Practice Files Available at: MicrosoftPressStore / MOSExcelExpert201/downloads About the Author Paul McFedries, a Microsoft Office expert and owner of the technical writing company Logophilia Limited, has authored nearly 100 books, including Microsoft Excel 2019 Formulas and Functions. Combined, his books have sold more than 4 million copies worldwide...

-Titulo Original : Mos Study Guide For Microsoft Excel Exam Mo-200-Fabricante : Microsoft Press-Descripcion Original: Advance your everyday proficiency with Excel! And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist: Excel Associate (Excel and Excel 2019) certification, this official Study Guide delivers: In-depth preparation for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to practice what you’ve learned Ready-made practice files Sharpen the skills measured by these objectives: Manage Worksheets and Workbooks Manage Data Cells and Ranges Manage Tables and Table Data Perform Operations by Using Formulas and Functions Manage Charts About MOS A Microsoft Office Specialist (MOS) certification validates your proficiency with Microsoft Office programs, demonstrating that you can meet globally recognized performance standards. Hands-on experience with the technology is required to successfully pass Microsoft Certification exams. About the Author Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997, guiding the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than four dozen books about Windows and Office (for Windows, Mac, and iPad), six generations of Microsoft Office Specialist certification study guides, video-based training courses for SharePoint and OneNote, QuickStudy guides for Windows 10 and Office 2016, and GO! series books for Outlook. Joan is a Microsoft Certified Professional, Microsoft Office Specialist Master (for all versions of Office since Office 2003), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), Microsoft Dynamics Specialist, and Microsoft Certified Trainer. She is also certified in Adobe InDesign and Intuit QuickBooks. A native of the Pacific Northwest and enthusiastic world traveler, Joan is now blissfully based in America’s Finest City with her simply divine daughter Trinity, Thai host daughter Thopad, and their faithful canine, feline, and aquatic companions...

-Titulo Original : Windows Internals, Part 2 (developer Reference)-Fabricante : Microsoft Press-Descripcion Original: The definitive guide to modern Windows internals: new coverage of virtualization, file systems, boot, security, and more. For advanced computing professionals, this is the definitive up-to-date guide to how Windows core components behave “under the hood.” Using it, experienced developers can build more powerful and scalable software, administrators can debug complex system and performance problems, and security researchers can harden their systems. This Seventh Edition is fully updated through the May 2021 (21H1/2104) updates to Windows 10 and Windows Server (2022, 2019, and 2016). It adds extensive content on Hyper-V, plus fully rewritten chapters on the boot process, new storage technologies, and Windows system and management mechanisms. As always, it delivers unparalleled insight based on insider access to Microsoft source code, with hands-on experiments using the latest debugging tools to show you Windows’ internal behaviors firsthand. With Windows 11 introducing new user interface design elements that build upon the same core technologies as Windows 10, readers will be well-prepared for this new chapter of computing. Leading Windows insiders help you: * Discover system mechanisms for serving device drivers and applications, including ALPC, Object Manager, synchronization, WNF, WoW64, and the processor execution model * Explore underlying hardware architecture, including trap processing, segmentation, and side channel vulnerabilities * Understand Windows virtualization, and how virtualization-based security (VBS) protects against OS vulnerabilities * Delve into key management and configuration mechanisms, including the Registry, Windows services, WMI, and Task Scheduling * Explore diagnostic services such as Event Tracing for Windows (ETW) and DTrace * Learn how the cache manager and file system drivers interact to provide reliable support for files, directories, and disks, including on Persistent Memory (NVDIMM) DAX devices. * Understand NTFS, ReFS, and other Windows file systems * Review Windows startup/shutdown operations, and OS components involved in boot flow * Analyze UEFI-based Secure Boot, Measured Boot, and Secure Launch About This Book * For experienced programmers, architects, software quality and performance specialists, administrators, security practitioners, and support professionals * Assumes you are a Windows power user About the Author Andrea Allievi (Greater Seattle, WA Area) is a Senior Kernel Engineer with more than 15 years of experience in the field. He works in the Windows Core OS team at Microsoft, where he designs and develops robust Windows kernel Security features. He is also active in the security research community and often speaks at conferences, including Recon and Blue Hat. He started as a Security Researcher in small Italian companies such as TgSoft and SaferBytes. He then moved to the Talos group at Cisco Systems, where his time was split between the development of anti-virus and anti-rootkit tools and security research of offensive and defensive technologies, particularly in the Windows kernel. In that time, after the design of the first UEFI Bootkit and the bypass of the Windows 8.1 Kernel Patch Protection, he became an internationally recognized expert in the operating systems internals. Alex Ionescu (Greater Seattle, WA Area) is a Senior Vice President of Endpoint Security at CrowdStrike, and an internationally recognized expert in low-level system software, operating system research and kernel development, security training, and reverse engineering. He teaches Windows Internals courses around the world and is active in the security research community through conference talks and bug bounty programs.Mark E. Russinovich (Seattle, WA Area) is a Technical Fellow in the Windows Azure Group at Microsoft, focusing on the Microsoft Cloud. He is a widely recognized expert in operating systems, distributed systems, and cy...

-Titulo Original : Windows Powershell Step By Step-Fabricante : Microsoft Press-Descripcion Original: Your hands-on guide to Windows PowerShell scripting fundamentals Expand your expertise--and teach yourself the fundamentals of Windows PowerShell scripting, including features available in Windows PowerShell 5. If you are an IT professional, power user, or consultant, you’ll get the guidance, exercises, and code you need to master core techniques for automating Windows setup, deployment, and management. Discover how to: Run cmdlets and command-line utilities Administer Windows-based servers and desktops with built-in cmdlets Use providers to access external information Write and run scripts from the Windows ISE Create functions that are easy to maintain Build standardized environments with profiles Automate Windows systems with WMI, CIM cmdlets, and remoting Automate Active Directory Domain Services (AD DS) Debug scripts and handle errors Run commands that survive interruptions Use Desired State Configuration (DSC) to manage software services and their environments Get powerful new modules from PowerShell Gallery About You This book is for: IT professionals and power users who want to get productive with Windows PowerShell, including new features in Windows PowerShell 5 Windows system administrators who want to be more efficient and productive Anyone pursuing Windows PowerShell certifications No experience with Windows PowerShell or other scripting technologies necessary About the Author Ed Wilson is the Microsoft Scripting Guy and a well-known scripting expert. He writes the daily Hey Scripting Guy! Blog--the most popular blog on TechNet. He has also spoken at TechEd and at the Microsoft internal TechReady conferences. He has written more than a dozen books, including nine on Windows scripting that were published by Microsoft Press. His books include Windows PowerShell Best Practices and Microsoft VBScript Step by Step...