SQL Server – Suggestions on Books for Learning SQL Server Business Intelligence

Recently few folks approached me asking for suggestions on some good books which they can refer for learning SQL Server Business Intelligence, basically SQL Server and all its components. Below I have listed some of the good books which I have come across so far and these are really some of the good ones to get you on-boarded to SQL Server Business Intelligence Platform. These books are really useful for learning SQL Server, SSIS, SSAS, SSRS, MDX, and other related tools/technologies in the SQL Server BI Space.

  • SQL Server BI (End-to-End):

Delivering Business Intelligence with Microsoft SQL Server 2008

Concepts Covered: Data Warehousing, Business Intelligence, SSIS, SSAS, MDX, Data Mining, SSRS, and Microsoft Excel Pivot Tables/Charts etc.

Visit the following URL for more details on this book:

Delivering Business Intelligence with Microsoft SQL Server 2008

The Microsoft Data Warehouse Toolkit, 2nd Edition: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Concepts Covered: Data Warehousing, Business Intelligence, Master Data Services (MDS), SSIS, SSAS, SSRS, PowerPivot, Microsoft Excel, and Office SharePoint etc.

Visit the following URL for more details on this book:

The Microsoft Data Warehouse Toolkit, 2nd Edition: With SQL Server 2008 R2 and the Microsoft Business Intelligence Toolset

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

Concepts Covered: Business Intelligence (Life cycle), SSIS, SSAS, SSRS, MDX, DMX, .NET Custom Coding/Integration (Building Custom Objects), Microsoft Excel, and Office SharePoint etc.

Visit the following URL for more details on this book:

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008

  • SQL Server/Database Engine:

Microsoft® SQL Server® 2008 Internals

Concepts Covered: Functioning of SQL Server, Database Management, Functioning of Query Optimizer, Isolation Levels, Concurrency, and so on.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 Internals

Microsoft® SQL Server® 2008 Step by Step

Concepts Covered: Installation, Basics of Core Components & Tools, Data Management, Database Management, High Availability Features, Overview of SSIS, SSAS, and SSRS.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 Step by Step

  • Transact-SQL:

Microsoft® SQL Server® 2008 T-SQL Fundamentals

Concepts Covered: Fundamentals of Transact-SQL Language, Different Types of Statements, Logical Query Execution/Processing, SQL Server Joins, Different Types of Queries, Pivoting and Grouping, Locking & Blocking Scenarios, and Data Manipulation etc.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 T-SQL Fundamentals

Inside Microsoft® SQL Server® 2008: T-SQL Querying

Concepts Covered: Fundamentals of SET Based Logic (against Procedural Logic/Language), Query Tuning/Optimization, Data Manipulation, Partitioning, Efficient Querying, Different Types of Queries, and Logical Puzzles etc.

Visit the following URL for more details on this book:

Inside Microsoft® SQL Server® 2008: T-SQL Querying

Inside Microsoft® SQL Server® 2008: T-SQL Programming

Concepts Covered: T-SQL & CLR based User Defined Functions, Stored Procedures, Triggers, Types etc., Transactions, Concurrency, & Error Handling, Working with Temporary Objects, Cursors, Dynamic SQL, Working with Date/Time, Spatial/Geometry/Geography, XML, XQuery data, Feature like Extended Events, Auditing, Change Data Capture (CDC), and Service Broker etc.

Visit the following URL for more details on this book:

Inside Microsoft® SQL Server® 2008: T-SQL Programming

  • SQL Server Integration Services (SSIS):

Professional Microsoft SQL Server 2008 Integration Services

Concepts Covered: Overview of Integration Services, Tasks, Containers, Source/Destination Adapters, Transformations, Expressions/Variables, Tuning, Source Control, Software Development Life Cycle, DTS 2000 Migration, Error & Event Handling, .NET Custom Coding (Programming), Administration, and Case Study etc.

Visit the following URL for more details on this book:

Professional Microsoft SQL Server 2008 Integration Services

  • SQL Server Analysis Services (SSRS):

Microsoft® SQL Server® 2008 Analysis Services Step by Step

Concepts Covered: Fundamentals of SSAS, Building an End-to-End OLAP Solution (Data Sources, Data Source Views, Dimensions, Facts, Partitions, and so on), Implementing Security, Deployment, Different Wizards (Cube, Aggregation etc.), Exploring Core SSAS Capabilities, and Dynamic Management Views etc.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 Analysis Services Step by Step

  • SQL Server Reporting Services (SSRS):

Microsoft® SQL Server® 2008 Reporting Services Step by Step

Concepts Covered: Installation & Configuration, Report Designer & Report Builder, Building Interactive Reports with Filters/Parameters, Drill-Down, & Drill through etc., Visualizations (Charts, Gauges etc.), Deployment (to Office SharePoint Server), Creating & Managing, Subscriptions, .NET Custom Coding etc.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 Reporting Services Step by Step

Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports

Concepts Covered: Advanced Reporting Techniques, Business Reporting Terminology/Paradigms, Report Design Concepts, Report Design Essentials, Columnar & Grouped Reports, Business Intelligence Dashboards & Elements, Chart & Gauge Reports, Filtering, Parameterization, and Games etc.

Visit the following URL for more details on this book:

Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports

  • Multidimensional Expressions (MDX):

Microsoft® SQL Server® 2008 MDX Step by Step

Concepts Covered: Building & Executing MDX Queries, Working with Tuples, Sets, & Expressions, Building Aggregations, Navigating Hierarchies, Time-Based Calculations, SSAS Cube Customization using MDX, Implementing Dynamic Security using MDX, and Building MDX Based SSRS Reports etc.

Visit the following URL for more details on this book:

Microsoft® SQL Server® 2008 MDX Step by Step

Do you know of any other good books for learning SQL Server Business Intelligence? Do share your experience and journey in learning SQL Server and its components.

Note: These suggestions are based on what I have heard or come across so far. Do sufficient research before you buy any books. Also, note that, I have made these suggestions in the interest of my blog’s readers and I am not associated with the publishers of any of the above books and I do not get any kind of benefits (direct/indirect) by making these suggestions.

Advertisements

About Dattatrey Sindol (Datta)

Datta is a Microsoft BI Enthusiast, passionate developer, and a blogger. View Full Profile

Posted on June 27, 2012, in BIDS, Books, Learning Resources, MOSS, SQL Client Tools, SQL Constraints, SQL Data Profiling, SQL Server, SSAS, SSIS, SSMS, SSRS, T-SQL and tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , . Bookmark the permalink. 4 Comments.

What are your thoughts?

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: