|
|
|
|
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 |
Do you want to master virtually every aspect of Access 2007, including all of the hot new features and interface? Would you like to pass the 77-605 MCAS exam? Whether you're a beginner or experienced user, this course will help you achieve all of the above! Most importantly, unlike every other Access 2007 course on the market, we actually teach you how to build a real, working database from scratch! 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 |
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 |
|
|