|
|
|
|
The most comprehensive 12 hours of hands on Excel 2007 training guaranteed or your money back! MORE |
Learn to master the numerous aspects of performance tuning and optimization from this essential video guide. This multimedia course makes learning performance tuning easy through the use of practical, real-world (a table with over 7 million rows used for demonstration) exercises structured around every component within Management Studio, SQL Server Profiler and other sophisticated tools. MORE |
You'll learn how to approach requirements gathering, data source analysis, management buying, multi-dimensional modeling and data warehouse/business intelligence project life cycle. Explore data warehouse architecture and Analysis Services cube design. And discover the MOLAP, ROLAP and HOLAP storage models for Analysis Services cubes. MORE |
The latest eBook from the editors at SQL Server Magazine. Our BI experts share solutions to common problems that you’ll encounter using SQL Server’s BI features. You’ll learn how to create better reports, dimensions, and data repositories, plus discover new ways to leverage Microsoft Office SharePoint Server 2007 and Microsoft Excel in your BI strategy. Our experts will also help you uncover how to get the most out of features like Reporting Services, SSRS and MOSS, and SSAS. MORE |
BI expert and SQL Server Magazine author Michelle Poolet covers a myriad of topics in this downloadable guide. You’ll learn about the characteristics and benefits of implementing a star schema in your organization. Plus, you’ll discover the differences between dimensional and entity relationship data warehouse models, and how to design and use essential data warehouse components, including fact tables and dimensions. More advanced topics are covered as well, including dimensions (e.g., slowly changing, rapidly changing, junk, degenerate), the benefits of using dimensional role-playing in a star schema, and how to horizontally partition a fact table. You’ll also uncover how to determine which type of data warehouse you have and which workloads it uses. MORE |
Learn the operations of Access 2007 to perform day-to-day SQL programming and form design & reporting responsibilities. Plus understand the advantages of using relational database software and what it means to personal productivity and department level business processes. Get started today! MORE |
Learn to maximize the numerous features of SSIS from this essential video guide. This multimedia course makes learning SSIS easy through the use of extensive practical, real-world exercises structured around every component within Business Intelligence Development Studio. You will learn to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets, Oracle and DB2 databases, and transform the data for OLAP analysis, mining, and reporting. MORE |
This CD-ROM based course covers how to identify and configure all major aspects of a Microsoft SQL Server 2008 RDBMS. Thru live screen image video and audio, you'll learn how to install and configure SQL Server 2008, create and manage databases and database devices. Plus, you'll learn to configure enterprise security with logins, users, roles and policy-based management. MORE |
|
|