SQL Unleashed, Second Edition, covers ANSII SQL and how to implement them with several major relational database platforms used on a day-to-day basis. SQL Unleashed focuses on more intermediate to advanced topics and the latest trends forthcoming in SQL. Designed to be used as both a reference and implementation tool, this book serves as a practical, pragmatic guide to day-to-day SQL programming and provide the most efficient solutions for getting the job done. Topics include database design and data definition, data manipulation, data selection, more advanced, QL implementations, the future of SQL, and vendor SQL extensions.

SQL Unleashed

Computers & Technology

Youness, Sakhr

Ladanyi, Hans

Boutquin, Pierre

Programming Languages

Sams.

With the vast amounts of data flowing through the workplace on a daily basis, Data warehouses have evolved to cope with the huge volumes involved by separating the data used for reporting and decision making from the operational systems. Microsoft have entered the world of datawarehousing with the introduction of SQL Server 7 and OLAP Services. 
The purpose of the data warehouse is simply to store the raw data. The combination of this with OLAP enables the data to be transformed into useful information that reflects the real factors affecting the enterprise. OLAP techniques may range from simple navigation and browsing of the data to more serious analyses, such as time-series and complex modeling.

Professional Data Warehousing with SQL Server 7.0 and OLAP Services

Business & Money

Management & Leadership

Apress

Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise. 
 In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. There is also an in-depth discussion of the exciting new topic of Web Housing. 
 By reading this book, you will learn how best to employ data warehousing and OLAP in your business, and how to leverage it to provide your organization with improved revenue and profitability. 
 This book covers: 
 Understanding Analysis Services Architecture Designing Data Warehouses and Data Marts Using Data Transformation Services (DTS) in Data Warehousing Techniques for Data Mining and Analysis Building OLAP cubes with Analysis Manager, and programmatically through DSO Securing, Administrating and Optimizing a Data Warehouse and OLAP system Using Multidimensional Expressions (MDX) to query OLAP cubes Building OLAP client applications with Visual Basic and ASP English Query, PivotTable Service

Professional SQL Server 2000 Data Warehousing with Analysis Services

Lee, Denny

Turley, Paul

Scott, Mark

Dewson, Robin

Bain, Tony

Ferguson, Sam

Graves, Chris

Benkovich, Mike

Skoglund, Robert

Joubert, Terrence

Programming

See the best price to sell, buy, or rent books by Youness, Sakhr. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Youness, Sakhr