Practical SQL
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. Create databases and related tables using your own data; Define the right data types for your information; Aggregate, sort, and filter data to find patterns; Use basic math and advanced statistical functions; Identify errors in data and cle ...
Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools. You'll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently. Create databases and related tables using your own data; Define the right data types for your information; Aggregate, sort, and filter data to find patterns; Use basic math and advanced statistical functions; Identify errors in data and cle ...
Exam Ref 70-346 Managing Office 365 Identities and Requirements, 2nd Edition
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-l ...
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-l ...
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. ...
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. ...
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. ...
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. ...
Exam Ref 70-762 Developing SQL Databases
Prepare for Microsoft Exam 70-762, Developing SQL Databases - and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, 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 database objects; Implement programmability objects; Manage database concurrency; Optimize database objects and SQL infrastructure. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases. Exam 70-762 focuses on skills and knowledge for building and implementing databases across organizations and ensuring high levels of data availa ...
Prepare for Microsoft Exam 70-762, Developing SQL Databases - and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, 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 database objects; Implement programmability objects; Manage database concurrency; Optimize database objects and SQL infrastructure. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working knowledge of Microsoft Windows, Transact-SQL, and relational databases. Exam 70-762 focuses on skills and knowledge for building and implementing databases across organizations and ensuring high levels of data availa ...
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 Serve ...
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 Serve ...
Exam Ref 70-767 Implementing a SQL Data Warehouse
Prepare for Microsoft Exam 70-767 - and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package. Focus on the expertise measured by these objectives: Design, and implement, and maintain a data warehouse; Extract, transform, and load data; Build data quality solutions. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working kno ...
Prepare for Microsoft Exam 70-767 - and help demonstrate your real-world mastery of skills for managing data warehouses. This exam is intended for Extract, Transform, Load (ETL) data warehouse developers who create business intelligence (BI) solutions. Their responsibilities include data cleansing as well as ETL and data warehouse implementation. The reader should have experience installing and implementing a Master Data Services (MDS) model, using MDS tools, and creating a Master Data Manager database and web application. The reader should understand how to design and implement ETL control flow elements and work with a SQL Service Integration Services package. Focus on the expertise measured by these objectives: Design, and implement, and maintain a data warehouse; Extract, transform, and load data; Build data quality solutions. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have working kno ...
Exam Ref 70-535 Architecting Microsoft Azure Solutions
Prepare for Microsoft Exam 70-535 - and help demonstrate your real-world mastery of architecting complete cloud solutions on the Microsoft Azure platform. Designed for architects and other cloud 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 compute infrastructure; Design data implementation; Design networking implementation; Design security and identity solutions; Design solutions by using platform services; Design for operations. This Microsoft Exam Ref: Organizes its coverage by exam skills; Features strategic, what-if scenarios to challenge you; Includes DevOps and hybrid technologies and scenarios; Assumes you have experience building infrastructure and applications on the Microsoft Azure platform, and understand the services it offers. ...
Prepare for Microsoft Exam 70-535 - and help demonstrate your real-world mastery of architecting complete cloud solutions on the Microsoft Azure platform. Designed for architects and other cloud 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 compute infrastructure; Design data implementation; Design networking implementation; Design security and identity solutions; Design solutions by using platform services; Design for operations. This Microsoft Exam Ref: Organizes its coverage by exam skills; Features strategic, what-if scenarios to challenge you; Includes DevOps and hybrid technologies and scenarios; Assumes you have experience building infrastructure and applications on the Microsoft Azure platform, and understand the services it offers. ...
Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, 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: Consume and transform data by using Microsoft Excel; Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies; Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis. ...
Prepare for Microsoft Exam 70-779 - and help demonstrate your real-world mastery of Microsoft Excel data analysis and visualization. Designed for BI professionals, data analysts, and others who analyze business data with Excel, 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: Consume and transform data by using Microsoft Excel; Model data, from building and optimizing data models through creating performance KPIs, actual and target calculations, and hierarchies; Visualize data, including creating and managing PivotTables and PivotCharts, and interacting with PowerBI. This Microsoft Exam Ref: Organizes its coverage by exam objectives; Features strategic, what-if scenarios to challenge you; Assumes you have a strong understanding of how to use Microsoft Excel to perform data analysis. ...
Microsoft Azure Security Center
This book presents comprehensive Azure Security Center techniques for safeguarding cloud and hybrid environments. Leading Microsoft security and cloud experts Yuri Diogenes and Dr. Thomas Shinder show how to apply Azure Security Center's full spectrum of features and capabilities to address protection, detection, and response in key operational scenarios. You'll learn how to secure any Azure workload, and optimize virtually all facets of modern security, from policies and identity to incident response and risk management. Whatever your role in Azure security, you'll learn how to save hours, days, or even weeks by solving problems in most efficient, reliable ways possible. Two of Microsoft's leading cloud security experts show how to: Assess the impact of cloud and hybrid environments on security, compliance, operations, data protection, and risk management; Master a new security paradigm for a world without traditional perimeters; Gain visibility and control to secure compute, netwo ...
This book presents comprehensive Azure Security Center techniques for safeguarding cloud and hybrid environments. Leading Microsoft security and cloud experts Yuri Diogenes and Dr. Thomas Shinder show how to apply Azure Security Center's full spectrum of features and capabilities to address protection, detection, and response in key operational scenarios. You'll learn how to secure any Azure workload, and optimize virtually all facets of modern security, from policies and identity to incident response and risk management. Whatever your role in Azure security, you'll learn how to save hours, days, or even weeks by solving problems in most efficient, reliable ways possible. Two of Microsoft's leading cloud security experts show how to: Assess the impact of cloud and hybrid environments on security, compliance, operations, data protection, and risk management; Master a new security paradigm for a world without traditional perimeters; Gain visibility and control to secure compute, netwo ...