PHI Learning: Microsoft Press

06/04/2024

📚 Publish With PHI Learning: 61 Years of Excellence 📚

Dear Academicians,

Your expertise catalyzes groundbreaking innovation. We would like to extend our invitation to send us your manuscript for publishing.

Scholarly publications stand as a testament to any professor's experience in their field. This publication offers a chance to showcase your dedication while positively impacting students, teachers, and Indian academia.

Please note: the books should be aligned with the prescribed NEP or UGC syllabus.

Let's discuss how we can bring your vision to life with PHI Learning:

Call: 011 4303 1100
Email: [email protected]

We will be privileged to be associated with your work!

04/12/2019

T-SQL QUERYING
By Itzik Ben-Gan, KEVIN, FARLEEl, ADAM MACHANIC, Dejan Sarka

The Book
Squeeze maximum performance and efciency from every T-SQL query you write or tune. Four leading experts take an indepth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Emphasizing a correct understanding of the language and its foundations, the authors present unique solutions they have spent years developing and rening. All code and techniques are fully updated to reect new T-SQL enhancements in Microsoft SQL Server 2014 and SQL Server 2012 and help you write faster, more efcient T-SQL code.

• Move from procedural programming to the language of sets and logic
• Master an efcient topdown tuning methodology
• Assess algorithmic complexity to predict performance
• Compare data aggregation techniques, including new grouping sets
• Efciently perform data analysis calculations
• Make the most of T-SQL’s optimized bulk import tools
• Avoid date/time pitfalls that lead to buggy, poorly performing code
• Create optimized BI statistical queries without addition.

The Authors
Itzik Ben-Gan, is a mentor and cofounder of SolidQ. A Microsoft Data Platform MVP since 1999, he has delivered T SQL querying, tuning, and programming training worldwide. His books include T-SQL Querying and Microsoft SQL Server 2012: High-Performance T-SQL Using Window Functions. He has written for SQL Server Pro, SolidQ Journal, and MSDN, and has spoken at SQLPASS, SQLBits, IT/Dev Connections, and SQLTeach. He is the author of two SolidQ T-SQL courses.

Dejan Sarka is a Microsoft MVP for SQL Server who develops database and business intelligence solutions. He has authored or coauthored many books about SQL Server, including the Training Kit for Exam 70-448.

The Contents
Foreword
Introduction
CHAPTER 1 Logical query processing
CHAPTER 2 Query tuning
CHAPTER 3 Multi-table queries
CHAPTER 4 Grouping, pivoting, and windowing
CHAPTER 5 TOP and OFFSET-FETCH
CHAPTER 6 Data modification
CHAPTER 7 Working with date and time
CHAPTER 8 T-SQL for BI practitioners
CHAPTER 9 Programmable objects
CHAPTER 10 In-Memory OLTP
CHAPTER 11 Graphs and recursive queries
Index

Buy the book from our website. Click http://social.phindia.com/EGHD1Fyg

Microsoft

04/12/2019

Plain & Simple
Microsoft Press Series Books are for every computer user, from the beginner up to intermediate. Also, ideal for school students

For beginning to intermediate users, Plain and Simple provides the right answers to address specific problems or tasks, with a minimum of jargon.

• Provides visual approach and shows the simplest ways to get things done
• Features numbered and easy-to-follow steps with screen shots
• Gives straightforward information needed - without any jargon

Click to know more or purchase the books http://social.phindia.com/Nlv3YdPS

&Simple

27/11/2019

Microsoft Press Series In Focus – Inside Out

The Microsoft Inside Out Advantage

The Inside Out series is designed for intermediate to advanced Microsoft Office and Windows customers and IT professionals who want to optimize their work, solve problems, and advance their expertise.

• Delivers in-depth reference geared to intermediate and advanced level users.

• Emphasizes authoritative, under-the-hood information.

• Focuses on time-saving solutions, troubleshooting tips, and workarounds that optimize the reader's efficiency and proficiency.

• Features "Inside Out" sidebars and "Troubleshooting" sidebars that call out expert, insider information not readily available from other sources.

• Frames complex concepts and examples with relevant context and background, covering both the "how" and the "why" of a feature.

• May sometimes include sample files, practice files, or other related material.

Buy the Inside Out books from our website. Click http://social.phindia.com/gWy9-OMN

Microsoft

20/11/2019

Preparing for Microsoft Certification Exams?
The Exam Ref having Microsoft Press Advantage helps achieve success

It is the official Microsoft exam reference focusing on the critical skills and knowledge as measured by Microsoft certification exams.

The Exam Ref books cover all the skills measured on a specific Microsoft Certification exam. The target audience is the IT professional or developer who has real-world product experience and is preparing for certification.

• Offers concise overview of each skill covered by the exam.
• Includes "Need more review?" reader aids to point readers to additional study materials should they need them.
• Delivers exam tips, summaries, and inline questions and answers to help readers identify key points.
• Includes "Thought Experiments" to help readers assess their readiness for the exam.

Buy Now from our website. Click http://social.phindia.com/p5R2JMDf

Our books are also available on Amazon, Flipkart, Snapdeal, RediffBooks, Shopclues, Google Books and Alibaba

Microsoft Office365 Asp.net Education

12/07/2019

Add to Learning - What is Power Pivot?

Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

In both Excel and in Power Pivot, you can create a Data Model, a collection of tables with relationships. The data model you see in a workbook in Excel is the same data model you see in the Power Pivot window. Any data you import into Excel is available in Power Pivot, and vice versa.

To learn which tasks to perform in Power Pivot and which in Excel; How the data is stored; How to SharePoint Click http://social.phindia.com/Mfd8lChe

