Search results for ""Microsoft Press,U.S.""
Microsoft Press,U.S. Exam Ref 70-761 Querying Data with Transact-SQL
Prepare for Microsoft Exam 70-761–and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Filter, sort, join, aggregate, and modify data • Use subqueries, table expressions, grouping sets, and pivoting • Query temporal and non-relational data, and output XML or JSON • Create views, user-defined functions, and stored procedures • Implement error handling, transactions, data types, and nulls This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer • Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database Querying Data with Transact-SQL About the Exam Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases with Transact-SQL in SQL Server 2016. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification. See full details at: microsoft.com/learning
£26.54
Microsoft Press,U.S. MOS 2010 Study Guide for Microsoft Word, Excel, PowerPoint, and Outlook Exams
Demonstrate your expertise with Microsoft Office 2010! This all-in-one guide is designed to help you practice and prepare for the four core Microsoft Office Specialist (MOS) exams. With the MOS 2010 Study Guide, you get full, objective-by-objective coverage for: Exam 77-881: Microsoft Word 2010 Exam 77-882: Microsoft Excel 2010 Exam 77-883: Microsoft PowerPoint 2010 Exam 77-884: Microsoft Outlook 2010 Use the book’s easy-to-follow procedures and illustrations to review the essential skills measured by the MOS exams. And you can apply what you’ve learned hands-on—using the downloadable files for all the book’s practice tasks.
£30.14
Microsoft Press,U.S. Exam Ref 70331 Core Solutions of Microsoft SharePoint Server 2013 MCSE
Prepare for Exam 70-331 - and help demonstrate your real-world mastery of Microsoft SharePoint Server 2013. This guide focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level.
£13.28
Microsoft Press,U.S. Windows Internals: System architecture, processes, threads, memory management, and more, Part 1
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
£33.29
Microsoft Press,U.S. Exam Ref 70-410 Installing and Configuring Windows Server 2012 R2 (MCSA)
Fully updated for Windows Server 2012 R2! Prepare for Microsoft Exam 70-410 - and help demonstrate your real-world mastery of implementing and configuring core services in Windows Server 2012 R2. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Install and configure servers Configure server roles and features Configure Hyper-V Deploy and configure core network services Install and administer Active Directory Create and manage Group Policy This Microsoft Exam Ref: Organizes its coverage by exam objectives. Features strategic, what-if scenarios to challenge you.
£26.54
Microsoft Press,U.S. Exam Ref 70-697 Configuring Windows Devices
Prepare for Microsoft Exam 70-697–and help demonstrate your real-world mastery of configuring Windows 10 devices in the enterprise. Designed for experienced IT professionals ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Manage identity • Plan desktop and device deployment • Plan and implement a Microsoft 365 Solution • Configure networking • Configure storage • Manage data access and protection • Manage remote access • Manage apps • Manage updates and recovery This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience with Windows desktop administration, maintenance, and troubleshooting; Windows 10 security, and integrated Azure features; as well as a basic understanding of Windows networking, Active Directory, and Microsoft Intune For details on requirements for taking Exam 70-697, go to https://www.microsoft.com/en-us/learning/exam-70-697.aspx
£26.99
Microsoft Press,U.S. Microsoft Excel 2019 Data Analysis and Business Modeling
Master business modeling and analysis techniques with Microsoft Excel 2019, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables–and how to effectively build a relational data source inside an Excel workbook.
£34.19
Microsoft Press,U.S. Analyzing Data with Power BI and Power Pivot for Excel
Renowned DAX experts Alberto Ferrari and Marco Russo teach you how to design data models for maximum efficiency and effectiveness. How can you use Excel and Power BI to gain real insights into your information? As you examine your data, how do you write a formula that provides the numbers you need? The answers to both of these questions lie with the data model. This book introduces the basic techniques for shaping data models in Excel and Power BI. It’s meant for readers who are new to data modeling as well as for experienced data modelers looking for tips from the experts. If you want to use Power BI or Excel to analyze data, the many real-world examples in this book will help you look at your reports in a different way—like experienced data modelers do. As you’ll soon see, with the right data model, the correct answer is always a simple one! By reading this book, you will: • Gain an understanding of the basics of data modeling, including tables, relationships, and keys • Familiarize yourself with star schemas, snowflakes, and common modeling techniques • Learn the importance of granularity • Discover how to use multiple fact tables, like sales and purchases, in a complex data model • Manage calendar-related calculations by using date tables • Track historical attributes, like previous addresses of customers or manager assignments • Use snapshots to compute quantity on hand • Work with multiple currencies in the most efficient way • Analyze events that have durations, including overlapping durations • Learn what data model you need to answer your specific business questions About This Book • For Excel and Power BI users who want to exploit the full power of their favorite tools • For BI professionals seeking new ideas for modeling data
£29.49
Microsoft Press,U.S. Microsoft Excel 2019 Step by Step
The quick way to learn Microsoft Excel 2019! This is learning made easy. Get more done quickly with Microsoft Excel 2019. Jump in wherever you need answers–brisk lessons and detailed screenshots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines Visualize data with 3D maps, funnel charts, and other powerful tools Import, process, summarize, and analyze huge datasets with Excel’s improved PowerPivot and Power Query Build powerful data models and use them in business intelligence Look up just the tasks and lessons you need
£29.99
Microsoft Press,U.S. Programming for Mixed Reality with Windows 10, Unity, Vuforia, and UrhoSharp
Develop AI-powered apps and games for HoloLens and mixed reality headsets This is a complete guide to programming AI-powered mixed reality apps with the Windows Mixed Reality platform. Step by step, Dawid Borycki guides you through every type of mixed reality development, from simple 2D to cutting-edge apps for Microsoft HoloLens and immersive headsets. First, you’ll learn to write UWP 2D apps that adapt for any Windows 10 device, transfer camera images to machine learning services, and use mobile sensor readings to control headset content. Then, building on these skills, you’ll master every facet of building cross-platform 3D apps that link augmented reality content to real objects. Advanced Microsoft technology expert Dawid Borycki shows how to: Set up a mixed reality development environment with all the tools you’ll need, including HoloLens and Mixed Reality simulators Write Universal Windows 2D apps for all Windows 10 devices, and adjust their views and capabilities to specific hardware Render media streams, acquire video from world-facing cameras, and detect human faces in those images Generate descriptions of what the user sees, and present them via text or speech Build AI-powered voice-controlled apps with Microsoft Cognitive Services (MCS) Master core concepts and techniques for building 3D mixed reality apps with Unity Format 3D objects with materials to create holograms Add interactions to holograms based on user input Integrate HoloLens capabilities, including air gestures, spatial sound, and mapping
£36.99
Microsoft Press,U.S. Exam Ref 70-533 Implementing Microsoft Azure Infrastructure Solutions
Prepare for the newest versions of Microsoft Exam 70-533–and help demonstrate your real-world mastery of implementing Microsoft Azure Infrastructure as a Service (IaaS). Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Design and implement Azure App Service Apps Create and manage compute resources, and implement containers Design and implement a storage strategy, including storage encryption Implement virtual networks, including new techniques for hybrid connections Design and deploy ARM Templates Manage Azure security and Recovery Services Manage Azure operations, including automation and data analysis Manage identities with Azure AD Connect Health, Azure AD Domain Services, and Azure AD single sign on This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you are an IT professional with experience implementing and monitoring cloud and hybrid solutions and/or supporting application lifecycle management This book covers the 533 objectives as of December 2017. If there are updates for this book, you will find them at https://aka.ms/examref5332E/errata. About the Exam Exam 70-533 focuses on skills and knowledge for provisioning and managing services in Microsoft Azure, including: implementing infrastructure components such as virtual networks, virtual machines, containers, web and mobile apps, and storage; planning and managing Azure AD, and configuring Azure AD integration with on-premises Active Directory domains. About Microsoft Certification Passing this exam helps qualify you for MCSA: Cloud Platform Microsoft Certified Solutions Associate certification, demonstrating your expertise in applying Microsoft cloud technologies to reduce costs and deliver value. To earn this certification, you must also pass any one of the following exams: 70-532 Developing Microsoft Azure Solutions, or 70-534 Architecting Microsoft Azure Solutions, or 70-535, Architecting Microsoft Azure Solutions, or 70-537: Configuring and Operating a Hybrid Cloud with Microsoft Azure Stack.
£33.49
Microsoft Press,U.S. Microsoft Word 2019 Step by Step
The quick way to learn Microsoft Word 2019 and Word for Office 365!This is learning made easy. Get more done quickly with Microsoft Word 2019 and Word for Office 365. Jump in wherever you need answers--brisk lessons and informative screenshots show you exactly what to do, step by step. Create great-looking, well-organized documents to enhance communication Use headings, bookmarks, and footnotes for more intuitive access to knowledge Visualize information by using diagrams and charts Illustrate concepts by using 3D models, icons, and screen clippings Collaborate, track changes, and coauthor documents in real-time Enforce security and privacy in electronic documents Quickly build tables of contents, indexes, and equations Generate individualized emails, letters, labels, envelopes, directories, and catalogs Supercharge efficiency with custom styles, themes, templates, and building blocks Look up just the tasks and lessons you need
£29.99
Microsoft Press,U.S. Exam Ref 70-745 Implementing a Software-Defined DataCenter
Prepare for Microsoft Exam 70-745–and help demonstrate your real-world mastery of skills needed to build and manage software-defined infrastructure with Windows Server 2016 and System Center 2016 Virtual Machine Manager (SC VMM). Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSE level. Focus on the expertise measured by these objectives: • Plan and implement System Center Virtual Machine Manager (VMM) core infrastructure • Implement Software-Defined Networking (SDN) • Implement software-defined storage • Implement datacenter compute solutions with Virtual Machine Manager (VMM) • Secure your software-defined datacenter • Monitor and maintain the software-defined datacenter This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience with System Center 2012 R2 Virtual Machine Manager and Windows Server 2016 networking, storage, Hyper-V, and Hyper-V Clusters About the Exam Exam 70-745 focuses on skills and knowledge for implementing a software-defined datacenter with Windows Server 2016 and Microsoft System Center 2016 Virtual Machine Manager (SCVMM). About Microsoft Certification Passing this exam earns you credit towards the Microsoft Certified Solutions Expert (MCSE): Cloud Platform and Infrastructure certification, validating that you have skills needed to run a highly efficient and modern data center, with expertise in cloud technologies, identity and systems management, virtualization, storage, and networking. See full details at: microsoft.com/learning
£33.49
Microsoft Press,U.S. Exam Ref 70-480 Programming in HTML5 with JavaScript and CSS3 (MCSD)
Prepare for Microsoft Exam 70-480—and help demonstrate your real-world mastery of programming with HTML5, JavaScript, and CSS3. Designed for experienced developers ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the Microsoft Specialist level. Focus on the expertise measured by these objectives: Implement and manipulate document structures and objects Implement program flow Access and secure data Use CSS3 in applications This Microsoft Exam Ref: Organizes its coverage by exam objectives. Features strategic, what-if scenarios to challenge you.
£29.49
Microsoft Press,U.S. Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
Prepare for Microsoft Exam 70-778–and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Consume and transform data by using Power BI Desktop Model and visualize data Configure dashboards, reports, and apps in the Power BI Service This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI
£40.40
Microsoft Press,U.S. Microsoft Office 2019 Step by Step
This is learning made easy. Get more done quickly with Office 2019. Jump in wherever you need answers - brisk lessons and colorful screenshots show you exactly what to do, step by step. Covers Word, Excel, PowerPoint and Outlook Format Word documents for maximum visual impact Build powerful, reliable Excel workbooks for analysis and reporting Prepare highly effective PowerPoint presentations Use Outlook to organize your email, calendar, and contacts Includes downloadable practice files
£30.59
Microsoft Press,U.S. Microsoft Excel 2019 Pivot Table Data Crunching
Renowned Excel experts Bill Jelen (MrExcel) and Michael Alexander help you crunch data from any source with Excel 2019 pivot tables. Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical “recipes” for solving real business problems, help you avoid common mistakes, and present tips and tricks you’ll find nowhere else. By reading this book, you will: • Master easy, powerful ways to create, customize, change, and control pivot tables • Control all future pivot tables using new pivot table defaults • Transform huge data sets into clear summary reports • Instantly highlight your most profitable customers, products, or regions • Use Power Query to quickly import, clean, shape, and analyze disparate data sources • Build geographical pivot tables with 3D Map • Construct and share state-of-the-art dynamic dashboards • Revamp analyses on the fly by dragging and dropping fields • Build dynamic self-service reporting systems • Share your pivot tables with colleagues • Create data mashups using the full Power Pivot capabilities of Excel 2019 and Excel in Office 365 • Automate pivot tables with macros and VBA • Save time by adapting reports with GetPivotData • Discover today’s most useful pivot table tips and shortcuts
£29.99
Microsoft Press,U.S. Exam Ref 70-698 Installing and Configuring Windows 10
Prepare for Microsoft Exam 70-698—and help demonstrate your real-world mastery of installing, configuring, managing, and maintaining Windows 10 core services. Designed for experienced IT professionals ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement Windows • Configure and support core services • Manage and maintain Windows This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience with installing, configuring, and locally managing and maintaining Windows 10 core services
£32.99
Microsoft Press,U.S. Windows 10 Plain & Simple
Learn the simplest ways to get things done with Windows 10 Here’s WHAT you’ll learn • Navigate Windows 10 Fall Creators Update quickly, easily, and efficiently • Get online with the sleek Microsoft Edge web browser • Make the most of the Cortana personal assistant • Efficiently manage your email, calendar, photos, and more • Access your files from anywhere with Microsoft OneDrive • Help secure your computer and protect your data Here’s HOW you’ll learn • Jump in wherever you need answers • Follow easy steps and screenshots to see exactly what to do • Get handy tips for new techniques and shortcuts • Use Try This! exercises to apply what you learn right away
£19.99
Microsoft Press,U.S. Exam Ref 70-768 Developing SQL Data Models
Prepare for Microsoft Exam 70-768–and help demonstrate your real-world mastery of Business Intelligence (BI) solutions development with SQL Server 2016 Analysis Services (SSAS), including modeling and queries. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Design a multidimensional BI semantic model • Design a tabular BI semantic model • Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) • Configure and maintain SSAS This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you are a database or BI professional with experience creating models, writing MDX or DAX queries, and using SSAS
£29.49
Microsoft Press,U.S. Programming the Microsoft Bot Framework: A Multiplatform Approach to Building Chatbots
This is the only comprehensive, authoritative guide to building Conversational User Interfaces (CUI, a.k.a. bots, chatbots, or chatterbots) with the Microsoft Bot Framework. Reflecting the next radical revolution in human-computer interaction, it will help you leverage advanced artificial intelligence (AI) and natural language processing to empower new and existing applications with stunningly intuitive conversational interfaces. Long-time Microsoft MVP Joe Mayo begins with high-level explanations of what Microsoft Bot Framework is, what you can do with it, and why it matters so much. Next, he presents the foundational knowledge you need to start creating real bots and CUIs. Step by step, you'll learn how to build message dialogs, manage conversations, interact with framework APIs, and incorporate powerful natural language processing with Microsoft's advanced Language Understanding Intelligent Service (LUIS). Mayo also offers detailed guidance on deploying your customized bots to key platforms such as Slack, Skype, and Facebook Messenger. Throughout, Mayo's practical examples combine code with clear explanations of when and why you would perform each task. From start to finish, Programming the Microsoft Bot Framework is relentlessly practical, helping you translate the advanced "magic" of intelligent bots into real solutions right now.
£36.99
Microsoft Press,U.S. Exam Ref 70-345 Designing and Deploying Microsoft Exchange Server 2016
Prepare for Microsoft Exam 70-345—and help demonstrate your real-world mastery of Exchange Server 2016 planning, deployment, migration, management, and troubleshooting. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the skills measured on the exam: Plan, deploy, manage, and troubleshoot mailbox databases Plan, deploy, manage, and troubleshoot client access services Plan, deploy, manage, and troubleshoot transport services Plan, deploy, and manage an Exchange infrastructure, recipients, and security Plan, deploy, and manage compliance, archiving, eDiscovery, and auditing Implement and manage coexistence, hybrid scenarios, migration, and federation This Microsoft Exam Ref: Organizes its coverage by the “Skills measured” posted on the exam webpage Features strategic, what-if scenarios to challenge you Provides exam preparation tips by top trainers Points to in-depth material by topic for exam candidates needing additional review Assumes you have experience designing and managing Exchange Server, and have responsibilities for Exchange Server 2016 messaging in an enterprise environment
£29.49
Microsoft Press,U.S. Exam Ref 70-744 Securing Windows Server 2016
Prepare for Microsoft Exam 70-744–and help demonstrate your real-world mastery of securing Windows Server 2016 environments. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSE level. Focus on the expertise measured by these objectives: • Implement server hardening solutions • Secure a virtualization infrastructure • Secure a network infrastructure • Manage privileged identities • Implement threat detection solutions • Implement workload-specific security This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have experience as a Windows Server administrator and an understanding of basic networking and Hyper-V virtualization fundamentals, Active Directory Domain Services principles, and Windows Server security principles
£29.49
Microsoft Press,U.S. Exam Ref 70-741 Networking with Windows Server 2016
Microsoft Exam 70-741 is for IT Pros interested in enhancing their skills for the latest version of Windows Server. This exam validates skills and knowledge for configuring advanced tasks required to deploy, manage, and maintain a Windows Server 2016 infrastructure, such as fault tolerance, certificate services, and identity federation. Passing this exam along with two other exams is required for MCSA and MCSE certifications. The Exam Ref is the official study guide for Microsoft certification exam 70-741. Featuring concise, objective-by-objective reviews and strategic case scenarios and Thought Experiments, exam candidates get professional-level preparation for the exam. The Exam Ref helps candidates maximize their performance on the exam and sharpen their job-role skills. It organizes material by the exam's objective domains Focus is on the skills measured on the exam: • Implement Domain Name System (DNS) • Implement DHCP • Implement IP Address Management (IPAM) • Implement network connectivity and remote access solutions • Implement core and distributed network solutions • Implement an advanced network infrastructure This Microsoft Exam Ref: • Organizes its coverage by the “Skills measured” posted on the exam webpage • Features strategic, what-if scenarios to challenge you • Points to in-depth material by topic for exam candidates needing additional review • Assumes you are an IT pro looking to validate your skills in and knowledge of installing and configuring Windows Server 2016
£29.49
Microsoft Press,U.S. Microsoft PowerPoint 2016 Step by Step
Now in full color! The quick way to learn Microsoft PowerPoint 2016!This is learning made easy. Get more done quickly with PowerPoint 2016. Jump in wherever you need answers--brisk lessons and colorful screenshots show you exactly what to do, step by step. Get easy-to-follow guidance from a certified Microsoft Office Specialist Master Learn and practice new skills while working with sample content, or look up specific procedures Create attractive electronic presentations and printed publications Incorporate professional design elements Use built-in tools to capture and edit graphics Include audio, video, and animated elements Supercharge your efficiency by creating custom slide masters and layouts Present data in tables, diagrams, and charts
£25.99
Microsoft Press,U.S. Microsoft Excel 2019 Formulas and Functions
Master core Excel tools for building powerful, reliable spreadsheets with Excel 2019 Formulas and Functions. Excel expert Paul McFedries shows how to use Excel core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from AutoFill to Excel’s newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation. Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions; insider insights; even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more. • Quickly create powerful spreadsheets with range names and array formulas • Use conditional formatting to instantly reveal anomalies, problems, or opportunities • Analyze your data with standard tables and PivotTables • Use complex criteria to filter data in lists • Understand correlations between data • Perform sophisticated what-if analyses • Use regression to track trends and make forecasts • Build loan, investment, and discount formulas • Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets
£29.99
Microsoft Press,U.S. MCSA Windows Server 2016 Exam Ref 3Pack
This bundle contains the following three Exam Refs, direct from Microsoft: Exam Ref 70-740 Installation, Storage, and Compute with Windows Server 2016, 9780735698826 Exam Ref 70-741 Networking with Windows Server 2016, 9780735697423 Exam Ref 70-742 Identity with Windows Server 2016, 9780735698819 These are the three exams necessary to receive MCSA certification in Windows Server 2016. This bundles saves the customer $20 versus the price of purchasing the three Exam Refs separately. Prepare for Microsoft certification Exams 70-740, 70-741, and 70-742 Covers all three exams needed for the MCSA in WIndows Server 2016 Save $20 versus the cost of buying the Exam Refs individually Organizes its coverage by the exam objectives Features strategic, what-if scenarios to challenge the exam candi
£73.99
Microsoft Press,U.S. MCSA SQL Server 2016 Database Development Exam Ref 2pack
Direct from Microsoft, this bundle contains the following two study guides at a $15 discount: Exam Ref 70-761 Querying Data with Transact-SQL, 9781509304332, offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with T-SQL database queries. Exam Ref 70-762 Developing SQL Databases, 9781509304912, offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database professionals need to succeed with SQL database development. These are the two exams necessary for the MCSA cer
£47.99
Microsoft Press,U.S. Exam Ref 70-764 Administering a SQL Database Infrastructure
Prepare for Microsoft Exam 70-764—and help demonstrate your real-world mastery of skills for database administration. This exam is intended for database administrators charged with installation, maintenance, and configuration tasks. Their responsibilities also include setting up database systems, making sure those systems operate efficiently, and regularly storing, backing up, and securing data from unauthorized access. Focus on the expertise measured by these objectives: • Configure data access and auditing • Manage backup and restore of databases • Manage and monitor SQL Server instances • Manage high availability and disaster recovery This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of database installation, configuration, and maintenance tasks. You should also have experience with setting up database systems, ensuring those systems operate efficiently, regularly storing and backing up data, and securing data from unauthorized access. About the Exam Exam 70-764 focuses on skills and knowledge required for database administration. About Microsoft Certification Passing both Exam 70-764 and Exam 70-765 (Provisioning SQL Databases) earns you credit toward an MCSA: SQL 2016 Database Administration certification. See full details at: microsoft.com/learning
£29.49
Microsoft Press,U.S. MOS 2016 Study Guide for Microsoft Excel
Advance your everyday proficiency with Excel 2016. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel 2016 Core 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 Practice files and sample solutions Sharpen the skills measured by these objectives: Create and manage worksheets and workbooks Manage data cells and ranges Create tables Perform operations with formulas and functions Create charts and objects 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.
£15.29
Microsoft Press,U.S. Training Kit Exam 70462 Administering Microsoft SQL Server 2012 Databases MCSA
This 2-in-1 Training Kit delivers preparation plus practice for Microsoft Exam 70-462. Ace your exam prep - and enhance your job skills - with hands-on lessons, practice tests, and other resources.
£51.97
Microsoft Press,U.S. Tabular Modeling in Microsoft SQL Server Analysis Services
With SQL Server Analysis Services 2016, Microsoft has dramatically upgraded its Tabular approach to business intelligence data modeling, making Tabular the easiest and best solution for most new projects. In this book, two world-renowned experts in Microsoft data modeling and analysis cover all you need to know to create complete BI solutions with these powerful new tools. Marco Russo and Alberto Ferrari walk you step-by-step through creating powerful data models, and then illuminate advanced features such as optimization, deployment, and scalability. Tabular Modeling in Microsoft SQL Server Analysis Services will be indispensable for everyone moving to Analysis Services Tabular, regardless of their previous experience with tabular-style models or with Microsoft's older Analysis Services offerings. It will also be an essential follow-up for every reader of the authors' highly-praised Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.
£40.04
Microsoft Press,U.S. MOS 2016 Study Guide for Microsoft Word Expert
Advance your expert skills in Word 2016. And earn the credential that proves it!! Demonstrate your expertise with Microsoft Word! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Word 2016 Expert certification, this official Study Guide delivers: In-depth exam prep for each MOS objective Detailed procedures to help build the skills measured by the exam Hands-on tasks to apply what you’ve learned Practice and review questions Ready-made practice files with solutions Sharpen the skills measured by these MOS objectives: Manage Document Options and Settings Design Advanced Documents Create Advanced References Create Custom Word Elements
£16.64
Microsoft Press,U.S. Programming Microsoft Azure Service Fabric
Build, operate, and orchestrate scalable microservices applications in the cloud This book combines a comprehensive guide to success with Microsoft Azure Service Fabric and a practical catalog of design patterns and best practices for microservices design, implementation, and operation. Haishi Bai brings together all the information you’ll need to deliver scalable and reliable distributed microservices applications on Service Fabric. He thoroughly covers the crucial DevOps aspects of utilizing Service Fabric, reviews its interactions with key cloud-based services, and introduces essential service integration mechanisms such as messaging systems and reactive systems. Leading Microsoft Azure expert Haishi Bai shows how to: Set up your Service Fabric development environment Program and deploy Service Fabric applications to a local or a cloud-based cluster Compare and use stateful services, stateless services, and the actor model Design Service Fabric applications to maximize availability, reliability, and scalability Improve management efficiency via scripting Configure network security and other advanced cluster settings Collect diagnostic data, and use Azure Operational Management Suite to interpret it Integrate microservices components developed in parallel Use containers to mobilize applications for failover, replication, scaling, and load balancing Streamline containerization with Docker in Linux and Windows environments Orchestrate containers to schedule workloads and maintain services at desired states Implement proven design patterns for common cloud application workloads Balance throughput, latency, scalability, and cost
£33.29
Microsoft Press,U.S. Exam Ref 70-346 Managing Office 365 Identities and Requirements
Prepare for Microsoft Exam 70-346, and demonstrate your real-world mastery of the skills needed to provision, manage, monitor, and troubleshoot Microsoft Office 365 identities and cloud services. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. The new Second Edition reflects all updated exam topics released by Microsoft through mid-2017. It covers the expertise measured by the following objectives: Provision Office 365 Plan and implement networking and security in Office 365 Manage cloud identities Implement and manage identities by using DirSync Implement and manage Federated Identities single sign on Monitor and troubleshoot Office 365 availability and usage Microsoft Exam Ref publications stand apart from third-party study guides because they: Provide guidance from Microsoft, the creator of Microsoft certification exams Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all content Streamline study by organizing material according to the exam’s objective domain (OD), covering one functional group and its objectives in each chapter Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions Explore big picture thinking around the planning and design aspects of the IT pro’s job role See full details about Exam 70-346 at: microsoft.com/learning
£26.54
Microsoft Press,U.S. Exam Ref 70774 Perform Cloud Data Science with Azure Machine Learning
Prepares students for Microsoft Exam 70-774-and helps them demonstrate real-world mastery of performing key data science activities with Azure Machine Learning services. Designed for experienced IT students ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
£26.54
Microsoft Press,U.S. Exam Ref 70-765 Provisioning SQL Databases
Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: • Implement SQL in Azure • Manage databases and instances • Manage storage This Microsoft Exam Ref: • Organizes its coverage by exam objectives • Features strategic, what-if scenarios to challenge you • Assumes you have working knowledge of SQL Server administration and maintenance, as well as Azure skills Provisioning SQL Databases About the Exam Exam 70-765 focuses on skills and knowledge for provisioning, upgrading, and configuring SQL Server; managing databases and files; and provisioning, migrating, and managing databases in the Microsoft Azure cloud. About Microsoft Certification Passing this exam as well as Exam 70-764: Administering a SQL Database Infrastructure earns you MCSA: SQL 2016 Database Administration certification, qualifying you for a position as a database administrator or infrastructure specialist. See full details at: microsoft.com/learning
£26.54
Microsoft Press,U.S. Microsoft Excel 2016 Step by Step
Now in full color! The quick way to learn Microsoft Excel 2016! This is learning made easy. Get more done quickly with Excel 2016. Jump in wherever you need answers--brisk lessons and full-color screen shots show you exactly what to do, step by step. Quickly set up workbooks, enter data, and format it for easier viewing Perform calculations and find and correct errors Filter, sort, summarize, and combine data Analyze data by using PivotTables, PivotCharts, scenarios, data tables, and Solver Visualize data with charts and graphs, including new sunbursts, waterfalls, and treemaps Build data models and use them in business intelligence analyses Create timelines, forecasts, and visualizations, including KPIs and PowerMap data maps Look up just the tasks and lessons you need
£23.39
Microsoft Press,U.S. MOS 2016 Study Guide for Microsoft Excel Expert
Hone your advanced Excel 2016 skills. And earn the credential that proves it! Demonstrate your expertise with Microsoft Excel! Designed to help you practice and prepare for Microsoft Office Specialist (MOS): Excel Expert 2016 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: Create and Manage Workbooks Apply Custom Formatting and Layouts Create Advanced Formulas Perform Data Analysis Create Advanced Charts and PivotTables
£25.75
Microsoft Press,U.S. Microsoft Excel 2019 VBA and Macros
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won’t find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Excel 2019 and Excel in Office 365. You’ll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate pivot tables to summarize, analyze, explore, and present data Use custom dialog boxes to collect data from others using Excel Improve the reliability and resiliency of your macros Integrate data from the internet, Access databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Create powerful solutions with classes, collections, and custom functions Solve sophisticated business analysis problems more rapidly About This Book For everyone who wants to get more done with Microsoft Excel in less time For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data
£26.99
Microsoft Press,U.S. T-SQL Fundamentals
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
£33.29
Microsoft Press,U.S. Modernizing the Datacenter with Windows Server and Hybrid Cloud
Transform your datacenter for breakthrough flexibility, agility, and scalability! Using public, private, and hybrid cloud services, you can transform your datacenter to serve fast-changing workloads, process and analyze enormous amounts of data, and achieve unprecedented flexibility and value. In this guide, two world-renowned experts in Microsoft datacenter technology show how to effectively leverage current legacy systems as you incorporate your optimal mix of cloud services. Drawing on extensive experience implementing Microsoft cloud solutions, they walk you step-by-step through your entire transition: strategy, deployment, security, identity protection, management, PowerShell automation, and more. Two concluding chapters offer indispensable advice for maximizing datacenter efficiency and supporting future innovation. Two leading enterprise cloud and Windows Server experts show how to: Move from legacy IT models to an agile service structure Implement managed self-service, iteration-based software updates, immutable infrastructure, and other elements of a modern IT environment Plan and smoothly integrate on-premises, Azure, Azure Stack, and Hybrid Cloud components Fortify IT security now and in the future Safeguard identities via new models and tools, including Remote Credential Guard Protect the OS, on premises and in the cloud Optimize datacenter efficiency via enterprise-class virtualization and other advanced technologies Promote innovation via microservices, DevOps, and NanoServer containerization
£34.19
Microsoft Press,U.S. Windows 10 Step by Step
The quick way to learn today’s Windows 10! This is learning made easy. Get more done quickly with the newest version of Windows 10. Jump in wherever you need answers–brisk lessons and colorful screenshots show you exactly what to do, step by step. Do what you want to do with Windows 10! Explore fun and functional improvements in the newest version Customize your sign-in and manage connections Quickly find files on your computer or in the cloud Tailor your Windows 10 experience for easy access to the information and tools you want Work more efficiently with Quick Action and other shortcuts Get personalized assistance and manage third-party services with Cortana Interact with the web faster and more safely with Microsoft Edge Protect your computer, information, and privacy
£29.49
Microsoft Press,U.S. Exam Ref 70-347 Enabling Office 365 Services
Prepare for Microsoft Exam 70-347--and help demonstrate your real-world mastery of the skills needed to help securely and efficiently provide Microsoft Office 365 services in any environment. Designed for experienced IT pros ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: Manage clients and end-user devices Provision Microsoft SharePoint Online site collections Configure Microsoft Exchange Online and Skype for Business for end users Plan for Exchange Online and Skype for Business This Microsoft Exam Ref: Organizes its coverage by exam objectives Features strategic, what-if scenarios to challenge you Provides exam preparation tips written by a top trainer, consultant, and sysadmin Assumes you have experience with the Office 365 Admin Center and an understanding of Exchange Online, Skype for Business, SharePoint Online, Office 365 ProPlus, and Microsoft Azure Active Directory
£26.54
Microsoft Press,U.S. Programming ASP.NET Core
The complete, pragmatic guide to building high-value solutions with ASP.NET Core Programming ASP.NET Core is the definitive guide to practical web-based application development with Microsoft’s new ASP.NET Core framework. Microsoft MVP Dino Esposito introduces proven techniques and well-crafted example code for solving real problems with ASP.NET Core. Step by step, he guides you through using all key ASP.NET Core technologies, including MVC for HTML generation, .NET Core, EF Core, ASP.NET Identity, dependency injection, and much more. Esposito thoroughly covers ASP.NET Core’s cross-platform capabilities and what’s changed from older ASP.NET versions, but he doesn’t stop there: he offers a complete learning path for every developer who wants to build production solutions, including mobile-specific solutions. Microsoft MVP Dino Esposito shows how to: • Create new projects and understand their structure • Set up and use the familiar MVC application model in ASP.NET Core • Write controller class code to govern all stages of request processing • Serve HTML from controllers, or directly via Razor Pages • Master the Razor language for quickly defining the layout of HTML views • Manage cross-cutting concerns such as global configuration data, error and exception handling, controller class design, and dependency injection • Secure applications with user authentication and ASP.NET Core’s policy-based user authorization API • Design for efficient data access, and choose the right option for reading and writing data • Build ASP.NET Core Web APIs that return JSON, XML, or other data • Use data binding to programmatically update visual components with fresh information • Build device-friendly web views for iOS and Android • Explore the radically new ASP.NET Core runtime environment and Dependency Injection (DI) infrastructure
£36.99
Microsoft Press,U.S. Exam Ref 70-743 Upgrading Your Skills to MCSA: Windows Server 2016
About the Book: Prepare for Microsoft Exam 70-743—and demonstrate that your skills are upgraded for Windows Server 2016. Designed for experienced IT pros ready to advance their status, this Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the skills measured on the exam: • Install Windows servers in host and compute environments • Implement storage solutions • Implement Hyper-V • Implement Windows containers• Implement high availability• Implement Domain Name System (DNS)• Implement IP Address Management (IPAM)• Implement network connectivity and remote access solutions• Implement an advanced network infrastructure• Install and configure Active Directory Domain Services (AD DS)• Implement identity federation and access solutions This Microsoft Exam Ref: • Organizes its coverage by the “Skills measured” posted on the exam webpage • Features strategic, what-if scenarios to challenge you • Points to in-depth material by topic for exam candidates needing additional review • Assumes you are an IT pro looking to validate your skills in and knowledge of installing and configuring Windows Server 2016
£29.49
Microsoft Press,U.S. Exam Ref 70-740 Installation, Storage and Compute with Windows Server 2016
Prepare for Microsoft Exam 70-740—and help demonstrate your real-world mastery of Windows Server 2016 installation, storage, and compute features and capabilities. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: •Install Windows Servers in host and compute environments •Implement storage solutions •Implement Hyper-V •Implement Windows containers •Implement high availability •Maintain and monitor server environments This Microsoft Exam Ref: •Organizes its coverage by exam objectives •Features strategic, what-if scenarios to challenge you •Assumes you have experience working with Windows Server in an enterprise environment; are familiar with core networking infrastructure, topologies, architectures, and protocols; and have experience with Windows clients and virtualization About the Exam Exam 70-740 focuses on the skills and knowledge necessary to implement and configure storage and compute features and functionality in Windows Server 2016. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of core Windows Server 2016 skills for reducing IT costs and delivering more business value. Exam 70-741 (Networking with Windows Server 2016) and Exam 70-742 (Identity with Windows Server 2016) are also required for MCSA: Windows Server 2016 certification. See full details at: microsoft.com/learning
£29.49