|
|
|
|
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 table and matrix report design, interactive OLAP reporting, executive dashboard & scorecard architecture for Enterprise Performance Management applications, and effective delivery of Business Intelligence to end users though data visualization, interactivity, sub reports and report linking. 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 |
This seven CD-ROM based course provides learners the steps to design, create and manage database objects. You’ll discover the most important principles of relational database design: logical and physical data modeling, primary and foreign keys and 3NF design guidelines. Practical applications and real life examples are incorporated into the instruction. MORE |
If you want to develop hands-on experience as an SQL Server 2008 Administrator, or prepare for the 70-432 exam, this course is for you! Whether you're a beginner or experienced in SQL Server administration, this course covers SQL Server 2008 in-depth as you configure and maintain your own enterprise data management system! Follow along with the many real-world examples in this course to work with your own database and lay the foundation towards becoming a DBA. MORE |
If you want to develop hands-on experience as a SQL Server 2008 developer or prepare for the 70-433 exam, this course is for you! Our SQL Server 2008 Database Development Training teaches you T-SQL, .NET/CLR development, data partitioning, advanced query techniques and much more. MORE |
The SQL Server 2008 System Views poster is an updated full-color diagram of catalog views, dynamic management views, tables, and objects for SQL Server 2008. In addition, relationship types and object scope are included. This poster is a must-have reference for every SQL DBA working with and migrating to SQL Server 2008. MORE |
The 10 lessons in the T-SQL 101 series can help you learn the basics, such as how to write queries that retrieve, add, update, and delete records in tables and how to group and aggregate data that you retrieved with queries so that you can produce informative reports. By the end of the series, you’ll even be able to create tables, views, and custom stored procedures. MORE |
|
|