You may also utilize our book to dig deeper into the details log on to http://social.phindia.com/alGYrPU2

Microsoft

28/06/2019

ANALYZING DATA WITH MICROSOFT POWER BI AND POWER PIVOT FOR EXCEL
By Alberto Ferrari and Marco Russo are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power Pivot, Power BI, DAX, and SQL Server Analysis Services. Both Ferrari and Russo provide consultancy and mentoring on business intelligence (BI). They are also frequent speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits.

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

Get all code samples, including complete apps, at
https://aka.ms/AnalyzeData/Downloads

Target Audience
For intermediate to advanced users of Microsoft Excel
• 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

Contents
Contents
Introduction
CHAPTER 1 Introduction to data modeling
CHAPTER 2 Using header/detail tables
CHAPTER 3 Using multiple fact tables
CHAPTER 4 Working with date and time
CHAPTER 5 Tracking historical attributes
CHAPTER 6 Using snapshots
CHAPTER 7 Analyzing date and time intervals
CHAPTER 8 Many-to-many relationships
CHAPTER 9 Working with different granularity
CHAPTER 10 Segmentation data models
CHAPTER 11 Working with multiple currencies
APPENDIX A Data modeling
Index

Buy a copy from our website and enhance your skills. Click http://social.phindia.com/alGYrPU2

Microsoft MicrosoftExcel Microsoft in Business

26/06/2019

T-SQL FUNDAMENTALS, THIRD EDITION By Itzik Ben-Gan
Effectively query and modify data using Transact-SQL
By
Mastering T-SQL fundamentals and write robust code for Microsoft SQL Server and Azure SQL Database.

The Book
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

The Contents
Introduction
CHAPTER 1 Background to T-SQL querying and programming
CHAPTER 2 Single-table queries
CHAPTER 3 Joins
CHAPTER 4 Subqueries
CHAPTER 5 Table expressions
CHAPTER 6 Set operators
CHAPTER 7 Beyond the fundamentals of querying
CHAPTER 8 Data modification
CHAPTER 9 Temporal tables
CHAPTER 10 Transactions and concurrency
CHAPTER 11 Programmable objects
Appendix: Getting started
Index

The Author
Itzik Ben-Gan, is a mentor and cofounder of SolidQ. A Microsoft Data Platform MVP since 1999, he has delivered T SQL querying, tuning, and programming training worldwide. His books include T-SQL Querying and Microsoft SQL Server 2012: High-Performance T-SQL Using Window Functions. He has written for SQL Server Pro, SolidQ Journal, and MSDN, and has spoken at SQLPASS, SQLBits, IT/Dev Connections, and SQLTeach. He is the author of two SolidQ T-SQL courses.

Purchase the book from our website. click http://social.phindia.com/wgviR53Z

Microsoft

25/06/2019

Need tutorials to learn ASP.Net Core
Click on the link https://www.tutorialspoint.com/asp.net_core/

Microsoft

ASP.NET Core Tutorial for Beginners - Learn ASP.NET Core in simple and easy steps starting from basic to advanced concepts with examples including Overview, Environment Setup, New Project, Project Layout, Project.Json, Configuration, Middleware, Exceptions, Static Files, Setup MVC, MVC Design Patter...

24/06/2019

Learn ASP.Net Core from Microsoft MVP Dino Esposito. In our book Programming ASP.Net Core, he 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

click the link http://social.phindia.com/WwTyMkSS to purchase the book.

Microsoft Microsoft .Net Expert

18/06/2019

Let’s Know What’s There In The Book

MICROSOFT EXCEL 2016 STEP BY STEP
By Curtis Frye

The quick way to learn Microsoft Excel 2016 and get more done!

This learning made easy reference shows you exactly what to do, step by step. Learn to

• 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

Let’s Know The Contents
Introductioni
Part 1: Create and format workbooks
1. Set up a workbook
2. Work with data and Excel tables.
3. Perform calculations on data
4. Change workbook appearance
Part 2: Analyze and present data
5. Manage worksheet data
6. Reorder and summarize data
7. Combine data from multiple sources
8. Analyze alternative data sets.
9. Create charts and graphics.
10. Create dynamic worksheets by using PivotTables
Part 3: Collaborate and share in Excel
11. Print worksheets and charts
12. Automate repetitive tasks by using macros
13. Work with other Microsoft Office apps
14. Collaborate with colleagues
Part 4: Perform advanced analysis
15. Perform business intelligence analysis .
16. Create forecasts and visualizations

Let’s Know About the Author
Curtis Frye is a writer, speaker, and performer who lives in Portland, Oregon. He is the author or co-author of more than 20 books, including Microsoft Excel 2013 Step by Step. In addition to his writing, Curt presents keynote addresses on Excel and motivational topics.

Purchase the book from our website at special discount. Click https://www.phindia.com/Books/BookDetail/OTc4ODEyMDM1MTk4MQ

Microsoft

18/06/2019

The Microsoft Press Plain and Simple Series
Books for every computer user, from the beginner up to the advanced power user

For beginning to intermediate users, Plain and Simple provides the right answers to address specific problems or tasks, with a minimum of jargon.

Provides visual approach and shows the simplest ways to get things done
Features numbered and easy-to-follow steps with screen shots
Gives straightforward information needed - without any jargon

Purchase from our website on topics Office 2013, Word 2013 Windows 8 for Tablets, click https://www.phindia.com/MicrosoftPressBooks/MicrosoftBookSeries/Z2VuZXJhbA/Mw

Microsoft

PHI Learning : Microsoft Press Book Step by Step Series Books