Pro T-SQL 2012 Programmer's Guide

SQL is a widely used to access most databases, therefore database developers and system administrators should be familiar with it. This hands-on SQL book will help beginner and intermediate users

Attention all SQL Pros, DAX is not just for writing Excel-based formulas! Get hands-on learning and expert advice on how to use the vast capabilities of the DAX language to solve common data modeling

A hands-on guide to using Excel in the business context First published in 2012, Using Excel for Business and Financial Modelling contains step-by-step instructions of how to solve common business pro

本書全面、翔實地介紹了應用SQL Server 2012資料庫管理系統進行資料庫管理的各種操作以及資料庫程式開發所需的各種知識和技能，主要內容包括：資料庫技術基礎，資料庫操作，表操作，查詢操作，視圖操作，索引操作，T-SQL程式設計和存儲過程操作，觸發器操作，游標、事務和鎖，資料庫安全操作，資料庫管理操作和SQL Server資料庫程式開發。作者在多年的資料庫教學與資料庫程式應用開發經驗的基礎上，

本書根據實際的工程開發過程，以項目為引導、任務為驅動來組織教材結構。全書以“教學管理系統”為開發案例，主要內容包括：數據庫基礎知識、概念模型、關係模型、SQL Server 2012概述、創建與管理數據庫、創建與管理數據表、SQL語言查詢、TSQL程序設計、視圖和索引、存儲

Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI―Microsoft’s leading self-service business intelligence application―and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanced applications of DAX to solve complex tasks.Often a task seems complex due to a lack of understanding, or a misunderstanding of core principles, and how certain components interact with each other. The authors of this book use solutions and examples to teach you how to solve complex problems. They explain the intricate workings of important concepts such as Filter Context and Context Transition. You will learn how Power BI, through combining DAX building blocks (such as measures, table filtering, and data lineage), can yield extraordinary analytical power. Throughout Pro Dax with Power BI t

本教材以目前流行的SQL Server 2012數據庫管理系統為藍本，詳細介紹數據庫系統的基礎知識、關系數據庫的規範化、關系數據庫的設計以及SQL Server數據庫操作、數據表操作、SQL數據查詢、T-SQL程序設計、索引和視圖、存儲過程、觸發器以及數據庫安全等，通過學習使學生能夠應用SQL Server數據庫管理系統設計開發應用管理系統。